Film_Locations_in_San_Francisco

Data source: data.sfgov.org

4 rows where Writer = 53

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
323 Chance- Season 1 ep108 57 2016 30 Huntington Park   TVM Productions 43 HULU 34 Peter Elkoff and Victoria Morrow 52 Andrew Bernstein 53 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
325 Chance- Season 1 ep108 57 2016 30 Fairmont Hotel The Fairmont Hotel was featured in many films, including The Rock and the TV series Hotel TVM Productions 43 HULU 34 Peter Elkoff and Victoria Morrow 52 Andrew Bernstein 53 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
326 Chance- Season 1 ep108 57 2016 30 1000 Mason St.   TVM Productions 43 HULU 34 Peter Elkoff and Victoria Morrow 52 Andrew Bernstein 53 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
327 Chance- Season 1 ep108 57 2016 30 St. Mary's Square Park   TVM Productions 43 HULU 34 Peter Elkoff and Victoria Morrow 52 Andrew Bernstein 53 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 39.085ms · Data source: data.sfgov.org