Film_Locations_in_San_Francisco

6 rows where Actor 2 = 42, Release Year = 30 and Title = 60

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
334	334	Chance- Season 1 ep110 60	2016 30	San Francisco General Hospital	TVM Productions 43	HULU 34	Alexandra Cunningham and Kem Nunn 51	Michael Lehmann 52	Hugh Laurie 280	Gretchen Mol 42	Ethan Suplee 463
335	335	Chance- Season 1 ep110 60	2016 30	1901 Ocean Ave. at Ashton Ave.	TVM Productions 43	HULU 34	Alexandra Cunningham and Kem Nunn 51	Michael Lehmann 52	Hugh Laurie 280	Gretchen Mol 42	Ethan Suplee 463
336	336	Chance- Season 1 ep110 60	2016 30	1 Urbano	TVM Productions 43	HULU 34	Alexandra Cunningham and Kem Nunn 51	Michael Lehmann 52	Hugh Laurie 280	Gretchen Mol 42	Ethan Suplee 463
337	337	Chance- Season 1 ep110 60	2016 30	18 Urbano	TVM Productions 43	HULU 34	Alexandra Cunningham and Kem Nunn 51	Michael Lehmann 52	Hugh Laurie 280	Gretchen Mol 42	Ethan Suplee 463
338	338	Chance- Season 1 ep110 60	2016 30	Ocean Park Motel	TVM Productions 43	HULU 34	Alexandra Cunningham and Kem Nunn 51	Michael Lehmann 52	Hugh Laurie 280	Gretchen Mol 42	Ethan Suplee 463
339	339	Chance- Season 1 ep110 60	2016 30	Cliffhouse, 1090 Point Lobos Ave.	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");