Film_Locations_in_San_Francisco

9 rows where Director = 210 and Distributor = 6

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
1393	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	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	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	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	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	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	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	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	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

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