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

82 rows where MOSE = 1

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: ACS, BPSI, CAU, DEP, DOB, DOE, DOF, DOHMH, HPD, HRA, 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
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
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
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
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
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
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
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
96 96 1/25/13 0 0 0 2 47 0 9 0 17 1 0 0 14 0 0 1 0 2 3 0 10 18 0 124
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
101 101 1/30/13 0 2 1 1 34 1 13 0 57 1 0 0 18 0 0 1 4 0 8 2 4 12 0 159
106 106 2/4/13 0 0 0 1 40 0 10 0 50 1 0 0 22 0 0 1 1 0 9 0 14 8 0 157
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
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
117 117 2/15/13 0 0 0 2 29 2 5 0 11 1 0 0 12 0 0 1 2 0 21 3 7 6 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
126 126 2/24/13 0 0 0 0 6 0 3 0 3 1 0 0 5 0 0 1 0 0 4 0 2 0 0 25
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
129 129 2/27/13 0 0 1 0 20 1 11 0 24 3 0 0 22 0 0 1 0 0 7 2 5 6 0 103
133 133 3/3/13 0 0 0 0 2 0 1 0 0 2 0 0 7 0 0 1 1 0 5 0 2 0 0 21
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
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
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
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
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
172 172 4/11/13 0 0 0 0 3 0 2 0 6 0 0 0 7 0 0 1 1 0 2 0 2 2 0 26
179 179 4/18/13 0 0 0 0 3 0 5 0 5 0 0 0 3 0 0 1 0 0 2 0 0 0 6 25
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
188 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
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
200 200 5/9/13 0 0 0 0 3 0 3 0 2 3 0 0 13 0 0 1 0 0 1 0 1 2 14 43
211 211 5/20/13 0 0 0 0 13 0 2 0 2 0 0 0 4 0 0 1 2 0 5 0 1 0 14 44
212 212 5/21/13 0 0 0 0 2 0 3 0 3 2 0 0 7 0 0 1 2 0 4 0 0 4 11 39
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
219 219 5/28/13 0 0 0 0 6 0 4 0 5 0 0 0 7 0 0 1 0 0 5 0 1 3 16 48
220 220 5/29/13 0 0 0 0 9 0 1 0 8 0 0 0 11 0 0 1 0 0 5 0 0 3 20 58
222 222 5/31/13 0 0 0 0 8 0 2 0 6 0 0 0 4 0 0 1 0 0 2 0 1 3 23 50
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
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
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
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
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
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
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
262 262 7/10/13 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 1 0 0 4 0 1 4 11 23
263 263 7/11/13 0 0 0 0 1 1 0 0 2 0 0 0 0 0 0 1 0 0 1 0 1 5 5 17
268 268 7/16/13 0 0 0 0 3 0 3 0 2 1 0 0 0 0 0 1 0 0 2 0 1 2 3 18
269 269 7/17/13 0 0 0 0 4 1 0 0 1 1 0 0 0 0 0 1 0 0 4 2 0 5 11 30
270 270 7/18/13 0 1 0 0 1 0 2 0 1 0 0 0 0 0 0 1 0 0 0 0 0 1 8 15
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
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
275 275 7/23/13 0 0 0 0 3 0 1 0 0 0 0 0 0 0 0 1 0 0 1 0 0 3 7 16
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
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
324 324 9/10/13 0 0 0 0 2 0 0 0 2 0 0 0 0 0 0 1 0 0 2 2 0 1 10 20
327 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
333 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
342 342 9/28/13 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 1 1 5
344 344 9/30/13 0 0 0 0 4 0 0 0 2 2 0 0 0 0 0 1 0 0 4 0 0 6 14 33
353 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
365 365 10/21/13 0 0 0 0 1 0 2 0 3 0 0 0 0 0 0 1 0 0 0 0 0 2 6 15
366 366 10/22/13 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 3 0 3 9
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
385 385 11/10/13 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 1 1 0 1 0 0 0 2 7
428 428 12/23/13 0 0 0 0 1 0 0 0 2 1 0 0 0 0 0 1 1 0 0 0 0 0 2 8
435 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
447 447 1/11/14 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 1 0 0 0 0 0 0 0 3
462 462 1/26/14 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 1 0 0 0 0 0 0 1 4
473 473 2/6/14 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 1 0 0 0 0 0 2 1 6
476 476 2/9/14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 2

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