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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1487 | 1487 | The Rock 280 | 1996 43 | Palace of Fine Arts (3301 Lyon Street) | The original Palace was built for the 1915 Panama-Pacific Exposition, and completely destroyed in 1964. It was rebuilt in 1965. | Hollywood Pictures 95 | Buena Vista Pictures 25 | Michael Bay 229 | David Weisberg 241 | Sean Connery 107 | Nicolas Cage 216 | |
1488 | 1488 | The Rock 280 | 1996 43 | The San Francisco Bay | Hollywood Pictures 95 | Buena Vista Pictures 25 | Michael Bay 229 | David Weisberg 241 | Sean Connery 107 | Nicolas Cage 216 | ||
1489 | 1489 | The Rock 280 | 1996 43 | New Russian Hill Market (1198 Pacific Avenue at Jones) | Hollywood Pictures 95 | Buena Vista Pictures 25 | Michael Bay 229 | David Weisberg 241 | Sean Connery 107 | Nicolas Cage 216 | ||
1490 | 1490 | The Rock 280 | 1996 43 | 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. | Hollywood Pictures 95 | Buena Vista Pictures 25 | Michael Bay 229 | David Weisberg 241 | Sean Connery 107 | Nicolas Cage 216 | |
1491 | 1491 | The Rock 280 | 1996 43 | Coit Tower | The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way. | Hollywood Pictures 95 | Buena Vista Pictures 25 | Michael Bay 229 | David Weisberg 241 | Sean Connery 107 | Nicolas Cage 216 | |
1492 | 1492 | The Rock 280 | 1996 43 | City Hall | The dome of SF's City Hall is almost a foot taller than that of the US Capitol Building. In 1954, Joe DiMaggio and Marilyn Monroe married at the Beaux Arts-style building. | Hollywood Pictures 95 | Buena Vista Pictures 25 | Michael Bay 229 | David Weisberg 241 | Sean Connery 107 | Nicolas Cage 216 | |
1493 | 1493 | The Rock 280 | 1996 43 | Alcatraz Island | Alcatraz Island was a military fort before it became a prison. | Hollywood Pictures 95 | Buena Vista Pictures 25 | Michael Bay 229 | David Weisberg 241 | Sean Connery 107 | Nicolas Cage 216 |
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");