Film_Locations_in_San_Francisco

Data source: data.sfgov.org

4 rows where Title = 155

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
836 Looking Season 2 ep 207 155 2015 10 770 Haight Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
837 Looking Season 2 ep 207 155 2015 10 Delores Park   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
838 Looking Season 2 ep 207 155 2015 10 Valenti, Marini, Perata, 4840 Mission Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
839 Looking Season 2 ep 207 155 2015 10 Sparky's Diner, 242 Church Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496

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