home / fivethirtyeight

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

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

1,783 rows sorted by CHALL

View and edit SQL

Suggested facets: NYC-3-1-1, ACS, BPSI, DEP, DOHMH, DPR, FEMA, HPD, HRA, MFANYC, MOSE, NYCHA, NYCSERVICE, NYPD, 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 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 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 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 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 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 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 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 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 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/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/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 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 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 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 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 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 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 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 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 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 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 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
147 3/17/13 0 0 0 0 0 0 5 0 1 0 0 0 5 0 0 0 1 0 8 0 0 0 0 20
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
175 4/14/13 0 0 0 0 0 0 0 0 0 0 0 0 5 0 0 0 0 0 3 1 1 0 0 10
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
188 4/27/13 0 0 0 0 0 0 2 0 1 0 0 0 3 0 0 1 0 0 3 0 0 0 6 16
195 5/4/13 0 0 0 0 0 0 1 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 3 6
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
218 5/27/13 0 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 1 0 0 0 1 0 1 5
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
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
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
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 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
259 7/7/13 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 1 3
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
280 7/28/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2
286 8/3/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1
287 8/4/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 2
292 8/9/13 0 0 0 0 0 0 2 0 1 1 0 0 0 0 0 0 0 0 2 0 0 0 8 14
294 8/11/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
297 8/14/13 0 0 0 0 0 0 2 0 2 2 0 0 0 0 0 0 0 0 0 0 0 3 6 15
300 8/17/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
304 8/21/13 0 0 0 0 0 0 0 0 9 2 0 0 0 0 0 0 0 0 0 0 1 1 7 20
307 8/24/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1
308 8/25/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 2
313 8/30/13 0 0 0 0 0 0 1 0 11 1 0 0 0 0 0 0 0 0 0 0 0 1 5 19
314 8/31/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
315 9/1/13 0 0 0 0 0 0 0 0 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 3
316 9/2/13 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 1 3
319 9/5/13 0 0 0 0 0 0 2 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 7 15
321 9/7/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 1 0 3
322 9/8/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2
323 9/9/13 0 0 0 0 0 0 1 0 4 2 0 0 0 0 0 0 0 0 0 0 0 2 7 16
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
327 9/13/13 0 0 0 0 0 0 1 0 4 2 0 0 0 0 0 1 0 0 0 0 0 3 3 14
329 9/15/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
332 9/18/13 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 2 0 0 1 3 8
333 9/19/13 0 0 0 0 0 0 1 0 2 1 0 0 0 0 0 1 0 0 2 0 0 1 8 16
336 9/22/13 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 2
339 9/25/13 0 0 0 0 0 0 1 0 2 0 0 0 0 0 0 0 0 0 1 0 0 3 8 15
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
341 9/27/13 0 0 0 0 0 0 0 0 3 2 0 0 0 0 0 0 0 0 1 1 0 2 8 17
343 9/29/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 8 9
345 10/1/13 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 2 9 13
350 10/6/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
351 10/7/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8 8
353 10/9/13 0 0 0 0 0 1 0 0 5 0 0 0 0 0 0 1 0 0 0 0 0 2 4 13
355 10/11/13 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 1 0 2 3 8
356 10/12/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2
357 10/13/13 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 2 4
362 10/18/13 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 3 4 10
364 10/20/13 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 2 3
369 10/25/13 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 2 0 0 1 5 10
370 10/26/13 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 3 5
373 10/29/13 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 2 0 0 1 0 1 9 17 31
375 10/31/13 0 0 0 0 0 0 1 0 1 1 0 0 0 0 0 0 0 0 1 0 1 0 8 13
376 11/1/13 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 5 9 16
377 11/2/13 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 4 0 0 2 5 12
380 11/5/13 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 1 0 1 5 9
384 11/9/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
390 11/15/13 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 5 8
391 11/16/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
399 11/24/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
403 11/28/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
412 12/7/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
416 12/11/13 0 0 0 0 0 0 0 0 4 1 0 0 0 0 0 0 0 0 0 0 0 0 2 7
419 12/14/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2
420 12/15/13 0 0 0 0 0 0 0 0 1 2 0 0 0 0 0 0 0 0 0 0 0 1 1 5
421 12/16/13 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 1 0 0 0 2 5
424 12/19/13 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 2 3
425 12/20/13 0 0 0 0 0 1 0 0 3 0 0 0 0 0 0 0 0 0 1 1 0 0 4 10
427 12/22/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
430 12/25/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
432 12/27/13 0 0 0 0 0 0 1 0 2 0 0 0 0 0 0 0 0 0 0 1 0 0 3 7
433 12/28/13 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 2
434 12/29/13 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 2
435 12/30/13 0 0 0 0 0 1 0 0 1 1 0 0 0 0 0 1 0 0 0 0 0 0 3 7
437 1/1/14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

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
)
Powered by Datasette · Query took 257.305ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub