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

11 rows where NYPD = 3

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: ACS, BPSI, CAU, CHALL, DEP, DOB, DOE, DOF, DOHMH, DPR, HPD, HRA, MOSE, NYCEM, NYCHA, NYCSERVICE, NYSDOL, 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
33 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
40 40 11/30/12 0 5 2 39 161 2 52 7 57 7 44 0 0 0 0 0 8 4 11 3 122 10 0 534
45 45 12/5/12 0 3 2 19 158 3 37 5 87 6 37 0 0 0 0 4 16 2 7 3 113 6 0 508
47 47 12/7/12 0 1 1 12 148 1 25 1 48 4 21 0 0 1 0 7 7 2 6 3 117 11 0 416
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
54 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
57 57 12/17/12 0 1 4 15 101 3 31 2 68 9 0 0 0 331 0 3 5 1 8 3 81 6 0 672
60 60 12/20/12 0 0 1 0 59 1 9 4 38 7 0 0 0 0 0 1 3 0 3 3 32 2 0 163
83 83 1/12/13 0 0 0 0 97 0 5 0 6 5 0 0 3 0 0 2 3 0 2 3 5 2 0 133
109 109 2/7/13 0 2 0 4 32 1 7 0 28 3 0 0 26 0 0 0 0 0 5 3 7 6 0 124
117 117 2/15/13 0 0 0 2 29 2 5 0 11 1 0 0 12 0 0 1 2 0 21 3 7 6 0 102

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