Film_Locations_in_San_Francisco

Data source: data.sfgov.org

28 rows where Director = 142

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Title, Release Year, Locations, Production Company, Distributor, Actor 1, 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  
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
1599 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 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 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 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 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 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 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 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 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 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

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