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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
865 | 865 | Magnum Force 160 | 1973 16 | Cost Plus World Market (2552 Taylor Street) | The Malpaso Company 59 | Warner Bros. Pictures 6 | Ted Post 138 | John Milius 139 | Clint Eastwood 295 | Hal Holbrook 124 | Mitchell Ryan 497 | |
866 | 866 | Magnum Force 160 | 1973 16 | Vermont Street between 20th and 22nd Streets | The Malpaso Company 59 | Warner Bros. Pictures 6 | Ted Post 138 | John Milius 139 | Clint Eastwood 295 | Hal Holbrook 124 | Mitchell Ryan 497 | |
867 | 867 | Magnum Force 160 | 1973 16 | San Francisco International Airport | SFO has a museum dedicated to aviation history. | The Malpaso Company 59 | Warner Bros. Pictures 6 | Ted Post 138 | John Milius 139 | Clint Eastwood 295 | Hal Holbrook 124 | Mitchell Ryan 497 |
868 | 868 | Magnum Force 160 | 1973 16 | San Francisco Drydock (20th and Illinois Streets) | The Malpaso Company 59 | Warner Bros. Pictures 6 | Ted Post 138 | John Milius 139 | Clint Eastwood 295 | Hal Holbrook 124 | Mitchell Ryan 497 | |
869 | 869 | Magnum Force 160 | 1973 16 | Pacific Heights Towers (2200 Sacramento Street, Pacific Heights) | The Malpaso Company 59 | Warner Bros. Pictures 6 | Ted Post 138 | John Milius 139 | Clint Eastwood 295 | Hal Holbrook 124 | Mitchell Ryan 497 | |
870 | 870 | Magnum Force 160 | 1973 16 | Lefty O' Doul Drawbridge/ 3rd Street Bridge (3rd Street, China Basin) | This is SF's only drawbridge, and was named after Francis Joseph "Lefty" O'Doul, a local baseball hero. | The Malpaso Company 59 | Warner Bros. Pictures 6 | Ted Post 138 | John Milius 139 | Clint Eastwood 295 | Hal Holbrook 124 | Mitchell Ryan 497 |
871 | 871 | Magnum Force 160 | 1973 16 | Hall of Justice (850 Bryant Street) | The Malpaso Company 59 | Warner Bros. Pictures 6 | Ted Post 138 | John Milius 139 | Clint Eastwood 295 | Hal Holbrook 124 | Mitchell Ryan 497 | |
872 | 872 | Magnum Force 160 | 1973 16 | 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. | The Malpaso Company 59 | Warner Bros. Pictures 6 | Ted Post 138 | John Milius 139 | Clint Eastwood 295 | Hal Holbrook 124 | Mitchell Ryan 497 |
873 | 873 | Magnum Force 160 | 1973 16 | 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. | The Malpaso Company 59 | Warner Bros. Pictures 6 | Ted Post 138 | John Milius 139 | Clint Eastwood 295 | Hal Holbrook 124 | Mitchell Ryan 497 |
874 | 874 | Magnum Force 160 | 1973 16 | Embarcadero Freeway | demolished | The Malpaso Company 59 | Warner Bros. Pictures 6 | Ted Post 138 | John Milius 139 | Clint Eastwood 295 | Hal Holbrook 124 | Mitchell Ryan 497 |
875 | 875 | Magnum Force 160 | 1973 16 | 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. | The Malpaso Company 59 | Warner Bros. Pictures 6 | Ted Post 138 | John Milius 139 | Clint Eastwood 295 | Hal Holbrook 124 | Mitchell Ryan 497 |
876 | 876 | Magnum Force 160 | 1973 16 | Broadway Tunnel (Russian Hill) | The Malpaso Company 59 | Warner Bros. Pictures 6 | Ted Post 138 | John Milius 139 | Clint Eastwood 295 | Hal Holbrook 124 | Mitchell Ryan 497 | |
877 | 877 | Magnum Force 160 | 1973 16 | 280 Freeway at Pennsylvania and Mariposa Streets | The Malpaso Company 59 | Warner Bros. Pictures 6 | Ted Post 138 | John Milius 139 | Clint Eastwood 295 | Hal Holbrook 124 | Mitchell Ryan 497 | |
878 | 878 | Magnum Force 160 | 1973 16 | 2190 Washington Street (Pacific Heights) | The Malpaso Company 59 | Warner Bros. Pictures 6 | Ted Post 138 | John Milius 139 | Clint Eastwood 295 | Hal Holbrook 124 | Mitchell Ryan 497 | |
879 | 879 | Magnum Force 160 | 1973 16 | 18th Street Overpass (Potrero Hill) | The Malpaso Company 59 | Warner Bros. Pictures 6 | Ted Post 138 | John Milius 139 | Clint Eastwood 295 | Hal Holbrook 124 | Mitchell Ryan 497 |
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");