Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: Title, Locations, Fun Facts, Production Company, Distributor, Director, Writer, Actor 1, Actor 2
Link | rowid ▼ | Title | Release Year | Locations | Fun Facts | Production Company | Distributor | Director | Writer | Actor 1 | Actor 2 | Actor 3 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
438 | 438 | Down Periscope 81 | 1996 43 | Twentieth Century Fox Film Corp. 14 | Twentieth Century Fox Film Corp. 13 | David S. Ward 74 | Hugh Wilson 74 | Kelsey Grammar 297 | Lauren Holly 7 | |||
444 | 444 | Dream for an Insomniac 83 | 1996 43 | Baker Beach | From 1986-1990, the north end of Baker Beach was home to the Burning Man festival. | Triton Productions 62 | Columbia TriStar Home Video 47 | Tiffanie DeBartolo 76 | Tiffanie DeBartolo 76 | Ione Skye 298 | Jennifer Aniston 64 | |
445 | 445 | Dream for an Insomniac 83 | 1996 43 | Elbo Room (647 Valencia Street) | This location is called the "Café Blue Eyes" in the film. | Triton Productions 62 | Columbia TriStar Home Video 47 | Tiffanie DeBartolo 76 | Tiffanie DeBartolo 76 | Ione Skye 298 | Jennifer Aniston 64 | |
628 | 628 | Happy Gilmore 113 | 1996 43 | Brillstein-Grey Entertainment 78 | Universal Pictures 41 | Dennis Dugan 105 | Tim Herlihy 105 | Adam Sandler 240 | ||||
658 | 658 | Homeward Bound II: Lost in San Francisco 124 | 1996 43 | Pier 39 (Fisherman's Wharf) | Walt Disney Pictures 70 | Buena Vista Pictures 25 | David R. Ellis 115 | Sheila Burnford 115 | Michael J. Fox 278 | Sally Field 100 | ||
705 | 705 | Jack 137 | 1996 43 | American Zoetrope 92 | Buena Vista Pictures 25 | Francis Ford Coppola 127 | James DeMonaco 127 | Robin Williams 265 | Diane Lane 112 | |||
715 | 715 | James and the Giant Peach 139 | 1996 43 | Skellington Productions 94 | Walt Disney Studios Home Entertainment 62 | Henry Selick 129 | Karey Kirkpatrick 128 | Richard Dreyfuss 252 | Jane Leeves 114 | |||
903 | 903 | Mother 169 | 1996 43 | Golden Gate Bridge | With 23 miles of ladders and 300,000 rivets in each tower, the Golden Gate Bridge was the world's longest span when it opened in 1937. | Paramount Pictures 4 | Paramount Pictures 3 | Albert Brooks 145 | Albert Brooks 148 | Albert Brooks 343 | Debbie Reynolds 130 | |
904 | 904 | Mother 169 | 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. | Paramount Pictures 4 | Paramount Pictures 3 | Albert Brooks 145 | Albert Brooks 148 | Albert Brooks 343 | Debbie Reynolds 130 | |
1022 | 1022 | Phenomenon 190 | 1996 43 | 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. | Touchstone Pictures 104 | Buena Vista Pictures 25 | Jon Turteltaub 159 | Gerald Dipego 164 | John Travolta 359 | Kyra Sedgwick 146 | |
1402 | 1402 | The Fan 256 | 1996 43 | Candlestick Park (602 Jamestown Ave.) | Then Vice President Richard Nixon threw out the first pitch when Candlestick opened in 1960. On August 29, 1966, The Beatles played their last concert for paying fans at Candlestick Park. | Mandalay Entertainment 57 | Columbia TriStar 109 | Tony Scott 211 | Phoef Sutton 223 | Robert De Niro 402 | Wesley Snipes 196 | |
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 | |
1542 | 1542 | Tin Cup 290 | 1996 43 | Regency Enterprises 52 | Warner Bros. Pictures 6 | Ron Shelton 237 | John Norville 250 | Kevin Costner 426 | Rene Russo 225 |
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");