Film_Locations_in_San_Francisco

5 rows where Release Year = 4

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
12	12	48 Hours 4	1982 4			Paramount Pictures 4	Paramount Pictures 3	Walter Hill 4	Walter Hill 3	Nick Nolte 19	Eddie Murphy 3	Annette O'Toole 440
253	253	Chan is Missing 48	1982 4	Li Po (916 Grant Avenue at Washington, Chinatown)		New Yorker Films 42	New Yorker Films 33	Wayne Wang 46	Wayne Wang 45	Wood Moy 279	Marc Hayashi 41	Lauren Chew 462
254	254	Chan is Missing 48	1982 4	Golden Dragon Restaurant (816 Washington Street at Grant)		New Yorker Films 42	New Yorker Films 33	Wayne Wang 46	Wayne Wang 45	Wood Moy 279	Marc Hayashi 41	Lauren Chew 462
1162	1162	Shoot the Moon 216	1982 4	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.	Metro-Goldwyn-Mayer (MGM) 71	Metro-Goldwyn-Mayer (MGM) 52	Alan Parker 178	Bo Goldman 188	Albert Finney 378	Diane Keaton 165
1213	1213	Star Trek II : The Wrath of Khan 224	1982 4	Golden Gate Park		Paramount Pictures 4	Paramount Pictures 3	Nicholas Meyer 186	Jack B. Sowards 195	William Shatner 383	Leonard Nimoy 171	George Takei 518

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