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

Table actions

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

1,626 rows where HPD = 0

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: NYC-3-1-1, ACS, BPSI, DEP, DOHMH, DPR, FEMA, HRA, MFANYC, MOSE, 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
1 1 10/22/12 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
2 2 10/23/12 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
3 3 10/24/12 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
4 4 10/25/12 0 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4
5 5 10/26/12 0 0 0 0 0 0 0 36 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 36
6 6 10/27/12 207 0 0 0 0 0 0 312 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 519
7 7 10/28/12 6325 0 0 0 0 0 0 23 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 6351
8 8 10/29/12 7922 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0 128 0 0 0 0 0 0 8054
9 9 10/30/12 2843 0 0 0 0 0 0 53 0 0 0 0 0 0 0 0 154 0 0 0 0 0 0 3050
10 10 10/31/12 7668 0 0 0 0 0 0 280 0 0 0 0 0 0 0 0 75 0 0 0 0 0 0 8023
11 11 11/1/12 1717 0 0 0 0 0 0 27 0 0 0 0 0 0 0 0 108 0 0 0 0 17 0 1869
12 12 11/2/12 317 0 0 0 0 0 0 28 0 0 0 0 0 0 0 0 71 0 0 0 0 43 0 459
13 13 11/3/12 103 0 0 0 0 0 0 250 0 0 0 0 0 0 0 0 36 0 0 0 0 9 0 398
14 14 11/4/12 106 0 0 0 0 0 0 4905 0 0 0 0 0 0 0 0 22 0 0 0 0 3 0 5036
15 15 11/5/12 186 0 0 4 0 0 12 1417 0 0 0 0 0 0 0 0 42 0 0 0 0 27 0 1688
16 16 11/6/12 232 0 0 42 0 0 31 1535 0 0 0 0 0 0 123 0 27 0 0 0 0 14 0 2004
17 17 11/7/12 269 0 0 33 0 0 55 1434 0 0 0 0 0 0 287 0 29 0 0 0 0 9 0 2116
18 18 11/8/12 169 0 0 37 0 0 72 1035 0 0 0 0 0 0 194 0 92 0 0 0 0 12 0 1611
19 19 11/9/12 115 0 0 112 0 0 57 143 0 0 0 0 0 0 182 0 59 0 0 0 0 11 0 679
20 20 11/10/12 28 0 0 66 0 0 90 36 0 0 0 0 0 0 104 0 11 0 0 0 0 1 0 336
21 21 11/11/12 27 0 0 43 0 0 56 50 0 0 0 0 0 0 62 0 3 0 0 0 0 1 0 242
22 22 11/12/12 56 0 0 93 0 0 89 258 0 0 0 0 0 0 212 0 29 0 0 0 0 13 0 750
23 23 11/13/12 0 0 0 101 83 0 100 220 0 0 0 0 0 0 0 0 21 0 0 0 0 12 0 537
24 24 11/14/12 0 0 3 81 107 0 74 83 0 0 0 0 0 0 0 0 26 0 0 0 0 12 0 386
25 25 11/15/12 5 0 28 53 235 0 78 49 0 0 0 0 0 0 0 0 27 4 0 0 0 8 0 487
26 26 11/16/12 0 0 17 44 202 0 45 34 0 0 0 0 0 0 0 0 17 7 0 0 0 13 0 379
27 27 11/17/12 0 0 6 15 105 0 32 5 0 0 0 0 0 0 0 0 7 6 0 0 0 1 0 177
28 28 11/18/12 0 0 4 38 91 0 30 28 0 0 0 0 0 0 0 0 12 4 0 0 0 0 0 207
29 29 11/19/12 0 0 14 46 202 0 97 63 0 0 0 0 0 0 0 0 13 10 0 0 0 7 0 452
30 30 11/20/12 0 0 9 37 224 0 59 25 0 0 0 0 0 0 0 0 12 5 0 0 0 14 0 385
31 31 11/21/12 0 0 5 23 191 0 42 14 0 0 3 0 0 0 0 0 8 3 0 8 0 4 0 301
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
33 33 11/23/12 0 0 7 27 189 0 43 1 0 0 52 0 0 0 0 0 4 3 42 3 0 4 0 375
34 34 11/24/12 0 0 3 25 164 4 25 2 0 0 31 0 0 0 0 0 9 4 25 2 0 17 0 311
35 35 11/25/12 0 0 1 13 134 2 17 11 0 0 18 0 0 0 0 0 6 2 71 5 0 18 0 298
36 36 11/26/12 0 0 4 38 578 2 47 30 0 0 54 0 0 0 0 0 18 6 93 4 1254 52 0 2180
37 37 11/27/12 0 0 8 29 465 0 46 15 0 0 56 0 0 0 0 0 12 4 26 1 797 28 0 1487
38 38 11/28/12 0 5 2 31 337 0 58 9 0 0 46 0 0 0 0 0 4 6 16 2 361 22 0 899
39 39 11/29/12 0 5 4 27 283 0 65 6 32 3 42 0 0 0 0 0 12 7 11 5 233 12 0 747
40 40 11/30/12 0 5 2 39 161 2 52 7 57 7 44 0 0 0 0 0 8 4 11 3 122 10 0 534
41 41 12/1/12 0 0 1 14 131 2 20 6 11 7 21 0 0 0 0 0 10 5 6 1 68 1 0 304
42 42 12/2/12 0 0 1 7 120 0 12 7 4 4 15 0 0 0 0 0 1 0 9 4 49 1 0 234
43 43 12/3/12 0 1 1 23 221 3 53 8 90 4 45 0 0 0 0 0 7 3 11 0 129 8 0 607
44 44 12/4/12 0 3 4 11 167 5 42 7 92 4 37 0 0 0 0 0 5 3 8 4 122 4 0 518
45 45 12/5/12 0 3 2 19 158 3 37 5 87 6 37 0 0 0 0 4 16 2 7 3 113 6 0 508
46 46 12/6/12 0 0 1 36 206 4 28 5 51 1 42 0 0 0 0 7 3 8 12 9 153 9 0 575
47 47 12/7/12 0 1 1 12 148 1 25 1 48 4 21 0 0 1 0 7 7 2 6 3 117 11 0 416
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
49 49 12/9/12 0 0 3 5 72 1 10 0 6 1 0 0 0 16 0 0 4 2 4 0 42 0 0 166
50 50 12/10/12 0 1 2 12 156 7 35 7 33 9 0 0 0 57 0 5 6 0 11 1 90 11 0 443
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
52 52 12/12/12 0 0 0 17 151 2 26 3 60 14 0 0 0 86 0 4 6 4 10 6 96 4 0 489
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
54 54 12/14/12 0 2 1 15 111 3 31 4 40 10 0 0 0 81 0 6 3 5 12 3 65 4 0 396
55 55 12/15/12 0 0 2 9 41 0 11 0 14 4 0 0 0 49 0 1 1 0 2 0 19 0 0 153
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
59 59 12/19/12 0 0 0 7 80 2 18 1 20 14 0 0 0 41 0 8 2 2 6 4 57 5 0 267
60 60 12/20/12 0 0 1 0 59 1 9 4 38 7 0 0 0 0 0 1 3 0 3 3 32 2 0 163
62 62 12/22/12 0 0 1 1 71 0 2 0 5 3 0 0 0 0 0 0 3 0 1 0 13 0 0 100
154 154 3/24/13 0 0 0 0 6 1 0 0 1 0 0 0 0 0 0 0 0 0 4 0 0 1 0 13
161 161 3/31/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 0 0 1 0 5
174 174 4/13/13 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 1 0 4 0 0 0 0 7
182 182 4/21/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 2
196 196 5/5/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 5
216 216 5/25/13 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 3 1 2 8
217 217 5/26/13 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 2
226 226 6/4/13 0 0 0 0 22 0 2 0 4 0 0 0 0 0 0 5 0 0 3 1 2 12 34 85
227 227 6/5/13 0 0 0 0 11 0 1 0 3 4 0 0 0 0 0 0 2 0 1 0 2 3 23 50
228 228 6/6/13 0 0 0 0 7 1 2 0 3 2 0 0 0 0 0 2 0 0 5 0 0 7 14 43
229 229 6/7/13 0 0 0 0 7 0 4 0 2 2 0 0 0 0 0 1 0 0 2 0 0 6 16 40
230 230 6/8/13 0 0 0 0 4 0 1 0 0 1 0 0 0 0 0 0 0 0 3 0 0 0 6 15
231 231 6/9/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 2 0 0 0 3 6
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
233 233 6/11/13 0 0 0 0 4 0 2 0 1 1 0 0 0 0 0 1 1 0 2 0 2 2 16 32
234 234 6/12/13 0 0 0 0 3 0 4 0 3 3 0 0 0 0 0 1 0 0 1 0 3 7 20 45
235 235 6/13/13 0 0 0 0 4 0 3 0 8 1 0 0 0 0 0 0 0 0 0 0 1 2 15 34
236 236 6/14/13 0 0 0 0 5 1 4 0 3 0 0 0 0 0 0 0 0 2 3 0 0 2 14 34
237 237 6/15/13 0 0 0 0 1 0 0 0 6 1 0 0 0 0 0 0 0 0 2 0 0 0 7 17
238 238 6/16/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 2
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
240 240 6/18/13 0 0 0 0 2 0 2 0 8 1 0 0 0 0 0 0 0 0 0 0 0 0 9 22
241 241 6/19/13 0 0 0 0 2 1 4 0 6 0 0 0 0 0 0 1 0 0 1 0 1 5 13 34
242 242 6/20/13 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 2 0 0 4 0 1 3 14 26
243 243 6/21/13 0 0 0 0 3 0 2 0 3 0 0 0 0 0 0 0 0 0 4 0 0 1 9 22
244 244 6/22/13 0 0 0 0 1 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 1 3 7
245 245 6/23/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 7 9
246 246 6/24/13 0 0 0 0 3 0 2 0 1 1 0 0 0 0 0 1 0 0 3 0 1 5 19 36
247 247 6/25/13 0 0 0 0 2 0 1 0 2 0 0 0 0 0 0 1 0 0 1 0 0 3 18 28
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
249 249 6/27/13 0 0 0 0 6 0 1 0 2 2 0 0 0 0 0 2 0 0 6 1 0 4 11 35
250 250 6/28/13 0 0 0 0 1 0 2 0 0 0 0 0 0 0 0 1 1 0 2 0 0 2 12 21
251 251 6/29/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 2 2 6
252 252 6/30/13 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 2 0 0 0 8 12
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
254 254 7/2/13 0 1 0 0 2 0 2 0 1 0 0 0 0 0 0 1 0 0 3 0 3 2 8 23
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
256 256 7/4/13 0 0 0 0 1 0 2 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 4
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

Next page

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
);