Film_Locations_in_San_Francisco

6 rows where Title = 15

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Production Company	Distributor	Director	Writer	Actor 1	Actor 2
45	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	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	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	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	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	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

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");