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

4 rows where SBS = 9 sorted by FEMA

View and edit SQL

Suggested facets: NYC-3-1-1, BPSI, CAU, CHALL, DEP, DOF, DOHMH, DPR, MFANYC, MOSE, NYCHA, NYCSERVICE, NYPD, NYSDOL, NYSEMERGENCYMG

SBS

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
13 11/3/12 103 0 0 0 0 0 0 250 0 0 0 0 0 0 0 0 36 0 0 0 0 9 0 398
17 11/7/12 269 0 0 33 0 0 55 1434 0 0 0 0 0 0 287 0 29 0 0 0 0 9 0 2116
46 12/6/12 0 0 1 36 206 4 28 5 51 1 42 0 0 0 0 7 3 8 12 9 153 9 0 575
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

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