Film_Locations_in_San_Francisco

Data source: data.sfgov.org

6 rows where Director = 62 and Distributor = 6

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
380 Copycat 68 1995 39 Treasure Island An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident. Regency Enterprises 52 Warner Bros. Pictures 6 Jon Amiel 62 Ann Biderman 61 Sigourney Weaver 285 Holly Hunter 50  
381 Copycat 68 1995 39 Twin Peaks The 2nd highest point in SF after Mt. Davidson, Twin Peaks sit at the geographic center of SF. The native Ohlone people called the area “Los Pechos de la Chola” or "Breasts of the Indian Maiden," but in the 19th Century when America took over the area, it was renamed "Twin Peaks". Regency Enterprises 52 Warner Bros. Pictures 6 Jon Amiel 62 Ann Biderman 61 Sigourney Weaver 285 Holly Hunter 50  
382 Copycat 68 1995 39 Sound Factory (1st and Harrison Streets)   Regency Enterprises 52 Warner Bros. Pictures 6 Jon Amiel 62 Ann Biderman 61 Sigourney Weaver 285 Holly Hunter 50  
383 Copycat 68 1995 39 Java House (Pier 40, Embarcadero)   Regency Enterprises 52 Warner Bros. Pictures 6 Jon Amiel 62 Ann Biderman 61 Sigourney Weaver 285 Holly Hunter 50  
384 Copycat 68 1995 39 Alta Plaza Park The park was originally a rock quarry and served as a campground for many survivors of the 1906 earthquake. The site was converted to a park in 1910. Regency Enterprises 52 Warner Bros. Pictures 6 Jon Amiel 62 Ann Biderman 61 Sigourney Weaver 285 Holly Hunter 50  
385 Copycat 68 1995 39 82 & 67 Rico Way (Marina District)   Regency Enterprises 52 Warner Bros. Pictures 6 Jon Amiel 62 Ann Biderman 61 Sigourney Weaver 285 Holly Hunter 50  

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