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 P0020048 = 0 and P0020072 = 1
This data as json, CSV (advanced)
Suggested facets: P0010021, P0010029, P0010032, P0010033, P0010034, P0010035, P0010036, P0010037, P0010038, P0010039, P0010040, P0010042, P0010043, P0010044, P0010045, P0010046, P0010047, P0010049, P0010050, P0010051, P0010052, P0010054, P0010058, P0010061, P0010064, P0010066, P0010070, P0010071, P0020017, P0020023, P0020031, P0020035, P0020038, P0020040, P0020041, P0020044, P0020045, P0020046, P0020050, P0020052, P0020053, P0020054, P0020056, P0020060, P0020063, P0020065, P0020066
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 37 | 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 |
| 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 |
| 40 | 40 | 67 | 155252 | 151852 | 3902 | 142116 | 519 | 1777 | 59 | 3479 | 3400 | 3087 | 496 | 11 | 72 | 1 | 127 | 373 | 454 | 277 | 1109 | 24 | 2 | 34 | 3 | 74 | 30 | 277 | 102 | 53 | 5 | 31 | 0 | 0 | 2 | 3 | 2 | 0 | 19 | 1 | 8 | 17 | 18 | 15 | 0 | 1 | 0 | 0 | 29 | 20 | 0 | 3 | 0 | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 155252 | 10536 | 144716 | 142238 | 2204 | 137243 | 405 | 1734 | 52 | 600 | 2478 | 2243 | 380 | 5 | 70 | 1 | 10 | 336 | 414 | 266 | 665 | 18 | 2 | 9 | 2 | 46 | 19 | 211 | 79 | 38 | 3 | 18 | 0 | 0 | 1 | 3 | 2 | 0 | 19 | 1 | 7 | 16 | 13 | 11 | 0 | 0 | 0 | 0 | 17 | 14 | 0 | 0 | 0 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 1 | 1 |
| 42 | 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 |
| 57 | 57 | 94 | 56247 | 54566 | 45462 | 2037 | 188 | 3293 | 36 | 3550 | 1681 | 1569 | 224 | 126 | 537 | 18 | 422 | 12 | 41 | 4 | 69 | 7 | 0 | 15 | 15 | 55 | 24 | 103 | 43 | 7 | 0 | 11 | 12 | 0 | 2 | 4 | 12 | 5 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 4 | 0 | 0 | 3 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 56247 | 9088 | 47159 | 46152 | 40844 | 1688 | 84 | 3255 | 26 | 255 | 1007 | 954 | 154 | 91 | 503 | 18 | 50 | 11 | 35 | 3 | 14 | 5 | 0 | 2 | 15 | 40 | 13 | 50 | 25 | 5 | 0 | 3 | 7 | 0 | 0 | 4 | 5 | 0 | 1 | 0 | 0 | 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 | 1 | 1 |
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 );