Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: Title, Release Year, Production Company, Distributor, Director, Writer, Actor 2
Link | rowid ▼ | Title | Release Year | Locations | Fun Facts | Production Company | Distributor | Director | Writer | Actor 1 | Actor 2 | Actor 3 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
887 | 887 | Milk 166 | 2008 59 | Duboce Park | Focus Features 106 | Focus Features 17 | Gus Van Sant 142 | Dustin Lance Black 145 | Sean Penn 40 | Emile Hirsch 128 | ||
888 | 888 | Milk 166 | 2008 59 | City Hall | The dome of SF's City Hall is almost a foot taller than that of the US Capitol Building. In 1954, Joe DiMaggio and Marilyn Monroe married at the Beaux Arts-style building. | Focus Features 106 | Focus Features 17 | Gus Van Sant 142 | Dustin Lance Black 145 | Sean Penn 40 | Emile Hirsch 128 | |
889 | 889 | Milk 166 | 2008 59 | Chinatown | First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. | Focus Features 106 | Focus Features 17 | Gus Van Sant 142 | Dustin Lance Black 145 | Sean Penn 40 | Emile Hirsch 128 | |
890 | 890 | Milk 166 | 2008 59 | 424 Sansome Street | Focus Features 106 | Focus Features 17 | Gus Van Sant 142 | Dustin Lance Black 145 | Sean Penn 40 | Emile Hirsch 128 | ||
891 | 891 | Milk 166 | 2008 59 | 29th and Dolores Street | Focus Features 106 | Focus Features 17 | Gus Van Sant 142 | Dustin Lance Black 145 | Sean Penn 40 | Emile Hirsch 128 | ||
892 | 892 | Milk 166 | 2008 59 | El Camino Del Mar | Focus Features 106 | Focus Features 17 | Gus Van Sant 142 | Dustin Lance Black 145 | Sean Penn 40 | Emile Hirsch 128 | ||
893 | 893 | Milk 166 | 2008 59 | 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. | Focus Features 106 | Focus Features 17 | Gus Van Sant 142 | Dustin Lance Black 145 | Sean Penn 40 | Emile Hirsch 128 | |
894 | 894 | Milk 166 | 2008 59 | Market & Castro Street | From 1910-1920 the Castro was called "Little Scandinavia" because of its high concentration of residents of Scandinavian ancestry. | Focus Features 106 | Focus Features 17 | Gus Van Sant 142 | Dustin Lance Black 145 | Sean Penn 40 | Emile Hirsch 128 | |
895 | 895 | Milk 166 | 2008 59 | Marine Fireman's Union Headquarters | Focus Features 106 | Focus Features 17 | Gus Van Sant 142 | Dustin Lance Black 145 | Sean Penn 40 | Emile Hirsch 128 | ||
896 | 896 | Milk 166 | 2008 59 | Lower Haight Street | Focus Features 106 | Focus Features 17 | Gus Van Sant 142 | Dustin Lance Black 145 | Sean Penn 40 | Emile Hirsch 128 | ||
898 | 898 | Milk 166 | 2008 59 | Grace Cathedral Episcopal Church (1100 California Street) | Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. | Focus Features 106 | Focus Features 17 | Gus Van Sant 142 | Dustin Lance Black 145 | Sean Penn 40 | Emile Hirsch 128 | |
899 | 899 | Milk 166 | 2008 59 | 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. | Focus Features 106 | Focus Features 17 | Gus Van Sant 142 | Dustin Lance Black 145 | Sean Penn 40 | Emile Hirsch 128 | |
1310 | 1310 | The Assassination of Richard Nixon 240 | 2004 5 | Tosca Café (242 Columbus Avenue, North Beach) | Anhelo Productions 146 | THINKFilm 104 | Niels Mueller 197 | Niels Mueller & Kevin Kennedy 209 | Sean Penn 40 | Naomi Watts 184 | ||
1311 | 1311 | The Assassination of Richard Nixon 240 | 2004 5 | 766 Sutter Street | Anhelo Productions 146 | THINKFilm 104 | Niels Mueller 197 | Niels Mueller & Kevin Kennedy 209 | Sean Penn 40 | Naomi Watts 184 |
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");