Data source: data.sfgov.org
This data as json, CSV (advanced)
Actor 3 ✖
Link | rowid | Title | Release Year | Locations | Fun Facts ▼ | Production Company | Distributor | Director | Writer | Actor 1 | Actor 2 | Actor 3 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1608 | 1608 | When We Rise 303 | 2017 20 | Buena Vista Park | Film 49 Productions 176 | Amercian Broadcasting Company 119 | Gus Van Sant 142 | Dustin Lance Black 145 | Guy Pierce 435 | Mary-Louise Parker 234 | Michael Kenneth Williams 550 | |
1609 | 1609 | When We Rise 303 | 2017 20 | Haight St. at Central | Film 49 Productions 176 | Amercian Broadcasting Company 119 | Gus Van Sant 142 | Dustin Lance Black 145 | Guy Pierce 435 | Mary-Louise Parker 234 | Michael Kenneth Williams 550 | |
1610 | 1610 | When We Rise 303 | 2017 20 | Eureka Arts Center, 4400 20th St. | Film 49 Productions 176 | Amercian Broadcasting Company 119 | Gus Van Sant 142 | Dustin Lance Black 145 | Guy Pierce 435 | Mary-Louise Parker 234 | Michael Kenneth Williams 550 | |
1611 | 1611 | When We Rise 303 | 2017 20 | Castro St. between 17th and 18th St. | Film 49 Productions 176 | Amercian Broadcasting Company 119 | Gus Van Sant 142 | Dustin Lance Black 145 | Guy Pierce 435 | Mary-Louise Parker 234 | Michael Kenneth Williams 550 | |
1612 | 1612 | When We Rise 303 | 2017 20 | 426 Castro St. | Film 49 Productions 176 | Amercian Broadcasting Company 119 | Gus Van Sant 142 | Dustin Lance Black 145 | Guy Pierce 435 | Mary-Louise Parker 234 | Michael Kenneth Williams 550 | |
1613 | 1613 | When We Rise 303 | 2017 20 | Powell St. at Market St. | Film 49 Productions 176 | Amercian Broadcasting Company 119 | Gus Van Sant 142 | Dustin Lance Black 145 | Guy Pierce 435 | Mary-Louise Parker 234 | Michael Kenneth Williams 550 | |
573 | 573 | GirlBoss 104 | 2017 20 | Mission Dolores Park, 19th St. & Dolores St. | After the devastating earthquake of 1906, the park served as a refugee camp for more than 1600 families who lost their home in the disaster. | Hippolyta Productions, LLC 72 | Netflix 53 | Jamie Babbit, Amanda Brotchie, Steven K. Tsuchida, Christian Ditter, John Riggi 96 | Kay Cannon 96 | Britt Robertson 309 | Ellie Reed 84 | Amanda Rea 480 |
590 | 590 | GirlBoss 104 | 2017 20 | Musee Mecanique, Fisherman's Wharf | An interactive museum consisting of 20th century penny arcade games and artifacts. | Hippolyta Productions, LLC 72 | Netflix 53 | Jamie Babbit, Amanda Brotchie, Steven K. Tsuchida, Christian Ditter, John Riggi 96 | Kay Cannon 96 | Britt Robertson 309 | Ellie Reed 84 | Amanda Rea 480 |
466 | 466 | Etruscan Smile 88 | 2017 20 | Legion of Honor, 100 34th Ave | California Palace of the Legion of Honor was completed in 1924, and on Armistice Day of that year the doors opened to the public. In keeping with the wishes of the donors, to “honor the dead while serving the living,” it was accepted by the city of San Francisco as a museum of fine arts dedicated to the memory of the 3,600 California men who had lost their lives on the battlefields of France during World War I. | Po Valley Productions, LLC 65 | TBD 43 | Oded Binnun/ Michel Brezis 80 | Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 | Brian Cox 300 | Roseanne Arquette 69 | Thora Birch 472 |
1598 | 1598 | When We Rise 303 | 2017 20 | City Hall | Exterior scenes include re-creating the White Night Riots on May 21, 1979 and the Gay Freedom March. Interior scenes included the wedding ceremony for Roma and Diane which had a few Board of Supervisors in the ceremony. The current Clerk for the Board of Supervisors played herself in one of the scenes filmed in the Chambers. | Film 49 Productions 176 | Amercian Broadcasting Company 119 | Gus Van Sant 142 | Dustin Lance Black 145 | Guy Pierce 435 | Mary-Louise Parker 234 | Michael Kenneth Williams 550 |
1607 | 1607 | When We Rise 303 | 2017 20 | Women's Building, 3543 18th St. | Roma Guy was one of the founders of the Women's Building | Film 49 Productions 176 | Amercian Broadcasting Company 119 | Gus Van Sant 142 | Dustin Lance Black 145 | Guy Pierce 435 | Mary-Louise Parker 234 | Michael Kenneth Williams 550 |
479 | 479 | Etruscan Smile 88 | 2017 20 | Bentley Reserve, 301 Battery Street | The Bentley Reserve is the former San Francisco Federal Reserve. Designed by architect George W. Kelham and completed in 1924, the building has been a prominent landmark of the Financial District for 89 years. | Po Valley Productions, LLC 65 | TBD 43 | Oded Binnun/ Michel Brezis 80 | Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 | Brian Cox 300 | Roseanne Arquette 69 | Thora Birch 472 |
481 | 481 | Etruscan Smile 88 | 2017 20 | Marriott Marquis, 780 Mission Street | The Marriott Marquis opened on October 17, 1989, the day of the Loma Prieta earthquake.[7] With better earthquake proofing than several nearby hotels, the building only lost a single window.[7] | Po Valley Productions, LLC 65 | TBD 43 | Oded Binnun/ Michel Brezis 80 | Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 | Brian Cox 300 | Roseanne Arquette 69 | Thora Birch 472 |
578 | 578 | GirlBoss 104 | 2017 20 | Clarion Alley between Valencia and Mission | The murals that make up this famous alley were first painted in 1992 and still looked after by the Clarion Alley Mural Project. | Hippolyta Productions, LLC 72 | Netflix 53 | Jamie Babbit, Amanda Brotchie, Steven K. Tsuchida, Christian Ditter, John Riggi 96 | Kay Cannon 96 | Britt Robertson 309 | Ellie Reed 84 | Amanda Rea 480 |
474 | 474 | Etruscan Smile 88 | 2017 20 | San Francisco City Hall | The museum party interiors were shot in the Historic San Francisco City Hall. | Po Valley Productions, LLC 65 | TBD 43 | Oded Binnun/ Michel Brezis 80 | Sarah Bellwood, Michal Lali Kagan, Michael McGowan Amital Stern, Jose Luis Sampedro 81 | Brian Cox 300 | Roseanne Arquette 69 | Thora Birch 472 |
579 | 579 | GirlBoss 104 | 2017 20 | Macchiarini Steps, Kearny between Vallejo and Broadway | The namesake for the steps was an Italian-American California-based modernist jeweler and sculptor who pioneered avant-garde jewelry. | Hippolyta Productions, LLC 72 | Netflix 53 | Jamie Babbit, Amanda Brotchie, Steven K. Tsuchida, Christian Ditter, John Riggi 96 | Kay Cannon 96 | Britt Robertson 309 | Ellie Reed 84 | Amanda Rea 480 |
581 | 581 | GirlBoss 104 | 2017 20 | La Taqueria, 2889 Mission St. | The restaurant was given the honor of "America's Best Burrito" in 2014 by ESPN's FiveThirtyEight. | Hippolyta Productions, LLC 72 | Netflix 53 | Jamie Babbit, Amanda Brotchie, Steven K. Tsuchida, Christian Ditter, John Riggi 96 | Kay Cannon 96 | Britt Robertson 309 | Ellie Reed 84 | Amanda Rea 480 |
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");