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 NYCEM

View and edit SQL

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
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 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 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 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 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
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 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 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 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
258 7/6/13 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7 10
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
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 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
264 7/12/13 0 0 0 0 8 0 3 0 0 1 0 0 0 0 0 0 0 0 2 0 1 0 10 25
265 7/13/13 0 0 0 0 1 0 0 0 0 2 0 0 0 0 0 0 0 0 1 0 2 1 4 11
266 7/14/13 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 4 6
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 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 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 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
272 7/20/13 0 0 0 0 1 0 0 0 1 1 0 0 0 0 0 0 0 0 1 0 0 0 2 6
273 7/21/13 0 0 0 0 2 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 2 6
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 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
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 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
279 7/27/13 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 1 4
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
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
283 7/31/13 0 0 0 0 3 1 1 0 1 0 0 0 0 0 0 2 0 0 0 0 1 4 7 20
284 8/1/13 0 0 0 0 2 0 0 0 7 1 0 0 0 0 0 0 0 0 0 0 0 3 7 20
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
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
291 8/8/13 0 0 0 0 1 0 2 0 1 1 0 0 0 0 0 0 0 0 2 0 0 5 5 17
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
293 8/10/13 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 1 4
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
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
299 8/16/13 0 0 0 0 2 0 1 0 2 3 0 0 0 0 0 0 0 0 0 0 1 3 7 19
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
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 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
303 8/20/13 0 0 0 0 1 0 1 0 8 2 0 0 0 0 0 0 0 0 0 0 0 0 6 18
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
305 8/22/13 0 0 0 0 3 0 0 0 1 1 0 0 0 0 0 5 0 0 0 0 0 4 9 23
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
310 8/27/13 0 0 0 0 2 2 2 0 4 1 0 0 0 0 0 0 0 0 1 0 0 5 10 27
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
312 8/29/13 0 0 0 0 3 0 0 0 5 0 0 0 0 0 0 0 0 0 0 0 0 1 5 14
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
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
318 9/4/13 0 0 0 0 1 0 0 0 7 0 0 0 0 0 0 0 0 0 0 0 0 1 3 12
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
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
325 9/11/13 0 0 0 0 3 0 0 0 12 2 0 0 0 0 0 0 0 0 1 0 0 2 5 25
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
328 9/14/13 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 2 5
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
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 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
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
334 9/20/13 0 0 0 0 1 0 0 0 2 0 0 0 0 0 0 0 0 0 3 0 0 0 8 14
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
337 9/23/13 0 0 0 0 1 0 1 0 3 2 0 0 0 0 0 0 0 0 2 0 0 2 4 15
338 9/24/13 0 0 0 0 3 0 0 0 2 1 0 0 0 0 0 0 0 0 0 0 0 3 12 21
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
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
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
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
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
346 10/2/13 0 0 0 0 1 1 0 0 3 0 0 0 0 0 0 0 0 0 1 0 0 2 3 11
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
348 10/4/13 0 0 0 0 1 0 1 0 3 1 0 0 0 0 0 0 0 0 1 0 0 3 6 16
349 10/5/13 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 5
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
352 10/8/13 0 0 0 0 1 0 3 0 0 0 0 0 0 0 0 2 0 0 1 2 0 3 4 16
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
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 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
358 10/14/13 0 0 0 0 4 0 0 0 1 1 0 0 0 0 0 0 0 0 1 0 0 1 5 13
359 10/15/13 0 0 0 0 4 1 2 0 4 0 0 0 0 0 0 2 0 0 2 2 1 0 7 25
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
361 10/17/13 0 0 0 0 2 3 0 0 6 1 0 0 0 0 0 0 0 0 0 0 0 1 7 20
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
363 10/19/13 0 0 0 0 1 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3
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

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 9.578ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub