home / fivethirtyeight

Menu
  • GraphQL API

sandy-311-calls/sandy-311-calls-by-day

Table actions
  • GraphQL API for sandy-311-calls/sandy-311-calls-by-day

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

59 rows where SBS = 2

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: ACS, BPSI, CAU, CHALL, DEP, DOB, DOE, DOF, DOHMH, 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
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
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
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
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
82 82 1/11/13 0 0 1 0 138 1 12 2 8 3 0 0 9 0 0 0 1 2 4 0 5 2 0 188
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
86 86 1/15/13 0 0 0 1 64 0 20 2 16 0 0 0 15 0 0 2 2 0 2 0 14 2 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
91 91 1/20/13 0 0 0 0 25 1 3 0 1 0 0 0 7 0 0 0 1 0 0 1 5 2 0 46
103 103 2/1/13 0 0 1 2 35 0 13 0 71 2 0 0 16 0 0 0 1 0 11 0 6 2 0 160
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
118 118 2/16/13 0 0 0 0 12 0 1 0 2 1 0 0 7 0 0 1 1 0 10 1 0 2 0 38
123 123 2/21/13 0 0 0 2 37 1 7 1 13 3 0 0 22 0 0 2 2 0 12 0 0 2 0 104
124 124 2/22/13 0 0 0 0 31 1 9 0 9 4 0 0 11 0 0 0 1 0 8 1 4 2 0 81
145 145 3/15/13 0 0 0 0 3 0 10 0 13 2 0 0 13 0 0 0 1 0 8 0 2 2 0 54
156 156 3/26/13 0 0 0 0 6 0 11 0 8 1 0 0 12 0 0 0 1 0 12 0 6 2 0 59
158 158 3/28/13 0 0 0 0 8 0 11 0 6 2 0 0 11 0 0 0 0 0 16 0 2 2 0 58
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
172 172 4/11/13 0 0 0 0 3 0 2 0 6 0 0 0 7 0 0 1 1 0 2 0 2 2 0 26
176 176 4/15/13 0 0 0 0 3 0 4 0 0 0 0 0 5 0 0 0 1 0 1 1 0 2 0 17
185 185 4/24/13 0 0 0 0 2 1 6 0 4 0 0 0 8 0 0 1 1 0 0 1 2 2 23 51
198 198 5/7/13 0 0 0 0 3 0 2 0 3 1 0 0 9 0 0 0 2 0 9 1 0 2 14 46
200 200 5/9/13 0 0 0 0 3 0 3 0 2 3 0 0 13 0 0 1 0 0 1 0 1 2 14 43
205 205 5/14/13 0 0 0 0 12 0 1 0 1 1 0 0 15 0 0 0 1 0 5 0 0 2 24 62
208 208 5/17/13 0 0 0 0 5 0 1 0 0 0 0 0 7 0 0 0 1 0 1 0 0 2 13 30
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
233 233 6/11/13 0 0 0 0 4 0 2 0 1 1 0 0 0 0 0 1 1 0 2 0 2 2 16 32
235 235 6/13/13 0 0 0 0 4 0 3 0 8 1 0 0 0 0 0 0 0 0 0 0 1 2 15 34
236 236 6/14/13 0 0 0 0 5 1 4 0 3 0 0 0 0 0 0 0 0 2 3 0 0 2 14 34
250 250 6/28/13 0 0 0 0 1 0 2 0 0 0 0 0 0 0 0 1 1 0 2 0 0 2 12 21
251 251 6/29/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 2 2 6
254 254 7/2/13 0 1 0 0 2 0 2 0 1 0 0 0 0 0 0 1 0 0 3 0 3 2 8 23
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
268 268 7/16/13 0 0 0 0 3 0 3 0 2 1 0 0 0 0 0 1 0 0 2 0 1 2 3 18
282 282 7/30/13 0 0 0 0 6 1 1 0 0 0 0 0 0 0 0 1 0 0 1 1 0 2 6 19
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
302 302 8/19/13 0 0 0 0 3 0 2 0 3 1 0 0 0 0 0 2 0 0 2 1 0 2 10 26
320 320 9/6/13 0 0 0 0 2 1 0 0 2 1 0 0 0 0 0 0 1 0 1 0 0 2 6 16
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
325 325 9/11/13 0 0 0 0 3 0 0 0 12 2 0 0 0 0 0 0 0 0 1 0 0 2 5 25
337 337 9/23/13 0 0 0 0 1 0 1 0 3 2 0 0 0 0 0 0 0 0 2 0 0 2 4 15
341 341 9/27/13 0 0 0 0 0 0 0 0 3 2 0 0 0 0 0 0 0 0 1 1 0 2 8 17
345 345 10/1/13 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 2 9 13
346 346 10/2/13 0 0 0 0 1 1 0 0 3 0 0 0 0 0 0 0 0 0 1 0 0 2 3 11
353 353 10/9/13 0 0 0 0 0 1 0 0 5 0 0 0 0 0 0 1 0 0 0 0 0 2 4 13
355 355 10/11/13 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 1 0 2 3 8
365 365 10/21/13 0 0 0 0 1 0 2 0 3 0 0 0 0 0 0 1 0 0 0 0 0 2 6 15
367 367 10/23/13 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 2 6 11
377 377 11/2/13 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 4 0 0 2 5 12
381 381 11/6/13 0 0 0 0 6 0 1 0 4 0 0 0 0 0 0 0 0 0 1 0 0 2 6 20
388 388 11/13/13 0 0 0 0 5 0 0 0 2 1 0 0 0 0 0 0 1 0 0 0 0 2 10 21
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
453 453 1/17/14 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 3
473 473 2/6/14 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 1 0 0 0 0 0 2 1 6
477 477 2/10/14 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 2 2 6
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
612 612 6/25/14 0 0 0 0 2 0 0 0 16 0 0 0 0 0 0 0 0 0 0 2 0 2 3 25
740 740 10/31/14 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 4
1646 1646 4/24/17 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 3 6

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
);
Powered by Datasette · Queries took 432.81ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette