Film_Locations_in_San_Francisco

Data source: data.sfgov.org

9 rows where Actor 3 = 60

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
1393 The Enforcer 255 1976 45 Sutter & Webster Streets   Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1394 The Enforcer 255 1976 45 Hall of Justice   Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1395 The Enforcer 255 1976 45 Coit Tower The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way. Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1396 The Enforcer 255 1976 45 City Hall The dome of SF's City Hall is almost a foot taller than that of the US Capitol Building. In 1954, Joe DiMaggio and Marilyn Monroe married at the Beaux Arts-style building. Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1397 The Enforcer 255 1976 45 Balmy Street (Mission District)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1398 The Enforcer 255 1976 45 Alcatraz Island Alcatraz Island was a military fort before it became a prison. Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1399 The Enforcer 255 1976 45 24th Street Mini Park (Mission District)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1400 The Enforcer 255 1976 45 23rd & Capp Streets (Mission District)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60
1401 The Enforcer 255 1976 45 Lefty O' Doul Drawbridge/ 3rd Street Bridge (3rd Street, China Basin) This is SF's only drawbridge, and was named after Francis Joseph "Lefty" O'Doul, a local baseball hero. Warner Bros. Pictures 38 Warner Bros. Pictures 6 James Fargo 210 Stirling Silliphant 222 Clint Eastwood 295 Tyne Daly 195 Harry Guardino 60

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 35.266ms · Data source: data.sfgov.org