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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1526 | 1526 | Time After Time 289 | 1979 44 | Huntington Park (California & Taylor Streets, Nob Hill) | The mansion of Arabella Huntington, widow of railroad magnate Collis P. Huntington, was destroyed in the 1906 earthquake and fire. Mrs. Huntington the donated the land on which the park now stands to the city. | Orion Pictures Corp. 166 | Columbia Broadcasting System (CBS) 38 | Nicholas Meyer 186 | Karl Alexander 249 | Malcolm McDowell 425 | Mary Steenburgen 224 | David Warner 546 |
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");