Film_Locations_in_San_Francisco

6 rows where Director = 46 and Distributor = 63

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
716	716	Joy Luck Club 140	1993 46	Hang Ah Alley (Chinatown)	Hollywood Pictures 95	National Broadcasting Company (NBC) 63	Wayne Wang 46	Amy Tan 129	Kieu Chinh 332	Tsai Chin 115	France Nuyen 493
717	717	Joy Luck Club 140	1993 46	Horace Mann School (3351 23rd Street)	Hollywood Pictures 95	National Broadcasting Company (NBC) 63	Wayne Wang 46	Amy Tan 129	Kieu Chinh 332	Tsai Chin 115	France Nuyen 493
718	718	Joy Luck Club 140	1993 46	901 Union Street	Hollywood Pictures 95	National Broadcasting Company (NBC) 63	Wayne Wang 46	Amy Tan 129	Kieu Chinh 332	Tsai Chin 115	France Nuyen 493
719	719	Joy Luck Club 140	1993 46	610 Rhode Island Street (Potrero Hill)	Hollywood Pictures 95	National Broadcasting Company (NBC) 63	Wayne Wang 46	Amy Tan 129	Kieu Chinh 332	Tsai Chin 115	France Nuyen 493
720	720	Joy Luck Club 140	1993 46	375 Laguna Honda Blvd.	Hollywood Pictures 95	National Broadcasting Company (NBC) 63	Wayne Wang 46	Amy Tan 129	Kieu Chinh 332	Tsai Chin 115	France Nuyen 493
721	721	Joy Luck Club 140	1993 46	180 Manchester Street	Hollywood Pictures 95	National Broadcasting Company (NBC) 63	Wayne Wang 46	Amy Tan 129	Kieu Chinh 332	Tsai Chin 115	France Nuyen 493

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