Film_Locations_in_San_Francisco

Data source: data.sfgov.org

4 rows where Director = 99 and Title = 107

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
611 Golden Gate 107 1994 48 Ross Alley (Chinatown) Ross Alley is the oldest alley in San Francisco. American Playhouse Theatrical Films 75 The Samuel Goldwyn Company 54 John Madden 99 David Henry Hwang 99 Matt Dillon 312 Joan Chen 86  
613 Golden Gate 107 1994 48 Bush Street (between Grant & Kearny Streets)   American Playhouse Theatrical Films 75 The Samuel Goldwyn Company 54 John Madden 99 David Henry Hwang 99 Matt Dillon 312 Joan Chen 86  
614 Golden Gate 107 1994 48 Buena Vista Park (Haight Street at Buena Vista) Established in 1867, Buena Vista Park is the oldest official park in San Francisco. American Playhouse Theatrical Films 75 The Samuel Goldwyn Company 54 John Madden 99 David Henry Hwang 99 Matt Dillon 312 Joan Chen 86  
615 Golden Gate 107 1994 48 Golden Gate Bridge With 23 miles of ladders and 300,000 rivets in each tower, the Golden Gate Bridge was the world's longest span when it opened in 1937. American Playhouse Theatrical Films 75 The Samuel Goldwyn Company 54 John Madden 99 David Henry Hwang 99 Matt Dillon 312 Joan Chen 86  

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 35.981ms · Data source: data.sfgov.org