Film_Locations_in_San_Francisco

Data source: data.sfgov.org

5 rows where Director = 47

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
255 Chance - Season 1 ep105 49 2016 30 Maiden Lane between Kearny and Grant   TVM Productions 43 HULU 34 Victoria Morrow 47 Roxann Dawson 46 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
256 Chance - Season 1 ep105 49 2016 30 The Drew School, 2901 California   TVM Productions 43 HULU 34 Victoria Morrow 47 Roxann Dawson 46 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
257 Chance - Season 1 ep105 49 2016 30 State Garage, 818 Leavenworth   TVM Productions 43 HULU 34 Victoria Morrow 47 Roxann Dawson 46 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
258 Chance - Season 1 ep105 49 2016 30 60 Leavenworth St.   TVM Productions 43 HULU 34 Victoria Morrow 47 Roxann Dawson 46 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
276 Chance - Season 1ep105 51 2016 30 Private alley along 20th St. between Tennessee and Minnesota   TVM Productions 43 HULU 34 Victoria Morrow 47 Roxann Dawson 46 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 28.914ms · Data source: data.sfgov.org