Film_Locations_in_San_Francisco

5 rows where Actor 1 = 331

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
713	713	Jagged Edge 138	1985 9	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.	Columbia Pictures Corp. 93	Columbia Pictures 4	Richard Marquand 128	Joe Eszterhas 24	Glenn Close 331	Jeff Bridges 113	Peter Coyote 446
714	714	Jagged Edge 138	1985 9	City Hall	The dome of SF's City Hall is almost a foot taller than that of the US Capitol Building. In 1954, Joe DiMaggio and Marilyn Monroe married at the Beaux Arts-style building.	Columbia Pictures Corp. 93	Columbia Pictures 4	Richard Marquand 128	Joe Eszterhas 24	Glenn Close 331	Jeff Bridges 113	Peter Coyote 446
881	881	Maxie 162	1985 9	Asian Art Museum (200 Larkin Street, Civic Center)	The Dalai Lama opened an exhibition on Wisdom and Compassion at the museum in 1991.	Elsboy Entertainment 103	Orion Pictures Corporation 56	Paul Aaron 139	Patricia Resnick 141	Glenn Close 331	Mandy Patinkin 125	Ruth Gordon 318
882	882	Maxie 162	1985 9	Grace Cathedral Episcopal Church (1100 California Street)	Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral.	Elsboy Entertainment 103	Orion Pictures Corporation 56	Paul Aaron 139	Patricia Resnick 141	Glenn Close 331	Mandy Patinkin 125	Ruth Gordon 318
883	883	Maxie 162	1985 9	722 Steiner Street (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.	Elsboy Entertainment 103	Orion Pictures Corporation 56	Paul Aaron 139	Patricia Resnick 141	Glenn Close 331	Mandy Patinkin 125	Ruth Gordon 318

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