home / sf-film-locations

Film_Locations_in_San_Francisco

Data source: data.sfgov.org

4 rows where Release Year = 70

View and edit SQL

Suggested facets: Fun Facts

Link rowid Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
1420 The House on Telegraph Hill 260 1951 70 Telegraph Hill Largely untouched by the 1906 earthquake, Telegraph Hill has the most pre-1870 buildings in the city. Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Robert Wise 215 Elick Moll 226 Richard Basehart 405 Valentina Cortese 198 William Lundigan 534
1421 The House on Telegraph Hill 260 1951 70 Market Street   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Robert Wise 215 Elick Moll 226 Richard Basehart 405 Valentina Cortese 198 William Lundigan 534
1422 The House on Telegraph Hill 260 1951 70 Coit Tower The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way. Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Robert Wise 215 Elick Moll 226 Richard Basehart 405 Valentina Cortese 198 William Lundigan 534
1423 The House on Telegraph Hill 260 1951 70 1227 Montgomery Street   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Robert Wise 215 Elick Moll 226 Richard Basehart 405 Valentina Cortese 198 William Lundigan 534

Advanced export

JSON shape: default, array

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