Film_Locations_in_San_Francisco

7 rows where Actor 2 = 202 and Director = 71

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
1434	1434	The Lineup 265	1958 72	War Memorial Opera House (401 Van Ness Avenue)	In 1945 the United Nations had its first conference at The War Memorial Opera House.	Pajemer Productions 158	Columbia Pictures 4	Don Siegel 71	Stirling Silliphant 222	Eli Wallach 409	Robert Keith 202	Richard Jaeckel 539
1435	1435	The Lineup 265	1958 72	The Embarcadero		Pajemer Productions 158	Columbia Pictures 4	Don Siegel 71	Stirling Silliphant 222	Eli Wallach 409	Robert Keith 202	Richard Jaeckel 539
1436	1436	The Lineup 265	1958 72	Sutro Baths (Point Lobos Avenue)		Pajemer Productions 158	Columbia Pictures 4	Don Siegel 71	Stirling Silliphant 222	Eli Wallach 409	Robert Keith 202	Richard Jaeckel 539
1437	1437	The Lineup 265	1958 72	Steinhart Aquarium (California Academy of Sciences, Golden Gate Park)	The Steinhart Aquarium is home to over 38,000 animals, which represent more than 900 species.	Pajemer Productions 158	Columbia Pictures 4	Don Siegel 71	Stirling Silliphant 222	Eli Wallach 409	Robert Keith 202	Richard Jaeckel 539
1438	1438	The Lineup 265	1958 72	Pier 41		Pajemer Productions 158	Columbia Pictures 4	Don Siegel 71	Stirling Silliphant 222	Eli Wallach 409	Robert Keith 202	Richard Jaeckel 539
1439	1439	The Lineup 265	1958 72	Mark Hopkins Intercontinental Hotel (1 Nob Hill Circle, Nob Hill)	The Top of the Mark lounge and restaurant at the top of the hotel was formerly a penthouse suite.	Pajemer Productions 158	Columbia Pictures 4	Don Siegel 71	Stirling Silliphant 222	Eli Wallach 409	Robert Keith 202	Richard Jaeckel 539
1440	1440	The Lineup 265	1958 72	2090 Jackson Street		Pajemer Productions 158	Columbia Pictures 4	Don Siegel 71	Stirling Silliphant 222	Eli Wallach 409	Robert Keith 202	Richard Jaeckel 539

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