home / fivethirtyeight

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

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

1,783 rows sorted by NYCHA

View and edit SQL

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
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 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 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 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 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 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 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 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 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/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
11 11/1/12 1717 0 0 0 0 0 0 27 0 0 0 0 0 0 0 0 108 0 0 0 0 17 0 1869
12 11/2/12 317 0 0 0 0 0 0 28 0 0 0 0 0 0 0 0 71 0 0 0 0 43 0 459
13 11/3/12 103 0 0 0 0 0 0 250 0 0 0 0 0 0 0 0 36 0 0 0 0 9 0 398
14 11/4/12 106 0 0 0 0 0 0 4905 0 0 0 0 0 0 0 0 22 0 0 0 0 3 0 5036
15 11/5/12 186 0 0 4 0 0 12 1417 0 0 0 0 0 0 0 0 42 0 0 0 0 27 0 1688
16 11/6/12 232 0 0 42 0 0 31 1535 0 0 0 0 0 0 123 0 27 0 0 0 0 14 0 2004
17 11/7/12 269 0 0 33 0 0 55 1434 0 0 0 0 0 0 287 0 29 0 0 0 0 9 0 2116
18 11/8/12 169 0 0 37 0 0 72 1035 0 0 0 0 0 0 194 0 92 0 0 0 0 12 0 1611
19 11/9/12 115 0 0 112 0 0 57 143 0 0 0 0 0 0 182 0 59 0 0 0 0 11 0 679
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 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
22 11/12/12 56 0 0 93 0 0 89 258 0 0 0 0 0 0 212 0 29 0 0 0 0 13 0 750
23 11/13/12 0 0 0 101 83 0 100 220 0 0 0 0 0 0 0 0 21 0 0 0 0 12 0 537
24 11/14/12 0 0 3 81 107 0 74 83 0 0 0 0 0 0 0 0 26 0 0 0 0 12 0 386
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
50 12/10/12 0 1 2 12 156 7 35 7 33 9 0 0 0 57 0 5 6 0 11 1 90 11 0 443
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
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
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 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
66 12/26/12 0 0 1 1 88 1 11 0 34 4 0 0 18 0 0 3 2 0 4 0 29 3 0 199
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
80 1/9/13 0 0 1 0 79 1 14 2 21 4 0 0 8 0 0 2 2 0 4 0 11 3 0 152
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
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
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
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
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
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
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
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
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
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
101 1/30/13 0 2 1 1 34 1 13 0 57 1 0 0 18 0 0 1 4 0 8 2 4 12 0 159
102 1/31/13 0 2 0 1 46 0 11 1 86 0 0 0 21 0 0 0 2 0 13 1 11 5 0 200
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
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
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
106 2/4/13 0 0 0 1 40 0 10 0 50 1 0 0 22 0 0 1 1 0 9 0 14 8 0 157
107 2/5/13 0 0 0 0 36 2 6 0 30 0 0 0 17 0 0 0 2 0 7 0 10 7 0 117
109 2/7/13 0 2 0 4 32 1 7 0 28 3 0 0 26 0 0 0 0 0 5 3 7 6 0 124
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
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 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
113 2/11/13 0 0 0 0 33 2 5 0 27 2 0 0 27 0 0 0 1 0 7 1 5 11 0 121
114 2/12/13 0 0 0 0 25 2 11 0 37 2 0 0 21 0 0 3 0 0 10 0 7 7 0 125
116 2/14/13 0 0 0 0 13 1 8 0 26 4 0 0 6 0 0 4 0 0 17 0 3 8 0 90
117 2/15/13 0 0 0 2 29 2 5 0 11 1 0 0 12 0 0 1 2 0 21 3 7 6 0 102
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
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 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
121 2/19/13 0 0 1 0 24 1 10 1 13 2 0 0 23 0 0 3 0 0 24 0 4 8 0 114
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 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
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 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
127 2/25/13 0 0 0 0 16 1 6 0 18 2 0 0 27 0 0 1 1 0 5 1 4 7 0 89
128 2/26/13 0 0 0 0 17 0 10 0 14 1 0 0 29 0 0 0 1 0 10 1 4 7 0 94
129 2/27/13 0 0 1 0 20 1 11 0 24 3 0 0 22 0 0 1 0 0 7 2 5 6 0 103
130 2/28/13 0 1 0 0 20 1 10 0 24 1 0 0 16 0 0 3 0 0 6 1 5 5 0 93
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 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
134 3/4/13 0 0 0 0 8 0 15 1 20 2 0 0 18 0 0 0 0 0 6 0 1 4 0 75
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
136 3/6/13 0 0 0 0 4 0 4 0 22 3 0 0 16 0 0 2 1 0 2 0 1 3 0 58
137 3/7/13 0 0 0 0 3 1 6 0 15 0 0 0 6 0 0 2 1 0 5 2 3 6 0 50
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 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
141 3/11/13 0 0 0 0 4 0 4 0 14 1 0 0 10 0 0 1 1 0 10 1 1 6 0 53
143 3/13/13 0 0 0 0 6 0 9 0 28 1 0 0 7 0 0 2 1 0 7 0 4 5 0 70
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
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
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
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
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 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
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
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
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 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
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
157 3/27/13 0 0 0 0 16 0 5 0 13 0 0 0 15 0 0 0 0 0 9 2 1 6 0 67
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
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
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
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 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 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 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
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

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 · Query took 366.508ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub