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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
380 | 380 | Copycat 68 | 1995 39 | Treasure Island | An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident. | Regency Enterprises 52 | Warner Bros. Pictures 6 | Jon Amiel 62 | Ann Biderman 61 | Sigourney Weaver 285 | Holly Hunter 50 | |
381 | 381 | Copycat 68 | 1995 39 | Twin Peaks | The 2nd highest point in SF after Mt. Davidson, Twin Peaks sit at the geographic center of SF. The native Ohlone people called the area “Los Pechos de la Chola” or "Breasts of the Indian Maiden," but in the 19th Century when America took over the area, it was renamed "Twin Peaks". | Regency Enterprises 52 | Warner Bros. Pictures 6 | Jon Amiel 62 | Ann Biderman 61 | Sigourney Weaver 285 | Holly Hunter 50 | |
382 | 382 | Copycat 68 | 1995 39 | Sound Factory (1st and Harrison Streets) | Regency Enterprises 52 | Warner Bros. Pictures 6 | Jon Amiel 62 | Ann Biderman 61 | Sigourney Weaver 285 | Holly Hunter 50 | ||
383 | 383 | Copycat 68 | 1995 39 | Java House (Pier 40, Embarcadero) | Regency Enterprises 52 | Warner Bros. Pictures 6 | Jon Amiel 62 | Ann Biderman 61 | Sigourney Weaver 285 | Holly Hunter 50 | ||
384 | 384 | Copycat 68 | 1995 39 | Alta Plaza Park | The park was originally a rock quarry and served as a campground for many survivors of the 1906 earthquake. The site was converted to a park in 1910. | Regency Enterprises 52 | Warner Bros. Pictures 6 | Jon Amiel 62 | Ann Biderman 61 | Sigourney Weaver 285 | Holly Hunter 50 | |
385 | 385 | Copycat 68 | 1995 39 | 82 & 67 Rico Way (Marina District) | Regency Enterprises 52 | Warner Bros. Pictures 6 | Jon Amiel 62 | Ann Biderman 61 | Sigourney Weaver 285 | Holly Hunter 50 |
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");