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

1,446 rows where SBS = 0

✎ 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, FEMA, HPD, HRA, 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
1 1 10/22/12 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
2 2 10/23/12 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
3 3 10/24/12 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
4 4 10/25/12 0 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4
5 5 10/26/12 0 0 0 0 0 0 0 36 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 36
6 6 10/27/12 207 0 0 0 0 0 0 312 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 519
7 7 10/28/12 6325 0 0 0 0 0 0 23 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 6351
8 8 10/29/12 7922 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0 128 0 0 0 0 0 0 8054
9 9 10/30/12 2843 0 0 0 0 0 0 53 0 0 0 0 0 0 0 0 154 0 0 0 0 0 0 3050
10 10 10/31/12 7668 0 0 0 0 0 0 280 0 0 0 0 0 0 0 0 75 0 0 0 0 0 0 8023
28 28 11/18/12 0 0 4 38 91 0 30 28 0 0 0 0 0 0 0 0 12 4 0 0 0 0 0 207
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
49 49 12/9/12 0 0 3 5 72 1 10 0 6 1 0 0 0 16 0 0 4 2 4 0 42 0 0 166
55 55 12/15/12 0 0 2 9 41 0 11 0 14 4 0 0 0 49 0 1 1 0 2 0 19 0 0 153
62 62 12/22/12 0 0 1 1 71 0 2 0 5 3 0 0 0 0 0 0 3 0 1 0 13 0 0 100
65 65 12/25/12 0 0 0 0 11 0 0 0 2 2 0 0 2 0 0 0 1 0 5 0 2 0 0 25
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
77 77 1/6/13 0 0 0 0 48 0 3 0 0 6 0 0 4 0 0 0 0 0 0 0 4 0 0 65
90 90 1/19/13 0 0 0 4 37 0 5 0 2 3 0 0 6 0 0 0 2 0 0 0 7 0 0 66
105 105 2/3/13 0 0 0 0 9 1 1 0 6 0 0 0 3 0 0 0 0 0 3 0 2 0 0 25
110 110 2/8/13 0 0 0 0 30 1 0 0 19 0 0 0 21 0 0 1 0 0 3 1 5 0 0 81
119 119 2/17/13 0 0 0 0 10 0 1 0 1 3 0 0 2 0 0 0 0 0 11 1 0 0 0 29
120 120 2/18/13 0 0 0 0 10 0 2 0 2 0 0 0 14 0 0 0 1 0 12 1 4 0 0 46
125 125 2/23/13 0 1 0 0 9 0 1 0 0 3 0 0 7 0 0 0 0 0 4 0 1 0 0 26
126 126 2/24/13 0 0 0 0 6 0 3 0 3 1 0 0 5 0 0 1 0 0 4 0 2 0 0 25
132 132 3/2/13 0 0 0 0 7 2 0 0 1 2 0 0 6 0 0 0 1 0 3 0 0 0 0 22
133 133 3/3/13 0 0 0 0 2 0 1 0 0 2 0 0 7 0 0 1 1 0 5 0 2 0 0 21
139 139 3/9/13 0 0 0 0 2 1 5 0 0 0 0 0 2 0 0 0 0 0 3 0 2 0 0 15
140 140 3/10/13 0 0 0 0 2 0 2 0 4 0 0 0 3 0 0 0 0 0 8 0 0 0 0 19
147 147 3/17/13 0 0 0 0 0 0 5 0 1 0 0 0 5 0 0 0 1 0 8 0 0 0 0 20
153 153 3/23/13 0 0 0 0 8 0 2 0 3 0 0 0 2 0 0 0 0 0 6 0 1 0 0 22
160 160 3/30/13 0 0 0 0 3 0 0 0 0 0 0 0 3 0 0 0 0 0 6 1 0 0 0 13
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
168 168 4/7/13 0 0 0 0 1 0 0 0 0 0 0 0 2 0 0 0 1 0 2 0 0 0 0 6
174 174 4/13/13 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 1 0 4 0 0 0 0 7
175 175 4/14/13 0 0 0 0 0 0 0 0 0 0 0 0 5 0 0 0 0 0 3 1 1 0 0 10
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
181 181 4/20/13 0 0 0 0 3 0 0 0 0 0 0 0 3 0 0 0 1 0 2 0 0 0 8 17
182 182 4/21/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 2
183 183 4/22/13 0 0 0 0 6 0 2 0 8 3 0 0 5 0 0 0 0 0 6 0 2 0 15 47
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
189 189 4/28/13 0 0 0 0 2 1 1 0 0 0 0 0 2 0 0 0 1 0 3 0 0 0 5 15
192 192 5/1/13 0 0 0 0 5 0 3 0 7 4 0 0 13 0 0 2 1 0 2 0 2 0 25 64
194 194 5/3/13 0 0 0 0 2 2 0 0 1 0 0 0 2 0 0 0 0 0 6 0 2 0 14 29
195 195 5/4/13 0 0 0 0 0 0 1 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 3 6
196 196 5/5/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 5
197 197 5/6/13 0 0 0 0 3 2 2 0 0 0 0 0 10 0 0 0 1 0 3 0 2 0 19 42
202 202 5/11/13 0 0 0 0 4 0 0 0 0 0 0 0 4 0 0 0 0 0 1 0 0 0 5 14
203 203 5/12/13 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 2 4
209 209 5/18/13 0 0 0 0 1 0 0 0 0 1 0 0 4 0 0 0 0 0 1 1 0 0 1 9
211 211 5/20/13 0 0 0 0 13 0 2 0 2 0 0 0 4 0 0 1 2 0 5 0 1 0 14 44
217 217 5/26/13 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 2
218 218 5/27/13 0 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 1 0 0 0 1 0 1 5
224 224 6/2/13 0 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 5 8
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
231 231 6/9/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 2 0 0 0 3 6
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
238 238 6/16/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 2
240 240 6/18/13 0 0 0 0 2 0 2 0 8 1 0 0 0 0 0 0 0 0 0 0 0 0 9 22
252 252 6/30/13 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 2 0 0 0 8 12
256 256 7/4/13 0 0 0 0 1 0 2 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 4
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
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
259 259 7/7/13 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 1 3
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
264 264 7/12/13 0 0 0 0 8 0 3 0 0 1 0 0 0 0 0 0 0 0 2 0 1 0 10 25
272 272 7/20/13 0 0 0 0 1 0 0 0 1 1 0 0 0 0 0 0 0 0 1 0 0 0 2 6
279 279 7/27/13 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 1 4
280 280 7/28/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2
287 287 8/4/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 2
292 292 8/9/13 0 0 0 0 0 0 2 0 1 1 0 0 0 0 0 0 0 0 2 0 0 0 8 14
293 293 8/10/13 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 1 4
294 294 8/11/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
296 296 8/13/13 0 0 0 0 2 0 0 0 7 1 0 0 0 0 0 0 2 0 0 0 0 0 3 15
300 300 8/17/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
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
306 306 8/23/13 0 0 0 0 2 0 1 0 0 0 0 0 0 0 0 0 1 0 1 1 0 0 5 11
308 308 8/25/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 2
314 314 8/31/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
315 315 9/1/13 0 0 0 0 0 0 0 0 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 3
316 316 9/2/13 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 1 3
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
322 322 9/8/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2
328 328 9/14/13 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 2 5
329 329 9/15/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
334 334 9/20/13 0 0 0 0 1 0 0 0 2 0 0 0 0 0 0 0 0 0 3 0 0 0 8 14
335 335 9/21/13 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 3 5
349 349 10/5/13 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 5
350 350 10/6/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
351 351 10/7/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8 8
356 356 10/12/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2
357 357 10/13/13 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 2 4
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
363 363 10/19/13 0 0 0 0 1 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3
364 364 10/20/13 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 2 3
366 366 10/22/13 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 3 0 3 9
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
370 370 10/26/13 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 3 5
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

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