Film_Locations_in_San_Francisco

12 rows where Actor 1 = 324

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2
652	652	High Crimes 123	2002 3	391 Pennsylvania Avenue at 19th Street		Twentieth Century Fox Corporation 63	Twentieth Century Fox Corporation 48	Carl Franklin 49	Yuri Zeltser 114	Ashley Judd 324	Morgan Freeman 99
1133	1133	Twisted 209	2004 5	Pier 24		Paramount Pictures 4	Paramount Pictures 3	Philip Kaufman 111	Sarah Thorp 181	Ashley Judd 324	Samuel L. Jackson 160
1547	1547	Twisted 209	2004 5	Red's Java House (Pier 30-32, The Embarcadero)		Paramount Pictures 4	Paramount Pictures 3	Philip Kaufman 111	Sarah Thorp 181	Ashley Judd 324	Samuel L. Jackson 160
1548	1548	Twisted 209	2004 5	Piers 30-32		Paramount Pictures 4	Paramount Pictures 3	Philip Kaufman 111	Sarah Thorp 181	Ashley Judd 324	Samuel L. Jackson 160
1549	1549	Twisted 209	2004 5	Pier 39		Paramount Pictures 4	Paramount Pictures 3	Philip Kaufman 111	Sarah Thorp 181	Ashley Judd 324	Samuel L. Jackson 160
1550	1550	Twisted 209	2004 5	Mojito (1337-1339 Grant Avenue)		Paramount Pictures 4	Paramount Pictures 3	Philip Kaufman 111	Sarah Thorp 181	Ashley Judd 324	Samuel L. Jackson 160
1551	1551	Twisted 209	2004 5	McCovey Point, China Basin Park (24 Willy Mays Plaza)		Paramount Pictures 4	Paramount Pictures 3	Philip Kaufman 111	Sarah Thorp 181	Ashley Judd 324	Samuel L. Jackson 160
1552	1552	Twisted 209	2004 5	Veterans' War Memorial Building (401 Van Ness Avenue)		Paramount Pictures 4	Paramount Pictures 3	Philip Kaufman 111	Sarah Thorp 181	Ashley Judd 324	Samuel L. Jackson 160
1553	1553	Twisted 209	2004 5			Paramount Pictures 4	Paramount Pictures 3	Philip Kaufman 111	Sarah Thorp 181	Ashley Judd 324	Samuel L. Jackson 160
1554	1554	Twisted 209	2004 5	La Bodega (1332 Grant Avenue at Vallejo)		Paramount Pictures 4	Paramount Pictures 3	Philip Kaufman 111	Sarah Thorp 181	Ashley Judd 324	Samuel L. Jackson 160
1555	1555	Twisted 209	2004 5	Vesuvio Café (255 Columbus Avenue)	Jack Kerouac was a regular at the café.	Paramount Pictures 4	Paramount Pictures 3	Philip Kaufman 111	Sarah Thorp 181	Ashley Judd 324	Samuel L. Jackson 160
1556	1556	Twisted 209	2004 5	The Saloon (1232 Grant Avenue)		Paramount Pictures 4	Paramount Pictures 3	Philip Kaufman 111	Sarah Thorp 181	Ashley Judd 324	Samuel L. Jackson 160

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