Film_Locations_in_San_Francisco

Data source: data.sfgov.org

6 rows where Director = 112

View and edit SQL

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

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
642 Herbie Rides Again 120 1974 49 Castagnola's Restaurant (Fisherman's Wharf)   Walt Disney Productions 82 Buena Vista Distribution 58 Robert Stevenson 112 Bill Walsh 111 Helen Hayes 321 Ken Berry 96 Stefanie Powers 473
643 Herbie Rides Again 120 1974 49 Sheraton Palace Hotel (639 Market Street) The hotel was destroyed in the 1906 earthquake and fire, had to be rebuilt, and was reopened in 1909. Walt Disney Productions 82 Buena Vista Distribution 58 Robert Stevenson 112 Bill Walsh 111 Helen Hayes 321 Ken Berry 96 Stefanie Powers 473
644 Herbie Rides Again 120 1974 49 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. Walt Disney Productions 82 Buena Vista Distribution 58 Robert Stevenson 112 Bill Walsh 111 Helen Hayes 321 Ken Berry 96 Stefanie Powers 473
1441 The Love Bug 266 1968 31 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. Walt Disney Productions 82 Buena Vista Distribution 58 Robert Stevenson 112 Bill Walsh 111 Dean Jones 410 Michele Lee 203 David Tomlinson 540
1442 The Love Bug 266 1968 31 100 Block of Lombard Street Lombard Street is not actually the most crooked in SF. That honor goes to Potrero Hill's Vermont Street between 22nd and 23rd. Walt Disney Productions 82 Buena Vista Distribution 58 Robert Stevenson 112 Bill Walsh 111 Dean Jones 410 Michele Lee 203 David Tomlinson 540
1543 To the Ends of the Earth 291 1948 56     Kennedy-Buckman Pictures 169 Columbia Pictures 4 Robert Stevenson 112 Jay Richard Kennedy 251 Dick Powell 427 Signe Hasso 226 Maylia 547

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