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 NYCEM

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
56 12/16/12 0 0 0 5 46 2 8 1 2 10 0 0 0 356 0 1 0 1 2 1 22 3 0 460
71 12/31/12 0 0 1 1 61 1 8 0 21 5 0 0 6 0 0 4 0 2 0 0 14 8 0 132
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
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
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
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
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
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
108 2/6/13 0 0 1 1 31 2 4 0 38 0 0 0 25 0 0 1 0 1 7 0 8 6 0 125
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
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
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
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
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
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
122 2/20/13 0 0 0 3 24 0 6 1 18 3 0 0 25 0 0 2 0 1 18 1 7 5 0 114
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
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
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
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
138 3/8/13 0 0 0 0 4 0 3 0 18 3 0 0 10 0 0 1 0 1 2 2 2 3 0 49
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
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
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
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
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
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
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
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
171 4/10/13 0 0 0 0 7 0 1 0 3 0 0 0 8 0 0 2 0 0 7 0 1 4 0 33
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
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
177 4/16/13 0 0 0 0 4 0 3 0 7 1 0 0 7 0 0 0 0 0 8 0 0 3 0 33
178 4/17/13 0 0 0 0 6 1 4 0 8 1 0 0 7 0 0 2 0 0 4 1 1 4 0 39
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
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 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
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 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
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
190 4/29/13 0 0 0 0 10 1 3 0 5 3 0 0 13 0 0 2 0 0 4 1 1 4 31 78
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 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
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 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 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
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
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
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 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
204 5/13/13 0 0 0 0 16 1 0 0 1 1 0 0 7 0 0 2 0 1 4 0 0 6 26 65
206 5/15/13 0 0 0 0 14 0 2 0 3 0 0 0 4 0 0 0 0 0 3 0 0 3 25 54
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
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
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
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 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
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
219 5/28/13 0 0 0 0 6 0 4 0 5 0 0 0 7 0 0 1 0 0 5 0 1 3 16 48
220 5/29/13 0 0 0 0 9 0 1 0 8 0 0 0 11 0 0 1 0 0 5 0 0 3 20 58
221 5/30/13 0 0 0 0 8 0 3 0 2 0 0 0 2 0 0 2 0 0 2 0 1 4 13 37
222 5/31/13 0 0 0 0 8 0 2 0 6 0 0 0 4 0 0 1 0 0 2 0 1 3 23 50
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
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
226 6/4/13 0 0 0 0 22 0 2 0 4 0 0 0 0 0 0 5 0 0 3 1 2 12 34 85
228 6/6/13 0 0 0 0 7 1 2 0 3 2 0 0 0 0 0 2 0 0 5 0 0 7 14 43
229 6/7/13 0 0 0 0 7 0 4 0 2 2 0 0 0 0 0 1 0 0 2 0 0 6 16 40
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 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
232 6/10/13 0 0 0 0 5 0 5 0 1 1 0 0 0 0 0 1 0 1 6 1 3 8 28 60
234 6/12/13 0 0 0 0 3 0 4 0 3 3 0 0 0 0 0 1 0 0 1 0 3 7 20 45
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 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
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 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 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
241 6/19/13 0 0 0 0 2 1 4 0 6 0 0 0 0 0 0 1 0 0 1 0 1 5 13 34
242 6/20/13 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 2 0 0 4 0 1 3 14 26
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 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

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