Film_Locations_in_San_Francisco

Data source: data.sfgov.org

117 rows where Release Year = 20 sorted by Fun Facts

View and edit SQL

Link rowid Title Release Year Locations Fun Facts ▼ Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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

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