sandy-311-calls/sandy-311-calls-by-day
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
10 rows where HPD = 9 sorted by BPSI
This data as json, copyable, CSV (advanced)
Suggested facets: BPSI, CAU, CHALL, DEP, DOB, DOE, DOF, DOHMH, MOSE, NYCEM, NYCHA, NYCSERVICE, NYPD, NYSDOL, SBS, NYSEMERGENCYMG
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
64 | 64 | 12/24/12 | 0 | 0 | 0 | 1 | 49 | 0 | 9 | 0 | 12 | 1 | 0 | 0 | 9 | 0 | 0 | 2 | 2 | 3 | 8 | 1 | 17 | 1 | 0 | 115 |
75 | 75 | 1/4/13 | 0 | 0 | 0 | 4 | 94 | 0 | 7 | 0 | 24 | 6 | 0 | 0 | 9 | 0 | 0 | 0 | 2 | 3 | 3 | 0 | 21 | 1 | 0 | 174 |
142 | 142 | 3/12/13 | 0 | 0 | 0 | 0 | 7 | 1 | 6 | 0 | 16 | 4 | 0 | 0 | 9 | 0 | 0 | 0 | 1 | 1 | 6 | 0 | 2 | 7 | 0 | 60 |
163 | 163 | 4/2/13 | 0 | 0 | 0 | 0 | 4 | 1 | 4 | 0 | 6 | 0 | 0 | 0 | 9 | 0 | 0 | 1 | 0 | 1 | 6 | 0 | 2 | 0 | 0 | 34 |
169 | 169 | 4/8/13 | 0 | 0 | 0 | 0 | 3 | 2 | 3 | 0 | 6 | 2 | 0 | 0 | 9 | 0 | 0 | 0 | 1 | 0 | 2 | 0 | 0 | 3 | 0 | 31 |
191 | 191 | 4/30/13 | 0 | 0 | 0 | 0 | 5 | 2 | 2 | 0 | 2 | 2 | 0 | 0 | 9 | 0 | 0 | 1 | 0 | 0 | 4 | 0 | 0 | 1 | 20 | 48 |
193 | 193 | 5/2/13 | 0 | 0 | 0 | 0 | 4 | 0 | 2 | 0 | 1 | 1 | 0 | 0 | 9 | 0 | 0 | 1 | 0 | 0 | 8 | 0 | 0 | 1 | 16 | 43 |
198 | 198 | 5/7/13 | 0 | 0 | 0 | 0 | 3 | 0 | 2 | 0 | 3 | 1 | 0 | 0 | 9 | 0 | 0 | 0 | 2 | 0 | 9 | 1 | 0 | 2 | 14 | 46 |
82 | 82 | 1/11/13 | 0 | 0 | 1 | 0 | 138 | 1 | 12 | 2 | 8 | 3 | 0 | 0 | 9 | 0 | 0 | 0 | 1 | 2 | 4 | 0 | 5 | 2 | 0 | 188 |
78 | 78 | 1/7/13 | 0 | 0 | 2 | 0 | 98 | 2 | 8 | 3 | 15 | 12 | 0 | 0 | 9 | 0 | 0 | 2 | 2 | 2 | 1 | 0 | 24 | 4 | 0 | 184 |
Advanced export
JSON shape: default, array, newline-delimited
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 );