Film_Locations_in_San_Francisco

Data source: data.sfgov.org

4 rows where Actor 2 = 37 and Distributor = 6

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
213 Burglar 43 1987 32 1627 Haight Street   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Hugh Wilson 41 Joseph Loeb III 40 Whoopi Goldberg 274 Bobcat Goldwait 37  
235 Burglar 43 1987 32 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. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Hugh Wilson 41 Joseph Loeb III 40 Whoopi Goldberg 274 Bobcat Goldwait 37  
236 Burglar 43 1987 32 Green Valley Restaurant (510 Green Street Near Grant)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Hugh Wilson 41 Joseph Loeb III 40 Whoopi Goldberg 274 Bobcat Goldwait 37  
237 Burglar 43 1987 32 1400 18th Street   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Hugh Wilson 41 Joseph Loeb III 40 Whoopi Goldberg 274 Bobcat Goldwait 37  

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