Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | Title | Release Year | Locations | Fun Facts | Production Company | Distributor | Director | Writer | Actor 1 | Actor 2 | Actor 3 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
836 | 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 | 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 | 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 | 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 |
JSON shape: default, array, newline-delimited
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");