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

133 rows where SBS = 1

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: NYC-3-1-1, ACS, BPSI, CAU, CHALL, DEP, DOB, DOE, DOF, DOHMH, DPR, HPD, MFANYC, 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
20 20 11/10/12 28 0 0 66 0 0 90 36 0 0 0 0 0 0 104 0 11 0 0 0 0 1 0 336
21 21 11/11/12 27 0 0 43 0 0 56 50 0 0 0 0 0 0 62 0 3 0 0 0 0 1 0 242
27 27 11/17/12 0 0 6 15 105 0 32 5 0 0 0 0 0 0 0 0 7 6 0 0 0 1 0 177
41 41 12/1/12 0 0 1 14 131 2 20 6 11 7 21 0 0 0 0 0 10 5 6 1 68 1 0 304
42 42 12/2/12 0 0 1 7 120 0 12 7 4 4 15 0 0 0 0 0 1 0 9 4 49 1 0 234
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
64 64 12/24/12 0 0 0 1 49 0 9 0 12 1 0 0 9 0 0 2 2 3 8 1 17 1 0 115
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
75 75 1/4/13 0 0 0 4 94 0 7 0 24 6 0 0 9 0 0 0 2 3 3 0 21 1 0 174
84 84 1/13/13 0 0 0 0 74 0 3 0 6 1 0 0 5 0 0 0 1 0 1 0 2 1 0 94
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
92 92 1/21/13 0 0 0 0 31 1 6 0 8 0 0 0 10 0 0 0 1 0 0 0 7 1 0 65
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
94 94 1/23/13 0 0 0 1 27 0 10 2 4 5 0 0 8 0 0 0 2 0 5 2 8 1 0 75
104 104 2/2/13 0 0 0 1 26 0 4 0 12 1 0 0 8 0 0 0 0 0 4 0 3 1 0 60
111 111 2/9/13 0 0 0 0 5 1 3 0 6 2 0 0 8 0 0 0 0 0 0 0 2 1 0 28
112 112 2/10/13 0 0 0 1 14 0 0 0 4 0 0 0 7 0 0 0 0 0 3 1 1 1 0 32
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
135 135 3/5/13 0 1 1 0 7 0 8 0 4 2 0 0 10 0 0 0 0 0 5 2 4 1 0 45
144 144 3/14/13 0 0 0 0 9 0 15 0 17 0 0 0 7 0 0 0 1 0 4 0 1 1 0 55
146 146 3/16/13 0 0 0 0 2 0 3 0 2 0 0 0 4 0 0 0 1 0 5 0 0 1 0 18
148 148 3/18/13 0 0 1 0 5 0 2 0 5 0 0 0 8 0 0 0 1 0 6 1 3 1 0 33
149 149 3/19/13 0 0 0 0 2 0 4 0 12 2 0 0 10 0 0 1 1 0 4 1 1 1 0 39
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
152 152 3/22/13 0 0 0 0 27 1 7 0 12 0 0 0 11 0 0 0 1 0 3 0 1 1 0 64
154 154 3/24/13 0 0 0 0 6 1 0 0 1 0 0 0 0 0 0 0 0 0 4 0 0 1 0 13
155 155 3/25/13 0 0 1 0 7 2 3 0 6 0 0 0 11 0 0 0 0 0 8 0 3 1 0 42
159 159 3/29/13 0 0 0 0 5 1 5 0 2 4 0 0 2 0 0 0 1 0 9 1 2 1 0 33
161 161 3/31/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 0 0 1 0 5
165 165 4/4/13 0 0 0 0 4 2 4 0 1 3 0 0 4 0 0 0 0 0 7 0 1 1 0 27
166 166 4/5/13 0 0 0 0 2 0 1 0 5 5 0 0 5 0 0 0 0 0 2 0 0 1 0 21
167 167 4/6/13 0 1 0 0 1 1 1 0 1 0 0 0 3 0 0 0 0 0 4 0 2 1 0 15
170 170 4/9/13 0 0 0 0 5 1 7 0 5 3 0 0 7 0 0 0 0 0 6 0 0 1 0 35
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
180 180 4/19/13 0 0 0 0 5 0 1 0 0 6 0 0 3 0 0 0 1 0 7 1 0 1 9 34
184 184 4/23/13 0 0 0 0 4 1 3 0 8 1 0 0 7 0 0 1 0 0 2 1 0 1 20 49
186 186 4/25/13 0 0 0 0 3 0 1 0 5 0 0 0 7 0 0 0 0 0 2 0 0 1 31 50
187 187 4/26/13 0 0 0 0 6 0 2 0 2 0 0 0 5 0 0 0 1 0 1 1 0 1 12 31
191 191 4/30/13 0 0 0 0 5 2 2 0 2 2 0 0 9 0 0 1 0 0 4 0 0 1 20 48
193 193 5/2/13 0 0 0 0 4 0 2 0 1 1 0 0 9 0 0 1 0 0 8 0 0 1 16 43
199 199 5/8/13 0 0 0 0 1 1 1 0 4 1 0 0 4 0 0 0 0 0 2 0 0 1 8 23
207 207 5/16/13 0 0 0 0 9 1 0 0 0 0 0 0 6 0 0 0 0 0 4 0 2 1 18 41
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
213 213 5/22/13 0 0 0 0 10 1 0 0 0 0 0 0 6 0 0 2 1 2 1 0 0 1 22 46
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
216 216 5/25/13 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 3 1 2 8
243 243 6/21/13 0 0 0 0 3 0 2 0 3 0 0 0 0 0 0 0 0 0 4 0 0 1 9 22
244 244 6/22/13 0 0 0 0 1 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 1 3 7
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
265 265 7/13/13 0 0 0 0 1 0 0 0 0 2 0 0 0 0 0 0 0 0 1 0 2 1 4 11
266 266 7/14/13 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 4 6
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
270 270 7/18/13 0 1 0 0 1 0 2 0 1 0 0 0 0 0 0 1 0 0 0 0 0 1 8 15
273 273 7/21/13 0 0 0 0 2 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 2 6
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
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
281 281 7/29/13 0 0 0 0 1 0 4 0 0 2 0 0 0 0 0 0 1 0 0 0 0 1 11 20
286 286 8/3/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1
288 288 8/5/13 0 0 0 0 2 0 4 0 1 1 0 0 0 0 0 0 2 0 5 1 1 1 12 30
289 289 8/6/13 0 0 0 0 1 0 2 0 3 2 0 0 0 0 0 0 1 0 1 0 0 1 12 23
301 301 8/18/13 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 3
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
307 307 8/24/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1
309 309 8/26/13 0 0 0 0 3 1 1 0 9 0 0 0 0 0 0 0 2 0 1 0 0 1 0 18
312 312 8/29/13 0 0 0 0 3 0 0 0 5 0 0 0 0 0 0 0 0 0 0 0 0 1 5 14
313 313 8/30/13 0 0 0 0 0 0 1 0 11 1 0 0 0 0 0 0 0 0 0 0 0 1 5 19
318 318 9/4/13 0 0 0 0 1 0 0 0 7 0 0 0 0 0 0 0 0 0 0 0 0 1 3 12
321 321 9/7/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 1 0 3
324 324 9/10/13 0 0 0 0 2 0 0 0 2 0 0 0 0 0 0 1 0 0 2 2 0 1 10 20
331 331 9/17/13 0 0 0 0 1 0 1 0 5 2 0 0 0 0 0 0 0 0 1 1 0 1 3 15
332 332 9/18/13 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 2 0 0 1 3 8
333 333 9/19/13 0 0 0 0 0 0 1 0 2 1 0 0 0 0 0 1 0 0 2 0 0 1 8 16
336 336 9/22/13 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 2
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
342 342 9/28/13 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 1 1 5
343 343 9/29/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 8 9
347 347 10/3/13 0 0 0 0 1 0 0 0 2 0 0 0 0 0 0 0 0 0 2 1 0 1 8 15
354 354 10/10/13 0 0 0 0 2 0 1 0 2 0 0 0 0 0 0 0 0 0 0 1 0 1 10 17
358 358 10/14/13 0 0 0 0 4 0 0 0 1 1 0 0 0 0 0 0 0 0 1 0 0 1 5 13
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
369 369 10/25/13 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 2 0 0 1 5 10
378 378 11/3/13 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 1 1 5
379 379 11/4/13 0 0 0 0 1 0 0 0 2 1 0 0 0 0 0 0 0 0 0 0 0 1 4 9
380 380 11/5/13 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 1 0 1 5 9
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
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
418 418 12/13/13 0 0 0 0 2 0 1 0 3 0 0 0 0 0 0 0 1 0 0 0 0 1 2 10
420 420 12/15/13 0 0 0 0 0 0 0 0 1 2 0 0 0 0 0 0 0 0 0 0 0 1 1 5
442 442 1/6/14 0 0 0 0 2 0 1 0 1 0 0 0 0 0 0 5 0 0 0 0 0 1 4 14
450 450 1/14/14 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 1 1 3 7
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
463 463 1/27/14 0 0 0 0 1 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 1 4 8
480 480 2/13/14 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 1 0 1 1 5
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
527 527 4/1/14 0 0 0 0 0 0 2 0 2 0 0 0 0 0 0 0 0 0 0 0 0 1 4 9
528 528 4/2/14 0 0 0 0 1 1 1 0 1 1 0 0 0 0 0 0 0 0 1 0 0 1 3 10
533 533 4/7/14 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 4 7

Next page

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