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

Table actions

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

18 rows where SBS = 5

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

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
53 53 12/13/12 0 1 1 20 111 3 11 7 48 11 0 0 0 65 0 2 2 1 8 3 96 5 0 395
59 59 12/19/12 0 0 0 7 80 2 18 1 20 14 0 0 0 41 0 8 2 2 6 4 57 5 0 267
79 79 1/8/13 0 0 1 0 66 0 7 0 7 5 0 0 12 0 0 3 1 1 1 0 22 5 0 131
85 85 1/14/13 0 0 0 0 162 0 13 5 14 2 0 0 7 0 0 1 2 1 0 1 19 5 0 232
102 102 1/31/13 0 2 0 1 46 0 11 1 86 0 0 0 21 0 0 0 2 0 13 1 11 5 0 200
122 122 2/20/13 0 0 0 3 24 0 6 1 18 3 0 0 25 0 0 2 0 1 18 1 7 5 0 114
130 130 2/28/13 0 1 0 0 20 1 10 0 24 1 0 0 16 0 0 3 0 0 6 1 5 5 0 93
143 143 3/13/13 0 0 0 0 6 0 9 0 28 1 0 0 7 0 0 2 1 0 7 0 4 5 0 70
201 201 5/10/13 0 0 0 0 14 0 3 0 0 1 0 0 1 0 0 4 1 0 5 0 0 5 12 46
225 225 6/3/13 0 0 0 0 33 0 4 0 5 2 0 0 1 0 0 0 1 0 2 0 3 5 46 102
239 239 6/17/13 0 0 0 0 4 1 6 0 2 1 0 0 0 0 0 0 1 1 0 1 0 5 14 36
241 241 6/19/13 0 0 0 0 2 1 4 0 6 0 0 0 0 0 0 1 0 0 1 0 1 5 13 34
246 246 6/24/13 0 0 0 0 3 0 2 0 1 1 0 0 0 0 0 1 0 0 3 0 1 5 19 36
263 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
269 269 7/17/13 0 0 0 0 4 1 0 0 1 1 0 0 0 0 0 1 0 0 4 2 0 5 11 30
291 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
310 310 8/27/13 0 0 0 0 2 2 2 0 4 1 0 0 0 0 0 0 0 0 1 0 0 5 10 27
376 376 11/1/13 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 5 9 16

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
);