Film_Locations_in_San_Francisco

Data source: data.sfgov.org

6 rows where Distributor = 11 sorted by Release Year

View and edit SQL

Link rowid Title Release Year ▼ Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
45 Alcatraz 15 2012 13 Filbert St. from Jones to Mason   Bonanza Productions Inc. 12 Warner Bros. Television 11 J.J. Abrams 14 Steven Lilien 13 Sarah Jones 249 Jorge Garcia 13  
46 Alcatraz 15 2012 13 Leavenworth from Filbert & Francisco St   Bonanza Productions Inc. 12 Warner Bros. Television 11 J.J. Abrams 14 Steven Lilien 13 Sarah Jones 249 Jorge Garcia 13  
47 Alcatraz 15 2012 13 Chestnut St. from Larkin to Columbus   Bonanza Productions Inc. 12 Warner Bros. Television 11 J.J. Abrams 14 Steven Lilien 13 Sarah Jones 249 Jorge Garcia 13  
48 Alcatraz 15 2012 13 Francisco St from Larkin to Polk   Bonanza Productions Inc. 12 Warner Bros. Television 11 J.J. Abrams 14 Steven Lilien 13 Sarah Jones 249 Jorge Garcia 13  
49 Alcatraz 15 2012 13 Broadway from Mason to Taylor   Bonanza Productions Inc. 12 Warner Bros. Television 11 J.J. Abrams 14 Steven Lilien 13 Sarah Jones 249 Jorge Garcia 13  
50 Alcatraz 15 2012 13 Taylor St. from Broadway to Filbert   Bonanza Productions Inc. 12 Warner Bros. Television 11 J.J. Abrams 14 Steven Lilien 13 Sarah Jones 249 Jorge Garcia 13  

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