Film_Locations_in_San_Francisco

Data source: data.sfgov.org

17 rows where Writer = 47

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
259 Chance - Season 1 Pilot 50 2016 30 Harvey Milk Rec Center, 50 Scott St.   TVM Productions 43 HULU 34 Lenny Abrahamson 48 Alexandra Cunningham and Kem Nunn 47 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
260 Chance - Season 1 Pilot 50 2016 30 66 Potomac   TVM Productions 43 HULU 34 Lenny Abrahamson 48 Alexandra Cunningham and Kem Nunn 47 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
261 Chance - Season 1 Pilot 50 2016 30 Mario's Café, 566 Columbus   TVM Productions 43 HULU 34 Lenny Abrahamson 48 Alexandra Cunningham and Kem Nunn 47 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
262 Chance - Season 1 Pilot 50 2016 30 Washington Square Park   TVM Productions 43 HULU 34 Lenny Abrahamson 48 Alexandra Cunningham and Kem Nunn 47 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
263 Chance - Season 1 Pilot 50 2016 30 William Stout Architectural Books, 804 Montgomery St.   TVM Productions 43 HULU 34 Lenny Abrahamson 48 Alexandra Cunningham and Kem Nunn 47 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
264 Chance - Season 1 Pilot 50 2016 30 1055 Montgomery St.   TVM Productions 43 HULU 34 Lenny Abrahamson 48 Alexandra Cunningham and Kem Nunn 47 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
265 Chance - Season 1 Pilot 50 2016 30 60 Leavenworth St.   TVM Productions 43 HULU 34 Lenny Abrahamson 48 Alexandra Cunningham and Kem Nunn 47 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
266 Chance - Season 1 Pilot 50 2016 30 Jefferson Square Park   TVM Productions 43 HULU 34 Lenny Abrahamson 48 Alexandra Cunningham and Kem Nunn 47 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
267 Chance - Season 1 Pilot 50 2016 30 UN Plaza/ Civic Center Bart steps   TVM Productions 43 HULU 34 Lenny Abrahamson 48 Alexandra Cunningham and Kem Nunn 47 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
268 Chance - Season 1 Pilot 50 2016 30 940 Powell St.   TVM Productions 43 HULU 34 Lenny Abrahamson 48 Alexandra Cunningham and Kem Nunn 47 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
269 Chance - Season 1 Pilot 50 2016 30 Ellis and Jones St.   TVM Productions 43 HULU 34 Lenny Abrahamson 48 Alexandra Cunningham and Kem Nunn 47 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
270 Chance - Season 1 Pilot 50 2016 30 Ellis Food Center, 398 Ellis   TVM Productions 43 HULU 34 Lenny Abrahamson 48 Alexandra Cunningham and Kem Nunn 47 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
271 Chance - Season 1 Pilot 50 2016 30 Jonell's Bar, 401 Ellis   TVM Productions 43 HULU 34 Lenny Abrahamson 48 Alexandra Cunningham and Kem Nunn 47 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
272 Chance - Season 1 Pilot 50 2016 30 State Garage, 818 Leavenworth   TVM Productions 43 HULU 34 Lenny Abrahamson 48 Alexandra Cunningham and Kem Nunn 47 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
273 Chance - Season 1 Pilot 50 2016 30 Antonio Alley   TVM Productions 43 HULU 34 Lenny Abrahamson 48 Alexandra Cunningham and Kem Nunn 47 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
274 Chance - Season 1 Pilot 50 2016 30 253 4th Ave.   TVM Productions 43 HULU 34 Lenny Abrahamson 48 Alexandra Cunningham and Kem Nunn 47 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
275 Chance - Season 1 Pilot 50 2016 30 Warren's Antiques, 375 9th St.   TVM Productions 43 HULU 34 Lenny Abrahamson 48 Alexandra Cunningham and Kem Nunn 47 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463

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