Film_Locations_in_San_Francisco

Data source: data.sfgov.org

8 rows where Release Year = 34

View and edit SQL

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

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
241 Can't Stop the Music 45 1980 34 101 Henry Adams Place   EMI Films 40 Associated Film Distribution (AFD) 32 Nancy Walker 43 Allan Carr 42 Ray Simpson 276 David Hodo 38 Felipe Rose 460
637 Heart Beat 117 1980 34 San Francisco Art Institute (800 Chestnut Street)   Orion Pictures Corporation 80 Orion Pictures Corporation 56 John Byrum 109 John Byrum 108 Nick Nolte 19 Sissy Spacek 93 John Heard 451
638 Heart Beat 117 1980 34 Washington Square Bar & Grill (1707 Powell)   Orion Pictures Corporation 80 Orion Pictures Corporation 56 John Byrum 109 John Byrum 108 Nick Nolte 19 Sissy Spacek 93 John Heard 451
639 Heart Beat 117 1980 34 City Lights Bookstore (261 Columbus) One of the country's earliest bookstores, City Lights was founded by, and still owned by beat poet Lawrence Ferlinghetti. The bookstore was often frequented by Beat writers like Allen Ginsberg and Jack Kerouac. Orion Pictures Corporation 80 Orion Pictures Corporation 56 John Byrum 109 John Byrum 108 Nick Nolte 19 Sissy Spacek 93 John Heard 451
992 Nine to Five 179 1980 34 Albert S. Samuels Clock (856 Market Street between Powell and Stockton)   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Colin Higgins 90 Colin Higgins 91 Jane Fonda 349 Lily Tomlin 136 Dolly Parton 504
1158 Serial 212 1980 34 Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. Paramount Pictures 4 Paramount Pictures 3 Bill Persky 175 Rich Eustis 184 Martin Mull 375 Tuesday Weld 162  
1332 The Competition 248 1980 34 Pier 39   Columbia Pictures Corporation 5 American Broadcasting Company (ABC) 51 Joel Oliansky 204 Joel Oliansky 215 Richard Dreyfuss 252 Amy Irving 190 Lee Remick 57
1333 The Competition 248 1980 34 California Academy of Sciences (Golden Gate Park) Founded in 1853, 3 years after California joined the United States, the Academy was originally named the California Academy of Natural Sciences and was the first institution of its kind in the United States. Columbia Pictures Corporation 5 American Broadcasting Company (ABC) 51 Joel Oliansky 204 Joel Oliansky 215 Richard Dreyfuss 252 Amy Irving 190 Lee Remick 57

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