Film_Locations_in_San_Francisco

14 rows where Release Year = 28

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
142	142	Big Trouble in Little China 35	1986 28			Twentieth Century Fox Film Corporation 13	Twentieth Century Fox Film Corporation 12	John Carpenter 33	Gary Goldman 32	Kurt Russell 267	Kim Catrall 30	James Hong 454
732	732	Kamikaze Hearts 145	1986 28	Market Street Between Noe and Sanchez		Leger/Bashore 98	Facets Multimedia Distribution 66	Juliet Bashore 133	Juliet Bashore 134	Tigr 337	Sharon Mitchell 120
1053	1053	Quicksilver 197	1986 28	Pacific Stock Exchange		Columbia Pictures Corporation 5	Columbia Pictures 4	Thomas Michael Donnelly 164	Thomas Michael Donnelly 170	Kevin Bacon 365	Jami Gertz 152	Paul Rodriguez 511
1214	1214	Star Trek IV: The Voyage Home 225	1986 28	West Harbor, Marina District		Paramount Pictures 4	Paramount Pictures 3	Leonard Nimoy 187	Steve Meerson 196	William Shatner 383	Leonard Nimoy 171	George Takei 518
1215	1215	Star Trek IV: The Voyage Home 225	1986 28	North Beach		Paramount Pictures 4	Paramount Pictures 3	Leonard Nimoy 187	Steve Meerson 196	William Shatner 383	Leonard Nimoy 171	George Takei 518
1216	1216	Star Trek IV: The Voyage Home 225	1986 28	Marina Green, Marina District	Before the 1906 earthquake, the land on which Marina Green sits was a tidal marsh, and rubble from the earthquake was dumped on the site. However, the site was filled in to provide land for the 1915 Panama-Pacific Exhibition.	Paramount Pictures 4	Paramount Pictures 3	Leonard Nimoy 187	Steve Meerson 196	William Shatner 383	Leonard Nimoy 171	George Takei 518
1217	1217	Star Trek IV: The Voyage Home 225	1986 28	Kearny & Pacific Streets		Paramount Pictures 4	Paramount Pictures 3	Leonard Nimoy 187	Steve Meerson 196	William Shatner 383	Leonard Nimoy 171	George Takei 518
1218	1218	Star Trek IV: The Voyage Home 225	1986 28	Intersection of Grant & Fresno Streets (North Beach)		Paramount Pictures 4	Paramount Pictures 3	Leonard Nimoy 187	Steve Meerson 196	William Shatner 383	Leonard Nimoy 171	George Takei 518
1219	1219	Star Trek IV: The Voyage Home 225	1986 28	Intersection of Columbus & Mason Streets		Paramount Pictures 4	Paramount Pictures 3	Leonard Nimoy 187	Steve Meerson 196	William Shatner 383	Leonard Nimoy 171	George Takei 518
1220	1220	Star Trek IV: The Voyage Home 225	1986 28	Intersection of Columbus & Kearney Streets		Paramount Pictures 4	Paramount Pictures 3	Leonard Nimoy 187	Steve Meerson 196	William Shatner 383	Leonard Nimoy 171	George Takei 518
1221	1221	Star Trek IV: The Voyage Home 225	1986 28	Golden Gate Park		Paramount Pictures 4	Paramount Pictures 3	Leonard Nimoy 187	Steve Meerson 196	William Shatner 383	Leonard Nimoy 171	George Takei 518
1222	1222	Star Trek IV: The Voyage Home 225	1986 28	Golden Gate Bridge	With 23 miles of ladders and 300,000 rivets in each tower, the Golden Gate Bridge was the world's longest span when it opened in 1937.	Paramount Pictures 4	Paramount Pictures 3	Leonard Nimoy 187	Steve Meerson 196	William Shatner 383	Leonard Nimoy 171	George Takei 518
1223	1223	Star Trek IV: The Voyage Home 225	1986 28	Bessie Charmichael Elementary School (375 Seventh Street, SOMA)		Paramount Pictures 4	Paramount Pictures 3	Leonard Nimoy 187	Steve Meerson 196	William Shatner 383	Leonard Nimoy 171	George Takei 518
1224	1224	Star Trek IV: The Voyage Home 225	1986 28	500 Block of Pacific Avenue (Chinatown)		Paramount Pictures 4	Paramount Pictures 3	Leonard Nimoy 187	Steve Meerson 196	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");