Film_Locations_in_San_Francisco

Data source: data.sfgov.org

21 rows where Production Company = 15

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Title, Release Year, Locations, Fun Facts, 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
386 386 Crackers 69 1984 40 24th Street between Mission Street and Potrero Avenue   Universal Pictures 15 Universal Pictures 41 Louis Malle 63 Jeffrey Fiskin 62 Donald Sutherland 286 Jack Warden 51 Sean Penn 40
387 387 Crackers 69 1984 40 La Rondalla (Valencia and 20th Streets)   Universal Pictures 15 Universal Pictures 41 Louis Malle 63 Jeffrey Fiskin 62 Donald Sutherland 286 Jack Warden 51 Sean Penn 40
497 497 Family Plot 90 1976 45 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. Universal Pictures 15 Universal Pictures 41 Alfred Hitchcock 81 Ernest Lehman 83 Karen Black 302 Bruce Dern 70 Barbara Harris 474
498 498 Family Plot 90 1976 45 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. Universal Pictures 15 Universal Pictures 41 Alfred Hitchcock 81 Ernest Lehman 83 Karen Black 302 Bruce Dern 70 Barbara Harris 474
499 499 Family Plot 90 1976 45 2230 Sacramento Street Called "1001 Franklin" in the film. Universal Pictures 15 Universal Pictures 41 Alfred Hitchcock 81 Ernest Lehman 83 Karen Black 302 Bruce Dern 70 Barbara Harris 474
500 500 Family Plot 90 1976 45 Nob Hill Railroad tycoons like Leland Stanford (founder of Stanford University) lived in Nob Hill at the turn of the 20th Century. The 1906 earthquake completely destroyed Nob Hill, with the exception of the wall that surrounded the mansions of Stanford and his neighbor Mark Hopkins. Universal Pictures 15 Universal Pictures 41 Alfred Hitchcock 81 Ernest Lehman 83 Karen Black 302 Bruce Dern 70 Barbara Harris 474
629 629 Hard to Hold 114 1984 40 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. Universal Pictures 15 Universal Pictures 41 Larry Peerce 106 Thomas Hedley, Jr.  106 Rick Springfield 317    
633 633 Heart and Souls 116 1993 46 Stockton Tunnel (Stockton Street at Sutter Street) Opened in 1914, the Stockton Tunnel was built to provide North Beach residents access to the thriving downtown area. Universal Pictures 15 Electric Parc 55 Tomas Gislason 108 Tomas Gislason 107 Jorgen Leth 319    
634 634 Heart and Souls 116 1993 46 2810 Pacific Avenue   Universal Pictures 15 Electric Parc 55 Tomas Gislason 108 Tomas Gislason 107 Jorgen Leth 319    
635 635 Heart and Souls 116 1993 46 War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House. Universal Pictures 15 Electric Parc 55 Tomas Gislason 108 Tomas Gislason 107 Jorgen Leth 319    
636 636 Heart and Souls 116 1993 46 Conservatory of Flowers (Golden Gate Park) The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. Universal Pictures 15 Electric Parc 55 Tomas Gislason 108 Tomas Gislason 107 Jorgen Leth 319    
662 662 Hulk 128 2003 38 Telegraph Hill Largely untouched by the 1906 earthquake, Telegraph Hill has the most pre-1870 buildings in the city. Universal Pictures 15 Universal Pictures 41 Ang Lee 119 Stan Lee 118 Eric Bana 326 Jennifer Connelly 104  
663 663 Hulk 128 2003 38 Vallejo Street at Sansome   Universal Pictures 15 Universal Pictures 41 Ang Lee 119 Stan Lee 118 Eric Bana 326 Jennifer Connelly 104  
664 664 Hulk 128 2003 38 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. Universal Pictures 15 Universal Pictures 41 Ang Lee 119 Stan Lee 118 Eric Bana 326 Jennifer Connelly 104  
665 665 Hulk 128 2003 38 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. Universal Pictures 15 Universal Pictures 41 Ang Lee 119 Stan Lee 118 Eric Bana 326 Jennifer Connelly 104  
880 880 Marnie 161 1964 51 On Board the SS President Cleveland, docked at Pier 50   Universal Pictures 15 Universal Pictures 41 Alfred Hitchcock 81 Jay Presson Allen 140 Tippi Hedren 116 Sean Connery 107 Martin Gabel 498
1196 1196 Sneakers 221 1992 22 The Embarcadero   Universal Pictures 15 Universal Pictures 41 Phil Alden Robinson 183 Walter Parkes 192 Sydney Poitier 381 Robert Redford 169  
1197 1197 Sneakers 221 1992 22 Hills Brothers Plaza (The Embarcadero at Harrison)   Universal Pictures 15 Universal Pictures 41 Phil Alden Robinson 183 Walter Parkes 192 Sydney Poitier 381 Robert Redford 169  
1326 1326 The Birds 243 1963 67 Powell and Geary Streets (Union Square) The pet shop featured in the film does not exist, but was based on the now-closed Robison's House of Pets formerly located on Maiden Lane. Universal Pictures 15 Universal Pictures 41 Alfred Hitchcock 81 Evan Hunter 211 Tippi Hedren 116 Suzanne Pleshette 187 Rod Taylor 528

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