Film_Locations_in_San_Francisco

4 rows where Director = 47, Release Year = 30 and Title = 49

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
255	255	Chance - Season 1 ep105 49	2016 30	Maiden Lane between Kearny and Grant	TVM Productions 43	HULU 34	Victoria Morrow 47	Roxann Dawson 46	Hugh Laurie 280	Gretchen Mol 42	Ethan Suplee 463
256	256	Chance - Season 1 ep105 49	2016 30	The Drew School, 2901 California	TVM Productions 43	HULU 34	Victoria Morrow 47	Roxann Dawson 46	Hugh Laurie 280	Gretchen Mol 42	Ethan Suplee 463
257	257	Chance - Season 1 ep105 49	2016 30	State Garage, 818 Leavenworth	TVM Productions 43	HULU 34	Victoria Morrow 47	Roxann Dawson 46	Hugh Laurie 280	Gretchen Mol 42	Ethan Suplee 463
258	258	Chance - Season 1 ep105 49	2016 30	60 Leavenworth St.	TVM Productions 43	HULU 34	Victoria Morrow 47	Roxann Dawson 46	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");