Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: Title, Release Year, Locations, Fun Facts, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 642 | 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 | 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 | 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 | 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 | 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 |
JSON shape: default, array, newline-delimited
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");