Film_Locations_in_San_Francisco

Data source: data.sfgov.org

13 rows where Director = 51

View and edit SQL

Suggested facets: Title

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
316 Chance- Season 1 ep107 56 2016 30 Punjab Café, 838 24th St.   TVM Productions 43 HULU 34 Alexandra Cunningham and Kem Nunn 51 Michael Lehmann 52 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
317 Chance- Season 1 ep107 56 2016 30 60 Potomac   TVM Productions 43 HULU 34 Alexandra Cunningham and Kem Nunn 51 Michael Lehmann 52 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
318 Chance- Season 1 ep107 56 2016 30 Buena Vista betweeen Upper Terrace and Java St.   TVM Productions 43 HULU 34 Alexandra Cunningham and Kem Nunn 51 Michael Lehmann 52 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
319 Chance- Season 1 ep107 56 2016 30 157 Commonwealth   TVM Productions 43 HULU 34 Alexandra Cunningham and Kem Nunn 51 Michael Lehmann 52 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
320 Chance- Season 1 ep107 56 2016 30 1461 Page St.   TVM Productions 43 HULU 34 Alexandra Cunningham and Kem Nunn 51 Michael Lehmann 52 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
321 Chance- Season 1 ep107 56 2016 30 1958 Valencia St.   TVM Productions 43 HULU 34 Alexandra Cunningham and Kem Nunn 51 Michael Lehmann 52 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
322 Chance- Season 1 ep107 56 2016 30 145 Barlett St.   TVM Productions 43 HULU 34 Alexandra Cunningham and Kem Nunn 51 Michael Lehmann 52 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
334 Chance- Season 1 ep110 60 2016 30 San Francisco General Hospital   TVM Productions 43 HULU 34 Alexandra Cunningham and Kem Nunn 51 Michael Lehmann 52 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
335 Chance- Season 1 ep110 60 2016 30 1901 Ocean Ave. at Ashton Ave.   TVM Productions 43 HULU 34 Alexandra Cunningham and Kem Nunn 51 Michael Lehmann 52 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
336 Chance- Season 1 ep110 60 2016 30 1 Urbano   TVM Productions 43 HULU 34 Alexandra Cunningham and Kem Nunn 51 Michael Lehmann 52 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
337 Chance- Season 1 ep110 60 2016 30 18 Urbano   TVM Productions 43 HULU 34 Alexandra Cunningham and Kem Nunn 51 Michael Lehmann 52 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
338 Chance- Season 1 ep110 60 2016 30 Ocean Park Motel   TVM Productions 43 HULU 34 Alexandra Cunningham and Kem Nunn 51 Michael Lehmann 52 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
339 Chance- Season 1 ep110 60 2016 30 Cliffhouse, 1090 Point Lobos Ave.   TVM Productions 43 HULU 34 Alexandra Cunningham and Kem Nunn 51 Michael Lehmann 52 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 33.698ms · Data source: data.sfgov.org