Film_Locations_in_San_Francisco

Data source: data.sfgov.org

4 rows where Actor 1 = 19

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
12 48 Hours 4 1982 4     Paramount Pictures 4 Paramount Pictures 3 Walter Hill 4 Walter Hill 3 Nick Nolte 19 Eddie Murphy 3 Annette O'Toole 440
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

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