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

1,783 rows sorted by DOHMH

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
224 6/2/13 0 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 5 8
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
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
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
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
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 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 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 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 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
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 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 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
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 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
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 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
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
260 7/8/13 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 4 8 16
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
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
267 7/15/13 0 0 0 0 3 0 2 0 4 0 0 0 0 0 0 0 1 0 3 0 0 1 7 21
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
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
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
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
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
290 8/7/13 0 0 0 0 1 0 2 0 0 0 0 0 0 0 0 0 2 1 2 0 0 3 11 22
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
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
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
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
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
309 8/26/13 0 0 0 0 3 1 1 0 9 0 0 0 0 0 0 0 2 0 1 0 0 1 0 18
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
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
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
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
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
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
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
335 9/21/13 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 3 5
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
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
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
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
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
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
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
368 10/24/13 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 6 9
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
371 10/27/13 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 6 8
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
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
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 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
381 11/6/13 0 0 0 0 6 0 1 0 4 0 0 0 0 0 0 0 0 0 1 0 0 2 6 20
383 11/8/13 0 0 0 0 3 0 0 0 4 0 0 0 0 0 0 0 0 0 1 0 1 0 6 15
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
386 11/11/13 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 13
387 11/12/13 0 0 0 0 6 1 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 2 11
389 11/14/13 0 0 0 0 3 0 0 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0 7 14
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

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 6.228ms