Film_Locations_in_San_Francisco
Data source:
data.sfgov.org
29 rows
where Actor 3 = 527
✎ View and edit SQL
This data as json, CSV (advanced)
Link
|
rowid ▼
|
Title
|
Release Year
|
Locations
|
Fun Facts
|
Production Company
|
Distributor
|
Director
|
Writer
|
Actor 1
|
Actor 2
|
Actor 3
|
1313 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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");