Film_Locations_in_San_Francisco
Data source:
data.sfgov.org
12 rows
where Title = 152
✎ 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
|
815 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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");