Film_Locations_in_San_Francisco

Data source: data.sfgov.org

9 rows where Director = 69, Distributor = 4 and Production Company = 5

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
488 Experiment in Terror 89 1962 29 George Washington High School (600 32nd Avenue )   Columbia Pictures Corporation 5 Columbia Pictures 4 Blake Edwards 69 The Gordons 82 Glenn Ford 301 Lee Remick 57 Stefanie Powers 473
489 Experiment in Terror 89 1962 29 Wells Fargo Bank (1 California Street, Financial District)   Columbia Pictures Corporation 5 Columbia Pictures 4 Blake Edwards 69 The Gordons 82 Glenn Ford 301 Lee Remick 57 Stefanie Powers 473
490 Experiment in Terror 89 1962 29 The Sea Captain's Chest (Fisherman's Wharf)   Columbia Pictures Corporation 5 Columbia Pictures 4 Blake Edwards 69 The Gordons 82 Glenn Ford 301 Lee Remick 57 Stefanie Powers 473
491 Experiment in Terror 89 1962 29 Sheraton Palace Hotel (2 Montgomery Street, Financial District) The hotel was destroyed in the 1906 earthquake and fire, had to be rebuilt, and was reopened in 1909. Columbia Pictures Corporation 5 Columbia Pictures 4 Blake Edwards 69 The Gordons 82 Glenn Ford 301 Lee Remick 57 Stefanie Powers 473
492 Experiment in Terror 89 1962 29 Roaring Twenties Nightclub (555 Broadway at Columbus)   Columbia Pictures Corporation 5 Columbia Pictures 4 Blake Edwards 69 The Gordons 82 Glenn Ford 301 Lee Remick 57 Stefanie Powers 473
493 Experiment in Terror 89 1962 29 Candlestick Park Then Vice President Richard Nixon threw out the first pitch when Candlestick opened in 1960. On August 29, 1966, The Beatles played their last concert for paying fans at Candlestick Park. Columbia Pictures Corporation 5 Columbia Pictures 4 Blake Edwards 69 The Gordons 82 Glenn Ford 301 Lee Remick 57 Stefanie Powers 473
494 Experiment in Terror 89 1962 29 2632 Larkin Street at Lombard   Columbia Pictures Corporation 5 Columbia Pictures 4 Blake Edwards 69 The Gordons 82 Glenn Ford 301 Lee Remick 57 Stefanie Powers 473
495 Experiment in Terror 89 1962 29 100 St. Germain Avenue   Columbia Pictures Corporation 5 Columbia Pictures 4 Blake Edwards 69 The Gordons 82 Glenn Ford 301 Lee Remick 57 Stefanie Powers 473
496 Experiment in Terror 89 1962 29 1 Montgomery Street at Post   Columbia Pictures Corporation 5 Columbia Pictures 4 Blake Edwards 69 The Gordons 82 Glenn Ford 301 Lee Remick 57 Stefanie Powers 473

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