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

9 rows where SBS = 7

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: BPSI, CAU, CHALL, DEP, DOB, DOE, DOF, DOHMH, HPD, MOSE, NYCEM, NYCHA, NYCSERVICE, NYPD, NYSDOL, 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
29 29 11/19/12 0 0 14 46 202 0 97 63 0 0 0 0 0 0 0 0 13 10 0 0 0 7 0 452
67 67 12/27/12 0 0 0 2 93 1 16 1 25 4 0 0 15 0 0 0 2 1 4 2 25 7 0 198
107 107 2/5/13 0 0 0 0 36 2 6 0 30 0 0 0 17 0 0 0 2 0 7 0 10 7 0 117
114 114 2/12/13 0 0 0 0 25 2 11 0 37 2 0 0 21 0 0 3 0 0 10 0 7 7 0 125
127 127 2/25/13 0 0 0 0 16 1 6 0 18 2 0 0 27 0 0 1 1 0 5 1 4 7 0 89
128 128 2/26/13 0 0 0 0 17 0 10 0 14 1 0 0 29 0 0 0 1 0 10 1 4 7 0 94
142 142 3/12/13 0 0 0 0 7 1 6 0 16 4 0 0 9 0 0 0 1 1 6 0 2 7 0 60
228 228 6/6/13 0 0 0 0 7 1 2 0 3 2 0 0 0 0 0 2 0 0 5 0 0 7 14 43
234 234 6/12/13 0 0 0 0 3 0 4 0 3 3 0 0 0 0 0 1 0 0 1 0 3 7 20 45

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