Film_Locations_in_San_Francisco

Data source: data.sfgov.org

11 rows where Director = 46

View and edit SQL

Suggested facets: Title, Release Year, Locations, Production Company, Distributor, Writer, Actor 1, Actor 2, Actor 3

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
253 Chan is Missing 48 1982 4 Li Po (916 Grant Avenue at Washington, Chinatown)   New Yorker Films 42 New Yorker Films 33 Wayne Wang 46 Wayne Wang 45 Wood Moy 279 Marc Hayashi 41 Lauren Chew 462
254 Chan is Missing 48 1982 4 Golden Dragon Restaurant (816 Washington Street at Grant)   New Yorker Films 42 New Yorker Films 33 Wayne Wang 46 Wayne Wang 45 Wood Moy 279 Marc Hayashi 41 Lauren Chew 462
411 Dim Sum: A Little Bit of Heart 77 1985 9 San Francisco International Airport SFO has a museum dedicated to aviation history. CIM 58 Orion Classics 44 Wayne Wang 46 Terrel Seltzer 70 Laureen Chew 294 Kim Chew 59 Victor Wong 470
412 Dim Sum: A Little Bit of Heart 77 1985 9 Li Po (916 Grant Avenue at Washington, Chinatown)   CIM 58 Orion Classics 44 Wayne Wang 46 Terrel Seltzer 70 Laureen Chew 294 Kim Chew 59 Victor Wong 470
413 Dim Sum: A Little Bit of Heart 77 1985 9 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. CIM 58 Orion Classics 44 Wayne Wang 46 Terrel Seltzer 70 Laureen Chew 294 Kim Chew 59 Victor Wong 470
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 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 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 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 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 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

CSV options:

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");
Powered by Datasette · Query took 38.563ms · Data source: data.sfgov.org