new_york_city

Custom SQL query returning 24 rows (hide)

Query parameters

rowidprecinct_2020P0010001P0010002P0010003P0010004P0010005P0010006P0010007P0010008P0010009P0010010P0010011P0010012P0010013P0010014P0010015P0010016P0010017P0010018P0010019P0010020P0010021P0010022P0010023P0010024P0010025P0010026P0010027P0010028P0010029P0010030P0010031P0010032P0010033P0010034P0010035P0010036P0010037P0010038P0010039P0010040P0010041P0010042P0010043P0010044P0010045P0010046P0010047P0010048P0010049P0010050P0010051P0010052P0010053P0010054P0010055P0010056P0010057P0010058P0010059P0010060P0010061P0010062P0010063P0010064P0010065P0010066P0010067P0010068P0010069P0010070P0010071P0020001P0020002P0020003P0020004P0020005P0020006P0020007P0020008P0020009P0020010P0020011P0020012P0020013P0020014P0020015P0020016P0020017P0020018P0020019P0020020P0020021P0020022P0020023P0020024P0020025P0020026P0020027P0020028P0020029P0020030P0020031P0020032P0020033P0020034P0020035P0020036P0020037P0020038P0020039P0020040P0020041P0020042P0020043P0020044P0020045P0020046P0020047P0020048P0020049P0020050P0020051P0020052P0020053P0020054P0020055P0020056P0020057P0020058P0020059P0020060P0020061P0020062P0020063P0020064P0020065P0020066P0020067P0020068P0020069P0020070P0020071P0020072P0020073
1 1 66679 64416 50484 2162 89 10569 26 1086 2263 2098 348 115 1151 28 174 48 53 0 39 8 1 5 26 99 3 151 64 28 1 8 3 1 3 20 16 1 2 0 1 1 2 0 0 0 0 0 13 7 1 3 0 1 0 0 1 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 66679 4676 62003 60094 47231 1982 57 10520 23 281 1909 1784 280 85 1110 26 61 44 52 0 20 7 1 1 25 71 1 113 52 22 1 3 2 1 1 15 12 1 2 0 0 0 1 0 0 0 0 0 11 6 1 2 0 1 0 0 1 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0
3 6 62226 60490 53227 1316 80 5023 21 823 1736 1596 286 121 883 13 120 23 41 1 29 7 0 6 27 37 2 119 53 10 0 10 14 0 2 12 12 1 1 0 2 0 1 1 0 0 0 0 18 14 0 3 0 0 0 1 0 0 0 0 0 0 0 0 3 3 0 0 0 0 0 0 0 62226 3781 58445 56956 50468 1214 47 4983 20 224 1489 1384 244 92 863 8 45 20 35 1 9 7 0 0 27 32 1 90 41 8 0 5 12 0 1 12 8 1 1 0 0 0 1 0 0 0 0 0 13 11 0 1 0 0 0 1 0 0 0 0 0 0 0 0 2 2 0 0 0 0 0 0 0
6 10 50180 48333 35838 4171 170 5653 15 2486 1847 1670 407 113 545 9 288 75 32 6 77 16 4 20 12 54 12 161 86 14 1 15 0 0 1 5 15 3 5 0 5 1 7 0 0 0 3 0 12 6 0 5 0 0 0 0 0 0 0 0 1 0 0 0 4 2 1 0 0 0 1 0 0 50180 8821 41359 40202 30799 3518 71 5604 12 198 1157 1062 250 75 509 8 58 59 28 6 9 14 2 0 12 31 1 88 50 10 0 6 0 0 0 5 10 0 5 0 0 0 2 0 0 0 0 0 5 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 1 0 0 0 0 0 0
8 14 20651 20019 12868 1481 56 4964 13 637 632 586 91 31 196 13 92 29 16 0 34 18 0 10 19 31 6 42 26 1 1 4 4 0 0 2 2 0 1 0 1 0 0 0 0 0 0 0 4 0 0 3 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20651 2198 18453 18005 11605 1353 34 4933 11 69 448 414 45 25 188 11 34 25 14 0 7 18 0 1 16 27 3 33 19 1 1 3 4 0 0 2 2 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9 17 79126 77567 63691 1711 71 11097 45 952 1559 1455 216 47 774 17 143 14 46 2 17 8 1 10 22 135 3 97 29 22 0 5 7 0 1 10 15 2 2 0 0 3 0 0 0 0 0 1 4 3 0 1 0 0 0 0 0 0 0 0 0 0 0 0 3 2 1 0 0 0 0 0 0 79126 4595 74531 73194 60226 1583 44 11038 35 268 1337 1261 177 39 751 17 52 11 45 1 9 6 0 0 21 129 3 73 20 21 0 0 7 0 1 9 12 0 1 0 0 2 0 0 0 0 0 0 3 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10 18 54066 52216 37624 3106 168 8462 27 2829 1850 1721 262 98 570 14 407 32 61 5 95 21 0 24 25 98 9 121 59 4 0 17 9 0 2 13 12 2 2 0 1 0 0 0 0 0 0 0 7 2 1 2 0 0 0 0 1 0 0 0 1 0 0 0 1 1 0 0 0 0 0 0 0 54066 8883 45183 44019 32682 2637 68 8389 25 218 1164 1088 179 60 537 13 65 25 60 5 30 20 0 1 24 68 1 73 40 2 0 2 6 0 1 12 8 0 2 0 0 0 0 0 0 0 0 0 3 1 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
11 19 208259 203870 178395 5365 231 16859 57 2963 4389 4098 610 243 2094 49 519 67 124 8 99 25 2 24 38 176 20 261 118 47 0 18 14 1 3 22 24 0 0 1 2 3 4 1 0 0 2 1 29 19 3 3 0 2 0 1 0 0 0 0 1 0 0 0 1 1 0 0 0 0 0 0 0 208259 13827 194432 190952 168711 4817 116 16727 48 533 3480 3298 469 189 2021 46 153 48 111 6 48 23 1 0 36 139 8 160 68 31 0 7 10 1 0 20 14 0 0 1 0 3 4 1 0 0 0 0 21 16 3 0 0 1 0 1 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0
13 22 25 25 6 18 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25 6 19 19 2 16 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
18 28 44781 42566 9799 27033 321 1607 43 3763 2215 1934 526 64 221 12 223 251 118 28 347 19 0 46 2 41 36 250 141 24 5 11 5 0 3 3 13 3 5 2 23 3 1 7 1 0 0 0 27 16 1 4 0 0 1 0 2 0 0 1 0 0 1 1 4 3 1 0 0 0 0 0 0 44781 9393 35388 34184 7227 25067 114 1570 27 179 1204 1057 350 37 218 8 14 165 103 26 96 14 0 7 1 17 1 136 88 15 3 3 2 0 0 3 6 1 4 0 3 3 1 3 1 0 0 0 7 5 1 0 0 0 0 0 0 0 0 1 0 0 0 0 4 3 1 0 0 0 0 0 0
36 61 159645 156825 121073 5940 299 24223 22 5268 2820 2690 312 83 1090 87 588 59 55 15 135 32 0 33 27 147 27 123 39 6 0 17 5 0 9 4 28 2 2 1 1 1 7 0 0 0 1 0 6 4 0 0 1 0 0 0 0 1 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 159645 13029 146616 144553 114720 5298 88 24107 14 326 2063 1993 237 64 1060 83 231 46 54 13 30 30 0 2 25 106 12 65 11 6 0 5 3 0 0 3 25 2 2 1 0 1 5 0 0 0 1 0 4 3 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0
38 63 108646 106194 49114 48543 326 5091 24 3096 2452 2277 488 72 375 11 256 97 271 92 404 36 5 26 15 104 25 159 41 57 2 16 4 0 6 0 3 0 6 0 2 1 14 7 0 0 0 0 15 5 1 5 1 0 2 0 1 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 108646 9247 99399 97652 45309 46606 198 5045 22 472 1747 1619 362 59 336 11 52 88 258 90 225 33 2 2 12 86 3 123 29 49 1 11 4 0 0 0 3 0 5 0 2 1 13 5 0 0 0 0 5 1 0 1 1 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
41 68 124491 121140 85271 2288 329 25884 39 7329 3351 3196 527 168 1170 60 761 33 79 7 105 35 0 38 20 183 10 135 59 21 2 14 6 2 9 7 11 0 0 1 1 0 1 0 1 0 0 0 19 8 0 5 0 4 0 0 1 0 0 1 0 0 0 0 1 0 0 0 1 0 0 0 0 124491 17868 106623 104486 76537 1757 97 25743 23 329 2137 2071 347 109 1110 57 118 27 73 4 36 35 0 1 19 133 2 59 18 15 1 3 4 2 0 6 7 0 0 1 0 0 1 0 1 0 0 0 6 5 0 0 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 1 0 0 0 0
44 71 98429 95882 20812 70414 358 1253 35 3010 2547 2296 534 59 182 8 199 292 270 140 536 5 0 23 4 27 17 235 106 55 0 17 3 0 4 3 3 1 7 0 13 7 7 8 0 0 1 0 12 4 2 2 0 0 0 0 1 0 0 0 1 0 2 0 4 4 0 0 0 0 0 0 0 98429 9157 89272 87601 18825 66958 199 1214 25 380 1671 1506 405 32 173 7 33 254 239 134 200 3 0 8 4 13 1 152 62 44 0 10 2 0 0 3 3 0 6 0 3 7 6 5 0 0 1 0 9 3 1 1 0 0 0 0 1 0 0 0 1 0 2 0 4 4 0 0 0 0 0 0 0
52 81 62722 60811 4581 50302 408 1096 20 4404 1911 1740 424 36 44 5 243 334 112 27 410 10 2 22 4 34 33 148 55 28 4 29 0 0 2 0 2 0 4 2 7 3 6 4 0 0 1 1 20 13 0 3 1 2 0 0 0 0 0 0 0 1 0 0 3 2 1 0 0 0 0 0 0 62722 10474 52248 51243 2128 47638 243 1068 12 154 1005 910 286 11 44 1 8 277 99 23 133 10 2 6 4 6 0 83 37 18 4 5 0 0 0 0 1 0 3 1 4 3 2 4 0 0 0 1 11 9 0 2 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0
54 84 48196 46319 33297 6470 158 4519 21 1854 1877 1735 327 104 710 14 180 101 49 16 112 6 1 23 15 64 13 137 59 28 3 11 5 0 4 5 7 0 6 0 2 2 3 2 0 0 0 0 4 2 0 2 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 48196 6078 42118 40735 30066 5935 79 4451 15 189 1383 1293 265 62 690 11 34 85 46 11 24 4 1 2 15 43 0 88 36 21 3 5 2 0 3 5 5 0 5 0 1 1 1 0 0 0 0 0 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
55 88 51421 48902 18769 23376 238 3393 11 3115 2519 2236 628 72 504 16 266 234 143 21 230 8 3 24 12 65 10 261 137 48 3 16 9 2 3 8 9 0 9 1 4 0 4 7 0 0 1 0 20 17 0 2 0 1 0 0 0 0 0 0 0 0 0 0 2 1 1 0 0 0 0 0 0 51421 8093 43328 41581 15904 21986 126 3341 8 216 1747 1534 504 43 480 14 22 197 133 17 56 7 3 1 12 45 0 194 112 36 3 5 7 0 1 8 5 0 6 1 1 0 2 6 0 0 1 0 17 16 0 0 0 1 0 0 0 0 0 0 0 0 0 0 2 1 1 0 0 0 0 0 0
70 112 112070 108553 71381 3240 223 29356 46 4307 3517 3271 385 95 1209 70 643 64 102 4 96 102 0 20 81 377 23 215 77 29 2 33 6 0 5 12 30 4 0 0 4 0 7 1 1 0 2 2 24 14 0 4 1 4 1 0 0 0 0 0 0 0 0 0 7 5 2 0 0 0 0 0 0 112070 15128 96942 94549 61927 2792 104 29200 29 497 2393 2260 218 36 1126 69 134 42 95 4 29 98 0 3 79 324 3 112 35 27 2 4 6 0 0 12 14 3 0 0 1 0 4 1 1 0 0 2 17 11 0 3 1 2 0 0 0 0 0 0 0 0 0 0 4 3 1 0 0 0 0 0 0
75 121 118708 114773 73769 16688 557 13217 78 10464 3935 3643 789 136 547 46 973 149 127 20 328 106 3 40 25 318 36 255 120 23 6 30 4 4 9 4 28 5 5 2 7 1 5 1 1 0 0 0 37 15 5 8 0 4 0 0 1 1 1 0 1 0 1 0 0 0 0 0 0 0 0 0 0 118708 27252 91456 89367 60934 14798 199 13050 43 343 2089 1949 570 93 479 39 97 115 113 18 56 93 1 2 24 242 7 121 62 15 6 5 2 4 2 4 9 0 5 2 1 1 2 0 1 0 0 0 19 10 3 3 0 1 0 0 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0
77 123 98032 96794 89264 1399 122 4551 33 1425 1238 1170 268 87 332 25 328 11 7 1 18 8 5 4 4 68 4 67 29 12 1 5 1 0 2 1 12 0 0 0 0 0 2 2 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 98032 7982 90050 89245 83295 1216 64 4521 25 124 805 768 218 70 319 23 57 8 6 0 4 8 5 1 3 46 0 37 15 7 1 3 1 0 2 1 3 0 0 0 0 0 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
5 9 76443 73259 48175 6904 361 10946 45 6828 3184 2877 534 155 912 31 590 123 63 6 199 25 5 73 31 88 42 275 139 28 2 24 11 0 5 17 13 8 6 6 6 0 5 1 0 0 4 0 28 16 4 4 1 1 0 0 2 0 0 0 0 0 0 0 3 2 1 0 0 0 0 1 1 76443 18291 58152 56307 39560 5466 127 10831 28 295 1845 1693 370 112 858 24 62 81 51 5 25 23 0 2 30 49 1 136 74 22 1 4 9 0 1 14 4 0 5 1 0 0 1 0 0 0 0 0 14 12 0 1 0 0 0 0 1 0 0 0 0 0 0 0 2 1 1 0 0 0 0 0 0
7 13 93640 90828 70786 4864 194 12883 39 2062 2812 2562 429 108 1268 21 295 71 64 6 82 24 0 21 34 127 12 223 104 32 2 9 16 2 7 14 17 4 1 0 2 0 6 1 0 0 0 6 24 11 1 8 1 0 0 1 0 0 2 0 0 0 0 0 2 2 0 0 0 0 0 1 1 93640 8565 85075 82936 65354 4369 100 12785 31 297 2139 1975 287 84 1208 19 69 59 59 6 26 20 0 1 33 99 5 151 75 22 2 3 13 2 1 13 10 0 1 0 0 0 3 0 0 0 0 6 12 9 0 0 1 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 1 1
37 62 181981 178420 100902 1894 537 63153 156 11778 3561 3431 296 128 1261 67 1123 20 80 6 66 94 1 58 36 155 40 112 41 9 2 6 6 0 7 11 15 4 1 2 0 1 3 0 3 0 1 0 13 11 0 0 0 2 0 0 0 0 0 0 0 0 0 0 4 3 0 1 0 0 0 1 1 181981 24239 157742 155581 90741 1362 145 62901 47 385 2161 2093 201 83 1206 58 228 13 74 6 15 88 1 0 35 81 4 55 12 7 2 1 4 0 0 11 10 1 0 1 0 1 3 0 2 0 0 0 9 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 3 0 0 0 0 0 1 1
42 69 84480 82675 6885 70837 311 2273 14 2355 1805 1658 352 23 93 15 139 191 234 138 379 13 1 9 12 39 20 133 27 30 1 16 1 0 1 6 2 4 10 1 8 8 10 8 0 0 0 0 13 5 0 5 2 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 1 84480 7059 77421 76134 4972 68396 193 2233 8 332 1287 1171 248 16 85 13 10 162 217 128 237 10 0 1 12 27 5 102 20 28 1 11 1 0 1 6 0 3 9 1 1 8 8 4 0 0 0 0 13 5 0 5 2 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 1
50 78 66664 63672 49139 6940 221 3957 31 3384 2992 2744 607 165 1144 24 314 76 126 12 104 13 1 50 19 82 7 231 109 37 1 21 9 0 7 13 18 0 4 0 5 0 5 0 0 0 2 0 15 7 0 5 1 1 0 0 1 0 0 0 0 0 0 0 1 1 0 0 0 0 0 1 1 66664 10248 56416 54326 43996 6036 92 3891 18 293 2090 1955 457 95 1072 21 26 62 117 12 20 9 1 3 18 41 1 127 50 26 1 6 5 0 3 12 15 0 4 0 0 0 5 0 0 0 0 0 7 5 0 1 1 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0