Film_Locations_in_San_Francisco

Data source: data.sfgov.org

11 rows where Director = 35

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
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 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 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 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 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 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 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 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 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 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 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

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 34.424ms · Data source: data.sfgov.org