Film_Locations_in_San_Francisco

11 rows where Director = 187

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
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");