Film_Locations_in_San_Francisco
Data source:
data.sfgov.org
13 rows
where Writer = 38
✎ 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
|
198 |
198 |
Budding Prospects, Pilot 41 |
2017 20 |
3050 24th Street |
|
Picrow Streaming Inc. 36 |
Amazon 29 |
Terry Zwigoff 39 |
Melissa Axelrod, T. C. Boyle (based on the book by) 38 |
Adam Rose 272 |
Will Sasso 35 |
Joel David Moore 458 |
199 |
199 |
Budding Prospects, Pilot 41 |
2017 20 |
3033 24th Street |
|
Picrow Streaming Inc. 36 |
Amazon 29 |
Terry Zwigoff 39 |
Melissa Axelrod, T. C. Boyle (based on the book by) 38 |
Adam Rose 272 |
Will Sasso 35 |
Joel David Moore 458 |
200 |
200 |
Budding Prospects, Pilot 41 |
2017 20 |
2937 24th Street |
|
Picrow Streaming Inc. 36 |
Amazon 29 |
Terry Zwigoff 39 |
Melissa Axelrod, T. C. Boyle (based on the book by) 38 |
Adam Rose 272 |
Will Sasso 35 |
Joel David Moore 458 |
201 |
201 |
Budding Prospects, Pilot 41 |
2017 20 |
1167 Alabama Street |
|
Picrow Streaming Inc. 36 |
Amazon 29 |
Terry Zwigoff 39 |
Melissa Axelrod, T. C. Boyle (based on the book by) 38 |
Adam Rose 272 |
Will Sasso 35 |
Joel David Moore 458 |
202 |
202 |
Budding Prospects, Pilot 41 |
2017 20 |
1641 York Street |
|
Picrow Streaming Inc. 36 |
Amazon 29 |
Terry Zwigoff 39 |
Melissa Axelrod, T. C. Boyle (based on the book by) 38 |
Adam Rose 272 |
Will Sasso 35 |
Joel David Moore 458 |
203 |
203 |
Budding Prospects, Pilot 41 |
2017 20 |
Bernal Heights Boulevard |
|
Picrow Streaming Inc. 36 |
Amazon 29 |
Terry Zwigoff 39 |
Melissa Axelrod, T. C. Boyle (based on the book by) 38 |
Adam Rose 272 |
Will Sasso 35 |
Joel David Moore 458 |
204 |
204 |
Budding Prospects, Pilot 41 |
2017 20 |
40 Prentiss Street |
|
Picrow Streaming Inc. 36 |
Amazon 29 |
Terry Zwigoff 39 |
Melissa Axelrod, T. C. Boyle (based on the book by) 38 |
Adam Rose 272 |
Will Sasso 35 |
Joel David Moore 458 |
205 |
205 |
Budding Prospects, Pilot 41 |
2017 20 |
500 Cortland Avenue |
|
Picrow Streaming Inc. 36 |
Amazon 29 |
Terry Zwigoff 39 |
Melissa Axelrod, T. C. Boyle (based on the book by) 38 |
Adam Rose 272 |
Will Sasso 35 |
Joel David Moore 458 |
206 |
206 |
Budding Prospects, Pilot 41 |
2017 20 |
Lucky Street |
|
Picrow Streaming Inc. 36 |
Amazon 29 |
Terry Zwigoff 39 |
Melissa Axelrod, T. C. Boyle (based on the book by) 38 |
Adam Rose 272 |
Will Sasso 35 |
Joel David Moore 458 |
207 |
207 |
Budding Prospects, Pilot 41 |
2017 20 |
1125 Guerrero Street |
|
Picrow Streaming Inc. 36 |
Amazon 29 |
Terry Zwigoff 39 |
Melissa Axelrod, T. C. Boyle (based on the book by) 38 |
Adam Rose 272 |
Will Sasso 35 |
Joel David Moore 458 |
208 |
208 |
Budding Prospects, Pilot 41 |
2017 20 |
Gough Street & Clay Street |
|
Picrow Streaming Inc. 36 |
Amazon 29 |
Terry Zwigoff 39 |
Melissa Axelrod, T. C. Boyle (based on the book by) 38 |
Adam Rose 272 |
Will Sasso 35 |
Joel David Moore 458 |
209 |
209 |
Budding Prospects, Pilot 41 |
2017 20 |
2007 Franklin Street |
|
Picrow Streaming Inc. 36 |
Amazon 29 |
Terry Zwigoff 39 |
Melissa Axelrod, T. C. Boyle (based on the book by) 38 |
Adam Rose 272 |
Will Sasso 35 |
Joel David Moore 458 |
210 |
210 |
Budding Prospects, Pilot 41 |
2017 20 |
951 Hudson Avenue |
|
Picrow Streaming Inc. 36 |
Amazon 29 |
Terry Zwigoff 39 |
Melissa Axelrod, T. C. Boyle (based on the book by) 38 |
Adam Rose 272 |
Will Sasso 35 |
Joel David Moore 458 |
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");