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

34 rows where NYSEMERGENCYMG = 5 sorted by DOHMH

View and edit SQL

Suggested facets: ACS, CHALL, DEP, DOB, DOF, DOHMH, HPD, MOSE, NYCEM, NYCHA, NYCSERVICE, NYPD, NYSDOL, SBS, total

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
189 4/28/13 0 0 0 0 2 1 1 0 0 0 0 0 2 0 0 0 1 0 3 0 0 0 5 15
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
202 5/11/13 0 0 0 0 4 0 0 0 0 0 0 0 4 0 0 0 0 0 1 0 0 0 5 14
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
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
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
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
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
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
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
394 11/19/13 0 0 0 0 1 0 0 0 4 0 0 0 0 0 0 0 0 0 1 0 1 0 5 12
400 11/25/13 0 0 0 0 7 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 13
402 11/27/13 0 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 5 8
404 11/29/13 0 0 0 0 4 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 5 10
411 12/6/13 0 0 0 0 2 1 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 5 10
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
470 2/3/14 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 5 8
511 3/16/14 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 6
590 6/3/14 0 0 0 0 2 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 5 9
639 7/22/14 0 0 0 0 2 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 5 10
1074 9/30/15 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 6
1115 11/10/15 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 6
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
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
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
414 12/9/13 0 0 0 0 2 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 5 9
568 5/12/14 0 0 0 0 1 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 5 8
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
575 5/19/14 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 1 0 1 0 0 0 5 9
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
618 7/1/14 0 0 0 0 2 0 0 0 8 2 0 0 0 0 0 0 0 0 0 0 0 0 5 17
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 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

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