Film_Locations_in_San_Francisco

7 rows where Actor 2 = 55

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
401	401	Dawn of the Planet of the Apes 73	2014 11	University Club	Fox Louisiana Productions, LLC 55	Twentieth Century Fox 42	Matt Reeves 67	Rick Jaffa 66	Gary Oldman 290	Keri Russell 55	Andy Serkis 466
402	402	Dawn of the Planet of the Apes 73	2014 11	Filbert St. from Hyde to Leavenworth	Fox Louisiana Productions, LLC 55	Twentieth Century Fox 42	Matt Reeves 67	Rick Jaffa 66	Gary Oldman 290	Keri Russell 55	Andy Serkis 466
403	403	Dawn of the Planet of the Apes 73	2014 11	California St from Mason to Kearny	Fox Louisiana Productions, LLC 55	Twentieth Century Fox 42	Matt Reeves 67	Rick Jaffa 66	Gary Oldman 290	Keri Russell 55	Andy Serkis 466
405	405	Dawn of the Planet of the Apes 73	2014 11	City Hall	Fox Louisiana Productions, LLC 55	Twentieth Century Fox 42	Matt Reeves 67	Rick Jaffa 66	Gary Oldman 290	Keri Russell 55	Andy Serkis 466
406	406	Dawn of the Planet of the Apes 73	2014 11	Alioto Park	Fox Louisiana Productions, LLC 55	Twentieth Century Fox 42	Matt Reeves 67	Rick Jaffa 66	Gary Oldman 290	Keri Russell 55	Andy Serkis 466
407	407	Dawn of the Planet of the Apes 73	2014 11	California & Powell	Fox Louisiana Productions, LLC 55	Twentieth Century Fox 42	Matt Reeves 67	Rick Jaffa 66	Gary Oldman 290	Keri Russell 55	Andy Serkis 466
408	408	Dawn of the Planet of the Apes 73	2014 11	Columbus & Pacific Ave	Fox Louisiana Productions, LLC 55	Twentieth Century Fox 42	Matt Reeves 67	Rick Jaffa 66	Gary Oldman 290	Keri Russell 55	Andy Serkis 466

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