Film_Locations_in_San_Francisco

9 rows where Production Company = 54

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
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

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