Film_Locations_in_San_Francisco

7 rows where Production Company = 52

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2
380	380	Copycat 68	1995 39	Treasure Island	An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident.	Regency Enterprises 52	Warner Bros. Pictures 6	Jon Amiel 62	Ann Biderman 61	Sigourney Weaver 285	Holly Hunter 50
381	381	Copycat 68	1995 39	Twin Peaks	The 2nd highest point in SF after Mt. Davidson, Twin Peaks sit at the geographic center of SF. The native Ohlone people called the area “Los Pechos de la Chola” or "Breasts of the Indian Maiden," but in the 19th Century when America took over the area, it was renamed "Twin Peaks".	Regency Enterprises 52	Warner Bros. Pictures 6	Jon Amiel 62	Ann Biderman 61	Sigourney Weaver 285	Holly Hunter 50
382	382	Copycat 68	1995 39	Sound Factory (1st and Harrison Streets)		Regency Enterprises 52	Warner Bros. Pictures 6	Jon Amiel 62	Ann Biderman 61	Sigourney Weaver 285	Holly Hunter 50
383	383	Copycat 68	1995 39	Java House (Pier 40, Embarcadero)		Regency Enterprises 52	Warner Bros. Pictures 6	Jon Amiel 62	Ann Biderman 61	Sigourney Weaver 285	Holly Hunter 50
384	384	Copycat 68	1995 39	Alta Plaza Park	The park was originally a rock quarry and served as a campground for many survivors of the 1906 earthquake. The site was converted to a park in 1910.	Regency Enterprises 52	Warner Bros. Pictures 6	Jon Amiel 62	Ann Biderman 61	Sigourney Weaver 285	Holly Hunter 50
385	385	Copycat 68	1995 39	82 & 67 Rico Way (Marina District)		Regency Enterprises 52	Warner Bros. Pictures 6	Jon Amiel 62	Ann Biderman 61	Sigourney Weaver 285	Holly Hunter 50
1542	1542	Tin Cup 290	1996 43			Regency Enterprises 52	Warner Bros. Pictures 6	Ron Shelton 237	John Norville 250	Kevin Costner 426	Rene Russo 225

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