Film_Locations_in_San_Francisco

5 rows where Actor 2 = 70

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
497	497	Family Plot 90	1976 45	Grace Cathedral Episcopal Church (1100 California Street)	Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral.	Universal Pictures 15	Universal Pictures 41	Alfred Hitchcock 81	Ernest Lehman 83	Karen Black 302	Bruce Dern 70	Barbara Harris 474
498	498	Family Plot 90	1976 45	Fairmont Hotel (950 Mason Street, Nob Hill)	In 1945 the Fairmont hosted the United Nations Conference on International Organization as delegates arrived to draft a charter for the organization. The U.S. Secretary of State, Edward Stettinius drafted the charter in the hotel's Garden Room.	Universal Pictures 15	Universal Pictures 41	Alfred Hitchcock 81	Ernest Lehman 83	Karen Black 302	Bruce Dern 70	Barbara Harris 474
499	499	Family Plot 90	1976 45	2230 Sacramento Street	Called "1001 Franklin" in the film.	Universal Pictures 15	Universal Pictures 41	Alfred Hitchcock 81	Ernest Lehman 83	Karen Black 302	Bruce Dern 70	Barbara Harris 474
500	500	Family Plot 90	1976 45	Nob Hill	Railroad tycoons like Leland Stanford (founder of Stanford University) lived in Nob Hill at the turn of the 20th Century. The 1906 earthquake completely destroyed Nob Hill, with the exception of the wall that surrounded the mansions of Stanford and his neighbor Mark Hopkins.	Universal Pictures 15	Universal Pictures 41	Alfred Hitchcock 81	Ernest Lehman 83	Karen Black 302	Bruce Dern 70	Barbara Harris 474
1433	1433	The Laughing Policeman 264	1973 16			Twentieth Century Fox Film Corporation 13	American Broadcasting Company (ABC) 51	Stuart Rosenberg 219	Thomas Rickman 230	Walter Matthau 408	Bruce Dern 70	Louis Gossett Jr. 538

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