Film_Locations_in_San_Francisco
Data source:
data.sfgov.org
15 rows
where Director = 213
✎ View and edit SQL
This data as json, CSV (advanced)
Suggested facets: Title, Release Year, Production Company, Distributor, Writer, Actor 1, Actor 2
Link
|
rowid ▼
|
Title
|
Release Year
|
Locations
|
Fun Facts
|
Production Company
|
Distributor
|
Director
|
Writer
|
Actor 1
|
Actor 2
|
Actor 3
|
1404 |
1404 |
The Game 258 |
1997 8 |
Merchant Exchange Building (465 California Street) |
|
Polygram Filmed Entertainment 156 |
Polygram Filmed Entertainment 110 |
David Fincher 213 |
John Brancato 224 |
Michael Douglas 245 |
Sean Penn 40 |
Deborah Kara Unger 532 |
1405 |
1405 |
The Game 258 |
1997 8 |
Washington Street & Waverly Place (Chinatown) |
|
Polygram Filmed Entertainment 156 |
Polygram Filmed Entertainment 110 |
David Fincher 213 |
John Brancato 224 |
Michael Douglas 245 |
Sean Penn 40 |
Deborah Kara Unger 532 |
1406 |
1406 |
The Game 258 |
1997 8 |
Stockton Tunnel Southern Approach Overhang (Bush & Stockton Streets, Chinatown) |
Opened in 1914, the Stockton Tunnel was built to provide North Beach residents access to the thriving downtown area. |
Polygram Filmed Entertainment 156 |
Polygram Filmed Entertainment 110 |
David Fincher 213 |
John Brancato 224 |
Michael Douglas 245 |
Sean Penn 40 |
Deborah Kara Unger 532 |
1407 |
1407 |
The Game 258 |
1997 8 |
Sheraton Palace Hotel (639 Market Street) |
The hotel was destroyed in the 1906 earthquake and fire, had to be rebuilt, and was reopened in 1909. |
Polygram Filmed Entertainment 156 |
Polygram Filmed Entertainment 110 |
David Fincher 213 |
John Brancato 224 |
Michael Douglas 245 |
Sean Penn 40 |
Deborah Kara Unger 532 |
1408 |
1408 |
The Game 258 |
1997 8 |
Ritz-Carlton Hotel (600 Stockton Street) |
|
Polygram Filmed Entertainment 156 |
Polygram Filmed Entertainment 110 |
David Fincher 213 |
John Brancato 224 |
Michael Douglas 245 |
Sean Penn 40 |
Deborah Kara Unger 532 |
1409 |
1409 |
The Game 258 |
1997 8 |
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. |
Polygram Filmed Entertainment 156 |
Polygram Filmed Entertainment 110 |
David Fincher 213 |
John Brancato 224 |
Michael Douglas 245 |
Sean Penn 40 |
Deborah Kara Unger 532 |
1410 |
1410 |
The Game 258 |
1997 8 |
Merchant Exchange Building |
|
Polygram Filmed Entertainment 156 |
Polygram Filmed Entertainment 110 |
David Fincher 213 |
John Brancato 224 |
Michael Douglas 245 |
Sean Penn 40 |
Deborah Kara Unger 532 |
1411 |
1411 |
The Game 258 |
1997 8 |
Mason & California Streets (Nob Hill) |
|
Polygram Filmed Entertainment 156 |
Polygram Filmed Entertainment 110 |
David Fincher 213 |
John Brancato 224 |
Michael Douglas 245 |
Sean Penn 40 |
Deborah Kara Unger 532 |
1412 |
1412 |
The Game 258 |
1997 8 |
Harrison Street (The Embarcadero) |
|
Polygram Filmed Entertainment 156 |
Polygram Filmed Entertainment 110 |
David Fincher 213 |
John Brancato 224 |
Michael Douglas 245 |
Sean Penn 40 |
Deborah Kara Unger 532 |
1413 |
1413 |
The Game 258 |
1997 8 |
City Club (155 Sansome Street) |
|
Polygram Filmed Entertainment 156 |
Polygram Filmed Entertainment 110 |
David Fincher 213 |
John Brancato 224 |
Michael Douglas 245 |
Sean Penn 40 |
Deborah Kara Unger 532 |
1414 |
1414 |
The Game 258 |
1997 8 |
Bay Bridge |
Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII. |
Polygram Filmed Entertainment 156 |
Polygram Filmed Entertainment 110 |
David Fincher 213 |
John Brancato 224 |
Michael Douglas 245 |
Sean Penn 40 |
Deborah Kara Unger 532 |
1415 |
1415 |
The Game 258 |
1997 8 |
Bank of America Building (555 California Street) |
The Bank of America Building was the tallest building on the West Coast from 1969-1972, when it was surpassed by the TransAmerica Pyramid. Today, the Bank of America building is the 5th tallest building on the West Coast. |
Polygram Filmed Entertainment 156 |
Polygram Filmed Entertainment 110 |
David Fincher 213 |
John Brancato 224 |
Michael Douglas 245 |
Sean Penn 40 |
Deborah Kara Unger 532 |
1416 |
1416 |
The Game 258 |
1997 8 |
301 Howard Street |
|
Polygram Filmed Entertainment 156 |
Polygram Filmed Entertainment 110 |
David Fincher 213 |
John Brancato 224 |
Michael Douglas 245 |
Sean Penn 40 |
Deborah Kara Unger 532 |
1417 |
1417 |
The Game 258 |
1997 8 |
1 Bush Street |
|
Polygram Filmed Entertainment 156 |
Polygram Filmed Entertainment 110 |
David Fincher 213 |
John Brancato 224 |
Michael Douglas 245 |
Sean Penn 40 |
Deborah Kara Unger 532 |
1622 |
1622 |
Zodiac 307 |
2007 75 |
SF Chronicle Building (901 Mission St) |
|
Paramount Pictures 4 |
Paramount Pictures 3 |
David Fincher 213 |
James Vanderbilt 266 |
Jake Gyllenhaal 438 |
Mark Ruffalo 118 |
|
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");