Film_Locations_in_San_Francisco

Data source: data.sfgov.org

20 rows where Distributor = 43, Release Year = 30 and Title = 74

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
404 404 Pushing Dead 74 2016 30 2930 3rd Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
452 452 Pushing Dead 74 2016 30 Hayes Street between Ashbury and Shrader   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
897 897 Pushing Dead 74 2016 30 1069 Tennessee Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1036 1036 Pushing Dead 74 2016 30 Blind Cat, 3050 24th Street, San Francisco Pushing Dead won the Audience Award for Frameline San Francisco International LGBTQ Film Festival 2016 Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1037 1037 Pushing Dead 74 2016 30 Cordova Market, 301 Rolph Street, San Francisco   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1038 1038 Pushing Dead 74 2016 30 915 Naples, San Francisco   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1039 1039 Pushing Dead 74 2016 30 Infield Batting Cages, 1888 Clement Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1040 1040 Pushing Dead 74 2016 30 42 Walter Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1041 1041 Pushing Dead 74 2016 30 Church Street MUNI Station   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1042 1042 Pushing Dead 74 2016 30 Double Happiness Health, 3380 20th Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1043 1043 Pushing Dead 74 2016 30 Ele Nino Traiing Cetner, 2920 3rd Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1044 1044 Pushing Dead 74 2016 30 Matching Half Café, 1799 McAllister Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1045 1045 Pushing Dead 74 2016 30 433 Baker Street,   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1046 1046 Pushing Dead 74 2016 30 Mission Neibhrohood Health Cetner, 240 Shotweel Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1047 1047 Pushing Dead 74 2016 30 Octavia at Grove Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1048 1048 Pushing Dead 74 2016 30 Koshland Park   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1049 1049 Pushing Dead 74 2016 30 Daniel's Pharmacy, 943 Geneva Ave   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1050 1050 Pushing Dead 74 2016 30 5th Ave @ Fulton Street in Golden Gate Park   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1051 1051 Pushing Dead 74 2016 30 Uva Enoteca, 568 Haight Street   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467
1052 1052 Pushing Dead 74 2016 30 Turk Street between Steiner and Scott Streets   Pushing Dead , LLC 56 TBD 43 Tom Brown 68 Tom Brown 67 Danny Glover 291 James Roday 56 Robin Weigert 467

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