Film_Locations_in_San_Francisco

Data source: data.sfgov.org

34 rows where Distributor = 13

View and edit SQL

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
55 All About Eve 17 1950 15 Curran Theater (445 Geary Street) Called the Shubert Theatre in the film. Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Joseph L. Mankiewicz 16 Joseph L. Mankiewicz 15 Bette Davis 251 Anne Baxter 15 George Sanders 444
121 Bedazzled 31 2000 25 1155 Filbert Street at Hyde   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Harold Ramis 29 Harold Ramis 28 Brendan Fraser 263 Elizabeth Hurley 27  
122 Bedazzled 31 2000 25 Washington Square Park (Filbert, between Stockton and Powell)   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Harold Ramis 29 Harold Ramis 28 Brendan Fraser 263 Elizabeth Hurley 27  
123 Bedazzled 31 2000 25 Vaillancourt Fountain (Justin Herman Plaza) Installed in 1975, the Vaillancourt Fountain is officially titled, "Québec Libre!". The night before the sculpture's inauguration, artist Armand Vaillancourt inscribed "Québec libre!" in red letters on the sculpture. The next day when he noticed that the note had been erased, Vaillancourt jumped on the statue to re-inscribe his message. Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Harold Ramis 29 Harold Ramis 28 Brendan Fraser 263 Elizabeth Hurley 27  
124 Bedazzled 31 2000 25 Montgomery & Market Streets   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Harold Ramis 29 Harold Ramis 28 Brendan Fraser 263 Elizabeth Hurley 27  
125 Bedazzled 31 2000 25 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. Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Harold Ramis 29 Harold Ramis 28 Brendan Fraser 263 Elizabeth Hurley 27  
375 Class Action 65 1991 37 Mission Dolores (3321 16th Street, Mission District) Mission Dolores' official name is Mission San Francisco de Assis. It is the oldest building in San Francisco, built in 1791, and has survived two major earthquakes. Interscope Communications 49 Twentieth Century Fox Film Corp. 13 Michael Apted 59 Carolyn Shelby 59 Gene Hackman 178 Mary Elizabeth Mastrantonio 47  
376 Class Action 65 1991 37 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. Interscope Communications 49 Twentieth Century Fox Film Corp. 13 Michael Apted 59 Carolyn Shelby 59 Gene Hackman 178 Mary Elizabeth Mastrantonio 47  
377 Class Action 65 1991 37 Bix Restaurant (56 Gold Street)   Interscope Communications 49 Twentieth Century Fox Film Corp. 13 Michael Apted 59 Carolyn Shelby 59 Gene Hackman 178 Mary Elizabeth Mastrantonio 47  
438 Down Periscope 81 1996 43     Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 David S. Ward 74 Hugh Wilson 74 Kelsey Grammar 297 Lauren Holly 7  
439 Dr. Dolittle 2 82 2001 33 West Chrissy Field (Presidio, Golden Gate National Recreation Area) This movie was the first to film in the revamped Chrissy Field Picnic Area. Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Steve Carr 75 Larry Levin 75 Eddie Murphy 3 Kristen Wilson 63  
440 Dr. Dolittle 2 82 2001 33 Sacramento St., Between Pierce & Broderick Streets   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Steve Carr 75 Larry Levin 75 Eddie Murphy 3 Kristen Wilson 63  
441 Dr. Dolittle 2 82 2001 33 Hyde Street & Lombard Street   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Steve Carr 75 Larry Levin 75 Eddie Murphy 3 Kristen Wilson 63  
442 Dr. Dolittle 2 82 2001 33 Building 924, 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. Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Steve Carr 75 Larry Levin 75 Eddie Murphy 3 Kristen Wilson 63  
443 Dr. Dolittle 2 82 2001 33 Broadway, Between Franklin & Laguna Streets   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Steve Carr 75 Larry Levin 75 Eddie Murphy 3 Kristen Wilson 63  
977 Nine Months 178 1995 39 The Malloch Apartment Building (1360 Montgomery Street)   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
978 Nine Months 178 1995 39 Wasteland Store (1600 Haight Street)   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
979 Nine Months 178 1995 39 Star's Café (55 Golden Gate Avenue at Van Ness)   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
980 Nine Months 178 1995 39 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. 1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
981 Nine Months 178 1995 39 San Francisco General Hospital Medical Center (1001 Potrero Avenue, Potrero Hill) SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County. 1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
982 Nine Months 178 1995 39 Pierce Street between Pacific & Green Streets   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
983 Nine Months 178 1995 39 Montgomery & Vallejo Streets   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
984 Nine Months 178 1995 39 Marathon Plaza (303 2nd Street)   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
985 Nine Months 178 1995 39 Jones Street at Bush   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
986 Nine Months 178 1995 39 Jack Kerouac Alley between Columbus & Grant Streets   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
987 Nine Months 178 1995 39 Chrissy Field Chrissy Field was originally an airfield for the Presidio Army Base. 1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
988 Nine Months 178 1995 39 Belli Building (722 Montgomery Street at Washington)   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
989 Nine Months 178 1995 39 Alamo Square   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
990 Nine Months 178 1995 39 60 Spear Street   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
991 Nine Months 178 1995 39 101 Henry Adams Place, 4th Floor   1492 Pictures 29 Twentieth Century Fox Film Corp. 13 Chris Columbus 31 Chris Columbus 154 Hugh Grant 348 Julianne Moore 135 Robin Williams 265
1420 The House on Telegraph Hill 260 1951 70 Telegraph Hill Largely untouched by the 1906 earthquake, Telegraph Hill has the most pre-1870 buildings in the city. Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Robert Wise 215 Elick Moll 226 Richard Basehart 405 Valentina Cortese 198 William Lundigan 534
1421 The House on Telegraph Hill 260 1951 70 Market Street   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Robert Wise 215 Elick Moll 226 Richard Basehart 405 Valentina Cortese 198 William Lundigan 534
1422 The House on Telegraph Hill 260 1951 70 Coit Tower The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way. Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Robert Wise 215 Elick Moll 226 Richard Basehart 405 Valentina Cortese 198 William Lundigan 534
1423 The House on Telegraph Hill 260 1951 70 1227 Montgomery Street   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Robert Wise 215 Elick Moll 226 Richard Basehart 405 Valentina Cortese 198 William Lundigan 534

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