Film_Locations_in_San_Francisco

Data source: data.sfgov.org

13 rows where Writer = 51

View and edit SQL

Suggested facets: Title, Locations, Director

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
309 Chance- Season 1 ep106 55 2016 30 Washington Square Park   TVM Productions 43 HULU 34 Sara Gran 50 Dan Attias 51 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
310 Chance- Season 1 ep106 55 2016 30 Grant between Union and Green   TVM Productions 43 HULU 34 Sara Gran 50 Dan Attias 51 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
311 Chance- Season 1 ep106 55 2016 30 60 Leavenworth St.   TVM Productions 43 HULU 34 Sara Gran 50 Dan Attias 51 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
312 Chance- Season 1 ep106 55 2016 30 Montgomery between Pacific and Broadway   TVM Productions 43 HULU 34 Sara Gran 50 Dan Attias 51 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
313 Chance- Season 1 ep106 55 2016 30 Treasure Island From the late 1980s, Treasure Island's old aircraft Hangar 2 (Building 2) and Hangar 3 (Building 3) served as sound stages for film-making and TV, including  Rent, The Pursuit of Happyness, Flubber, What Dreams May Come, Patch Adams, The Parent Trap, Bicentennial Man and the TV series Trauma. TVM Productions 43 HULU 34 Sara Gran 50 Dan Attias 51 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
314 Chance- Season 1 ep106 55 2016 30 2 Rowland   TVM Productions 43 HULU 34 Sara Gran 50 Dan Attias 51 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
315 Chance- Season 1 ep106 55 2016 30 McAllister between Leavenworth and Hyde   TVM Productions 43 HULU 34 Sara Gran 50 Dan Attias 51 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
328 Chance- Season 1 ep109 59 2016 30 Terry A. Francois Blvd.   TVM Productions 43 HULU 34 Sara Gran and Pete Begler 54 Dan Attias 51 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
329 Chance- Season 1 ep109 59 2016 30 2 Rowland   TVM Productions 43 HULU 34 Sara Gran and Pete Begler 54 Dan Attias 51 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
330 Chance- Season 1 ep109 59 2016 30 Ocean Park Motel   TVM Productions 43 HULU 34 Sara Gran and Pete Begler 54 Dan Attias 51 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
331 Chance- Season 1 ep109 59 2016 30 Cliffhouse, 1090 Point Lobos Ave.   TVM Productions 43 HULU 34 Sara Gran and Pete Begler 54 Dan Attias 51 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
332 Chance- Season 1 ep109 59 2016 30 850 Bryant- 6th floor County Jail The former County Jail on the 6th floor was re-created to resemble a Mexican jail for the scene TVM Productions 43 HULU 34 Sara Gran and Pete Begler 54 Dan Attias 51 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
333 Chance- Season 1 ep109 59 2016 30 60 Leavenworth St.   TVM Productions 43 HULU 34 Sara Gran and Pete Begler 54 Dan Attias 51 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 30.837ms · Data source: data.sfgov.org