Film_Locations_in_San_Francisco

Data source: data.sfgov.org

29 rows where Actor 3 = 527

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
1313 The Dead Pool 242 1988 23 Hall of Justice (850 Bryant Street)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1346 The Dead Pool 242 1988 23 San Francisco Drydock (The Dogpatch)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1347 The Dead Pool 242 1988 23 Washington Square Park (North Beach) Washington Square Park is not actually a square, as it has 5 sides. North Beach is not a beach. The statue in the Park is Ben Franklin, not George Washington. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1348 The Dead Pool 242 1988 23 One Thousand Powell Apartments (1000 Powell Street)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1349 The Dead Pool 242 1988 23 The Cannery (281 Leavenworth Street, Fisherman's Wharf)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1350 The Dead Pool 242 1988 23 Portsmouth Square (Chinatown)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1351 The Dead Pool 242 1988 23 Pierce St. & Golden Gate Avenue (Hayes Valley)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1352 The Dead Pool 242 1988 23 Pierce & California Streets (Pacific Heights)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1353 The Dead Pool 242 1988 23 Pier 3 (The Embarcadero)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1354 The Dead Pool 242 1988 23 New Asia Restaurant (772 Pacific Avenue at Grant)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1355 The Dead Pool 242 1988 23 Nam Yuen Restaurant (740 Washington Street, Chinatown)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1356 The Dead Pool 242 1988 23 Mirant Energy, LLC (1301 Illinois Street, The Dogpatch)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1357 The Dead Pool 242 1988 23 McAllister & Scott Streets (Hayes Valley)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1358 The Dead Pool 242 1988 23 KGO-TV ABC7 TV Studios (900 Front Street, Waterfront Historic District)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1360 The Dead Pool 242 1988 23 San Francisco National Military Cemetery (Lincoln Blvd., The Presidio, Golden Gate National Recreation Center)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1361 The Dead Pool 242 1988 23 Silver Restaurant (737 Washington Street, Chinatown)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1362 The Dead Pool 242 1988 23 Fremont Street Exit of Bay Bridge   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1363 The Dead Pool 242 1988 23 Folsom & Essex Streets   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1364 The Dead Pool 242 1988 23 Eber Electronics (2355 Market Street, Castro)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1365 The Dead Pool 242 1988 23 Clementina & Sumner Streets   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1366 The Dead Pool 242 1988 23 Carl & Cole Streets (Cole Valley)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1367 The Dead Pool 242 1988 23 710 Steiner Street (Hayes Valley)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1368 The Dead Pool 242 1988 23 550 El Camino Del Mar (Seacliff)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1369 The Dead Pool 242 1988 23 23rd & Iowa Streets (Dogpatch)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1370 The Dead Pool 242 1988 23 22nd Bet. Carolina & Rhode Island Streets (Potrero Hill)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1371 The Dead Pool 242 1988 23 22nd & Wisconsin Streets (Potrero Hill)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1372 The Dead Pool 242 1988 23 20th & De Haro Streets (Potrero Hill)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1373 The Dead Pool 242 1988 23 1954 Mason Street (North Beach)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527
1374 The Dead Pool 242 1988 23 San Francisco General Hospital Medical Center (1001 Potrero Avenue, Potrero Hill) SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Buddy Van Horn 199 Harry Julian Fink 71 Clint Eastwood 295 Liam Neeson 186 Patricia Clarkson 527

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 34.615ms · Data source: data.sfgov.org