Film_Locations_in_San_Francisco
Data source:
data.sfgov.org
9 rows
where Distributor = 18 and Release Year = 20 sorted by Director
✎ View and edit SQL
This data as json, CSV (advanced)
Suggested facets: Title, Production Company, Director, 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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
1163 |
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 |
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 |
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");