Film_Locations_in_San_Francisco

6 rows where Director = 54

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
328	328	Chance- Season 1 ep109 59	2016 30	Terry A. Francois Blvd.		TVM Productions 43	HULU 34	Sara Gran and Pete Begler 54	Dan Attias 51	Hugh Laurie 280	Gretchen Mol 42	Ethan Suplee 463
329	329	Chance- Season 1 ep109 59	2016 30	2 Rowland		TVM Productions 43	HULU 34	Sara Gran and Pete Begler 54	Dan Attias 51	Hugh Laurie 280	Gretchen Mol 42	Ethan Suplee 463
330	330	Chance- Season 1 ep109 59	2016 30	Ocean Park Motel		TVM Productions 43	HULU 34	Sara Gran and Pete Begler 54	Dan Attias 51	Hugh Laurie 280	Gretchen Mol 42	Ethan Suplee 463
331	331	Chance- Season 1 ep109 59	2016 30	Cliffhouse, 1090 Point Lobos Ave.		TVM Productions 43	HULU 34	Sara Gran and Pete Begler 54	Dan Attias 51	Hugh Laurie 280	Gretchen Mol 42	Ethan Suplee 463
332	332	Chance- Season 1 ep109 59	2016 30	850 Bryant- 6th floor County Jail	The former County Jail on the 6th floor was re-created to resemble a Mexican jail for the scene	TVM Productions 43	HULU 34	Sara Gran and Pete Begler 54	Dan Attias 51	Hugh Laurie 280	Gretchen Mol 42	Ethan Suplee 463
333	333	Chance- Season 1 ep109 59	2016 30	60 Leavenworth St.		TVM Productions 43	HULU 34	Sara Gran and Pete Begler 54	Dan Attias 51	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");