Film_Locations_in_San_Francisco

Data source: data.sfgov.org

48 rows where Distributor = 41

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Title, Release Year, Fun Facts, Production Company, 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
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
518 518 Flower Drum Song 96 1961 47 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. Fields Productions 69 Universal Pictures 41 Henry Koster 87 Joseph Fields 88 Nancy Kwan 304 James Shigeta 76 Benson Fong 476
519 519 Flower Drum Song 96 1961 47 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. Fields Productions 69 Universal Pictures 41 Henry Koster 87 Joseph Fields 88 Nancy Kwan 304 James Shigeta 76 Benson Fong 476
628 628 Happy Gilmore 113 1996 43     Brillstein-Grey Entertainment 78 Universal Pictures 41 Dennis Dugan 105 Tim Herlihy 105 Adam Sandler 240    
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    
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  
723 723 Junior 142 1994 48 2552 Hyde Street   Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494
724 724 Junior 142 1994 48 United Nations Plaza (Civic Center) United Nations Plaza was built in 1975 and across its walkways are white lines into which the preamble to the preamble of the UN charter is carved. Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494
725 725 Junior 142 1994 48 Postcard Row (Alamo Square, Hayes Valley) The 6 Victorian homes across from Alamo Square Park are among the few Victorians to survive the Great Fire. Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494
726 726 Junior 142 1994 48 Hyatt Fisherman's Wharf (555 Northpoint Street)   Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494
727 727 Junior 142 1994 48 Fairmont Hotel (950 Mason Street, Nob Hill)   Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494
728 728 Junior 142 1994 48 Chinatown Gate Designed in 1970, the Chinatown Gate (aka the Dragon Gate) is based on ceremonial gates found in Chinese villages. Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494
729 729 Junior 142 1994 48 722 Steiner Street   Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494
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
886 886 Midnight Lace 165 1960 58 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. Arwin Productions 105 Universal Pictures 41 David Miller 141 Ivan Goff 144 Doris Day 341 Rex Harrison 127 John Gavin 500
1010 1010 Patch Adams 187 1998 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. Bungalow 78 Productions 118 Universal Pictures 41 Tom Shadyac 156 Steve Oedekerk 162 Robin Williams 265 Philip Seymour Hoffman 143  
1011 1011 Patch Adams 187 1998 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. Bungalow 78 Productions 118 Universal Pictures 41 Tom Shadyac 156 Steve Oedekerk 162 Robin Williams 265 Philip Seymour Hoffman 143  
1012 1012 Patch Adams 187 1998 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. Bungalow 78 Productions 118 Universal Pictures 41 Tom Shadyac 156 Steve Oedekerk 162 Robin Williams 265 Philip Seymour Hoffman 143  
1070 1070 Raising Cain 199 1992 22     Pacific Western 125 Universal Pictures 41 Brian DePalma 45 Brian DePalma 172 John Lithgow 367    
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  
1226 1226 Steve Jobs 227 2015 10 War Memorial Opera House (401 Van Ness Avenue)   RDF Productions LLC 138 Universal Pictures 41 Danny Boyle 188 Aaron Sorkin 198 Michael Fassbender 384 Kate Winslet 172 Seth Rogen 519
1227 1227 Steve Jobs 227 2015 10 Davies Symphony Hall (201 Van Ness Ave.)   RDF Productions LLC 138 Universal Pictures 41 Danny Boyle 188 Aaron Sorkin 198 Michael Fassbender 384 Kate Winslet 172 Seth Rogen 519
1228 1228 Steve Jobs 227 2015 10 Sutter-Stockton Garage (444 Stockton)   RDF Productions LLC 138 Universal Pictures 41 Danny Boyle 188 Aaron Sorkin 198 Michael Fassbender 384 Kate Winslet 172 Seth Rogen 519
1229 1229 Steve Jobs 227 2015 10 California St. from Jones St. to Mason St.   RDF Productions LLC 138 Universal Pictures 41 Danny Boyle 188 Aaron Sorkin 198 Michael Fassbender 384 Kate Winslet 172 Seth Rogen 519
1230 1230 Steve Jobs 227 2015 10 Powell St. from California St. to Sutter St.   RDF Productions LLC 138 Universal Pictures 41 Danny Boyle 188 Aaron Sorkin 198 Michael Fassbender 384 Kate Winslet 172 Seth Rogen 519
1231 1231 Steve Jobs 227 2015 10 Jackson St. from Mason St. to Powell St.   RDF Productions LLC 138 Universal Pictures 41 Danny Boyle 188 Aaron Sorkin 198 Michael Fassbender 384 Kate Winslet 172 Seth Rogen 519
1232 1232 Steve Jobs 227 2015 10 Intersection of Columbus and Kearny   RDF Productions LLC 138 Universal Pictures 41 Danny Boyle 188 Aaron Sorkin 198 Michael Fassbender 384 Kate Winslet 172 Seth Rogen 519
1233 1233 Steve Jobs 227 2015 10 Intersection of Clay St. and Walter U Lum Plc   RDF Productions LLC 138 Universal Pictures 41 Danny Boyle 188 Aaron Sorkin 198 Michael Fassbender 384 Kate Winslet 172 Seth Rogen 519
1234 1234 Steve Jobs 227 2015 10 Mission St and 5th St   RDF Productions LLC 138 Universal Pictures 41 Danny Boyle 188 Aaron Sorkin 198 Michael Fassbender 384 Kate Winslet 172 Seth Rogen 519
1235 1235 Steve Jobs 227 2015 10 21st and Collingswood St.   RDF Productions LLC 138 Universal Pictures 41 Danny Boyle 188 Aaron Sorkin 198 Michael Fassbender 384 Kate Winslet 172 Seth Rogen 519
1236 1236 Steve Jobs 227 2015 10 Castro St. between 21st an Hill St   RDF Productions LLC 138 Universal Pictures 41 Danny Boyle 188 Aaron Sorkin 198 Michael Fassbender 384 Kate Winslet 172 Seth Rogen 519
1237 1237 Steve Jobs 227 2015 10 21st and Sanchez St   RDF Productions LLC 138 Universal Pictures 41 Danny Boyle 188 Aaron Sorkin 198 Michael Fassbender 384 Kate Winslet 172 Seth Rogen 519
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
1614 1614 Woman on the Run 304 1950 15 Former Hall of Justice (750 Kearny Street at Washington)   Fidelity Pictures Corporation 177 Universal Pictures 41 Norman Foster 247 Norman Foster 263 Ann Sheridan 350 Dennis O'Keefe 235 Robert Keith 202
1615 1615 Woman on the Run 304 1950 15 835-865 Market Street at 5th Street The Emporium, a department store, stood in this location. Bloomingdale's is now located here. Fidelity Pictures Corporation 177 Universal Pictures 41 Norman Foster 247 Norman Foster 263 Ann Sheridan 350 Dennis O'Keefe 235 Robert Keith 202
1616 1616 Woman on the Run 304 1950 15 819 Mason Street at Pine   Fidelity Pictures Corporation 177 Universal Pictures 41 Norman Foster 247 Norman Foster 263 Ann Sheridan 350 Dennis O'Keefe 235 Robert Keith 202
1617 1617 Woman on the Run 304 1950 15 772 Commercial Street at Kearney Called "Man Loh's Oriental Roof Garden" in the film. Fidelity Pictures Corporation 177 Universal Pictures 41 Norman Foster 247 Norman Foster 263 Ann Sheridan 350 Dennis O'Keefe 235 Robert Keith 202
1618 1618 Woman on the Run 304 1950 15 1801 Laguna at Bush   Fidelity Pictures Corporation 177 Universal Pictures 41 Norman Foster 247 Norman Foster 263 Ann Sheridan 350 Dennis O'Keefe 235 Robert Keith 202
1619 1619 Woman on the Run 304 1950 15 Cable Car Signal Box (California Street at Powell Street) SF Cable Cars are the only moving National Historical Landmark. Fidelity Pictures Corporation 177 Universal Pictures 41 Norman Foster 247 Norman Foster 263 Ann Sheridan 350 Dennis O'Keefe 235 Robert Keith 202

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