Film_Locations_in_San_Francisco

Data source: data.sfgov.org

5 rows where Director = 13

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
40 Age of Adaline 14 2015 10 Pier 50- end of the pier   Lionsgate / Sidney Kimmel Entertainment / Lakeshore Entertainment 11   Lee Toland Krieger 13 J. Mills Goodloe 12 Blake Lively 248 Harrison Ford 12 Ellen Burstyn 442
41 Age of Adaline 14 2015 10 California @ Montgomery   Lionsgate / Sidney Kimmel Entertainment / Lakeshore Entertainment 11   Lee Toland Krieger 13 J. Mills Goodloe 12 Blake Lively 248 Harrison Ford 12 Ellen Burstyn 442
42 Age of Adaline 14 2015 10 Montgomery/Green   Lionsgate / Sidney Kimmel Entertainment / Lakeshore Entertainment 11   Lee Toland Krieger 13 J. Mills Goodloe 12 Blake Lively 248 Harrison Ford 12 Ellen Burstyn 442
43 Age of Adaline 14 2015 10 Driving various SF Streets   Lionsgate / Sidney Kimmel Entertainment / Lakeshore Entertainment 11   Lee Toland Krieger 13 J. Mills Goodloe 12 Blake Lively 248 Harrison Ford 12 Ellen Burstyn 442
44 Age of Adaline 14 2015 10 Plate Shots SF streets various   Lionsgate / Sidney Kimmel Entertainment / Lakeshore Entertainment 11   Lee Toland Krieger 13 J. Mills Goodloe 12 Blake Lively 248 Harrison Ford 12 Ellen Burstyn 442

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