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

24 rows where NYSEMERGENCYMG = 6

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: CHALL, DEP, DOB, DOF, DOHMH, HPD, MOSE, NYCEM, NYCHA, NYCSERVICE, NYPD, NYSDOL, SBS, 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
179 179 4/18/13 0 0 0 0 3 0 5 0 5 0 0 0 3 0 0 1 0 0 2 0 0 0 6 25
188 188 4/27/13 0 0 0 0 0 0 2 0 1 0 0 0 3 0 0 1 0 0 3 0 0 0 6 16
230 230 6/8/13 0 0 0 0 4 0 1 0 0 1 0 0 0 0 0 0 0 0 3 0 0 0 6 15
282 282 7/30/13 0 0 0 0 6 1 1 0 0 0 0 0 0 0 0 1 0 0 1 1 0 2 6 19
285 285 8/2/13 0 0 0 0 3 0 0 0 0 2 0 0 0 0 0 1 0 0 1 1 0 3 6 17
297 297 8/14/13 0 0 0 0 0 0 2 0 2 2 0 0 0 0 0 0 0 0 0 0 0 3 6 15
303 303 8/20/13 0 0 0 0 1 0 1 0 8 2 0 0 0 0 0 0 0 0 0 0 0 0 6 18
320 320 9/6/13 0 0 0 0 2 1 0 0 2 1 0 0 0 0 0 0 1 0 1 0 0 2 6 16
326 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
348 348 10/4/13 0 0 0 0 1 0 1 0 3 1 0 0 0 0 0 0 0 0 1 0 0 3 6 16
360 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
365 365 10/21/13 0 0 0 0 1 0 2 0 3 0 0 0 0 0 0 1 0 0 0 0 0 2 6 15
367 367 10/23/13 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 2 6 11
368 368 10/24/13 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 6 9
371 371 10/27/13 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 6 8
381 381 11/6/13 0 0 0 0 6 0 1 0 4 0 0 0 0 0 0 0 0 0 1 0 0 2 6 20
383 383 11/8/13 0 0 0 0 3 0 0 0 4 0 0 0 0 0 0 0 0 0 1 0 1 0 6 15
443 443 1/7/14 0 0 0 0 5 0 0 0 5 0 0 0 0 0 0 0 0 0 0 0 0 0 6 16
452 452 1/16/14 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 2 0 1 1 6 11
459 459 1/23/14 0 0 0 0 2 0 0 0 1 2 0 0 0 0 0 0 0 0 0 0 0 0 6 11
499 499 3/4/14 0 0 0 0 3 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 6 10
514 514 3/19/14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6 6
519 519 3/24/14 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 6 9
873 873 3/13/15 0 0 0 0 0 0 3 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 6 12

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