sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 17 rows (hide)

Query parameters

This data as json, CSV

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
88 22 18 Ocean Beach On Jan. 25, 1878, the King Philip ship crashed in Ocean Beach. Occasionally, the ship's wreckage may be found on the beach-- most recently it was seen in 2007. 19 15 20 19 255    
374 64 18 San Francisco Public Library Main Branch (100 Larkin Street)   48 6 58 58 216 46  
410 76 18     57 20 70 69 293 58 469
429 79 18 Webster Street   60 45 72 72 3 61  
430 79 18 Telegraph Hill Blvd (Telegraph Hill)   60 45 72 72 3 61  
431 79 18 Larkin & Hyde Streets   60 45 72 72 3 61  
432 79 18 Gabbiano's Restaurant (Ferry Building) Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. 60 45 72 72 3 61  
433 79 18 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. 60 45 72 72 3 61  
434 79 18 2107 Union Street   60 45 72 72 3 61  
435 79 18 2100 Green Street   60 45 72 72 3 61  
661 127 18 Marriot Hotel (55 4th Street at Market)   13 12 118 117 325 103  
1010 187 18 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. 118 41 156 162 265 143  
1011 187 18 Sheraton Palace Hotel (639 Market Street) The hotel was destroyed in the 1906 earthquake and fire, had to be rebuilt, and was reopened in 1909. 118 41 156 162 265 143  
1012 187 18 Presidio (Golden Gate National Recreation Area) In 1776, Spain made the Presidio a fortified area. The area was then given to Mexico, but then given to the US in 1848. The 1994 demilitarization of the area in 1994 marked the end of its 219 years of military use. 118 41 156 162 265 143  
1212 223 18 S.S. Jeremiah O'Brien   137 84 185 194 197 23  
1455 274 18 Administration Building (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. 70 25 225 237 414 210  
1581 299 18 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. 156 110 243 259 265 232  
Powered by Datasette · Query took 2.228ms · Data source: data.sfgov.org