Film_Locations_in_San_Francisco

Data source: data.sfgov.org

22 rows where Actor 1 = 107

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Title, Release Year, Locations, Fun Facts, Production Company, Distributor, Director, Writer, Actor 2

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
1456 1456 The Presidio 275 1988 23 Washington Street & Waverly Place (Chinatown)   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1457 1457 The Presidio 275 1988 23 Sansome Street (The Embarcadero)   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1458 1458 The Presidio 275 1988 23 Presidio (Golden Gate National Recreation Area) In 1776, Spain made the Presidio a fortified area. The area was then given to Mexico, but then given to the US in 1848. The 1994 demilitarization of the area in 1994 marked the end of its 219 years of military use. Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1459 1459 The Presidio 275 1988 23 Montgomery & Vallejo Streets (Telegraph Hill)   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1460 1460 The Presidio 275 1988 23 Market & 2nd Streets   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1461 1461 The Presidio 275 1988 23 Hayes & Polk Streets (Civic Center)   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1462 1462 The Presidio 275 1988 23 Golden Gate Bridge With 23 miles of ladders and 300,000 rivets in each tower, the Golden Gate Bridge was the world's longest span when it opened in 1937. Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1463 1463 The Presidio 275 1988 23 Fort Point (Presidio, Golden Gate National Recreation Area) Built in 1853, Fort Point is the only West Coast fort built by the Union Army. Though the Confederate army planned to attack San Francisco, the commanding Confederate general learned that the war had ended while end route to SF. Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1464 1464 The Presidio 275 1988 23 Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1465 1465 The Presidio 275 1988 23 Coit Tower The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way. Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1466 1466 The Presidio 275 1988 23 Civic Center Plaza   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1467 1467 The Presidio 275 1988 23 Battery Street (The Embarcadero)   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1468 1468 The Presidio 275 1988 23 900 Block of Grant Avenue (Chinatown)   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1469 1469 The Presidio 275 1988 23 700 Block of Jackson Street (Chinatown)   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1470 1470 The Presidio 275 1988 23 200 Block of Sansome Street (Financial District)   Paramount Pictures 4 Paramount Pictures 3 Peter Hyams 226 Larry Ferguson 238 Sean Connery 107 Mark Harmon 211 Meg Ryan 46
1487 1487 The Rock 280 1996 43 Palace of Fine Arts (3301 Lyon Street) The original Palace was built for the 1915 Panama-Pacific Exposition, and completely destroyed in 1964. It was rebuilt in 1965. Hollywood Pictures 95 Buena Vista Pictures 25 Michael Bay 229 David Weisberg 241 Sean Connery 107 Nicolas Cage 216  
1488 1488 The Rock 280 1996 43 The San Francisco Bay   Hollywood Pictures 95 Buena Vista Pictures 25 Michael Bay 229 David Weisberg 241 Sean Connery 107 Nicolas Cage 216  
1489 1489 The Rock 280 1996 43 New Russian Hill Market (1198 Pacific Avenue at Jones)   Hollywood Pictures 95 Buena Vista Pictures 25 Michael Bay 229 David Weisberg 241 Sean Connery 107 Nicolas Cage 216  
1490 1490 The Rock 280 1996 43 Fairmont Hotel (950 Mason Street, Nob Hill) In 1945 the Fairmont hosted the United Nations Conference on International Organization as delegates arrived to draft a charter for the organization. The U.S. Secretary of State, Edward Stettinius drafted the charter in the hotel's Garden Room. Hollywood Pictures 95 Buena Vista Pictures 25 Michael Bay 229 David Weisberg 241 Sean Connery 107 Nicolas Cage 216  
1491 1491 The Rock 280 1996 43 Coit Tower The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way. Hollywood Pictures 95 Buena Vista Pictures 25 Michael Bay 229 David Weisberg 241 Sean Connery 107 Nicolas Cage 216  
1492 1492 The Rock 280 1996 43 City Hall The dome of SF's City Hall is almost a foot taller than that of the US Capitol Building. In 1954, Joe DiMaggio and Marilyn Monroe married at the Beaux Arts-style building. Hollywood Pictures 95 Buena Vista Pictures 25 Michael Bay 229 David Weisberg 241 Sean Connery 107 Nicolas Cage 216  
1493 1493 The Rock 280 1996 43 Alcatraz Island Alcatraz Island was a military fort before it became a prison. Hollywood Pictures 95 Buena Vista Pictures 25 Michael Bay 229 David Weisberg 241 Sean Connery 107 Nicolas Cage 216  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "Film_Locations_in_San_Francisco" (
"Title" INTEGER,
  "Release Year" INTEGER,
  "Locations" TEXT,
  "Fun Facts" REAL,
  "Production Company" INTEGER,
  "Distributor" INTEGER,
  "Director" INTEGER,
  "Writer" INTEGER,
  "Actor 1" INTEGER,
  "Actor 2" INTEGER,
  "Actor 3" INTEGER
,
FOREIGN KEY ("Title") REFERENCES [Title](id),
    FOREIGN KEY ("Director") REFERENCES [Director](id),
    FOREIGN KEY ("Actor 2") REFERENCES [Actors](id),
    FOREIGN KEY ("Actor 1") REFERENCES [Actors](id),
    FOREIGN KEY ("Writer") REFERENCES [Writer](id),
    FOREIGN KEY ("Release Year") REFERENCES [Release Year](id),
    FOREIGN KEY ("Actor 3") REFERENCES [Actors](id),
    FOREIGN KEY ("Production Company") REFERENCES [Production Company](id),
    FOREIGN KEY ("Distributor") REFERENCES [Distributor](id));
CREATE INDEX ["Film_Locations_in_San_Francisco_Title"] ON [Film_Locations_in_San_Francisco]("Title");
CREATE INDEX ["Film_Locations_in_San_Francisco_Director"] ON [Film_Locations_in_San_Francisco]("Director");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 2"] ON [Film_Locations_in_San_Francisco]("Actor 2");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 1"] ON [Film_Locations_in_San_Francisco]("Actor 1");
CREATE INDEX ["Film_Locations_in_San_Francisco_Writer"] ON [Film_Locations_in_San_Francisco]("Writer");
CREATE INDEX ["Film_Locations_in_San_Francisco_Release Year"] ON [Film_Locations_in_San_Francisco]("Release Year");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 3"] ON [Film_Locations_in_San_Francisco]("Actor 3");
CREATE INDEX ["Film_Locations_in_San_Francisco_Production Company"] ON [Film_Locations_in_San_Francisco]("Production Company");
CREATE INDEX ["Film_Locations_in_San_Francisco_Distributor"] ON [Film_Locations_in_San_Francisco]("Distributor");
Powered by Datasette · Query took 39.773ms · Data source: data.sfgov.org