Film_Locations_in_San_Francisco

Data source: data.sfgov.org

22 rows where Director = 71

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Title, Release Year, Locations, Production Company, Distributor, Writer, Actor 1, Actor 2

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
414 414 Dirty Harry 78 1971 42 Marina Green, Marina District Before the 1906 earthquake, the land on which Marina Green sits was a tidal marsh, and rubble from the earthquake was dumped on the site. However, the site was filled in to provide land for the 1915 Panama-Pacific Exhibition. The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
415 415 Dirty Harry 78 1971 42 Washington Square, North Beach   The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
416 416 Dirty Harry 78 1971 42 The Embarcadero   The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
417 417 Dirty Harry 78 1971 42 St. Peter & Paul's Church (666 Filbert Street, Washington Square) Though Marilyn Monroe and Joe DiMaggio were not allowed to be married at the Church (DiMaggio had married his first wife at the Church but was divorced), the couple returned to the steps of the Church for photos, following their City Hall nuptials. The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
418 418 Dirty Harry 78 1971 42 San Francisco Drydock (20th and Illinois Streets)   The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
419 419 Dirty Harry 78 1971 42 Portsmouth Square (Chinatown) In 1847 the first public school in California was erected on what would become Portsmouth Square. The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
420 420 Dirty Harry 78 1971 42 Mt. Davidson Cross, Mt. Davidson The cross sits at the highest point in San Francisco (938 feet). This version of the cross was erected in 1934.Though in Dirty Harry the cross is lit at night, the City stopped this practice in 1990. The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
421 421 Dirty Harry 78 1971 42 Mission Dolores Park (Mission District) The two land plots that comprise the Park were used as a Jewish cemetery until 1894 when San Francisco prohibited all burials within city limits. The graves were moved to Colma, CA. The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
422 422 Dirty Harry 78 1971 42 Kezar Stadium, Golden Gate Park The stadium was demolished and completely rebuilt after sustaining damages in the 1898 Loma Prieta earthquake. The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
423 423 Dirty Harry 78 1971 42 Holiday Inn Select Downtown Hotel (750 Kearney Street)   The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
424 424 Dirty Harry 78 1971 42 Hall of Justice (850 Bryant Street)   The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
425 425 Dirty Harry 78 1971 42 Forest Hill Station- MUNI   The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
426 426 Dirty Harry 78 1971 42 Dante Building (1606 Stockton Street at Union)   The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
427 427 Dirty Harry 78 1971 42 California Hall (625 Polk Street, Van Ness/Civic Center)   The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
428 428 Dirty Harry 78 1971 42 Bank of America Building (555 California Street) The Bank of America Building was the tallest building on the West Coast from 1969-1972, when it was surpassed by the TransAmerica Pyramid. Today, the Bank of America building is the 5th tallest building on the West Coast. The Malpaso Company 59 Warner Brothers 30 Don Siegel 71 Harry Julian Fink 71 Clint Eastwood 295 Harry Guardino 60  
1434 1434 The Lineup 265 1958 72 War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House. Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
1435 1435 The Lineup 265 1958 72 The Embarcadero   Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
1436 1436 The Lineup 265 1958 72 Sutro Baths (Point Lobos Avenue)   Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
1437 1437 The Lineup 265 1958 72 Steinhart Aquarium (California Academy of Sciences, Golden Gate Park) The Steinhart Aquarium is home to over 38,000 animals, which represent more than 900 species. Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
1438 1438 The Lineup 265 1958 72 Pier 41   Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
1439 1439 The Lineup 265 1958 72 Mark Hopkins Intercontinental Hotel (1 Nob Hill Circle, Nob Hill) The Top of the Mark lounge and restaurant at the top of the hotel was formerly a penthouse suite. Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
1440 1440 The Lineup 265 1958 72 2090 Jackson Street   Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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");
Powered by Datasette · Query took 34.945ms · Data source: data.sfgov.org