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

50 rows where NYCHA = 1

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: ACS, BPSI, CAU, DEP, DOB, DOE, DOF, DOHMH, DPR, HPD, HRA, MOSE, NYCEM, NYCSERVICE, NYPD, NYSDOL, SBS, 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
32 32 11/22/12 0 0 2 8 58 0 10 0 0 0 8 0 0 0 0 0 2 1 4 0 0 0 0 93
48 48 12/8/12 0 0 0 5 109 0 13 0 11 8 0 0 0 18 0 4 5 1 5 0 56 2 0 237
51 51 12/11/12 0 0 1 17 132 1 15 2 61 9 0 0 0 48 0 1 9 1 4 2 109 11 0 423
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
56 56 12/16/12 0 0 0 5 46 2 8 1 2 10 0 0 0 356 0 1 0 1 2 1 22 3 0 460
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
58 58 12/18/12 0 0 3 8 95 0 30 2 41 5 0 0 0 231 0 1 8 1 6 0 50 8 0 489
63 63 12/23/12 0 1 0 0 45 0 0 2 2 6 0 0 7 0 0 0 1 1 4 0 7 1 0 77
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
69 69 12/29/12 0 0 1 1 81 1 2 1 6 0 0 0 3 0 0 2 1 1 0 0 8 0 0 108
70 70 12/30/12 0 0 0 0 47 0 3 0 2 3 0 0 6 0 0 0 4 1 0 1 6 0 0 73
72 72 1/1/13 0 0 0 0 30 0 0 13 1 1 0 0 1 0 0 0 0 1 0 1 6 1 0 55
76 76 1/5/13 0 0 0 0 58 0 4 0 5 4 0 0 3 0 0 0 0 1 0 1 4 2 0 82
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
81 81 1/10/13 0 0 0 1 115 2 11 0 6 4 0 0 8 0 0 3 2 1 1 0 20 2 0 176
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
87 87 1/16/13 0 0 0 0 67 1 11 1 14 1 0 0 17 0 0 1 2 1 2 1 20 1 0 140
89 89 1/18/13 0 0 1 1 59 0 9 1 10 1 0 0 22 0 0 1 0 1 3 1 13 2 0 125
93 93 1/22/13 0 0 1 0 69 1 9 2 18 2 0 0 21 0 0 1 4 1 3 1 22 1 0 156
95 95 1/24/13 0 0 0 1 39 0 11 1 22 2 0 0 10 0 0 1 1 1 1 0 11 16 0 117
99 99 1/28/13 0 1 1 0 44 0 12 1 34 4 0 0 12 0 0 4 1 1 3 0 10 20 0 148
100 100 1/29/13 0 2 1 0 52 0 9 0 31 6 0 0 28 0 0 0 1 1 1 4 13 19 0 168
108 108 2/6/13 0 0 1 1 31 2 4 0 38 0 0 0 25 0 0 1 0 1 7 0 8 6 0 125
115 115 2/13/13 0 0 1 2 26 1 3 1 26 1 0 0 18 0 0 0 0 1 11 1 8 2 0 102
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
131 131 3/1/13 0 0 1 0 14 0 4 0 20 4 0 0 14 0 0 0 0 1 6 0 2 1 0 67
138 138 3/8/13 0 0 0 0 4 0 3 0 18 3 0 0 10 0 0 1 0 1 2 2 2 3 0 49
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
150 150 3/20/13 0 0 0 0 6 1 5 0 7 2 0 0 12 0 0 0 1 1 11 0 2 1 0 49
151 151 3/21/13 0 0 0 0 5 0 2 0 0 1 0 0 11 0 0 1 1 1 12 0 1 3 0 38
162 162 4/1/13 0 0 0 0 8 1 3 0 11 0 0 0 12 0 0 0 1 1 9 2 2 3 0 53
163 163 4/2/13 0 0 0 0 4 1 4 0 6 0 0 0 9 0 0 1 0 1 6 0 2 0 0 34
164 164 4/3/13 0 0 0 0 10 1 3 0 5 1 0 0 13 0 0 0 0 1 4 1 0 2 0 41
173 173 4/12/13 0 0 0 0 2 1 4 0 4 2 0 0 4 0 0 0 0 1 4 0 1 1 0 24
204 204 5/13/13 0 0 0 0 16 1 0 0 1 1 0 0 7 0 0 2 0 1 4 0 0 6 26 65
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
232 232 6/10/13 0 0 0 0 5 0 5 0 1 1 0 0 0 0 0 1 0 1 6 1 3 8 28 60
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
248 248 6/26/13 0 0 0 0 2 1 2 0 4 1 0 0 0 0 0 0 0 1 6 0 1 3 11 32
253 253 7/1/13 0 0 0 0 5 1 5 0 6 0 0 0 0 0 0 0 1 1 5 0 0 3 16 43
255 255 7/3/13 0 0 0 0 2 0 4 0 2 2 0 0 0 0 0 0 0 1 3 0 0 2 12 28
257 257 7/5/13 0 0 0 0 2 1 1 0 1 0 0 0 0 0 0 0 1 1 5 0 1 0 13 26
261 261 7/9/13 0 0 0 0 4 1 1 0 0 1 0 0 0 0 0 1 1 1 4 0 0 0 15 29
271 271 7/19/13 0 2 0 0 3 0 1 0 3 3 0 0 0 0 0 1 0 1 2 0 0 4 5 25
276 276 7/24/13 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 1 1 1 0 0 1 12 18
290 290 8/7/13 0 0 0 0 1 0 2 0 0 0 0 0 0 0 0 0 2 1 2 0 0 3 11 22
298 298 8/15/13 0 0 0 0 1 0 3 0 0 0 0 0 0 0 0 1 0 1 2 0 2 2 10 22
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
340 340 9/26/13 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 1 4 8
372 372 10/28/13 0 0 0 0 4 0 0 0 1 1 0 0 0 0 0 1 0 1 1 1 0 3 17 30

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