Film_Locations_in_San_Francisco

Data source: data.sfgov.org

19 rows where Production Company = 101, Release Year = 30 and Title = 149

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
778 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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

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