Film_Locations_in_San_Francisco

Data source: data.sfgov.org

7 rows where Writer = 66

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
401 Dawn of the Planet of the Apes 73 2014 11 University Club   Fox Louisiana Productions, LLC 55 Twentieth Century Fox 42 Matt Reeves 67 Rick Jaffa 66 Gary Oldman 290 Keri Russell 55 Andy Serkis 466
402 Dawn of the Planet of the Apes 73 2014 11 Filbert St. from Hyde to Leavenworth   Fox Louisiana Productions, LLC 55 Twentieth Century Fox 42 Matt Reeves 67 Rick Jaffa 66 Gary Oldman 290 Keri Russell 55 Andy Serkis 466
403 Dawn of the Planet of the Apes 73 2014 11 California St from Mason to Kearny   Fox Louisiana Productions, LLC 55 Twentieth Century Fox 42 Matt Reeves 67 Rick Jaffa 66 Gary Oldman 290 Keri Russell 55 Andy Serkis 466
405 Dawn of the Planet of the Apes 73 2014 11 City Hall   Fox Louisiana Productions, LLC 55 Twentieth Century Fox 42 Matt Reeves 67 Rick Jaffa 66 Gary Oldman 290 Keri Russell 55 Andy Serkis 466
406 Dawn of the Planet of the Apes 73 2014 11 Alioto Park   Fox Louisiana Productions, LLC 55 Twentieth Century Fox 42 Matt Reeves 67 Rick Jaffa 66 Gary Oldman 290 Keri Russell 55 Andy Serkis 466
407 Dawn of the Planet of the Apes 73 2014 11 California & Powell   Fox Louisiana Productions, LLC 55 Twentieth Century Fox 42 Matt Reeves 67 Rick Jaffa 66 Gary Oldman 290 Keri Russell 55 Andy Serkis 466
408 Dawn of the Planet of the Apes 73 2014 11 Columbus & Pacific Ave   Fox Louisiana Productions, LLC 55 Twentieth Century Fox 42 Matt Reeves 67 Rick Jaffa 66 Gary Oldman 290 Keri Russell 55 Andy Serkis 466

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