Film_Locations_in_San_Francisco
Data source:
data.sfgov.org
11 rows
where Distributor = 26
✎ View and edit SQL
This data as json, CSV (advanced)
Link
|
rowid ▼
|
Title
|
Release Year
|
Locations
|
Fun Facts
|
Production Company
|
Distributor
|
Director
|
Writer
|
Actor 1
|
Actor 2
|
Actor 3
|
145 |
145 |
Birth of the Dragon 37 |
2016 30 |
Lands End Trail at Eagles Point/ Lincoln Park Golf Course |
The character of Steve McKee was based on actor Steve McQueen who studied with Bruce Lee in the later 60's. |
BOTD U.S. Productions, Inc. 32 |
Kylin Pictures 26 |
George Nolfi 35 |
Christopher Wilkinson, Stephen J. Rivele 34 |
Philip Ng 269 |
Billy Magnussen 32 |
Yu Xia 456 |
146 |
146 |
Birth of the Dragon 37 |
2016 30 |
Pier 45 - Jeremiah O'Brien Liberty Ship |
The SS Jeremiah O'Brien is a rare survivor of the invasion at Normandy on D-Day in WWII. |
BOTD U.S. Productions, Inc. 32 |
Kylin Pictures 26 |
George Nolfi 35 |
Christopher Wilkinson, Stephen J. Rivele 34 |
Philip Ng 269 |
Billy Magnussen 32 |
Yu Xia 456 |
147 |
147 |
Birth of the Dragon 37 |
2016 30 |
Leavenworth at Green |
|
BOTD U.S. Productions, Inc. 32 |
Kylin Pictures 26 |
George Nolfi 35 |
Christopher Wilkinson, Stephen J. Rivele 34 |
Philip Ng 269 |
Billy Magnussen 32 |
Yu Xia 456 |
148 |
148 |
Birth of the Dragon 37 |
2016 30 |
Leavenworth at Union |
|
BOTD U.S. Productions, Inc. 32 |
Kylin Pictures 26 |
George Nolfi 35 |
Christopher Wilkinson, Stephen J. Rivele 34 |
Philip Ng 269 |
Billy Magnussen 32 |
Yu Xia 456 |
149 |
149 |
Birth of the Dragon 37 |
2016 30 |
Hyde at Union |
|
BOTD U.S. Productions, Inc. 32 |
Kylin Pictures 26 |
George Nolfi 35 |
Christopher Wilkinson, Stephen J. Rivele 34 |
Philip Ng 269 |
Billy Magnussen 32 |
Yu Xia 456 |
150 |
150 |
Birth of the Dragon 37 |
2016 30 |
California at Grant |
|
BOTD U.S. Productions, Inc. 32 |
Kylin Pictures 26 |
George Nolfi 35 |
Christopher Wilkinson, Stephen J. Rivele 34 |
Philip Ng 269 |
Billy Magnussen 32 |
Yu Xia 456 |
151 |
151 |
Birth of the Dragon 37 |
2016 30 |
Grant between Bush and Broadway |
|
BOTD U.S. Productions, Inc. 32 |
Kylin Pictures 26 |
George Nolfi 35 |
Christopher Wilkinson, Stephen J. Rivele 34 |
Philip Ng 269 |
Billy Magnussen 32 |
Yu Xia 456 |
152 |
152 |
Birth of the Dragon 37 |
2016 30 |
California at Mason |
|
BOTD U.S. Productions, Inc. 32 |
Kylin Pictures 26 |
George Nolfi 35 |
Christopher Wilkinson, Stephen J. Rivele 34 |
Philip Ng 269 |
Billy Magnussen 32 |
Yu Xia 456 |
153 |
153 |
Birth of the Dragon 37 |
2016 30 |
Spofford between Clay and Washington |
|
BOTD U.S. Productions, Inc. 32 |
Kylin Pictures 26 |
George Nolfi 35 |
Christopher Wilkinson, Stephen J. Rivele 34 |
Philip Ng 269 |
Billy Magnussen 32 |
Yu Xia 456 |
154 |
154 |
Birth of the Dragon 37 |
2016 30 |
Twin Peaks Blvd. |
|
BOTD U.S. Productions, Inc. 32 |
Kylin Pictures 26 |
George Nolfi 35 |
Christopher Wilkinson, Stephen J. Rivele 34 |
Philip Ng 269 |
Billy Magnussen 32 |
Yu Xia 456 |
155 |
155 |
Birth of the Dragon 37 |
2016 30 |
Waverly Pl between Washington and Sacramento |
|
BOTD U.S. Productions, Inc. 32 |
Kylin Pictures 26 |
George Nolfi 35 |
Christopher Wilkinson, Stephen J. Rivele 34 |
Philip Ng 269 |
Billy Magnussen 32 |
Yu Xia 456 |
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");