sandy-311-calls/sandy-311-calls-by-day

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

7 rows where HPD = 12 sorted by DEP

View and edit SQL

Suggested facets: ACS, BPSI, CAU, CHALL, DEP, DOB, DOE, DOF, DOHMH, MOSE, NYCEM, NYCHA, NYCSERVICE, NYPD, NYSDOL, SBS, NYSEMERGENCYMG

HPD

Link rowid date NYC-3-1-1 ACS BPSI CAU CHALL DEP ▼ DOB DOE DOF DOHMH DPR FEMA HPD HRA MFANYC MOSE NYCEM NYCHA NYCSERVICE NYPD NYSDOL SBS NYSEMERGENCYMG total
79 1/8/13 0 0 1 0 66 0 7 0 7 5 0 0 12 0 0 3 1 1 1 0 22 5 0 131
99 1/28/13 0 1 1 0 44 0 12 1 34 4 0 0 12 0 0 4 1 1 3 0 10 20 0 148
156 3/26/13 0 0 0 0 6 0 11 0 8 1 0 0 12 0 0 0 1 0 12 0 6 2 0 59
214 5/23/13 0 0 0 0 9 0 1 0 4 1 0 0 12 0 0 0 2 0 1 0 0 1 7 38
150 3/20/13 0 0 0 0 6 1 5 0 7 2 0 0 12 0 0 0 1 1 11 0 2 1 0 49
162 4/1/13 0 0 0 0 8 1 3 0 11 0 0 0 12 0 0 0 1 1 9 2 2 3 0 53
117 2/15/13 0 0 0 2 29 2 5 0 11 1 0 0 12 0 0 1 2 0 21 3 7 6 0 102

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "sandy-311-calls/sandy-311-calls-by-day" (
"date" TEXT,
  "NYC-3-1-1" INTEGER,
  "ACS" INTEGER,
  "BPSI" INTEGER,
  "CAU" INTEGER,
  "CHALL" INTEGER,
  "DEP" INTEGER,
  "DOB" INTEGER,
  "DOE" INTEGER,
  "DOF" INTEGER,
  "DOHMH" INTEGER,
  "DPR" INTEGER,
  "FEMA" INTEGER,
  "HPD" INTEGER,
  "HRA" INTEGER,
  "MFANYC" INTEGER,
  "MOSE" INTEGER,
  "NYCEM" INTEGER,
  "NYCHA" INTEGER,
  "NYCSERVICE" INTEGER,
  "NYPD" INTEGER,
  "NYSDOL" INTEGER,
  "SBS" INTEGER,
  "NYSEMERGENCYMG" INTEGER,
  "total" INTEGER
);
Powered by Datasette · Query took 84.111ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub