Film_Locations_in_San_Francisco

Data source: data.sfgov.org

13 rows where Director = 3

View and edit SQL

Suggested facets: Title, Release Year, Distributor, Writer, Actor 1, Actor 2

Production Company

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
10 40 Days and 40 Nights 3 2002 3 The Walden House, Buena Vista Park Established in 1867, Buena Vista Park is the oldest official park in San Francisco. Miramax Films 3 Miramax Films 2 Michael Lehmann 3 Robert Perez 2 Josh Hartnett 239 Shaynnyn Sossamon 2  
11 40 Days and 40 Nights 3 2002 3 Café Trieste (609 Vallejo) Francis Ford Coppola allegedly wrote large portions of "The Godfather" trilogy in Café Trieste. Miramax Films 3 Miramax Films 2 Michael Lehmann 3 Robert Perez 2 Josh Hartnett 239 Shaynnyn Sossamon 2  
288 Chance- Season 1 ep103 53 2016 30 60 Leavenworth St.   TVM Productions 43 HULU 34 Michael Lehmann 3 Kem Nunn 49 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
289 Chance- Season 1 ep103 53 2016 30 Blue Danube Café, 306 Clement   TVM Productions 43 HULU 34 Michael Lehmann 3 Kem Nunn 49 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
290 Chance- Season 1 ep103 53 2016 30 San Francisco Art Institute, 800 Chestnut   TVM Productions 43 HULU 34 Michael Lehmann 3 Kem Nunn 49 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
291 Chance- Season 1 ep103 53 2016 30 Laguna Honda Hospital   TVM Productions 43 HULU 34 Michael Lehmann 3 Kem Nunn 49 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
292 Chance- Season 1 ep103 53 2016 30 350 Santa Ana Ave.   TVM Productions 43 HULU 34 Michael Lehmann 3 Kem Nunn 49 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
293 Chance- Season 1 ep103 53 2016 30 878-898 Chestnut St.   TVM Productions 43 HULU 34 Michael Lehmann 3 Kem Nunn 49 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
294 Chance- Season 1 ep103 53 2016 30 Forrest Hill Muni Station A Muni station agent played himself in this scene. TVM Productions 43 HULU 34 Michael Lehmann 3 Kem Nunn 49 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
295 Chance- Season 1 ep103 53 2016 30 60 Potomac   TVM Productions 43 HULU 34 Michael Lehmann 3 Kem Nunn 49 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
296 Chance- Season 1 ep103 53 2016 30 The Drew School, 2901 California   TVM Productions 43 HULU 34 Michael Lehmann 3 Kem Nunn 49 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
297 Chance- Season 1 ep103 53 2016 30 San Bruno and Alameda   TVM Productions 43 HULU 34 Michael Lehmann 3 Kem Nunn 49 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
298 Chance- Season 1 ep103 53 2016 30 17th and Arkansas   TVM Productions 43 HULU 34 Michael Lehmann 3 Kem Nunn 49 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463

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