Film_Locations_in_San_Francisco

2 rows where Production Company = 57

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
410	410	Desperate Measures 76	1998 18			Mandalay Entertainment 57	TriStar Pictures 20	Barbet Schroeder 70	David Klass 69	Michael Keaton 293	Andy Garcia 58	Raven-Symone 469
1402	1402	The Fan 256	1996 43	Candlestick Park (602 Jamestown Ave.)	Then Vice President Richard Nixon threw out the first pitch when Candlestick opened in 1960. On August 29, 1966, The Beatles played their last concert for paying fans at Candlestick Park.	Mandalay Entertainment 57	Columbia TriStar 109	Tony Scott 211	Phoef Sutton 223	Robert De Niro 402	Wesley Snipes 196

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