Film_Locations_in_San_Francisco

Data source: data.sfgov.org

4 rows where Actor 3 = 465

View and edit SQL

Suggested facets: Director, Writer, Actor 1, Actor 2

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

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