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

1,783 rows sorted by date

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: NYC-3-1-1, ACS, BPSI, DEP, DOHMH, DPR, FEMA, HPD, HRA, MFANYC, MOSE, NYCHA, NYCSERVICE, NYPD, 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
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
437 437 1/1/14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
802 802 1/1/15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1167 1167 1/1/16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1533 1533 1/1/17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
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
446 446 1/10/14 0 0 0 0 0 0 1 0 3 0 0 0 0 0 0 0 0 0 1 0 0 0 3 8
811 811 1/10/15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1
1176 1176 1/10/16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1542 1542 1/10/17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
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
447 447 1/11/14 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 1 0 0 0 0 0 0 0 3
812 812 1/11/15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1177 1177 1/11/16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
1543 1543 1/11/17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
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
448 448 1/12/14 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 3 5
813 813 1/12/15 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
1178 1178 1/12/16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1
1544 1544 1/12/17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
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
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
814 814 1/13/15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
1179 1179 1/13/16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 2
1545 1545 1/13/17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
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
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
815 815 1/14/15 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 2
1180 1180 1/14/16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2
1546 1546 1/14/17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
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
451 451 1/15/14 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 2
816 816 1/15/15 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
1181 1181 1/15/16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1547 1547 1/15/17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
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
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
817 817 1/16/15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
1182 1182 1/16/16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1548 1548 1/16/17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
88 88 1/17/13 0 0 0 1 52 0 10 1 11 5 0 0 7 0 0 1 1 0 3 1 11 4 0 108
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
818 818 1/17/15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1183 1183 1/17/16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1549 1549 1/17/17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
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
454 454 1/18/14 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 2
819 819 1/18/15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1184 1184 1/18/16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1550 1550 1/18/17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
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
455 455 1/19/14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1
820 820 1/19/15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
1185 1185 1/19/16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2
1551 1551 1/19/17 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
73 73 1/2/13 0 0 0 1 107 2 10 9 14 6 0 0 15 0 0 2 1 3 3 1 35 4 0 213
438 438 1/2/14 0 0 0 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 6
803 803 1/2/15 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 4
1168 1168 1/2/16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1534 1534 1/2/17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
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
456 456 1/20/14 0 0 0 0 0 0 0 0 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5
821 821 1/20/15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2
1186 1186 1/20/16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1552 1552 1/20/17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
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
457 457 1/21/14 0 0 0 0 5 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7 14
822 822 1/21/15 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 2 4
1187 1187 1/21/16 1 0 0 0 0 0 1 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4
1553 1553 1/21/17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
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
458 458 1/22/14 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 3
823 823 1/22/15 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2
1188 1188 1/22/16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
1554 1554 1/22/17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
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
459 459 1/23/14 0 0 0 0 2 0 0 0 1 2 0 0 0 0 0 0 0 0 0 0 0 0 6 11
824 824 1/23/15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
1189 1189 1/23/16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1555 1555 1/23/17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
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
460 460 1/24/14 0 0 0 0 2 1 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 1 6
825 825 1/24/15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
1190 1190 1/24/16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1556 1556 1/24/17 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
96 96 1/25/13 0 0 0 2 47 0 9 0 17 1 0 0 14 0 0 1 0 2 3 0 10 18 0 124
461 461 1/25/14 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 2 0 0 1 5
826 826 1/25/15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1191 1191 1/25/16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1557 1557 1/25/17 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
97 97 1/26/13 0 0 0 0 43 0 5 0 3 0 0 0 6 0 0 1 2 0 0 1 3 3 0 67
462 462 1/26/14 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 1 0 0 0 0 0 0 1 4
827 827 1/26/15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1192 1192 1/26/16 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
1558 1558 1/26/17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
98 98 1/27/13 0 0 0 0 34 0 1 0 1 0 0 0 10 0 0 0 1 0 0 0 0 3 0 50
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
828 828 1/27/15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2
1193 1193 1/27/16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1559 1559 1/27/17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

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