Film_Locations_in_San_Francisco

Data source: data.sfgov.org

13 rows where Writer = 38 sorted by Production Company

View and edit SQL

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

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