fivethirtyeight

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

Custom SQL query returning 101 rows (hide)

This data as json, copyable, CSV

rowiddateNYC-3-1-1ACSBPSICAUCHALLDEPDOBDOEDOFDOHMHDPRFEMAHPDHRAMFANYCMOSENYCEMNYCHANYCSERVICENYPDNYSDOLSBSNYSEMERGENCYMGtotal
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
25 11/15/12 5 0 28 53 235 0 78 49 0 0 0 0 0 0 0 0 27 4 0 0 0 8 0 487
26 11/16/12 0 0 17 44 202 0 45 34 0 0 0 0 0 0 0 0 17 7 0 0 0 13 0 379
27 11/17/12 0 0 6 15 105 0 32 5 0 0 0 0 0 0 0 0 7 6 0 0 0 1 0 177
28 11/18/12 0 0 4 38 91 0 30 28 0 0 0 0 0 0 0 0 12 4 0 0 0 0 0 207
29 11/19/12 0 0 14 46 202 0 97 63 0 0 0 0 0 0 0 0 13 10 0 0 0 7 0 452
30 11/20/12 0 0 9 37 224 0 59 25 0 0 0 0 0 0 0 0 12 5 0 0 0 14 0 385
31 11/21/12 0 0 5 23 191 0 42 14 0 0 3 0 0 0 0 0 8 3 0 8 0 4 0 301
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
70 12/30/12 0 0 0 0 47 0 3 0 2 3 0 0 6 0 0 0 4 1 0 1 6 0 0 73
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
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
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
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
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
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
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
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
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
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
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
218 5/27/13 0 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 1 0 0 0 1 0 1 5
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
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
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
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
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
258 7/6/13 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7 10
259 7/7/13 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 1 3
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
266 7/14/13 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 4 6
270 7/18/13 0 1 0 0 1 0 2 0 1 0 0 0 0 0 0 1 0 0 0 0 0 1 8 15
273 7/21/13 0 0 0 0 2 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 2 6
277 7/25/13 0 2 0 0 1 0 3 0 0 0 0 0 0 0 0 0 0 0 0 1 2 1 7 17
280 7/28/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2
281 7/29/13 0 0 0 0 1 0 4 0 0 2 0 0 0 0 0 0 1 0 0 0 0 1 11 20
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
284 8/1/13 0 0 0 0 2 0 0 0 7 1 0 0 0 0 0 0 0 0 0 0 0 3 7 20
286 8/3/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1
287 8/4/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 2
293 8/10/13 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 1 4
294 8/11/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
296 8/13/13 0 0 0 0 2 0 0 0 7 1 0 0 0 0 0 0 2 0 0 0 0 0 3 15
297 8/14/13 0 0 0 0 0 0 2 0 2 2 0 0 0 0 0 0 0 0 0 0 0 3 6 15
299 8/16/13 0 0 0 0 2 0 1 0 2 3 0 0 0 0 0 0 0 0 0 0 1 3 7 19
300 8/17/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
301 8/18/13 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 3
303 8/20/13 0 0 0 0 1 0 1 0 8 2 0 0 0 0 0 0 0 0 0 0 0 0 6 18
304 8/21/13 0 0 0 0 0 0 0 0 9 2 0 0 0 0 0 0 0 0 0 0 1 1 7 20
305 8/22/13 0 0 0 0 3 0 0 0 1 1 0 0 0 0 0 5 0 0 0 0 0 4 9 23
307 8/24/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1
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
312 8/29/13 0 0 0 0 3 0 0 0 5 0 0 0 0 0 0 0 0 0 0 0 0 1 5 14
313 8/30/13 0 0 0 0 0 0 1 0 11 1 0 0 0 0 0 0 0 0 0 0 0 1 5 19
314 8/31/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
315 9/1/13 0 0 0 0 0 0 0 0 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 3
318 9/4/13 0 0 0 0 1 0 0 0 7 0 0 0 0 0 0 0 0 0 0 0 0 1 3 12
319 9/5/13 0 0 0 0 0 0 2 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 7 15
322 9/8/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2
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
327 9/13/13 0 0 0 0 0 0 1 0 4 2 0 0 0 0 0 1 0 0 0 0 0 3 3 14
329 9/15/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
330 9/16/13 0 0 0 0 2 0 1 0 6 0 0 0 0 0 0 0 0 0 0 1 0 3 8 21
335 9/21/13 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 3 5
336 9/22/13 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 2
338 9/24/13 0 0 0 0 3 0 0 0 2 1 0 0 0 0 0 0 0 0 0 0 0 3 12 21
343 9/29/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 8 9
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
349 10/5/13 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 5
350 10/6/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
351 10/7/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8 8