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

29 rows where NYSEMERGENCYMG = 7

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: ACS, 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
210 210 5/19/13 0 0 0 0 1 0 0 0 0 1 0 0 1 0 0 0 0 0 0 1 0 1 7 12
214 214 5/23/13 0 0 0 0 9 0 1 0 4 1 0 0 12 0 0 0 2 0 1 0 0 1 7 38
215 215 5/24/13 0 0 0 0 5 0 0 0 1 1 0 0 1 0 0 1 0 1 3 0 1 1 7 22
223 223 6/1/13 0 0 0 0 7 0 1 0 0 0 0 0 2 0 0 0 0 0 2 0 0 2 7 21
237 237 6/15/13 0 0 0 0 1 0 0 0 6 1 0 0 0 0 0 0 0 0 2 0 0 0 7 17
245 245 6/23/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 7 9
258 258 7/6/13 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7 10
267 267 7/15/13 0 0 0 0 3 0 2 0 4 0 0 0 0 0 0 0 1 0 3 0 0 1 7 21
275 275 7/23/13 0 0 0 0 3 0 1 0 0 0 0 0 0 0 0 1 0 0 1 0 0 3 7 16
277 277 7/25/13 0 2 0 0 1 0 3 0 0 0 0 0 0 0 0 0 0 0 0 1 2 1 7 17
278 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 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
284 284 8/1/13 0 0 0 0 2 0 0 0 7 1 0 0 0 0 0 0 0 0 0 0 0 3 7 20
299 299 8/16/13 0 0 0 0 2 0 1 0 2 3 0 0 0 0 0 0 0 0 0 0 1 3 7 19
304 304 8/21/13 0 0 0 0 0 0 0 0 9 2 0 0 0 0 0 0 0 0 0 0 1 1 7 20
319 319 9/5/13 0 0 0 0 0 0 2 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 7 15
323 323 9/9/13 0 0 0 0 0 0 1 0 4 2 0 0 0 0 0 0 0 0 0 0 0 2 7 16
359 359 10/15/13 0 0 0 0 4 1 2 0 4 0 0 0 0 0 0 2 0 0 2 2 1 0 7 25
361 361 10/17/13 0 0 0 0 2 3 0 0 6 1 0 0 0 0 0 0 0 0 0 0 0 1 7 20
389 389 11/14/13 0 0 0 0 3 0 0 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0 7 14
393 393 11/18/13 0 0 0 0 5 0 0 0 7 0 0 0 0 0 0 0 0 0 1 0 0 1 7 21
395 395 11/20/13 0 0 0 0 1 1 0 0 2 1 0 0 0 0 0 0 0 0 1 0 0 1 7 14
396 396 11/21/13 0 0 0 0 2 0 0 0 1 0 0 0 0 0 0 0 0 0 2 0 1 1 7 14
401 401 11/26/13 0 0 0 0 7 0 1 0 1 0 0 0 0 0 0 0 0 0 0 2 0 0 7 18
409 409 12/4/13 0 0 0 0 6 0 1 0 3 1 0 0 0 0 0 0 0 0 0 0 0 1 7 19
445 445 1/9/14 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 7 11
449 449 1/13/14 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 1 0 0 0 0 2 7 12
457 457 1/21/14 0 0 0 0 5 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7 14
492 492 2/25/14 0 0 0 0 2 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 2 2 7 15

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