Film_Locations_in_San_Francisco

5 rows where Release Year = 17

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2
76	76	Another 48 Hours 21	1990 17			Eddie Murphy Productions 18	Paramount Pictures 3	Walter Hill 4	Walter Hill 3	Eddie Murphy 3	Nick Nolte 19
999	999	Pacific Heights 183	1990 17	Texas & 19th Streets (Potrero Hill)		Morgan Creek Productions 115	Twentieth Century Fox Film Corporation 12	John Schlesinger 152	Daniel Pyne 158	Melanie Griffith 353	Matthew Modine 140
1000	1000	Pacific Heights 183	1990 17	Financial District		Morgan Creek Productions 115	Twentieth Century Fox Film Corporation 12	John Schlesinger 152	Daniel Pyne 158	Melanie Griffith 353	Matthew Modine 140
1001	1001	Pacific Heights 183	1990 17	Chinatown	First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US.	Morgan Creek Productions 115	Twentieth Century Fox Film Corporation 12	John Schlesinger 152	Daniel Pyne 158	Melanie Griffith 353	Matthew Modine 140
1034	1034	Pretty Woman 195	1990 17			Touchstone Pictures 104	Buena Vista Pictures 25	Garry Marshall 27	J.F. Lawton 168	Richard Gere 264	Julia Roberts 150

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