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

38 rows where NYSEMERGENCYMG = 4 sorted by DOHMH

View and edit SQL

Suggested facets: CHALL, DEP, DOB, DOF, DOHMH, 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
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
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
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
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
417 12/12/13 0 0 0 0 1 0 0 0 3 0 0 0 0 0 0 0 1 0 0 0 0 0 4 9
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
431 12/26/13 0 0 0 0 1 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 4 7
439 1/3/14 0 0 0 0 0 0 1 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 4 7
442 1/6/14 0 0 0 0 2 0 1 0 1 0 0 0 0 0 0 5 0 0 0 0 0 1 4 14
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
515 3/20/14 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 4 6
526 3/31/14 0 0 0 0 1 0 2 0 1 0 0 0 0 0 0 0 0 0 1 0 1 0 4 10
527 4/1/14 0 0 0 0 0 0 2 0 2 0 0 0 0 0 0 0 0 0 0 0 0 1 4 9
533 4/7/14 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 4 7
544 4/18/14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 4 5
550 4/24/14 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 6
563 5/7/14 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 4 6
565 5/9/14 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 4 8
571 5/15/14 0 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 4 6
605 6/18/14 0 0 0 0 1 0 0 0 13 0 0 0 0 0 0 0 0 0 0 0 0 0 4 18
646 7/29/14 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 4 6
684 9/5/14 0 0 0 0 0 2 1 0 6 0 0 0 0 0 0 0 0 0 0 0 0 1 4 14
758 11/18/14 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 4 7
893 4/2/15 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 4 7
954 6/2/15 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 5
1026 8/13/15 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 5
1046 9/2/15 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 4 6
1068 9/24/15 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 5
1733 7/20/17 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 4 6
379 11/4/13 0 0 0 0 1 0 0 0 2 1 0 0 0 0 0 0 0 0 0 0 0 1 4 9
407 12/2/13 0 0 0 0 2 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 4 8
463 1/27/14 0 0 0 0 1 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 1 4 8
520 3/25/14 0 0 0 0 2 0 1 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 4 9
599 6/12/14 0 0 0 0 1 0 0 0 18 1 0 0 0 0 0 0 0 0 0 0 0 0 4 24
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
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
472 2/5/14 0 0 0 0 0 0 0 0 1 2 0 0 0 0 0 0 0 0 1 0 0 0 4 8

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