nyc_2010pop_2020precincts

2010 NYC population by NYC police precinct, as they were drawn in 2020. For details and column descriptions see this blog post.

Data license: CC BY-SA 4.0 · Data source: US Census & NYC Open Data Portal, combined by John Keefe

10 rows where P0020041 = 2

View and edit SQL

Suggested facets: P0010012, P0010014, P0010019, P0010021, P0010028, P0010029, P0010031, P0010032, P0010033, P0010034, P0010035, P0010036, P0010037, P0010038, P0010039, P0010040, P0010042, P0010043, P0010044, P0010046, P0010047, P0010048, P0010049, P0010050, P0010051, P0010052, P0010053, P0010054, P0010055, P0010056, P0010057, P0010058, P0010059, P0010060, P0010061, P0010062, P0010063, P0010064, P0010065, P0010066, P0010067, P0010069, P0010070, P0010071, P0020009, P0020014, P0020016, P0020023, P0020024, P0020027, P0020030, P0020031, P0020032, P0020033, P0020034, P0020035, P0020036, P0020037, P0020038, P0020039, P0020040, P0020042, P0020044, P0020045, P0020046, P0020047, P0020048, P0020050, P0020052, P0020053, P0020054, P0020055, P0020056, P0020058, P0020059, P0020060, P0020061, P0020062, P0020063, P0020065, P0020066, P0020067, P0020068, P0020069

P0020041

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
20 32 70942 68227 7498 51411 541 1282 33 7462 2715 2376 622 47 145 10 335 385 117 44 515 2 4 41 7 54 48 308 173 32 0 30 11 0 3 1 4 1 12 3 12 10 7 4 1 1 2 1 27 14 1 8 0 1 0 0 1 0 0 0 0 2 0 0 4 2 1 1 0 0 0 0 0 70942 16299 54643 53275 3823 47791 242 1217 19 183 1368 1163 398 34 132 4 14 305 98 34 114 2 3 0 5 20 0 184 119 22 0 15 3 0 0 1 1 0 7 2 2 7 4 1 0 0 0 0 18 13 0 3 0 0 0 0 0 0 0 0 0 2 0 0 3 1 1 1 0 0 0 0 0
21 33 76958 71025 22218 14215 1277 2315 62 30938 5933 5374 941 126 233 16 2034 152 68 16 996 37 19 361 12 150 213 521 149 41 2 154 4 5 19 0 23 12 5 0 21 0 6 13 2 52 11 2 30 5 0 18 0 0 1 1 0 2 0 0 2 0 0 1 8 4 3 0 1 0 0 0 0 76958 57168 19790 19009 7895 8619 113 2109 5 268 781 701 214 37 182 5 29 89 53 12 31 6 0 8 7 27 1 72 39 15 0 2 2 1 1 0 3 0 4 0 2 0 2 1 0 0 0 0 3 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 1 3 0 1 0 0 0 0
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
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
43 70 160664 156129 67162 60984 778 15281 64 11860 4535 4203 723 126 679 22 809 226 301 124 756 115 4 69 32 184 33 291 101 57 6 19 1 1 7 5 24 10 8 0 7 7 23 7 0 4 3 1 30 16 0 4 2 4 1 2 0 0 0 0 0 0 1 0 11 5 0 0 0 0 6 0 0 160664 25165 135499 132816 59590 56948 346 15147 37 748 2683 2465 470 49 648 18 127 188 284 111 297 105 1 5 31 126 5 191 67 45 6 5 1 1 0 2 20 4 6 0 2 7 19 3 0 0 2 1 22 12 0 2 2 3 0 2 0 0 0 0 0 0 1 0 5 5 0 0 0 0 0 0 0
64 106 122441 110973 43894 22601 1653 22456 182 20187 11468 10708 454 114 352 10 1197 177 2700 308 1437 423 31 247 124 2777 357 702 82 48 5 37 3 0 8 6 30 9 29 4 6 30 231 54 8 45 36 31 55 29 0 4 0 1 0 0 0 2 0 2 7 3 5 2 3 3 0 0 0 0 0 0 0 122441 28309 94132 84898 31739 20990 1156 22203 160 8650 9234 8622 224 51 320 9 88 150 2647 307 1168 402 27 145 124 2631 329 563 34 37 4 16 3 0 0 5 23 0 28 4 2 30 220 53 8 37 28 31 46 26 0 1 0 0 0 0 0 2 0 2 7 3 5 0 3 3 0 0 0 0 0 0 0
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
72 114 202766 195116 116720 23533 1176 29341 168 24178 7650 7157 1118 317 1396 81 2314 204 199 40 509 221 3 142 78 461 74 430 158 40 4 65 12 3 26 19 28 10 7 4 6 3 18 3 4 9 9 2 60 34 0 9 1 12 0 2 0 0 0 1 0 1 0 0 3 3 0 0 0 0 0 0 0 202766 54441 148325 144175 91531 21019 354 28947 133 2191 4150 3911 727 173 1286 74 448 151 177 35 184 204 3 18 74 343 14 218 87 22 4 16 9 2 0 18 15 6 7 4 2 3 10 1 2 5 3 2 19 12 0 2 0 3 0 2 0 0 0 0 0 0 0 0 2 2 0 0 0 0 0 0 0
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
74 120 113008 108593 58854 28373 686 8922 59 11699 4415 4030 1043 183 479 34 936 311 162 23 522 53 4 89 18 135 38 343 179 23 3 35 7 3 6 5 22 11 11 1 5 7 13 2 0 1 8 1 35 24 0 3 0 5 2 1 0 0 0 0 0 0 0 0 6 4 0 0 0 0 2 1 1 113008 29914 83094 80887 46061 25436 264 8756 37 333 2207 1993 739 105 415 27 66 238 142 18 91 47 2 6 18 79 0 190 117 15 1 6 6 3 1 4 8 0 11 0 2 7 9 0 0 0 0 0 20 15 0 1 0 2 2 0 0 0 0 0 0 0 0 0 4 4 0 0 0 0 0 0 0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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
);
Powered by Datasette · Query took 424.396ms · Data license: CC BY-SA 4.0 · Data source: US Census & NYC Open Data Portal, combined by John Keefe