Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | Title | Release Year | Locations | Fun Facts | Production Company | Distributor | Director | Writer | Actor 1 | Actor 2 | Actor 3 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
504 | 504 | Fearless 94 | 1993 46 | 400 Montgomery Street | Spring Creek Productions 68 | Warner Bros. Pictures 6 | Peter Weir 85 | Rafael Yglesias 86 | Jeff Bridges 113 | Isabella Rosellini 74 | Rosie Perez 475 | |
505 | 505 | Fearless 94 | 1993 46 | Folsom Street & Embarcadero | Spring Creek Productions 68 | Warner Bros. Pictures 6 | Peter Weir 85 | Rafael Yglesias 86 | Jeff Bridges 113 | Isabella Rosellini 74 | Rosie Perez 475 | |
506 | 506 | Fearless 94 | 1993 46 | Varennes Alley between Filbert and Union | Spring Creek Productions 68 | Warner Bros. Pictures 6 | Peter Weir 85 | Rafael Yglesias 86 | Jeff Bridges 113 | Isabella Rosellini 74 | Rosie Perez 475 | |
507 | 507 | Fearless 94 | 1993 46 | St. Peter & Paul's Church (666 Filbert Street, Washington Square) | Though Marilyn Monroe and Joe DiMaggio were not allowed to be married at the Church (DiMaggio had married his first wife at the Church but was divorced), the couple returned to the steps of the Church for photos, following their City Hall nuptials. | Spring Creek Productions 68 | Warner Bros. Pictures 6 | Peter Weir 85 | Rafael Yglesias 86 | Jeff Bridges 113 | Isabella Rosellini 74 | Rosie Perez 475 |
508 | 508 | Fearless 94 | 1993 46 | San Francisco General Hospital Medical Center (1001 Potrero Avenue, Potrero Hill) | SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County. | Spring Creek Productions 68 | Warner Bros. Pictures 6 | Peter Weir 85 | Rafael Yglesias 86 | Jeff Bridges 113 | Isabella Rosellini 74 | Rosie Perez 475 |
509 | 509 | Fearless 94 | 1993 46 | Kohl Building (400 Montgomery Street) | Spring Creek Productions 68 | Warner Bros. Pictures 6 | Peter Weir 85 | Rafael Yglesias 86 | Jeff Bridges 113 | Isabella Rosellini 74 | Rosie Perez 475 | |
510 | 510 | Fearless 94 | 1993 46 | Bank of America Building (555 California Street) | The Bank of America Building was the tallest building on the West Coast from 1969-1972, when it was surpassed by the TransAmerica Pyramid. Today, the Bank of America building is the 5th tallest building on the West Coast. | Spring Creek Productions 68 | Warner Bros. Pictures 6 | Peter Weir 85 | Rafael Yglesias 86 | Jeff Bridges 113 | Isabella Rosellini 74 | Rosie Perez 475 |
511 | 511 | Fearless 94 | 1993 46 | 90 Gold Street | Spring Creek Productions 68 | Warner Bros. Pictures 6 | Peter Weir 85 | Rafael Yglesias 86 | Jeff Bridges 113 | Isabella Rosellini 74 | Rosie Perez 475 | |
512 | 512 | Fearless 94 | 1993 46 | 5th and Beale Streets | Spring Creek Productions 68 | Warner Bros. Pictures 6 | Peter Weir 85 | Rafael Yglesias 86 | Jeff Bridges 113 | Isabella Rosellini 74 | Rosie Perez 475 |
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");