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
50 rows where NYCHA = 1
This data as json, copyable, CSV (advanced)
Suggested facets: ACS, BPSI, CAU, DEP, DOB, DOE, DOF, DOHMH, DPR, HPD, HRA, MOSE, NYCEM, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32 | 32 | 11/22/12 | 0 | 0 | 2 | 8 | 58 | 0 | 10 | 0 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 0 | 0 | 0 | 93 |
48 | 48 | 12/8/12 | 0 | 0 | 0 | 5 | 109 | 0 | 13 | 0 | 11 | 8 | 0 | 0 | 0 | 18 | 0 | 4 | 5 | 1 | 5 | 0 | 56 | 2 | 0 | 237 |
51 | 51 | 12/11/12 | 0 | 0 | 1 | 17 | 132 | 1 | 15 | 2 | 61 | 9 | 0 | 0 | 0 | 48 | 0 | 1 | 9 | 1 | 4 | 2 | 109 | 11 | 0 | 423 |
53 | 53 | 12/13/12 | 0 | 1 | 1 | 20 | 111 | 3 | 11 | 7 | 48 | 11 | 0 | 0 | 0 | 65 | 0 | 2 | 2 | 1 | 8 | 3 | 96 | 5 | 0 | 395 |
56 | 56 | 12/16/12 | 0 | 0 | 0 | 5 | 46 | 2 | 8 | 1 | 2 | 10 | 0 | 0 | 0 | 356 | 0 | 1 | 0 | 1 | 2 | 1 | 22 | 3 | 0 | 460 |
57 | 57 | 12/17/12 | 0 | 1 | 4 | 15 | 101 | 3 | 31 | 2 | 68 | 9 | 0 | 0 | 0 | 331 | 0 | 3 | 5 | 1 | 8 | 3 | 81 | 6 | 0 | 672 |
58 | 58 | 12/18/12 | 0 | 0 | 3 | 8 | 95 | 0 | 30 | 2 | 41 | 5 | 0 | 0 | 0 | 231 | 0 | 1 | 8 | 1 | 6 | 0 | 50 | 8 | 0 | 489 |
63 | 63 | 12/23/12 | 0 | 1 | 0 | 0 | 45 | 0 | 0 | 2 | 2 | 6 | 0 | 0 | 7 | 0 | 0 | 0 | 1 | 1 | 4 | 0 | 7 | 1 | 0 | 77 |
67 | 67 | 12/27/12 | 0 | 0 | 0 | 2 | 93 | 1 | 16 | 1 | 25 | 4 | 0 | 0 | 15 | 0 | 0 | 0 | 2 | 1 | 4 | 2 | 25 | 7 | 0 | 198 |
69 | 69 | 12/29/12 | 0 | 0 | 1 | 1 | 81 | 1 | 2 | 1 | 6 | 0 | 0 | 0 | 3 | 0 | 0 | 2 | 1 | 1 | 0 | 0 | 8 | 0 | 0 | 108 |
70 | 70 | 12/30/12 | 0 | 0 | 0 | 0 | 47 | 0 | 3 | 0 | 2 | 3 | 0 | 0 | 6 | 0 | 0 | 0 | 4 | 1 | 0 | 1 | 6 | 0 | 0 | 73 |
72 | 72 | 1/1/13 | 0 | 0 | 0 | 0 | 30 | 0 | 0 | 13 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 6 | 1 | 0 | 55 |
76 | 76 | 1/5/13 | 0 | 0 | 0 | 0 | 58 | 0 | 4 | 0 | 5 | 4 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 4 | 2 | 0 | 82 |
79 | 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 |
81 | 81 | 1/10/13 | 0 | 0 | 0 | 1 | 115 | 2 | 11 | 0 | 6 | 4 | 0 | 0 | 8 | 0 | 0 | 3 | 2 | 1 | 1 | 0 | 20 | 2 | 0 | 176 |
85 | 85 | 1/14/13 | 0 | 0 | 0 | 0 | 162 | 0 | 13 | 5 | 14 | 2 | 0 | 0 | 7 | 0 | 0 | 1 | 2 | 1 | 0 | 1 | 19 | 5 | 0 | 232 |
87 | 87 | 1/16/13 | 0 | 0 | 0 | 0 | 67 | 1 | 11 | 1 | 14 | 1 | 0 | 0 | 17 | 0 | 0 | 1 | 2 | 1 | 2 | 1 | 20 | 1 | 0 | 140 |
89 | 89 | 1/18/13 | 0 | 0 | 1 | 1 | 59 | 0 | 9 | 1 | 10 | 1 | 0 | 0 | 22 | 0 | 0 | 1 | 0 | 1 | 3 | 1 | 13 | 2 | 0 | 125 |
93 | 93 | 1/22/13 | 0 | 0 | 1 | 0 | 69 | 1 | 9 | 2 | 18 | 2 | 0 | 0 | 21 | 0 | 0 | 1 | 4 | 1 | 3 | 1 | 22 | 1 | 0 | 156 |
95 | 95 | 1/24/13 | 0 | 0 | 0 | 1 | 39 | 0 | 11 | 1 | 22 | 2 | 0 | 0 | 10 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 11 | 16 | 0 | 117 |
99 | 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 |
100 | 100 | 1/29/13 | 0 | 2 | 1 | 0 | 52 | 0 | 9 | 0 | 31 | 6 | 0 | 0 | 28 | 0 | 0 | 0 | 1 | 1 | 1 | 4 | 13 | 19 | 0 | 168 |
108 | 108 | 2/6/13 | 0 | 0 | 1 | 1 | 31 | 2 | 4 | 0 | 38 | 0 | 0 | 0 | 25 | 0 | 0 | 1 | 0 | 1 | 7 | 0 | 8 | 6 | 0 | 125 |
115 | 115 | 2/13/13 | 0 | 0 | 1 | 2 | 26 | 1 | 3 | 1 | 26 | 1 | 0 | 0 | 18 | 0 | 0 | 0 | 0 | 1 | 11 | 1 | 8 | 2 | 0 | 102 |
122 | 122 | 2/20/13 | 0 | 0 | 0 | 3 | 24 | 0 | 6 | 1 | 18 | 3 | 0 | 0 | 25 | 0 | 0 | 2 | 0 | 1 | 18 | 1 | 7 | 5 | 0 | 114 |
131 | 131 | 3/1/13 | 0 | 0 | 1 | 0 | 14 | 0 | 4 | 0 | 20 | 4 | 0 | 0 | 14 | 0 | 0 | 0 | 0 | 1 | 6 | 0 | 2 | 1 | 0 | 67 |
138 | 138 | 3/8/13 | 0 | 0 | 0 | 0 | 4 | 0 | 3 | 0 | 18 | 3 | 0 | 0 | 10 | 0 | 0 | 1 | 0 | 1 | 2 | 2 | 2 | 3 | 0 | 49 |
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 |
150 | 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 |
151 | 151 | 3/21/13 | 0 | 0 | 0 | 0 | 5 | 0 | 2 | 0 | 0 | 1 | 0 | 0 | 11 | 0 | 0 | 1 | 1 | 1 | 12 | 0 | 1 | 3 | 0 | 38 |
162 | 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 |
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 |
164 | 164 | 4/3/13 | 0 | 0 | 0 | 0 | 10 | 1 | 3 | 0 | 5 | 1 | 0 | 0 | 13 | 0 | 0 | 0 | 0 | 1 | 4 | 1 | 0 | 2 | 0 | 41 |
173 | 173 | 4/12/13 | 0 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 4 | 2 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 1 | 4 | 0 | 1 | 1 | 0 | 24 |
204 | 204 | 5/13/13 | 0 | 0 | 0 | 0 | 16 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 7 | 0 | 0 | 2 | 0 | 1 | 4 | 0 | 0 | 6 | 26 | 65 |
215 | 215 | 5/24/13 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 3 | 0 | 1 | 1 | 7 | 22 |
232 | 232 | 6/10/13 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 6 | 1 | 3 | 8 | 28 | 60 |
239 | 239 | 6/17/13 | 0 | 0 | 0 | 0 | 4 | 1 | 6 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 5 | 14 | 36 |
248 | 248 | 6/26/13 | 0 | 0 | 0 | 0 | 2 | 1 | 2 | 0 | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 6 | 0 | 1 | 3 | 11 | 32 |
253 | 253 | 7/1/13 | 0 | 0 | 0 | 0 | 5 | 1 | 5 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 5 | 0 | 0 | 3 | 16 | 43 |
255 | 255 | 7/3/13 | 0 | 0 | 0 | 0 | 2 | 0 | 4 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 2 | 12 | 28 |
257 | 257 | 7/5/13 | 0 | 0 | 0 | 0 | 2 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 5 | 0 | 1 | 0 | 13 | 26 |
261 | 261 | 7/9/13 | 0 | 0 | 0 | 0 | 4 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 4 | 0 | 0 | 0 | 15 | 29 |
271 | 271 | 7/19/13 | 0 | 2 | 0 | 0 | 3 | 0 | 1 | 0 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 2 | 0 | 0 | 4 | 5 | 25 |
276 | 276 | 7/24/13 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 1 | 12 | 18 |
290 | 290 | 8/7/13 | 0 | 0 | 0 | 0 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 2 | 0 | 0 | 3 | 11 | 22 |
298 | 298 | 8/15/13 | 0 | 0 | 0 | 0 | 1 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 2 | 0 | 2 | 2 | 10 | 22 |
326 | 326 | 9/12/13 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 5 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 4 | 6 | 19 |
340 | 340 | 9/26/13 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 4 | 8 |
372 | 372 | 10/28/13 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 3 | 17 | 30 |
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 );