Film_Locations_in_San_Francisco

Data source: data.sfgov.org

93 rows where Distributor = 18

View and edit SQL

Suggested facets: Title, Release Year, Fun Facts, Production Company, Writer, Actor 1, Actor 2, Actor 3

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
91 Ballers Season 3 25 2017 20 Fairmont Hotel (950 Mason Street, Nob Hill)   Chori Perros Productions, LLC 22 HBO 18 Julian Farino 23 Stephen Levinson 22 Dwayne Johnson 258 John David Washington 21 Omar Benson Miller 447
92 Ballers Season 3 25 2017 20 Embarcadero around Rincon Park   Chori Perros Productions, LLC 22 HBO 18 Julian Farino 23 Stephen Levinson 22 Dwayne Johnson 258 John David Washington 21 Omar Benson Miller 447
93 Ballers Season 3 25 2017 20 San Remo Hotel (2237 Mason)   Chori Perros Productions, LLC 22 HBO 18 Julian Farino 23 Stephen Levinson 22 Dwayne Johnson 258 John David Washington 21 Omar Benson Miller 447
94 Ballers Season 3 25 2017 20 Huntington Park (California & Taylor Streets, Nob Hill)   Chori Perros Productions, LLC 22 HBO 18 Julian Farino 23 Stephen Levinson 22 Dwayne Johnson 258 John David Washington 21 Omar Benson Miller 447
95 Ballers Season 3 25 2017 20 Driving around Taylor/Pacific/Leavenworth   Chori Perros Productions, LLC 22 HBO 18 Julian Farino 23 Stephen Levinson 22 Dwayne Johnson 258 John David Washington 21 Omar Benson Miller 447
96 Ballers Season 3 25 2017 20 California and Jones St.   Chori Perros Productions, LLC 22 HBO 18 Julian Farino 23 Stephen Levinson 22 Dwayne Johnson 258 John David Washington 21 Omar Benson Miller 447
97 Ballers Season 3 25 2017 20 Another Café, 1191 Pine St at Leavenworth   Chori Perros Productions, LLC 22 HBO 18 Julian Farino 23 Stephen Levinson 22 Dwayne Johnson 258 John David Washington 21 Omar Benson Miller 447
778 Looking "Special" 149 2016 30 Capital Restaurant, 839 Clay Street Russell Tovey originally auditioned for the role of Patrick, but was unsuccessful. After the show got picked up, the character of Kevin was written with him in mind. Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
779 Looking "Special" 149 2016 30 1080 Natoma Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
780 Looking "Special" 149 2016 30 1246 Folsom Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
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
797 Looking Season 2 ep 202 150 2015 10 901 Valencia Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
798 Looking Season 2 ep 202 150 2015 10 314 11th Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
799 Looking Season 2 ep 202 150 2015 10 1246 Folsom Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
800 Looking Season 2 ep 202 150 2015 10 Eddy @ Polk Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
801 Looking Season 2 ep 202 150 2015 10 Church @ Duboce Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
802 Looking Season 2 ep 202 150 2015 10 100 Church Street 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
803 Looking Season 2 ep 202 150 2015 10 770 Haight Street This home was also used in MILK, Big Sur and Diary of a Teenage Girl Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
804 Looking Season 2 ep 202 150 2015 10 651 Brannan Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
805 Looking Season 2 ep 202 150 2015 10 1400 16th Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
806 Looking Season 2 ep 202 150 2015 10 601 Buena Vista Ave West   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
807 Looking Season 2 ep 203 151 2015 10 Balboa pool Lot, San Jose Avenue & Havelock St   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
808 Looking Season 2 ep 203 151 2015 10 Willy's Barber shop, 3227 22nd Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
809 Looking Season 2 ep 203 151 2015 10 Mad Dog Bar, 530 Haight Street 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
810 Looking Season 2 ep 203 151 2015 10 770 Haight Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
811 Looking Season 2 ep 203 151 2015 10 Kezar Pavillion   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
812 Looking Season 2 ep 203 151 2015 10 Boxer Stadium, 166 Havelock Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
813 Looking Season 2 ep 203 151 2015 10 Mission Rec Center, 2450 Harrison Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
814 Looking Season 2 ep 203 151 2015 10 Doc's Clock, 2575 Misison Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
815 Looking Season 2 ep 204 152 2015 10 Esta Noche, 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
816 Looking Season 2 ep 204 152 2015 10 1890 Clay Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
817 Looking Season 2 ep 204 152 2015 10 Larken Street Youth Services, 1138 Sutter Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
818 Looking Season 2 ep 204 152 2015 10 Daniel's Pharmacy, 943 Geneva Ave.   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
819 Looking Season 2 ep 204 152 2015 10 Castro Street @ 18th street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
820 Looking Season 2 ep 204 152 2015 10 601 Buena Vista Ave West   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
821 Looking Season 2 ep 204 152 2015 10 Urban Flowers, 4029 18th Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
822 Looking Season 2 ep 204 152 2015 10 3650 21st Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
823 Looking Season 2 ep 204 152 2015 10 Bi-Rite Creamery, 3692 18th Stret   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
824 Looking Season 2 ep 204 152 2015 10 Dolores Park, San Francisco Russell Tovey originally auditioned for the role of Patrick, but was unsuccessful. After the show got picked up, the character of Kevin was written with him in mind. Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
825 Looking Season 2 ep 204 152 2015 10 970 Geary Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
826 Looking Season 2 ep 204 152 2015 10 534 Hyde Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
827 Looking Season 2 ep 205 153 2015 10 534 Hyde Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
828 Looking Season 2 ep 205 153 2015 10 24th Between Portrero & Alabama   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
829 Looking Season 2 ep 205 153 2015 10 745 Treat Ave   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
830 Looking Season 2 ep 205 153 2015 10 Always Open Car Wash, 2560 Marin Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
831 Looking Season 2 ep 205 153 2015 10 160 Church Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
832 Looking Season 2 ep 205 153 2015 10 1119 Alabama Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
833 Looking Season 2 ep 206 154 2015 10 745 Treat Ave.   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
834 Looking Season 2 ep 206 154 2015 10 1890 Clay Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
835 Looking Season 2 ep 206 154 2015 10 770 Haight Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
836 Looking Season 2 ep 207 155 2015 10 770 Haight Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
837 Looking Season 2 ep 207 155 2015 10 Delores Park   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
838 Looking Season 2 ep 207 155 2015 10 Valenti, Marini, Perata, 4840 Mission Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
839 Looking Season 2 ep 207 155 2015 10 Sparky's Diner, 242 Church Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
840 Looking Season 2 ep 208 156 2015 10 2450 Harrison Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
841 Looking Season 2 ep 208 156 2015 10 1246 Folsom Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
842 Looking Season 2 ep 208 156 2015 10 Citizens Band, 1198 Folsom Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
843 Looking Season 2 ep 208 156 2015 10 1111 California Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
844 Looking Season 2 ep 208 156 2015 10 950 Mason Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
845 Looking Season 2 ep 209 157 2015 10 SF Zoo, 2945 Sloat Blvd   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
846 Looking Season 2 ep 209 157 2015 10 1246 Folsom Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
847 Looking Season 2 ep 209 157 2015 10 68 Division Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
848 Looking Season 2 ep 209 157 2015 10 8 Octavia Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
849 Looking Season 2 ep 209 157 2015 10 1890 Clay Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
850 Looking Season 2 ep 209 157 2015 10 Tonga Room, Fairmont Hotel, 950 Mason Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
851 Looking Season 2 ep 209 157 2015 10 Muddy Waters, 521 Valencia Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
852 Looking Season 2 ep 209 157 2015 10 Mission Arts Center, 2450 Harrison Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
853 Looking Season 2 ep 210 158 2015 10 8 Octavia Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
854 Looking Season 2 ep 210 158 2015 10 BART Station @ 16th Street & Mission Streets   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
855 Looking Season 2 ep 210 158 2015 10 67 Deming Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
856 Looking Season 2 ep 210 158 2015 10 Twin Peaks Park   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
857 Looking Season 2 ep 210 158 2015 10 Vega Coffee, 1245 Folsom Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
858 Looking Season 2 ep 210 158 2015 10 SF City Hall Polk Street Steps   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
859 Looking Season 2 ep 210 158 2015 10 Mission Street @ 22nd Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
860 Looking Season 2 ep 210 158 2015 10 Willy's Barber shop, 3227 22nd Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
861 Looking Season 2 ep 210 158 2015 10 Mission Rec Center, 2450 Harrison Street   Mission Street Productions, LLC 101 HBO 18 Andrew Haigh 136 Michael Lannan 137 Jonathan Groff 339 Frankie Alvarez 123 Murray Bartlett 496
1163 Silicon Valley Season 4 217 2017 20 Moscone Center Parking Garage/3rd St.   Brown Hill Productions, LLC 134 HBO 18 Mike Judge 179 John Altschuler 189 Thomas Middleditch 379 T.J. Miller 166 Josh Brener 516
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

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