Film_Locations_in_San_Francisco

Data source: data.sfgov.org

9 rows where Actor 2 = 53

View and edit SQL

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

CSV options:

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");
Powered by Datasette · Query took 37.014ms · Data source: data.sfgov.org