Film_Locations_in_San_Francisco

9 rows where Actor 2 = 180

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2
1271	1271	Sweet November 235	2001 33	Marquee Lofts (1000 Van Ness Avenue at Alice B. Toklas Place)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Pat O'Connor 193	Paul Yurick 205	Keanu Reeves 391	Charlize Theron 180
1272	1272	Sweet November 235	2001 33	Hotel Majestic (1500 Sutter Street)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Pat O'Connor 193	Paul Yurick 205	Keanu Reeves 391	Charlize Theron 180
1273	1273	Sweet November 235	2001 33	Foote, Cone & Belding (733 Front Street at Pacific)	The building is called "Jabe & Dunne Advertising Agency" in the movie.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	Pat O'Connor 193	Paul Yurick 205	Keanu Reeves 391	Charlize Theron 180
1274	1274	Sweet November 235	2001 33	Farley's Café (1315 18th Street Near Missouri)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Pat O'Connor 193	Paul Yurick 205	Keanu Reeves 391	Charlize Theron 180
1275	1275	Sweet November 235	2001 33	Citicorp Center (1 Sansome Street at Sutter)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Pat O'Connor 193	Paul Yurick 205	Keanu Reeves 391	Charlize Theron 180
1276	1276	Sweet November 235	2001 33	Christopher's Books (1400 18th Street)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Pat O'Connor 193	Paul Yurick 205	Keanu Reeves 391	Charlize Theron 180
1277	1277	Sweet November 235	2001 33	Chrissy Field	Chrissy Field was originally an airfield for the Presidio Army Base.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	Pat O'Connor 193	Paul Yurick 205	Keanu Reeves 391	Charlize Theron 180
1278	1278	Sweet November 235	2001 33	Blooms Saloon (18th Street between Missouri and Texas Streets)		Warner Bros. Pictures 38	Warner Bros. Pictures 6	Pat O'Connor 193	Paul Yurick 205	Keanu Reeves 391	Charlize Theron 180
1279	1279	Sweet November 235	2001 33	Mission Dolores Park (Mission District)	The two land plots that comprise the Park were used as a Jewish cemetery until 1894 when San Francisco prohibited all burials within city limits. The graves were moved to Colma, CA.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	Pat O'Connor 193	Paul Yurick 205	Keanu Reeves 391	Charlize Theron 180

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