Film_Locations_in_San_Francisco

Data source: data.sfgov.org

18 rows where Release Year = 16

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Title, Production Company, Distributor, Director, Writer, Actor 1, Actor 2, Actor 3

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
56 56 American Graffiti 18 1973 16 Mel's Drive-In (Corner of Van Ness & Mission Street, Mission District) This restaurant location was demolished; however another Mel's was reopened in 1986 on 3355 Geary Blvd. Universal Pictures 15 Universal Pictures' 14 George Lucas 17 George Lucas 16 Richard Dreyfuss 252 Ron Howard 16 Paul Le Mat 445
57 57 American Graffiti 18 1973 16 3355 Geary Blvd.   Universal Pictures 15 Universal Pictures' 14 George Lucas 17 George Lucas 16 Richard Dreyfuss 252 Ron Howard 16 Paul Le Mat 445
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
1433 1433 The Laughing Policeman 264 1973 16     Twentieth Century Fox Film Corporation 13 American Broadcasting Company (ABC) 51 Stuart Rosenberg 219 Thomas Rickman 230 Walter Matthau 408 Bruce Dern 70 Louis Gossett Jr. 538

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 35.704ms · Data source: data.sfgov.org