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 P0020042 = 0 and P0020065 = 1
This data as json, CSV (advanced)
Suggested facets: P0010018, P0010021, P0010029, P0010031, P0010032, P0010033, P0010035, P0010036, P0010038, P0010039, P0010040, P0010041, P0010042, P0010043, P0010044, P0010045, P0010046, P0010047, P0010048, P0010049, P0010050, P0010051, P0010052, P0010053, P0010055, P0010056, P0010057, P0010058, P0010059, P0010062, P0010063, P0010064, P0010065, P0010066, P0010067, P0010070, P0010071, P0020009, P0020015, P0020020, P0020021, P0020023, P0020024, P0020027, P0020031, P0020032, P0020033, P0020034, P0020035, P0020036, P0020037, P0020038, P0020039, P0020040, P0020041, P0020043, P0020044, P0020045, P0020046, P0020048, P0020050, P0020051, P0020052, P0020053, P0020054, P0020057, P0020059, P0020060, P0020061, P0020066, P0020067, P0020069, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 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 |
2 | 2 | 5 | 52568 | 51415 | 13436 | 2784 | 81 | 32795 | 18 | 2301 | 1153 | 1083 | 161 | 49 | 432 | 9 | 152 | 22 | 38 | 1 | 43 | 63 | 4 | 8 | 31 | 59 | 11 | 58 | 19 | 6 | 0 | 11 | 4 | 0 | 1 | 3 | 2 | 1 | 1 | 0 | 2 | 0 | 2 | 0 | 3 | 1 | 1 | 1 | 11 | 4 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 52568 | 5910 | 46658 | 45884 | 10739 | 2299 | 33 | 32708 | 13 | 92 | 774 | 742 | 89 | 37 | 412 | 7 | 17 | 18 | 33 | 1 | 3 | 60 | 2 | 0 | 30 | 33 | 0 | 27 | 9 | 6 | 0 | 0 | 4 | 0 | 0 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 0 | 0 | 4 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
25 | 25 | 42 | 79762 | 75079 | 13814 | 38416 | 1357 | 448 | 240 | 20804 | 4683 | 4348 | 587 | 64 | 40 | 14 | 1329 | 489 | 80 | 81 | 1112 | 18 | 14 | 282 | 3 | 104 | 131 | 315 | 68 | 19 | 2 | 57 | 0 | 0 | 18 | 0 | 2 | 6 | 6 | 0 | 79 | 3 | 10 | 16 | 1 | 18 | 7 | 3 | 15 | 5 | 0 | 3 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 4 | 4 | 79762 | 46013 | 33749 | 33114 | 918 | 31387 | 230 | 358 | 22 | 199 | 635 | 557 | 146 | 11 | 16 | 2 | 18 | 160 | 57 | 61 | 67 | 6 | 1 | 3 | 0 | 5 | 4 | 70 | 35 | 10 | 2 | 4 | 0 | 0 | 1 | 0 | 0 | 0 | 5 | 0 | 7 | 0 | 5 | 1 | 0 | 0 | 0 | 0 | 3 | 1 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 4 | 4 |
41 | 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 |
45 | 45 | 72 | 126230 | 120736 | 52711 | 5849 | 1573 | 33565 | 62 | 26976 | 5494 | 5080 | 710 | 508 | 770 | 34 | 1869 | 63 | 151 | 12 | 347 | 67 | 11 | 214 | 44 | 201 | 79 | 372 | 125 | 23 | 1 | 64 | 18 | 0 | 39 | 6 | 30 | 26 | 3 | 0 | 3 | 0 | 14 | 2 | 1 | 8 | 8 | 1 | 37 | 16 | 7 | 4 | 0 | 2 | 1 | 0 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 3 | 5 | 3 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 126230 | 57375 | 68855 | 67085 | 29464 | 3688 | 178 | 33288 | 33 | 434 | 1770 | 1643 | 316 | 88 | 723 | 24 | 51 | 42 | 143 | 12 | 52 | 53 | 1 | 3 | 40 | 94 | 1 | 109 | 49 | 12 | 0 | 3 | 7 | 0 | 0 | 5 | 15 | 1 | 1 | 0 | 0 | 0 | 11 | 2 | 1 | 2 | 0 | 0 | 17 | 16 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |
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 |
65 | 65 | 107 | 151107 | 144396 | 65452 | 20719 | 643 | 47326 | 130 | 10126 | 6711 | 6269 | 777 | 134 | 1788 | 77 | 1060 | 201 | 454 | 46 | 447 | 232 | 2 | 63 | 112 | 784 | 92 | 390 | 142 | 69 | 7 | 31 | 9 | 3 | 7 | 10 | 23 | 8 | 7 | 1 | 5 | 0 | 47 | 4 | 0 | 9 | 4 | 4 | 49 | 29 | 0 | 10 | 0 | 5 | 0 | 0 | 0 | 0 | 1 | 0 | 4 | 0 | 0 | 0 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 151107 | 25621 | 125486 | 120925 | 52871 | 19107 | 352 | 47039 | 91 | 1465 | 4561 | 4297 | 450 | 65 | 1705 | 74 | 137 | 173 | 419 | 46 | 183 | 220 | 2 | 15 | 109 | 641 | 58 | 236 | 77 | 55 | 6 | 8 | 7 | 0 | 0 | 6 | 14 | 2 | 5 | 1 | 2 | 0 | 42 | 3 | 0 | 6 | 0 | 2 | 27 | 18 | 0 | 1 | 0 | 4 | 0 | 0 | 0 | 0 | 1 | 0 | 3 | 0 | 0 | 0 | 1 | 1 | 0 | 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 );