Film_Locations_in_San_Francisco

7 rows where Actor 2 = 117

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
723	723	Junior 142	1994 48	2552 Hyde Street		Northern Lights Entertainment 67	Universal Pictures 41	Ivan Reitman 84	Kevin Wade 131	Arnold Schwarzenegger 334	Danny DeVito 117	Emma Thompson 494
724	724	Junior 142	1994 48	United Nations Plaza (Civic Center)	United Nations Plaza was built in 1975 and across its walkways are white lines into which the preamble to the preamble of the UN charter is carved.	Northern Lights Entertainment 67	Universal Pictures 41	Ivan Reitman 84	Kevin Wade 131	Arnold Schwarzenegger 334	Danny DeVito 117	Emma Thompson 494
725	725	Junior 142	1994 48	Postcard Row (Alamo Square, Hayes Valley)	The 6 Victorian homes across from Alamo Square Park are among the few Victorians to survive the Great Fire.	Northern Lights Entertainment 67	Universal Pictures 41	Ivan Reitman 84	Kevin Wade 131	Arnold Schwarzenegger 334	Danny DeVito 117	Emma Thompson 494
726	726	Junior 142	1994 48	Hyatt Fisherman's Wharf (555 Northpoint Street)		Northern Lights Entertainment 67	Universal Pictures 41	Ivan Reitman 84	Kevin Wade 131	Arnold Schwarzenegger 334	Danny DeVito 117	Emma Thompson 494
727	727	Junior 142	1994 48	Fairmont Hotel (950 Mason Street, Nob Hill)		Northern Lights Entertainment 67	Universal Pictures 41	Ivan Reitman 84	Kevin Wade 131	Arnold Schwarzenegger 334	Danny DeVito 117	Emma Thompson 494
728	728	Junior 142	1994 48	Chinatown Gate	Designed in 1970, the Chinatown Gate (aka the Dragon Gate) is based on ceremonial gates found in Chinese villages.	Northern Lights Entertainment 67	Universal Pictures 41	Ivan Reitman 84	Kevin Wade 131	Arnold Schwarzenegger 334	Danny DeVito 117	Emma Thompson 494
729	729	Junior 142	1994 48	722 Steiner Street		Northern Lights Entertainment 67	Universal Pictures 41	Ivan Reitman 84	Kevin Wade 131	Arnold Schwarzenegger 334	Danny DeVito 117	Emma Thompson 494

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