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

23 rows where SBS = 4 sorted by FEMA

View and edit SQL

Suggested facets: ACS, BPSI, CAU, CHALL, DEP, DOB, DOE, DOF, DOHMH, DPR, HPD, HRA, MOSE, NYCEM, NYCHA, NYCSERVICE, NYPD, NYSDOL, NYSEMERGENCYMG, total

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
31 11/21/12 0 0 5 23 191 0 42 14 0 0 3 0 0 0 0 0 8 3 0 8 0 4 0 301
33 11/23/12 0 0 7 27 189 0 43 1 0 0 52 0 0 0 0 0 4 3 42 3 0 4 0 375
44 12/4/12 0 3 4 11 167 5 42 7 92 4 37 0 0 0 0 0 5 3 8 4 122 4 0 518
52 12/12/12 0 0 0 17 151 2 26 3 60 14 0 0 0 86 0 4 6 4 10 6 96 4 0 489
54 12/14/12 0 2 1 15 111 3 31 4 40 10 0 0 0 81 0 6 3 5 12 3 65 4 0 396
73 1/2/13 0 0 0 1 107 2 10 9 14 6 0 0 15 0 0 2 1 3 3 1 35 4 0 213
78 1/7/13 0 0 2 0 98 2 8 3 15 12 0 0 9 0 0 2 2 2 1 0 24 4 0 184
88 1/17/13 0 0 0 1 52 0 10 1 11 5 0 0 7 0 0 1 1 0 3 1 11 4 0 108
134 3/4/13 0 0 0 0 8 0 15 1 20 2 0 0 18 0 0 0 0 0 6 0 1 4 0 75
171 4/10/13 0 0 0 0 7 0 1 0 3 0 0 0 8 0 0 2 0 0 7 0 1 4 0 33
178 4/17/13 0 0 0 0 6 1 4 0 8 1 0 0 7 0 0 2 0 0 4 1 1 4 0 39
190 4/29/13 0 0 0 0 10 1 3 0 5 3 0 0 13 0 0 2 0 0 4 1 1 4 31 78
212 5/21/13 0 0 0 0 2 0 3 0 3 2 0 0 7 0 0 1 2 0 4 0 0 4 11 39
221 5/30/13 0 0 0 0 8 0 3 0 2 0 0 0 2 0 0 2 0 0 2 0 1 4 13 37
249 6/27/13 0 0 0 0 6 0 1 0 2 2 0 0 0 0 0 2 0 0 6 1 0 4 11 35
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
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
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
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
305 8/22/13 0 0 0 0 3 0 0 0 1 1 0 0 0 0 0 5 0 0 0 0 0 4 9 23
326 9/12/13 0 0 0 0 0 1 0 0 5 1 0 0 0 0 0 0 0 1 1 0 0 4 6 19
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

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