Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: Title, Release Year, Writer, Actor 1, Actor 2, Actor 3
Link | rowid | Title | Release Year | Locations | Fun Facts | Production Company | Distributor | Director | Writer ▼ | Actor 1 | Actor 2 | Actor 3 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
497 | 497 | Family Plot 90 | 1976 45 | Grace Cathedral Episcopal Church (1100 California Street) | Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. | Universal Pictures 15 | Universal Pictures 41 | Alfred Hitchcock 81 | Ernest Lehman 83 | Karen Black 302 | Bruce Dern 70 | Barbara Harris 474 |
498 | 498 | Family Plot 90 | 1976 45 | Fairmont Hotel (950 Mason Street, Nob Hill) | In 1945 the Fairmont hosted the United Nations Conference on International Organization as delegates arrived to draft a charter for the organization. The U.S. Secretary of State, Edward Stettinius drafted the charter in the hotel's Garden Room. | Universal Pictures 15 | Universal Pictures 41 | Alfred Hitchcock 81 | Ernest Lehman 83 | Karen Black 302 | Bruce Dern 70 | Barbara Harris 474 |
499 | 499 | Family Plot 90 | 1976 45 | 2230 Sacramento Street | Called "1001 Franklin" in the film. | Universal Pictures 15 | Universal Pictures 41 | Alfred Hitchcock 81 | Ernest Lehman 83 | Karen Black 302 | Bruce Dern 70 | Barbara Harris 474 |
500 | 500 | Family Plot 90 | 1976 45 | Nob Hill | Railroad tycoons like Leland Stanford (founder of Stanford University) lived in Nob Hill at the turn of the 20th Century. The 1906 earthquake completely destroyed Nob Hill, with the exception of the wall that surrounded the mansions of Stanford and his neighbor Mark Hopkins. | Universal Pictures 15 | Universal Pictures 41 | Alfred Hitchcock 81 | Ernest Lehman 83 | Karen Black 302 | Bruce Dern 70 | Barbara Harris 474 |
880 | 880 | Marnie 161 | 1964 51 | On Board the SS President Cleveland, docked at Pier 50 | Universal Pictures 15 | Universal Pictures 41 | Alfred Hitchcock 81 | Jay Presson Allen 140 | Tippi Hedren 116 | Sean Connery 107 | Martin Gabel 498 | |
1326 | 1326 | The Birds 243 | 1963 67 | Powell and Geary Streets (Union Square) | The pet shop featured in the film does not exist, but was based on the now-closed Robison's House of Pets formerly located on Maiden Lane. | Universal Pictures 15 | Universal Pictures 41 | Alfred Hitchcock 81 | Evan Hunter 211 | Tippi Hedren 116 | Suzanne Pleshette 187 | Rod Taylor 528 |
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");