nyc_2010pop_2020precincts
Data license: CC BY-SA 4.0 · Data source: US Census & NYC Open Data Portal, combined by John Keefe
5 rows where P0020023 = 0 and P0020054 = 2
This data as json, CSV (advanced)
Suggested facets: P0010021, P0010029, P0010032, P0010033, P0010034, P0010038, P0010039, P0010040, P0010043, P0010046, P0010047, P0010049, P0010050, P0010051, P0010052, P0010053, P0010054, P0010055, P0010056, P0010057, P0010058, P0010059, P0010060, P0010062, P0010063, P0010064, P0010065, P0010070, P0010071, P0020018, P0020024, P0020030, P0020031, P0020032, P0020033, P0020035, P0020036, P0020038, P0020040, P0020041, P0020042, P0020043, P0020044, P0020045, P0020046, P0020048, P0020049, P0020052, P0020053, P0020055, P0020056, P0020059, P0020060, P0020061, P0020065, P0020066, P0020067
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22 | 22 | 34 | 113062 | 104866 | 47323 | 12314 | 1462 | 2911 | 65 | 40791 | 8196 | 7416 | 1379 | 200 | 456 | 30 | 2817 | 122 | 72 | 26 | 1292 | 41 | 13 | 423 | 8 | 244 | 293 | 717 | 222 | 55 | 4 | 185 | 11 | 3 | 36 | 9 | 31 | 31 | 8 | 0 | 17 | 1 | 6 | 26 | 0 | 52 | 17 | 3 | 55 | 19 | 0 | 21 | 0 | 2 | 3 | 0 | 1 | 1 | 0 | 0 | 4 | 2 | 0 | 2 | 7 | 7 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 113062 | 77808 | 35254 | 34101 | 25547 | 5335 | 115 | 2685 | 15 | 404 | 1153 | 1029 | 280 | 73 | 386 | 12 | 62 | 58 | 61 | 8 | 24 | 13 | 0 | 3 | 5 | 40 | 4 | 107 | 50 | 18 | 0 | 6 | 6 | 0 | 1 | 7 | 6 | 0 | 3 | 0 | 5 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 17 | 10 | 0 | 4 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
53 | 53 | 83 | 112634 | 106366 | 34183 | 28095 | 1522 | 4953 | 135 | 37478 | 6268 | 5892 | 820 | 141 | 215 | 37 | 2618 | 175 | 127 | 71 | 872 | 59 | 26 | 325 | 25 | 192 | 189 | 359 | 91 | 17 | 4 | 68 | 4 | 0 | 33 | 7 | 20 | 28 | 11 | 0 | 9 | 5 | 17 | 16 | 1 | 16 | 5 | 7 | 17 | 7 | 0 | 5 | 0 | 2 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 112634 | 73616 | 39018 | 37849 | 9564 | 22688 | 201 | 4776 | 31 | 589 | 1169 | 1071 | 235 | 34 | 170 | 14 | 55 | 115 | 103 | 52 | 129 | 32 | 0 | 10 | 19 | 92 | 11 | 88 | 27 | 11 | 2 | 3 | 2 | 0 | 0 | 7 | 5 | 0 | 9 | 0 | 1 | 5 | 8 | 3 | 0 | 4 | 0 | 1 | 10 | 5 | 0 | 1 | 0 | 2 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
70 | 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 |
73 | 73 | 115 | 171576 | 162076 | 66142 | 13700 | 1914 | 27250 | 85 | 52985 | 9500 | 9029 | 818 | 243 | 671 | 35 | 4821 | 113 | 166 | 77 | 515 | 260 | 17 | 438 | 66 | 660 | 129 | 421 | 113 | 33 | 1 | 74 | 16 | 0 | 36 | 7 | 48 | 29 | 9 | 1 | 4 | 0 | 15 | 11 | 1 | 7 | 13 | 3 | 44 | 25 | 5 | 3 | 0 | 8 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 6 | 2 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 171576 | 110108 | 61468 | 59259 | 20334 | 10683 | 243 | 26996 | 30 | 973 | 2209 | 2068 | 194 | 25 | 562 | 23 | 133 | 96 | 149 | 60 | 75 | 229 | 0 | 6 | 65 | 442 | 9 | 113 | 33 | 27 | 1 | 7 | 5 | 0 | 0 | 3 | 7 | 1 | 6 | 1 | 2 | 0 | 12 | 1 | 1 | 3 | 0 | 3 | 23 | 19 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 5 | 1 | 4 | 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 );