Film_Locations_in_San_Francisco

Data source: data.sfgov.org

21 rows where Writer = 96

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
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
574 GirlBoss 104 2017 20 Green and Divisadero   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
575 GirlBoss 104 2017 20 1375 Haight St.   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
576 GirlBoss 104 2017 20 Mission Thrift, 2330 Mission St.   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
577 GirlBoss 104 2017 20 The Castro Theater, 429 Castro St.   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
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
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
580 GirlBoss 104 2017 20 Fillmore and Waller   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
582 GirlBoss 104 2017 20 Various Haight St. Vintage Shops   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
583 GirlBoss 104 2017 20 Clayton Post Office, 554 Clayton St.   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
584 GirlBoss 104 2017 20 Taylor and Union   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
585 GirlBoss 104 2017 20 Filbert between Leavenworth and Hyde   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
586 GirlBoss 104 2017 20 Filbert between Grant and Kearny   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
587 GirlBoss 104 2017 20 Filbert and Kearny Steps   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
588 GirlBoss 104 2017 20 Boulevard Restaurant, 1 Mission St.   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
589 GirlBoss 104 2017 20 Grant between California and Washington   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
591 GirlBoss 104 2017 20 Mission between 19th and 25th St.   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
592 GirlBoss 104 2017 20 Underground SF, 424 Haight St.   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
593 GirlBoss 104 2017 20 Fillmore between Haight and Waller   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 30.14ms · Data source: data.sfgov.org