Film_Locations_in_San_Francisco

9 rows where Production Company = 93

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
713	713	Jagged Edge 138	1985 9	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.	Columbia Pictures Corp. 93	Columbia Pictures 4	Richard Marquand 128	Joe Eszterhas 24	Glenn Close 331	Jeff Bridges 113	Peter Coyote 446
714	714	Jagged Edge 138	1985 9	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.	Columbia Pictures Corp. 93	Columbia Pictures 4	Richard Marquand 128	Joe Eszterhas 24	Glenn Close 331	Jeff Bridges 113	Peter Coyote 446
1429	1429	The Lady from Shanghai 263	1947 41	Steinhart Aquarium (California Academy of Sciences, Golden Gate Park)	The Steinhart Aquarium is home to over 38,000 animals, which represent more than 900 species.	Columbia Pictures Corp. 93	Columbia Pictures 4	Orson Welles 218	Orson Welles 229	Rita Hayworth 354	Orson Welles 201	Everett Sloane 537
1430	1430	The Lady from Shanghai 263	1947 41	Mandarin Theatre (1021 Grant Avenue)	The Mandarin Theatre was renamed the Sun Sing Theatre in 1949. It closed 1986.	Columbia Pictures Corp. 93	Columbia Pictures 4	Orson Welles 218	Orson Welles 229	Rita Hayworth 354	Orson Welles 201	Everett Sloane 537
1431	1431	The Lady from Shanghai 263	1947 41	Golden Gate Park	The Playland amusement park where "Hall of Mirrors" sequence at the end of the movie was filmed has since been destroyed. However, relics from the park are now housed at the nearby Cliff House.	Columbia Pictures Corp. 93	Columbia Pictures 4	Orson Welles 218	Orson Welles 229	Rita Hayworth 354	Orson Welles 201	Everett Sloane 537
1432	1432	The Lady from Shanghai 263	1947 41	Former Hall of Justice (750 Kearny Street at Washington)		Columbia Pictures Corp. 93	Columbia Pictures 4	Orson Welles 218	Orson Welles 229	Rita Hayworth 354	Orson Welles 201	Everett Sloane 537
1448	1448	The Net 270	1995 39	Moscone Convention Center		Columbia Pictures Corp. 93	Columbia Pictures 4	Irwin Winkler 223	John Brancato 224	Sandra Bullock 411	Jeremy Northam 207
1449	1449	The Net 270	1995 39	Montgomery & Market Streets		Columbia Pictures Corp. 93	Columbia Pictures 4	Irwin Winkler 223	John Brancato 224	Sandra Bullock 411	Jeremy Northam 207
1494	1494	The Sweetest Thing 281	2002 3	Golden Gate National Recreation Area	The size of the Recreation Area is over two and a half greater than that of the city and county of San Francisco.	Columbia Pictures Corp. 93	Columbia Pictures 4	Roger Kumble 230	Nancy M. Pimental 242	Cameron Diaz 418	Christina Applegate 217

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