Film_Locations_in_San_Francisco

8 rows where Actor 1 = 289

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
398	398	Dark Passage 72	1947 41	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.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	Delmer Daves 66	Delmer Daves & David Goodis 65	Humphrey Bogart 289	Lauren Bacal 54	Bruce Bennett 465
399	399	Dark Passage 72	1947 41	The Malloch Apartment Building (1360 Montgomery Street)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Delmer Daves 66	Delmer Daves & David Goodis 65	Humphrey Bogart 289	Lauren Bacal 54	Bruce Bennett 465
400	400	Dark Passage 72	1947 41	Filbert Steps, Filbert Street		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Delmer Daves 66	Delmer Daves & David Goodis 65	Humphrey Bogart 289	Lauren Bacal 54	Bruce Bennett 465
1328	1328	The Caine Mutiny 245	1954 69	The Embarcadero		Stanley Kramer Productions 113	Columbia Pictures 4	Edward Dmytryk 201	Stanley Roberts 212	Humphrey Bogart 289	Fred MacMurray 188	Jose Ferrer 529
1329	1329	The Caine Mutiny 245	1954 69	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.	Stanley Kramer Productions 113	Columbia Pictures 4	Edward Dmytryk 201	Stanley Roberts 212	Humphrey Bogart 289	Fred MacMurray 188	Jose Ferrer 529
1443	1443	The Maltese Falcon 267	1941 63	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.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	John Huston 220	John Huston 231	Humphrey Bogart 289	Mary Astor 204	Gladys George 541
1444	1444	The Maltese Falcon 267	1941 63	Ferry Building	Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	John Huston 220	John Huston 231	Humphrey Bogart 289	Mary Astor 204	Gladys George 541
1445	1445	The Maltese Falcon 267	1941 63	Burritt Alley (Off Bush Street, between Powell and Stockton Streets)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	John Huston 220	John Huston 231	Humphrey Bogart 289	Mary Astor 204	Gladys George 541

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