Film_Locations_in_San_Francisco

Data source: data.sfgov.org

168 rows where Release Year = 30

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
781 Looking "Special" 149 2016 30 Li Po Lounge, 916 Grant Avenue Li Po Cocktail Lounge was one of the Top 10 Dive Bars in San Francisco in 2011 by SF Weekly Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
782 Looking "Special" 149 2016 30 Encore Karaoke, 1550 California Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
783 Looking "Special" 149 2016 30 San Francisco City Hall   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
784 Looking "Special" 149 2016 30 The Stud, 399 9th Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
785 Looking "Special" 149 2016 30 Van Ness and Market Street MUNI exit The character of Doris was originally a recurring role, but everyone on the team liked Lauren Weedman's performance so much that she became a full time regular during the second season. Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
786 Looking "Special" 149 2016 30 10th Street between Market & Mission   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
787 Looking "Special" 149 2016 30 Philz Coffee, 1258 Minnesota Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
788 Looking "Special" 149 2016 30 Grant Avenue between Sacramento and Washington   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
789 Looking "Special" 149 2016 30 The End Up, 401 6th Streeet   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
790 Looking "Special" 149 2016 30 Orphan Andy's, 3991 17th Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
791 Looking "Special" 149 2016 30 Castro Street between 17th & 18th   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
792 Looking "Special" 149 2016 30 17th & Market Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
793 Looking "Special" 149 2016 30 Point Lobos Avenue   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
794 Looking "Special" 149 2016 30 Bernal Heights Neighborhood Jake Shears, lead singer of the band Scissor Sisters, auditioned for the role of Dom. Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
795 Looking "Special" 149 2016 30 3079 16th Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
796 Looking "Special" 149 2016 30 Fisherman's Wharf   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
897 Pushing Dead 74 2016 30 1069 Tennessee Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
955 Murder in the First, Season 3 173 2016 30 Golden Gate Park   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
956 Murder in the First, Season 3 173 2016 30 Civic Center Plaza   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
957 Murder in the First, Season 3 173 2016 30 500 Grove Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
958 Murder in the First, Season 3 173 2016 30 600 Octavia Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
959 Murder in the First, Season 3 173 2016 30 535 Octavia Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
960 Murder in the First, Season 3 173 2016 30 Patricia's Green   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
961 Murder in the First, Season 3 173 2016 30 Ivy Street between Laguna and Gough Streets   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
962 Murder in the First, Season 3 173 2016 30 Linden Alley between Octavia and Gough Streets   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
963 Murder in the First, Season 3 173 2016 30 Hall of Justice (850 Bryant Street)   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
964 Murder in the First, Season 3 173 2016 30 Harriet Alley   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
965 Murder in the First, Season 3 173 2016 30 Howard Street at Steuart Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
966 Murder in the First, Season 3 173 2016 30 Red's Java House (Pier 30)   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
967 Murder in the First, Season 3 173 2016 30 887 De Haro Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
968 Murder in the First, Season 3 173 2016 30 Pier 96   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
969 Murder in the First, Season 3 173 2016 30 2633 Vallejo Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
1036 Pushing Dead 74 2016 30 Blind Cat, 3050 24th Street, San Francisco Pushing Dead won the Audience Award for Frameline San Francisco International LGBTQ Film Festival 2016 Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1037 Pushing Dead 74 2016 30 Cordova Market, 301 Rolph Street, San Francisco   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1038 Pushing Dead 74 2016 30 915 Naples, San Francisco   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1039 Pushing Dead 74 2016 30 Infield Batting Cages, 1888 Clement Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1040 Pushing Dead 74 2016 30 42 Walter Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1041 Pushing Dead 74 2016 30 Church Street MUNI Station   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1042 Pushing Dead 74 2016 30 Double Happiness Health, 3380 20th Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1043 Pushing Dead 74 2016 30 Ele Nino Traiing Cetner, 2920 3rd Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1044 Pushing Dead 74 2016 30 Matching Half Café, 1799 McAllister Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1045 Pushing Dead 74 2016 30 433 Baker Street,   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1046 Pushing Dead 74 2016 30 Mission Neibhrohood Health Cetner, 240 Shotweel Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1047 Pushing Dead 74 2016 30 Octavia at Grove Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1048 Pushing Dead 74 2016 30 Koshland Park   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1049 Pushing Dead 74 2016 30 Daniel's Pharmacy, 943 Geneva Ave   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1050 Pushing Dead 74 2016 30 5th Ave @ Fulton Street in Golden Gate Park   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1051 Pushing Dead 74 2016 30 Uva Enoteca, 568 Haight Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1052 Pushing Dead 74 2016 30 Turk Street between Steiner and Scott Streets   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1138 Sense8 - Season 2 210 2016 30 Westerfeld House, 1198 Fulton St. In the 1940's, the house became a 14-unit apartment building that housed jazz musicians including John Handy. This location serves as the hideout for the San Francisco-based character Nomi. Unpronounceable Productions, LLC 131 Netflix 53 Wachowski Siblings 173 J. Michael Straczynski, Wachowiski Siblings 182 Jamie Clayton 374 Daryl Hannah 126 Naveen Andrews 514
1139 Sense8 - Season 2 210 2016 30 67-69 Deming St.   Unpronounceable Productions, LLC 131 Netflix 53 Wachowski Siblings 173 J. Michael Straczynski, Wachowiski Siblings 182 Jamie Clayton 374 Daryl Hannah 126 Naveen Andrews 514
1140 Sense8 - Season 2 210 2016 30 The Women's Building, 3543 18th St. The mural painted outside the building was painted by 7 women artists including Juana Alicia, Miranda Bergman and Meera Desai. The computer lab scene was filmed inside the building. Unpronounceable Productions, LLC 131 Netflix 53 Wachowski Siblings 173 J. Michael Straczynski, Wachowiski Siblings 182 Jamie Clayton 374 Daryl Hannah 126 Naveen Andrews 514
1141 Sense8 - Season 2 210 2016 30 Julia Morgan Ballroom at the Merchant's Exchange Building, 465 California St. An extremely popular location for weddings, the namesake of the ballroom was an architect most famous for her work on Hearst Castle. Unpronounceable Productions, LLC 131 Netflix 53 Wachowski Siblings 173 J. Michael Straczynski, Wachowiski Siblings 182 Jamie Clayton 374 Daryl Hannah 126 Naveen Andrews 514
1142 Sense8 - Season 2 210 2016 30 Marina Morrison Bridal, 30 Maiden Ln.   Unpronounceable Productions, LLC 131 Netflix 53 Wachowski Siblings 173 J. Michael Straczynski, Wachowiski Siblings 182 Jamie Clayton 374 Daryl Hannah 126 Naveen Andrews 514
1143 Sense8 - Season 2 210 2016 30 Grace Cathedral, 1100 California St. Martin Luther King, Jr. gave a sermon at the cathedral to celebrate the completion and consecration of the church in 1964. Unpronounceable Productions, LLC 131 Netflix 53 Wachowski Siblings 173 J. Michael Straczynski, Wachowiski Siblings 182 Jamie Clayton 374 Daryl Hannah 126 Naveen Andrews 514
1144 Sense8 - Season 2 210 2016 30 San Francisco City Hall, 1 Dr. Carlton B. Goodlett Pl. Many films have shot scene in and around the building including Raiders of the Lost Ark, Invasion of the Body Snatchers, Dirty Harry, The Towering Inferno, A View to a Kill and most recently, Milk. The Christmas party scene for this show was shot in the Rotunda. Unpronounceable Productions, LLC 131 Netflix 53 Wachowski Siblings 173 J. Michael Straczynski, Wachowiski Siblings 182 Jamie Clayton 374 Daryl Hannah 126 Naveen Andrews 514
1145 Sense8 - Season 2 210 2016 30 City Lights Bookstore, 261 Columbus Ave. Howl and Other Poems by Allen Ginsberg was published in 1956 by City Lights after poet and founder Laurence Ferlinghetti heard Ginsberg read it in 1955. Unpronounceable Productions, LLC 131 Netflix 53 Wachowski Siblings 173 J. Michael Straczynski, Wachowiski Siblings 182 Jamie Clayton 374 Daryl Hannah 126 Naveen Andrews 514
1146 Sense8 - Season 2 210 2016 30 Billy Goat Hill, Castro St. & 30th St. This park was the location of a popular swing with great views of the City. Unpronounceable Productions, LLC 131 Netflix 53 Wachowski Siblings 173 J. Michael Straczynski, Wachowiski Siblings 182 Jamie Clayton 374 Daryl Hannah 126 Naveen Andrews 514
1147 Sense8 - Season 2 210 2016 30 The Castro Theater, 429 Castro St. The theater has an organ which is played before every film showing. Unpronounceable Productions, LLC 131 Netflix 53 Wachowski Siblings 173 J. Michael Straczynski, Wachowiski Siblings 182 Jamie Clayton 374 Daryl Hannah 126 Naveen Andrews 514
1148 Sense8 - Season 2 210 2016 30 Mission Creek Harbor along Channel St.   Unpronounceable Productions, LLC 131 Netflix 53 Wachowski Siblings 173 J. Michael Straczynski, Wachowiski Siblings 182 Jamie Clayton 374 Daryl Hannah 126 Naveen Andrews 514
1149 Sense8 - Season 2 210 2016 30 Grant between Sacramento and Jack Kerouac Alley   Unpronounceable Productions, LLC 131 Netflix 53 Wachowski Siblings 173 J. Michael Straczynski, Wachowiski Siblings 182 Jamie Clayton 374 Daryl Hannah 126 Naveen Andrews 514
1150 Sense8 - Season 2 210 2016 30 Castle between Union and Green   Unpronounceable Productions, LLC 131 Netflix 53 Wachowski Siblings 173 J. Michael Straczynski, Wachowiski Siblings 182 Jamie Clayton 374 Daryl Hannah 126 Naveen Andrews 514
1151 Sense8 - Season 2 210 2016 30 Green between Kearny and Montgomery   Unpronounceable Productions, LLC 131 Netflix 53 Wachowski Siblings 173 J. Michael Straczynski, Wachowiski Siblings 182 Jamie Clayton 374 Daryl Hannah 126 Naveen Andrews 514
1152 Sense8 - Season 2 210 2016 30 Montgomery between Green and Broadway   Unpronounceable Productions, LLC 131 Netflix 53 Wachowski Siblings 173 J. Michael Straczynski, Wachowiski Siblings 182 Jamie Clayton 374 Daryl Hannah 126 Naveen Andrews 514
1153 Sense8 - Season 2 210 2016 30 Washington between Stockton and Kearny   Unpronounceable Productions, LLC 131 Netflix 53 Wachowski Siblings 173 J. Michael Straczynski, Wachowiski Siblings 182 Jamie Clayton 374 Daryl Hannah 126 Naveen Andrews 514
1154 Sense8 - Season 2 210 2016 30 Spofford between Washington and Clay   Unpronounceable Productions, LLC 131 Netflix 53 Wachowski Siblings 173 J. Michael Straczynski, Wachowiski Siblings 182 Jamie Clayton 374 Daryl Hannah 126 Naveen Andrews 514
1155 Sense8 - Season 2 210 2016 30 Clay between Stockton and Grant   Unpronounceable Productions, LLC 131 Netflix 53 Wachowski Siblings 173 J. Michael Straczynski, Wachowiski Siblings 182 Jamie Clayton 374 Daryl Hannah 126 Naveen Andrews 514
1156 Sense8 - Season 2 210 2016 30 Filbert between Hyde and Jones   Unpronounceable Productions, LLC 131 Netflix 53 Wachowski Siblings 173 J. Michael Straczynski, Wachowiski Siblings 182 Jamie Clayton 374 Daryl Hannah 126 Naveen Andrews 514

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