Film_Locations_in_San_Francisco

7 rows where Title = 56

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
316	316	Chance- Season 1 ep107 56	2016 30	Punjab Café, 838 24th St.	TVM Productions 43	HULU 34	Alexandra Cunningham and Kem Nunn 51	Michael Lehmann 52	Hugh Laurie 280	Gretchen Mol 42	Ethan Suplee 463
317	317	Chance- Season 1 ep107 56	2016 30	60 Potomac	TVM Productions 43	HULU 34	Alexandra Cunningham and Kem Nunn 51	Michael Lehmann 52	Hugh Laurie 280	Gretchen Mol 42	Ethan Suplee 463
318	318	Chance- Season 1 ep107 56	2016 30	Buena Vista betweeen Upper Terrace and Java St.	TVM Productions 43	HULU 34	Alexandra Cunningham and Kem Nunn 51	Michael Lehmann 52	Hugh Laurie 280	Gretchen Mol 42	Ethan Suplee 463
319	319	Chance- Season 1 ep107 56	2016 30	157 Commonwealth	TVM Productions 43	HULU 34	Alexandra Cunningham and Kem Nunn 51	Michael Lehmann 52	Hugh Laurie 280	Gretchen Mol 42	Ethan Suplee 463
320	320	Chance- Season 1 ep107 56	2016 30	1461 Page St.	TVM Productions 43	HULU 34	Alexandra Cunningham and Kem Nunn 51	Michael Lehmann 52	Hugh Laurie 280	Gretchen Mol 42	Ethan Suplee 463
321	321	Chance- Season 1 ep107 56	2016 30	1958 Valencia St.	TVM Productions 43	HULU 34	Alexandra Cunningham and Kem Nunn 51	Michael Lehmann 52	Hugh Laurie 280	Gretchen Mol 42	Ethan Suplee 463
322	322	Chance- Season 1 ep107 56	2016 30	145 Barlett St.	TVM Productions 43	HULU 34	Alexandra Cunningham and Kem Nunn 51	Michael Lehmann 52	Hugh Laurie 280	Gretchen Mol 42	Ethan Suplee 463

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