Film_Locations_in_San_Francisco
Data source:
data.sfgov.org
19 rows
where Release Year = 30 and Writer = 137
✎ 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
|
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 |
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");