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

17 rows where NYSEMERGENCYMG = 8 sorted by DOHMH

View and edit SQL

Suggested facets: ACS, CHALL, DEP, DOB, DOF, DOHMH, HPD, MOSE, NYCEM, 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
181 4/20/13 0 0 0 0 3 0 0 0 0 0 0 0 3 0 0 0 1 0 2 0 0 0 8 17
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
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
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
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
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
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
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
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
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
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
199 5/8/13 0 0 0 0 1 1 1 0 4 1 0 0 4 0 0 0 0 0 2 0 0 1 8 23
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
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
375 10/31/13 0 0 0 0 0 0 1 0 1 1 0 0 0 0 0 0 0 0 1 0 1 0 8 13
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
382 11/7/13 0 0 0 0 6 0 0 0 0 2 0 0 0 0 0 0 2 0 3 0 0 0 8 21

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