Film_Locations_in_San_Francisco

Data source: data.sfgov.org

10 rows where Writer = 50

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
299 Chance- Season 1 ep104 54 2016 30 Bush and Sansome St.   TVM Productions 43 HULU 34 Carl Franklin 49 Peter Elkoff 50 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
300 Chance- Season 1 ep104 54 2016 30 Bayview Police Station, 201 Williams Ave.   TVM Productions 43 HULU 34 Carl Franklin 49 Peter Elkoff 50 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
301 Chance- Season 1 ep104 54 2016 30 Miraloma Mall at Portola Frontage Road   TVM Productions 43 HULU 34 Carl Franklin 49 Peter Elkoff 50 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
302 Chance- Season 1 ep104 54 2016 30 1018 Tennessee St.   TVM Productions 43 HULU 34 Carl Franklin 49 Peter Elkoff 50 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
303 Chance- Season 1 ep104 54 2016 30 901/909Tennessee St.   TVM Productions 43 HULU 34 Carl Franklin 49 Peter Elkoff 50 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
304 Chance- Season 1 ep104 54 2016 30 11 San Jacinto Ave.   TVM Productions 43 HULU 34 Carl Franklin 49 Peter Elkoff 50 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
305 Chance- Season 1 ep104 54 2016 30 Palace of Fine Arts The Palace of Fine Arts was designed by Bernard Maybeck and was originally constructed for the 1915 Panama-Pacific Exposition.  It has been in films such as Time After Time, The Room, Twisted, So I Married An Axe Murderer and The Rock. TVM Productions 43 HULU 34 Carl Franklin 49 Peter Elkoff 50 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
306 Chance- Season 1 ep104 54 2016 30 Agua Vista Park at Mission Rock, 817 Terry A Francois Blvd.   TVM Productions 43 HULU 34 Carl Franklin 49 Peter Elkoff 50 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
307 Chance- Season 1 ep104 54 2016 30 200 Kansas St.   TVM Productions 43 HULU 34 Carl Franklin 49 Peter Elkoff 50 Hugh Laurie 280 Gretchen Mol 42 Ethan Suplee 463
308 Chance- Season 1 ep104 54 2016 30 15th St. between Vermont and Kansas   TVM Productions 43 HULU 34 Carl Franklin 49 Peter Elkoff 50 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 31.291ms · Data source: data.sfgov.org