Film_Locations_in_San_Francisco

Data source: data.sfgov.org

11 rows where Writer = 48

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
277 Chance- Season 1 ep102 52 2016 30 Mason and Pacific   TVM Productions 43 HULU 34 Lenny Abrahamson 48 Alexandra Cunningham  48 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
278 Chance- Season 1 ep102 52 2016 30 John St. between Powell and Mason   TVM Productions 43 HULU 34 Lenny Abrahamson 48 Alexandra Cunningham  48 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
279 Chance- Season 1 ep102 52 2016 30 Westin St. Francis   TVM Productions 43 HULU 34 Lenny Abrahamson 48 Alexandra Cunningham  48 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
280 Chance- Season 1 ep102 52 2016 30 Betelnut restaurant, 2030 Union St.   TVM Productions 43 HULU 34 Lenny Abrahamson 48 Alexandra Cunningham  48 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
281 Chance- Season 1 ep102 52 2016 30 Sutter Stockton Garage, 444 Stockton   TVM Productions 43 HULU 34 Lenny Abrahamson 48 Alexandra Cunningham  48 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
282 Chance- Season 1 ep102 52 2016 30 YWCA, 940 Powell   TVM Productions 43 HULU 34 Lenny Abrahamson 48 Alexandra Cunningham  48 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
283 Chance- Season 1 ep102 52 2016 30 Warren's Antiques, 375 9th St.   TVM Productions 43 HULU 34 Lenny Abrahamson 48 Alexandra Cunningham  48 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
284 Chance- Season 1 ep102 52 2016 30 Heron and Berwick Alleys   TVM Productions 43 HULU 34 Lenny Abrahamson 48 Alexandra Cunningham  48 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
285 Chance- Season 1 ep102 52 2016 30 Duboce St., Duboce Café   TVM Productions 43 HULU 34 Lenny Abrahamson 48 Alexandra Cunningham  48 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
286 Chance- Season 1 ep102 52 2016 30 Potomac and Waller   TVM Productions 43 HULU 34 Lenny Abrahamson 48 Alexandra Cunningham  48 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
287 Chance- Season 1 ep102 52 2016 30 State Garage, 818 Leavenworth   TVM Productions 43 HULU 34 Lenny Abrahamson 48 Alexandra Cunningham  48 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 37.661ms · Data source: data.sfgov.org