Film_Locations_in_San_Francisco

9 rows where Release Year = 37

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
375	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	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	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
448	448	Dying Young 85	1991 37			Twentieth Century Fox Corporation 63	Twentieth Century Fox Corporation 48	Joel Schumacher 77	Richard Friedenberg 78	Julia Roberts 150	Campbell Scott 66
1161	1161	Shattered 215	1991 37			Capella International 133	Metro-Goldwyn-Mayer 83	Wolfgang Petersen 177	Wolfgang Petersen 187	Tom Berenger 377	Bob Hoskins 164
1225	1225	Star Trek VI: The Undiscovered Country 226	1991 37	Golden Gate Bridge	With 23 miles of ladders and 300,000 rivets in each tower, the Golden Gate Bridge was the world's longest span when it opened in 1937.	Paramount Pictures 4	Paramount Pictures 3	Nicholas Meyer 186	Nimoy 197	William Shatner 383	Leonard Nimoy 171	George Takei 518
1391	1391	The Doctor 253	1991 37			Silver Screen Partners IV 26	Buena Vista Pictures 25	Randa Haines 208	Robert Caswell 220	William Hurt 400	Christine Lahti 194
1392	1392	The Doors 254	1991 37			Bill Graham Films 154	TriStar Pictures 20	Oliver Stone 209	J. Randal Johnson 221	Val Kilmer 401	Meg Ryan 46
1558	1558	Until the End of the World 296	1991 37	Tosca Café (242 Columbus Avenue, North Beach)		Village Roadshow Pictures 172	Warner Bros. Pictures 6	Wim Wenders 241	Wim Wenders 256	Solveig Dommartin 430

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