Film_Locations_in_San_Francisco

16 rows where Release Year = 15

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
55	55	All About Eve 17	1950 15	Curran Theater (445 Geary Street)	Called the Shubert Theatre in the film.	Twentieth Century Fox Film Corp. 14	Twentieth Century Fox Film Corp. 13	Joseph L. Mankiewicz 16	Joseph L. Mankiewicz 15	Bette Davis 251	Anne Baxter 15	George Sanders 444
389	389	D.O.A 71	1950 15	Powell & California Streets		Cardinal Pictures 54	United Artists 19	Rudolph Mate 65	Russell Rouse 64	Edmond O'Brien 288	Pamela Britton 53	Luther Adler 464
390	390	D.O.A 71	1950 15	Southern Pacific Memorial Hospital (1400 Fell Street)		Cardinal Pictures 54	United Artists 19	Rudolph Mate 65	Russell Rouse 64	Edmond O'Brien 288	Pamela Britton 53	Luther Adler 464
391	391	D.O.A 71	1950 15	The Embarcadero/ Ferry Building	Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters.	Cardinal Pictures 54	United Artists 19	Rudolph Mate 65	Russell Rouse 64	Edmond O'Brien 288	Pamela Britton 53	Luther Adler 464
392	392	D.O.A 71	1950 15	Union Square	During the Civil War, pro-Union rallies were held in the Square, and thus the area was called "Union Square".	Cardinal Pictures 54	United Artists 19	Rudolph Mate 65	Russell Rouse 64	Edmond O'Brien 288	Pamela Britton 53	Luther Adler 464
393	393	D.O.A 71	1950 15	Westin St. Francis Hotel (335 Powell Street)	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.	Cardinal Pictures 54	United Artists 19	Rudolph Mate 65	Russell Rouse 64	Edmond O'Brien 288	Pamela Britton 53	Luther Adler 464
394	394	D.O.A 71	1950 15	Chambord Apartments (1298 Sacramento Street at Jones)		Cardinal Pictures 54	United Artists 19	Rudolph Mate 65	Russell Rouse 64	Edmond O'Brien 288	Pamela Britton 53	Luther Adler 464
395	395	D.O.A 71	1950 15	Mark Hopkins Intercontinental Hotel (1 Nob Hill Circle)	The Top of the Mark lounge and restaurant at the top of the hotel was formerly a penthouse suite.	Cardinal Pictures 54	United Artists 19	Rudolph Mate 65	Russell Rouse 64	Edmond O'Brien 288	Pamela Britton 53	Luther Adler 464
396	396	D.O.A 71	1950 15	Market & Steuart Streets (Financial District)		Cardinal Pictures 54	United Artists 19	Rudolph Mate 65	Russell Rouse 64	Edmond O'Brien 288	Pamela Britton 53	Luther Adler 464
397	397	D.O.A 71	1950 15	Market Street (from 6th- 4th Streets)		Cardinal Pictures 54	United Artists 19	Rudolph Mate 65	Russell Rouse 64	Edmond O'Brien 288	Pamela Britton 53	Luther Adler 464
1614	1614	Woman on the Run 304	1950 15	Former Hall of Justice (750 Kearny Street at Washington)		Fidelity Pictures Corporation 177	Universal Pictures 41	Norman Foster 247	Norman Foster 263	Ann Sheridan 350	Dennis O'Keefe 235	Robert Keith 202
1615	1615	Woman on the Run 304	1950 15	835-865 Market Street at 5th Street	The Emporium, a department store, stood in this location. Bloomingdale's is now located here.	Fidelity Pictures Corporation 177	Universal Pictures 41	Norman Foster 247	Norman Foster 263	Ann Sheridan 350	Dennis O'Keefe 235	Robert Keith 202
1616	1616	Woman on the Run 304	1950 15	819 Mason Street at Pine		Fidelity Pictures Corporation 177	Universal Pictures 41	Norman Foster 247	Norman Foster 263	Ann Sheridan 350	Dennis O'Keefe 235	Robert Keith 202
1617	1617	Woman on the Run 304	1950 15	772 Commercial Street at Kearney	Called "Man Loh's Oriental Roof Garden" in the film.	Fidelity Pictures Corporation 177	Universal Pictures 41	Norman Foster 247	Norman Foster 263	Ann Sheridan 350	Dennis O'Keefe 235	Robert Keith 202
1618	1618	Woman on the Run 304	1950 15	1801 Laguna at Bush		Fidelity Pictures Corporation 177	Universal Pictures 41	Norman Foster 247	Norman Foster 263	Ann Sheridan 350	Dennis O'Keefe 235	Robert Keith 202
1619	1619	Woman on the Run 304	1950 15	Cable Car Signal Box (California Street at Powell Street)	SF Cable Cars are the only moving National Historical Landmark.	Fidelity Pictures Corporation 177	Universal Pictures 41	Norman Foster 247	Norman Foster 263	Ann Sheridan 350	Dennis O'Keefe 235	Robert Keith 202

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