Film_Locations_in_San_Francisco

Data source: data.sfgov.org

15 rows where Production Company = 71

View and edit SQL

Suggested facets: Title, Release Year, Director, Writer, Actor 1, Actor 2

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
563 Getting Even with Dad 103 1994 48 California & Grant Streets   Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Dutch 94 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
564 Getting Even with Dad 103 1994 48 War Memorial Building (401 Van Ness Avenue)   Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
565 Getting Even with Dad 103 1994 48 Transbay Terminal (Mission Street at 1st Street) Built in 1939, the Terminal linked San Francisco, the East Bay, and Sacramento by rail for the first time. Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
566 Getting Even with Dad 103 1994 48 140 Maiden Lane   Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
567 Getting Even with Dad 103 1994 48 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. Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
568 Getting Even with Dad 103 1994 48 Neiman Marcus (150 Stockton Street, Union Square) The City of Paris department store previously occupied the space that now houses Neiman Marcus. City of Paris' original rotunda and glass dome were incorporated into Neiman Marcus' design. Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
569 Getting Even with Dad 103 1994 48 Mason Street at Jackson   Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
570 Getting Even with Dad 103 1994 48 M.H. de Young Memorial Museum (Golden Gate Park)   Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
571 Getting Even with Dad 103 1994 48 Embarcadero Street Station- BART   Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
572 Getting Even with Dad 103 1994 48 Candlestick Park (602 Jamestown Ave.) Then Vice President Richard Nixon threw out the first pitch when Candlestick opened in 1960. On August 29, 1966, The Beatles played their last concert for paying fans at Candlestick Park. Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
612 Golden Gate 107 1994 48 University of California Hastings College of the Law   Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 David Henry Hwang 99 Matt Dillon 312 Joan Chen 86  
617 Greed 109 1924 52 Cliff House (1090 Point Lobos Avenue) In 1887, the Cliff House was severely damaged when the schooner Parallel, abandoned and loaded with dynamite, ran aground on the rocks below. Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Eric von Stroheim  101 Eric von Stroheim  101 Zasu Pitts 313 Gibson Gowland 88 Jean Hersholt 483
618 Greed 109 1924 52 Bush and Sutter Streets   Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Eric von Stroheim  101 Eric von Stroheim  101 Zasu Pitts 313 Gibson Gowland 88 Jean Hersholt 483
619 Greed 109 1924 52 Hayes Street at Laguna   Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Eric von Stroheim  101 Eric von Stroheim  101 Zasu Pitts 313 Gibson Gowland 88 Jean Hersholt 483
1162 Shoot the Moon 216 1982 4 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. Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Alan Parker 178 Bo Goldman 188 Albert Finney 378 Diane Keaton 165  

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