Film_Locations_in_San_Francisco

8 rows where Release Year = 41

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
398	398	Dark Passage 72	1947 41	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.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	Delmer Daves 66	Delmer Daves & David Goodis 65	Humphrey Bogart 289	Lauren Bacal 54	Bruce Bennett 465
399	399	Dark Passage 72	1947 41	The Malloch Apartment Building (1360 Montgomery Street)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Delmer Daves 66	Delmer Daves & David Goodis 65	Humphrey Bogart 289	Lauren Bacal 54	Bruce Bennett 465
400	400	Dark Passage 72	1947 41	Filbert Steps, Filbert Street		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Delmer Daves 66	Delmer Daves & David Goodis 65	Humphrey Bogart 289	Lauren Bacal 54	Bruce Bennett 465
993	993	Nora Prentiss 180	1947 41	Belgravia Apartments (795 Sutter Street at Jones)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Vincent Sherman 150	N. Richard Nash 155	Ann Sheridan 350	Kent Smith 137	Bruce Bennett 465
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

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