Film_Locations_in_San_Francisco

Data source: data.sfgov.org

9 rows where Director = 95 and Writer = 95

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
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  

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