nyc_2010pop_2020precincts
Data license: CC BY-SA 4.0 · Data source: US Census & NYC Open Data Portal, combined by John Keefe
7 rows where P0010062 = 0 and P0020039 = 4
This data as json, CSV (advanced)
Suggested facets: P0010007, P0010018, P0010021, P0010022, P0010029, P0010030, P0010032, P0010034, P0010035, P0010036, P0010037, P0010038, P0010039, P0010040, P0010041, P0010042, P0010043, P0010045, P0010046, P0010049, P0010051, P0010052, P0010053, P0010055, P0010056, P0010057, P0010058, P0010059, P0010060, P0010061, P0010063, P0010064, P0010065, P0010067, P0010070, P0010071, P0020007, P0020016, P0020018, P0020021, P0020023, P0020024, P0020026, P0020027, P0020028, P0020031, P0020032, P0020035, P0020036, P0020037, P0020038, P0020040, P0020041, P0020042, P0020043, P0020044, P0020045, P0020046, P0020047, P0020048, P0020049, P0020050, P0020052, P0020053, P0020054, P0020055, P0020059, P0020060, P0020063, P0020065, P0020066, P0020067, P0020072, P0020073
| Link | rowid ▼ | precinct_2020 | P0010001 | P0010002 | P0010003 | P0010004 | P0010005 | P0010006 | P0010007 | P0010008 | P0010009 | P0010010 | P0010011 | P0010012 | P0010013 | P0010014 | P0010015 | P0010016 | P0010017 | P0010018 | P0010019 | P0010020 | P0010021 | P0010022 | P0010023 | P0010024 | P0010025 | P0010026 | P0010027 | P0010028 | P0010029 | P0010030 | P0010031 | P0010032 | P0010033 | P0010034 | P0010035 | P0010036 | P0010037 | P0010038 | P0010039 | P0010040 | P0010041 | P0010042 | P0010043 | P0010044 | P0010045 | P0010046 | P0010047 | P0010048 | P0010049 | P0010050 | P0010051 | P0010052 | P0010053 | P0010054 | P0010055 | P0010056 | P0010057 | P0010058 | P0010059 | P0010060 | P0010061 | P0010062 | P0010063 | P0010064 | P0010065 | P0010066 | P0010067 | P0010068 | P0010069 | P0010070 | P0010071 | P0020001 | P0020002 | P0020003 | P0020004 | P0020005 | P0020006 | P0020007 | P0020008 | P0020009 | P0020010 | P0020011 | P0020012 | P0020013 | P0020014 | P0020015 | P0020016 | P0020017 | P0020018 | P0020019 | P0020020 | P0020021 | P0020022 | P0020023 | P0020024 | P0020025 | P0020026 | P0020027 | P0020028 | P0020029 | P0020030 | P0020031 | P0020032 | P0020033 | P0020034 | P0020035 | P0020036 | P0020037 | P0020038 | P0020039 | P0020040 | P0020041 | P0020042 | P0020043 | P0020044 | P0020045 | P0020046 | P0020047 | P0020048 | P0020049 | P0020050 | P0020051 | P0020052 | P0020053 | P0020054 | P0020055 | P0020056 | P0020057 | P0020058 | P0020059 | P0020060 | P0020061 | P0020062 | P0020063 | P0020064 | P0020065 | P0020066 | P0020067 | P0020068 | P0020069 | P0020070 | P0020071 | P0020072 | P0020073 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19 | 19 | 30 | 60685 | 56601 | 14707 | 21103 | 816 | 1465 | 42 | 18468 | 4084 | 3730 | 701 | 113 | 178 | 5 | 1264 | 169 | 88 | 37 | 726 | 18 | 5 | 229 | 10 | 107 | 80 | 322 | 135 | 22 | 1 | 83 | 5 | 4 | 11 | 2 | 12 | 4 | 4 | 4 | 10 | 1 | 5 | 1 | 0 | 10 | 6 | 2 | 29 | 6 | 0 | 14 | 1 | 2 | 0 | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 60685 | 34825 | 25860 | 24895 | 6178 | 16951 | 161 | 1369 | 19 | 217 | 965 | 849 | 265 | 55 | 164 | 2 | 37 | 120 | 77 | 24 | 64 | 11 | 0 | 5 | 8 | 16 | 1 | 106 | 65 | 14 | 1 | 2 | 4 | 0 | 0 | 2 | 3 | 1 | 4 | 4 | 1 | 1 | 3 | 0 | 0 | 0 | 1 | 0 | 7 | 3 | 0 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 24 | 24 | 41 | 52246 | 48506 | 12955 | 15828 | 1041 | 455 | 50 | 18177 | 3740 | 3451 | 589 | 106 | 39 | 3 | 1232 | 233 | 33 | 19 | 747 | 20 | 3 | 229 | 0 | 97 | 101 | 266 | 127 | 3 | 0 | 31 | 2 | 0 | 8 | 1 | 10 | 8 | 4 | 0 | 53 | 0 | 6 | 5 | 0 | 4 | 4 | 0 | 20 | 2 | 0 | 11 | 0 | 4 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 52246 | 39089 | 13157 | 12807 | 694 | 11536 | 92 | 331 | 10 | 144 | 350 | 306 | 87 | 19 | 21 | 2 | 13 | 67 | 27 | 7 | 37 | 6 | 1 | 2 | 0 | 16 | 1 | 42 | 25 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 10 | 0 | 0 | 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 |
| 33 | 33 | 50 | 101720 | 96855 | 54359 | 15730 | 757 | 5184 | 42 | 20783 | 4865 | 4377 | 1018 | 126 | 441 | 18 | 1404 | 132 | 85 | 19 | 656 | 26 | 2 | 163 | 17 | 166 | 104 | 441 | 207 | 38 | 10 | 71 | 6 | 2 | 17 | 3 | 10 | 16 | 5 | 4 | 10 | 0 | 12 | 4 | 0 | 12 | 14 | 0 | 36 | 11 | 0 | 20 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 10 | 6 | 1 | 0 | 3 | 0 | 0 | 1 | 1 | 101720 | 44156 | 57564 | 56199 | 39181 | 11432 | 146 | 5022 | 26 | 392 | 1365 | 1224 | 384 | 51 | 394 | 14 | 70 | 67 | 62 | 15 | 48 | 18 | 1 | 6 | 13 | 71 | 10 | 127 | 70 | 17 | 10 | 3 | 2 | 0 | 6 | 1 | 4 | 2 | 4 | 2 | 2 | 0 | 3 | 1 | 0 | 0 | 0 | 0 | 10 | 3 | 0 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 39 | 39 | 66 | 191382 | 187193 | 134948 | 5312 | 709 | 34011 | 48 | 12165 | 4189 | 3886 | 472 | 144 | 903 | 61 | 1223 | 55 | 204 | 23 | 196 | 186 | 0 | 82 | 30 | 243 | 64 | 276 | 150 | 23 | 1 | 17 | 11 | 1 | 6 | 3 | 18 | 8 | 4 | 0 | 1 | 6 | 17 | 1 | 0 | 2 | 5 | 2 | 21 | 12 | 1 | 1 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 5 | 5 | 191382 | 24854 | 166528 | 164193 | 125152 | 4338 | 179 | 33856 | 22 | 646 | 2335 | 2246 | 288 | 72 | 875 | 43 | 206 | 43 | 189 | 23 | 79 | 183 | 0 | 14 | 29 | 192 | 10 | 82 | 13 | 21 | 1 | 0 | 10 | 0 | 0 | 1 | 11 | 0 | 4 | 0 | 1 | 4 | 15 | 0 | 0 | 1 | 0 | 0 | 6 | 2 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 |
| 50 | 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 |
| 67 | 67 | 109 | 247354 | 240457 | 95236 | 6596 | 555 | 122496 | 106 | 15468 | 6897 | 6559 | 513 | 143 | 2131 | 35 | 1780 | 77 | 189 | 16 | 246 | 305 | 0 | 110 | 152 | 781 | 81 | 279 | 82 | 36 | 1 | 44 | 7 | 0 | 23 | 12 | 30 | 8 | 4 | 3 | 3 | 1 | 9 | 7 | 2 | 6 | 0 | 1 | 53 | 25 | 0 | 8 | 0 | 11 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 5 | 0 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 247354 | 41164 | 206190 | 202136 | 73668 | 5512 | 215 | 122012 | 82 | 647 | 4054 | 3900 | 273 | 61 | 2030 | 31 | 120 | 58 | 181 | 10 | 64 | 298 | 0 | 2 | 147 | 619 | 6 | 120 | 38 | 25 | 0 | 1 | 6 | 0 | 0 | 11 | 18 | 0 | 4 | 2 | 0 | 1 | 6 | 4 | 2 | 1 | 0 | 1 | 30 | 20 | 0 | 1 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 5 | 0 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 76 | 76 | 122 | 138982 | 136452 | 119790 | 3397 | 330 | 8474 | 43 | 4418 | 2530 | 2358 | 469 | 166 | 658 | 29 | 649 | 52 | 52 | 9 | 85 | 32 | 0 | 18 | 23 | 99 | 17 | 154 | 52 | 8 | 0 | 17 | 17 | 0 | 3 | 10 | 29 | 5 | 4 | 1 | 0 | 1 | 4 | 0 | 0 | 3 | 0 | 0 | 17 | 10 | 1 | 3 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 138982 | 15903 | 123079 | 121540 | 109879 | 2863 | 168 | 8370 | 32 | 228 | 1539 | 1434 | 361 | 135 | 583 | 25 | 89 | 42 | 39 | 9 | 19 | 29 | 0 | 5 | 22 | 75 | 1 | 96 | 32 | 5 | 0 | 7 | 16 | 0 | 0 | 10 | 15 | 0 | 4 | 1 | 0 | 1 | 4 | 0 | 0 | 1 | 0 | 0 | 8 | 4 | 0 | 1 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "nyc_2010pop_2020precincts" ( "precinct_2020" INTEGER, "P0010001" INTEGER, "P0010002" INTEGER, "P0010003" INTEGER, "P0010004" INTEGER, "P0010005" INTEGER, "P0010006" INTEGER, "P0010007" INTEGER, "P0010008" INTEGER, "P0010009" INTEGER, "P0010010" INTEGER, "P0010011" INTEGER, "P0010012" INTEGER, "P0010013" INTEGER, "P0010014" INTEGER, "P0010015" INTEGER, "P0010016" INTEGER, "P0010017" INTEGER, "P0010018" INTEGER, "P0010019" INTEGER, "P0010020" INTEGER, "P0010021" INTEGER, "P0010022" INTEGER, "P0010023" INTEGER, "P0010024" INTEGER, "P0010025" INTEGER, "P0010026" INTEGER, "P0010027" INTEGER, "P0010028" INTEGER, "P0010029" INTEGER, "P0010030" INTEGER, "P0010031" INTEGER, "P0010032" INTEGER, "P0010033" INTEGER, "P0010034" INTEGER, "P0010035" INTEGER, "P0010036" INTEGER, "P0010037" INTEGER, "P0010038" INTEGER, "P0010039" INTEGER, "P0010040" INTEGER, "P0010041" INTEGER, "P0010042" INTEGER, "P0010043" INTEGER, "P0010044" INTEGER, "P0010045" INTEGER, "P0010046" INTEGER, "P0010047" INTEGER, "P0010048" INTEGER, "P0010049" INTEGER, "P0010050" INTEGER, "P0010051" INTEGER, "P0010052" INTEGER, "P0010053" INTEGER, "P0010054" INTEGER, "P0010055" INTEGER, "P0010056" INTEGER, "P0010057" INTEGER, "P0010058" INTEGER, "P0010059" INTEGER, "P0010060" INTEGER, "P0010061" INTEGER, "P0010062" INTEGER, "P0010063" INTEGER, "P0010064" INTEGER, "P0010065" INTEGER, "P0010066" INTEGER, "P0010067" INTEGER, "P0010068" INTEGER, "P0010069" INTEGER, "P0010070" INTEGER, "P0010071" INTEGER, "P0020001" INTEGER, "P0020002" INTEGER, "P0020003" INTEGER, "P0020004" INTEGER, "P0020005" INTEGER, "P0020006" INTEGER, "P0020007" INTEGER, "P0020008" INTEGER, "P0020009" INTEGER, "P0020010" INTEGER, "P0020011" INTEGER, "P0020012" INTEGER, "P0020013" INTEGER, "P0020014" INTEGER, "P0020015" INTEGER, "P0020016" INTEGER, "P0020017" INTEGER, "P0020018" INTEGER, "P0020019" INTEGER, "P0020020" INTEGER, "P0020021" INTEGER, "P0020022" INTEGER, "P0020023" INTEGER, "P0020024" INTEGER, "P0020025" INTEGER, "P0020026" INTEGER, "P0020027" INTEGER, "P0020028" INTEGER, "P0020029" INTEGER, "P0020030" INTEGER, "P0020031" INTEGER, "P0020032" INTEGER, "P0020033" INTEGER, "P0020034" INTEGER, "P0020035" INTEGER, "P0020036" INTEGER, "P0020037" INTEGER, "P0020038" INTEGER, "P0020039" INTEGER, "P0020040" INTEGER, "P0020041" INTEGER, "P0020042" INTEGER, "P0020043" INTEGER, "P0020044" INTEGER, "P0020045" INTEGER, "P0020046" INTEGER, "P0020047" INTEGER, "P0020048" INTEGER, "P0020049" INTEGER, "P0020050" INTEGER, "P0020051" INTEGER, "P0020052" INTEGER, "P0020053" INTEGER, "P0020054" INTEGER, "P0020055" INTEGER, "P0020056" INTEGER, "P0020057" INTEGER, "P0020058" INTEGER, "P0020059" INTEGER, "P0020060" INTEGER, "P0020061" INTEGER, "P0020062" INTEGER, "P0020063" INTEGER, "P0020064" INTEGER, "P0020065" INTEGER, "P0020066" INTEGER, "P0020067" INTEGER, "P0020068" INTEGER, "P0020069" INTEGER, "P0020070" INTEGER, "P0020071" INTEGER, "P0020072" INTEGER, "P0020073" INTEGER );