Film_Locations_in_San_Francisco

Data source: data.sfgov.org

7 rows where Actor 1 = 350

View and edit SQL

Suggested facets: Title, Release Year, Production Company, Distributor, Director, Writer, Actor 2, Actor 3

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

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 31.19ms · Data source: data.sfgov.org