Film_Locations_in_San_Francisco

Data source: data.sfgov.org

7 rows where Actor 1 = 434

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
1583 What's Up Doc? 301 1972 62 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. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Peter Bogdanovich 245 Peter Bogdanovich & Buck Henry 261 Barbra Streisand 434 Ryan O'Neal 233  
1584 What's Up Doc? 301 1972 62 San Francisco Hilton (333 O'Farrell Street)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Peter Bogdanovich 245 Peter Bogdanovich & Buck Henry 261 Barbra Streisand 434 Ryan O'Neal 233  
1585 What's Up Doc? 301 1972 62 Lombard Street between Hyde and Leavenworth   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Peter Bogdanovich 245 Peter Bogdanovich & Buck Henry 261 Barbra Streisand 434 Ryan O'Neal 233  
1586 What's Up Doc? 301 1972 62 Hyde Street Pier   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Peter Bogdanovich 245 Peter Bogdanovich & Buck Henry 261 Barbra Streisand 434 Ryan O'Neal 233  
1587 What's Up Doc? 301 1972 62 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Peter Bogdanovich 245 Peter Bogdanovich & Buck Henry 261 Barbra Streisand 434 Ryan O'Neal 233  
1588 What's Up Doc? 301 1972 62 Alta Plaza Park (Steiner Street) The park was originally a rock quarry and served as a campground for many survivors of the 1906 earthquake. The site was converted to a park in 1910. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Peter Bogdanovich 245 Peter Bogdanovich & Buck Henry 261 Barbra Streisand 434 Ryan O'Neal 233  
1589 What's Up Doc? 301 1972 62 22nd Avenue & Balboa Street (Richmond District)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Peter Bogdanovich 245 Peter Bogdanovich & Buck Henry 261 Barbra Streisand 434 Ryan O'Neal 233  

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