Film_Locations_in_San_Francisco

Data source: data.sfgov.org

117 rows where Release Year = 20

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
1164 Silicon Valley Season 4 217 2017 20 Howard St between 3rd and 4th St.   Brown Hill Productions, LLC 134 HBO 18 Mike Judge 179 John Altschuler 189 Thomas Middleditch 379 T.J. Miller 166 Josh Brener 516
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
1599 When We Rise 303 2017 20 United Nations Plaza   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
1600 When We Rise 303 2017 20 520 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
1601 When We Rise 303 2017 20 Castro Theatre, 429 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
1602 When We Rise 303 2017 20 440 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
1603 When We Rise 303 2017 20 Bay Bridge   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
1604 When We Rise 303 2017 20 24th St. between Florida and Alabama   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
1605 When We Rise 303 2017 20 Harvey Milk Plaza, 17th and Castro   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
1606 When We Rise 303 2017 20 Twin Peaks Bar, 401 Castro   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
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

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