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

150 rows where NYPD = 1

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: ACS, BPSI, CAU, DEP, DOB, DOE, DOF, DOHMH, DPR, HPD, HRA, MOSE, NYCEM, NYCHA, NYCSERVICE, 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
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
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
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
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
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
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
73 73 1/2/13 0 0 0 1 107 2 10 9 14 6 0 0 15 0 0 2 1 3 3 1 35 4 0 213
74 74 1/3/13 0 2 0 0 84 1 6 2 18 6 0 0 10 0 0 1 6 2 4 1 22 3 0 168
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
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
88 88 1/17/13 0 0 0 1 52 0 10 1 11 5 0 0 7 0 0 1 1 0 3 1 11 4 0 108
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
91 91 1/20/13 0 0 0 0 25 1 3 0 1 0 0 0 7 0 0 0 1 0 0 1 5 2 0 46
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
97 97 1/26/13 0 0 0 0 43 0 5 0 3 0 0 0 6 0 0 1 2 0 0 1 3 3 0 67
102 102 1/31/13 0 2 0 1 46 0 11 1 86 0 0 0 21 0 0 0 2 0 13 1 11 5 0 200
110 110 2/8/13 0 0 0 0 30 1 0 0 19 0 0 0 21 0 0 1 0 0 3 1 5 0 0 81
112 112 2/10/13 0 0 0 1 14 0 0 0 4 0 0 0 7 0 0 0 0 0 3 1 1 1 0 32
113 113 2/11/13 0 0 0 0 33 2 5 0 27 2 0 0 27 0 0 0 1 0 7 1 5 11 0 121
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
118 118 2/16/13 0 0 0 0 12 0 1 0 2 1 0 0 7 0 0 1 1 0 10 1 0 2 0 38
119 119 2/17/13 0 0 0 0 10 0 1 0 1 3 0 0 2 0 0 0 0 0 11 1 0 0 0 29
120 120 2/18/13 0 0 0 0 10 0 2 0 2 0 0 0 14 0 0 0 1 0 12 1 4 0 0 46
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
124 124 2/22/13 0 0 0 0 31 1 9 0 9 4 0 0 11 0 0 0 1 0 8 1 4 2 0 81
127 127 2/25/13 0 0 0 0 16 1 6 0 18 2 0 0 27 0 0 1 1 0 5 1 4 7 0 89
128 128 2/26/13 0 0 0 0 17 0 10 0 14 1 0 0 29 0 0 0 1 0 10 1 4 7 0 94
130 130 2/28/13 0 1 0 0 20 1 10 0 24 1 0 0 16 0 0 3 0 0 6 1 5 5 0 93
141 141 3/11/13 0 0 0 0 4 0 4 0 14 1 0 0 10 0 0 1 1 0 10 1 1 6 0 53
148 148 3/18/13 0 0 1 0 5 0 2 0 5 0 0 0 8 0 0 0 1 0 6 1 3 1 0 33
149 149 3/19/13 0 0 0 0 2 0 4 0 12 2 0 0 10 0 0 1 1 0 4 1 1 1 0 39
159 159 3/29/13 0 0 0 0 5 1 5 0 2 4 0 0 2 0 0 0 1 0 9 1 2 1 0 33
160 160 3/30/13 0 0 0 0 3 0 0 0 0 0 0 0 3 0 0 0 0 0 6 1 0 0 0 13
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
175 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
176 176 4/15/13 0 0 0 0 3 0 4 0 0 0 0 0 5 0 0 0 1 0 1 1 0 2 0 17
178 178 4/17/13 0 0 0 0 6 1 4 0 8 1 0 0 7 0 0 2 0 0 4 1 1 4 0 39
180 180 4/19/13 0 0 0 0 5 0 1 0 0 6 0 0 3 0 0 0 1 0 7 1 0 1 9 34
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
184 184 4/23/13 0 0 0 0 4 1 3 0 8 1 0 0 7 0 0 1 0 0 2 1 0 1 20 49
185 185 4/24/13 0 0 0 0 2 1 6 0 4 0 0 0 8 0 0 1 1 0 0 1 2 2 23 51
187 187 4/26/13 0 0 0 0 6 0 2 0 2 0 0 0 5 0 0 0 1 0 1 1 0 1 12 31
190 190 4/29/13 0 0 0 0 10 1 3 0 5 3 0 0 13 0 0 2 0 0 4 1 1 4 31 78
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
209 209 5/18/13 0 0 0 0 1 0 0 0 0 1 0 0 4 0 0 0 0 0 1 1 0 0 1 9
210 210 5/19/13 0 0 0 0 1 0 0 0 0 1 0 0 1 0 0 0 0 0 0 1 0 1 7 12
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
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
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
274 274 7/22/13 0 1 0 0 4 1 1 0 1 4 0 0 0 0 0 1 0 0 2 1 0 6 5 27
277 277 7/25/13 0 2 0 0 1 0 3 0 0 0 0 0 0 0 0 0 0 0 0 1 2 1 7 17
278 278 7/26/13 0 0 0 0 4 0 1 0 3 0 0 0 0 0 0 0 0 0 4 1 1 4 7 25
282 282 7/30/13 0 0 0 0 6 1 1 0 0 0 0 0 0 0 0 1 0 0 1 1 0 2 6 19
285 285 8/2/13 0 0 0 0 3 0 0 0 0 2 0 0 0 0 0 1 0 0 1 1 0 3 6 17
288 288 8/5/13 0 0 0 0 2 0 4 0 1 1 0 0 0 0 0 0 2 0 5 1 1 1 12 30
295 295 8/12/13 0 0 0 0 1 0 0 0 2 2 0 0 0 0 0 0 1 0 1 1 0 6 3 17
301 301 8/18/13 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 3
302 302 8/19/13 0 0 0 0 3 0 2 0 3 1 0 0 0 0 0 2 0 0 2 1 0 2 10 26
306 306 8/23/13 0 0 0 0 2 0 1 0 0 0 0 0 0 0 0 0 1 0 1 1 0 0 5 11
308 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
311 311 8/28/13 0 0 0 0 1 1 1 0 3 0 0 0 0 0 0 2 0 0 0 1 0 3 1 13
317 317 9/3/13 0 0 0 0 2 0 0 0 2 0 0 0 0 0 0 0 0 0 2 1 1 3 3 14
330 330 9/16/13 0 0 0 0 2 0 1 0 6 0 0 0 0 0 0 0 0 0 0 1 0 3 8 21
331 331 9/17/13 0 0 0 0 1 0 1 0 5 2 0 0 0 0 0 0 0 0 1 1 0 1 3 15
341 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
347 347 10/3/13 0 0 0 0 1 0 0 0 2 0 0 0 0 0 0 0 0 0 2 1 0 1 8 15
354 354 10/10/13 0 0 0 0 2 0 1 0 2 0 0 0 0 0 0 0 0 0 0 1 0 1 10 17
355 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
360 360 10/16/13 0 0 0 0 1 1 2 0 4 0 0 0 0 0 0 0 0 0 1 1 0 4 6 20
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
376 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
378 378 11/3/13 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 1 1 5
380 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
398 398 11/23/13 0 0 0 0 4 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 2 8
422 422 12/17/13 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 5 9
425 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
432 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
460 460 1/24/14 0 0 0 0 2 1 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 1 6
475 475 2/8/14 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 4
480 480 2/13/14 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 1 0 1 1 5
488 488 2/21/14 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 4 7
502 502 3/7/14 0 0 0 0 2 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 2 6
536 536 4/10/14 0 0 0 0 0 0 4 0 0 2 0 0 0 0 0 0 0 0 1 1 0 0 1 9
547 547 4/21/14 0 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 2 1 0 0 3 8
555 555 4/29/14 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 3 5
559 559 5/3/14 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 1 3
570 570 5/14/14 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 0 0 1 0 0 5 8
576 576 5/20/14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1
589 589 6/2/14 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 3 5
613 613 6/26/14 0 0 0 0 0 0 0 0 6 2 0 0 0 0 0 0 0 0 0 1 0 0 0 9
614 614 6/27/14 0 0 0 0 0 0 0 0 8 0 0 0 0 0 0 0 0 0 1 1 0 0 3 13
625 625 7/8/14 0 0 0 0 0 0 0 0 5 0 0 0 0 0 0 0 0 0 0 1 0 0 2 8
632 632 7/15/14 0 0 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0 0 0 1 0 0 1 6
642 642 7/25/14 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 1 0 0 2 5
683 683 9/4/14 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 1 4
689 689 9/10/14 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 1 0 0 2 5
692 692 9/13/14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 2

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