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

109 rows where DEP = 1

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: ACS, BPSI, CAU, DOB, DOE, DOF, DOHMH, DPR, FEMA, HPD, HRA, MOSE, NYCEM, NYCHA, NYCSERVICE, NYPD, NYSDOL, 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
47 47 12/7/12 0 1 1 12 148 1 25 1 48 4 21 0 0 1 0 7 7 2 6 3 117 11 0 416
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
51 51 12/11/12 0 0 1 17 132 1 15 2 61 9 0 0 0 48 0 1 9 1 4 2 109 11 0 423
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
66 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
67 67 12/27/12 0 0 0 2 93 1 16 1 25 4 0 0 15 0 0 0 2 1 4 2 25 7 0 198
68 68 12/28/12 0 1 0 0 72 1 21 0 28 11 0 0 13 0 0 2 1 4 5 2 10 6 0 177
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
71 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
74 74 1/3/13 0 2 0 0 84 1 6 2 18 6 0 0 10 0 0 1 6 2 4 1 22 3 0 168
80 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
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
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
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
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
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
101 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
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
109 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 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 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
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
116 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
121 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 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
127 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
129 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 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
137 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 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
142 142 3/12/13 0 0 0 0 7 1 6 0 16 4 0 0 9 0 0 0 1 1 6 0 2 7 0 60
150 150 3/20/13 0 0 0 0 6 1 5 0 7 2 0 0 12 0 0 0 1 1 11 0 2 1 0 49
152 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
154 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
159 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
162 162 4/1/13 0 0 0 0 8 1 3 0 11 0 0 0 12 0 0 0 1 1 9 2 2 3 0 53
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
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
167 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 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
173 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
178 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
184 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
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
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
190 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
199 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
204 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
207 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
213 213 5/22/13 0 0 0 0 10 1 0 0 0 0 0 0 6 0 0 2 1 2 1 0 0 1 22 46
228 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
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
239 239 6/17/13 0 0 0 0 4 1 6 0 2 1 0 0 0 0 0 0 1 1 0 1 0 5 14 36
241 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
248 248 6/26/13 0 0 0 0 2 1 2 0 4 1 0 0 0 0 0 0 0 1 6 0 1 3 11 32
253 253 7/1/13 0 0 0 0 5 1 5 0 6 0 0 0 0 0 0 0 1 1 5 0 0 3 16 43
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
260 260 7/8/13 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 4 8 16
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
263 263 7/11/13 0 0 0 0 1 1 0 0 2 0 0 0 0 0 0 1 0 0 1 0 1 5 5 17
269 269 7/17/13 0 0 0 0 4 1 0 0 1 1 0 0 0 0 0 1 0 0 4 2 0 5 11 30
274 274 7/22/13 0 1 0 0 4 1 1 0 1 4 0 0 0 0 0 1 0 0 2 1 0 6 5 27
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
283 283 7/31/13 0 0 0 0 3 1 1 0 1 0 0 0 0 0 0 2 0 0 0 0 1 4 7 20
309 309 8/26/13 0 0 0 0 3 1 1 0 9 0 0 0 0 0 0 0 2 0 1 0 0 1 0 18
311 311 8/28/13 0 0 0 0 1 1 1 0 3 0 0 0 0 0 0 2 0 0 0 1 0 3 1 13
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
326 326 9/12/13 0 0 0 0 0 1 0 0 5 1 0 0 0 0 0 0 0 1 1 0 0 4 6 19
340 340 9/26/13 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 1 4 8
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
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
360 360 10/16/13 0 0 0 0 1 1 2 0 4 0 0 0 0 0 0 0 0 0 1 1 0 4 6 20
362 362 10/18/13 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 3 4 10
387 387 11/12/13 0 0 0 0 6 1 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 2 11
390 390 11/15/13 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 5 8
395 395 11/20/13 0 0 0 0 1 1 0 0 2 1 0 0 0 0 0 0 0 0 1 0 0 1 7 14
397 397 11/22/13 0 0 0 0 2 1 0 0 1 1 0 0 0 0 0 0 1 0 1 0 0 0 2 9
411 411 12/6/13 0 0 0 0 2 1 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 5 10
425 425 12/20/13 0 0 0 0 0 1 0 0 3 0 0 0 0 0 0 0 0 0 1 1 0 0 4 10
435 435 12/30/13 0 0 0 0 0 1 0 0 1 1 0 0 0 0 0 1 0 0 0 0 0 0 3 7
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
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
528 528 4/2/14 0 0 0 0 1 1 1 0 1 1 0 0 0 0 0 0 0 0 1 0 0 1 3 10
596 596 6/9/14 0 0 0 0 1 1 1 0 2 0 0 0 0 0 0 0 0 0 0 0 0 1 1 7
633 633 7/16/14 0 0 0 0 1 1 0 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0 3 9
662 662 8/14/14 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 3
687 687 9/8/14 0 0 0 0 0 1 0 0 4 3 0 0 0 0 0 0 0 0 0 0 0 1 2 11
688 688 9/9/14 0 0 0 0 0 1 3 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10
700 700 9/21/14 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
701 701 9/22/14 0 0 0 0 0 1 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4
710 710 10/1/14 0 0 0 0 3 1 0 0 4 0 0 0 0 0 0 0 0 0 0 1 0 0 3 12
722 722 10/13/14 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 2
738 738 10/29/14 0 0 0 0 5 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 7
757 757 11/17/14 0 0 0 0 1 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 4
759 759 11/19/14 0 0 0 0 0 1 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 3 6
785 785 12/15/14 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 2
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
805 805 1/4/15 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 3

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