Film_Locations_in_San_Francisco

14 rows where Release Year = 62

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
1023	1023	Play it Again, Sam 191	1972 62	Balboa at 22nd Avenue		Paramount Pictures 4	Paramount Pictures 3	Herbert Ross 160	Woody Allen 35	Woody Allen 360	Diane Keaton 147	Tony Roberts 507
1024	1024	Play it Again, Sam 191	1972 62	The Music Concourse (Martin Luther King, Jr. Drive, Golden Gate Park)	The theater closed in 1985.	Paramount Pictures 4	Paramount Pictures 3	Herbert Ross 160	Woody Allen 35	Woody Allen 360	Diane Keaton 147	Tony Roberts 507
1025	1025	Play it Again, Sam 191	1972 62	Surf Theater (4520 Irving Street)		Paramount Pictures 4	Paramount Pictures 3	Herbert Ross 160	Woody Allen 35	Woody Allen 360	Diane Keaton 147	Tony Roberts 507
1026	1026	Play it Again, Sam 191	1972 62	Hyde Street Cable Car		Paramount Pictures 4	Paramount Pictures 3	Herbert Ross 160	Woody Allen 35	Woody Allen 360	Diane Keaton 147	Tony Roberts 507
1027	1027	Play it Again, Sam 191	1972 62	Aquatic Park (Jefferson Street)	Located at one end of Fisherman's Wharf, Aquatic Park was built as part of FDR's Works Progress Administration Project.	Paramount Pictures 4	Paramount Pictures 3	Herbert Ross 160	Woody Allen 35	Woody Allen 360	Diane Keaton 147	Tony Roberts 507
1028	1028	Play it Again, Sam 191	1972 62	15-17 Fresno Street		Paramount Pictures 4	Paramount Pictures 3	Herbert Ross 160	Woody Allen 35	Woody Allen 360	Diane Keaton 147	Tony Roberts 507
1331	1331	The Candidate 247	1972 62	Westin St. Francis Hotel (335 Powell Street, Union Square)	The hotel was originally supposed to be named the Crocker Hotel, after Charles Founder the railroad magnate who founded it. However, the hotel took the name the St. Francis after one of the earliest Gold Rush hotels.	Redford-Ritchie Productions 150	Warner Bros. Pictures 6	Michael Ritchie 203	Jeremy Larner 214	Robert Redford 169	Peter Boyle 189
1583	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	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	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	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	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	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	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

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");