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

14 rows where P0020041 = 1

View and edit SQL

Suggested facets: P0010014, P0010015, P0010017, P0010018, P0010020, P0010021, P0010023, P0010027, P0010028, P0010029, P0010030, P0010031, P0010032, P0010033, P0010034, 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, P0010063, P0010064, P0010065, P0010066, P0010068, P0010069, P0010070, P0010071, P0020009, P0020010, P0020013, P0020014, P0020016, P0020018, P0020019, P0020020, P0020021, P0020022, P0020023, P0020024, P0020025, P0020026, P0020027, P0020028, P0020029, P0020030, P0020031, P0020032, P0020033, P0020034, P0020035, P0020036, P0020037, P0020038, P0020039, P0020040, P0020042, P0020043, P0020044, P0020045, P0020046, P0020047, P0020048, P0020049, P0020050, P0020051, P0020052, P0020053, P0020054, P0020055, P0020056, P0020057, P0020059, P0020060, P0020063, P0020065, P0020066, P0020067, P0020072, P0020073

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
4 7 56355 54055 21520 5992 326 19328 28 6861 2300 2108 365 98 403 12 588 73 90 3 195 45 10 75 22 86 43 164 69 19 1 19 9 0 1 6 15 6 3 1 1 0 3 0 0 7 4 0 25 16 0 6 0 0 0 1 0 0 0 0 2 0 0 0 3 0 3 0 0 0 0 0 0 56355 17976 38379 37470 13479 4578 95 19192 10 116 909 819 166 46 355 6 16 56 76 2 16 35 1 1 21 21 1 72 35 14 1 1 8 0 0 4 4 0 3 0 1 0 1 0 0 0 0 0 16 14 0 1 0 0 0 1 0 0 0 0 0 0 0 0 2 0 2 0 0 0 0 0 0
12 20 102624 100080 84116 4511 183 9024 34 2212 2544 2359 337 135 1206 22 302 63 54 3 89 10 1 21 29 75 12 173 77 23 1 11 14 0 2 20 16 0 2 0 2 0 2 1 0 1 0 1 11 6 0 5 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 102624 8609 94015 92070 78880 3855 87 8958 25 265 1945 1822 258 107 1148 22 65 55 49 2 12 9 1 4 29 61 0 117 50 17 1 2 11 0 1 18 10 0 2 0 1 0 2 1 0 0 0 1 6 3 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
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
23 40 91497 86028 21270 31385 1782 646 72 30873 5469 5127 607 81 62 16 1902 423 78 25 1201 39 13 293 3 110 274 321 74 14 3 56 0 1 7 4 6 27 6 6 64 4 3 23 1 10 10 2 19 5 0 6 1 0 0 0 0 0 0 0 0 4 3 0 2 0 0 1 0 0 1 0 0 91497 64887 26610 26043 1428 23680 177 525 17 216 567 518 148 7 40 6 9 114 50 17 85 19 0 1 3 17 2 49 22 10 0 0 0 0 0 3 0 0 5 1 1 1 2 3 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
28 45 120833 116361 61310 31256 792 5668 68 17267 4472 4065 916 108 307 33 1313 241 110 28 584 68 3 101 10 145 98 367 197 18 1 50 14 0 3 2 25 9 5 1 8 2 8 13 1 5 3 2 38 24 1 7 0 3 0 0 1 0 1 0 0 0 1 0 1 1 0 0 0 0 0 1 1 120833 44175 76658 75118 41615 26967 277 5506 33 720 1540 1381 387 60 259 26 83 176 99 25 79 58 1 8 10 95 15 145 77 11 0 7 6 0 0 2 12 6 3 0 1 1 7 6 1 3 2 0 13 9 1 2 0 0 0 0 0 0 0 0 0 0 1 0 1 1 0 0 0 0 0 0 0
31 48 83266 78828 23662 28195 1377 1027 98 24469 4438 4142 698 88 101 12 1313 276 98 64 827 39 18 251 14 111 232 271 75 3 0 51 4 1 6 0 5 35 3 1 31 0 15 9 0 22 8 2 20 4 0 12 0 0 0 0 0 0 0 1 0 1 2 0 5 3 2 0 0 0 0 0 0 83266 53447 29819 29144 6219 21548 172 930 22 253 675 633 163 19 76 7 13 112 76 52 55 13 2 3 6 27 9 38 20 2 0 2 0 1 0 0 0 0 2 0 1 0 7 1 0 2 0 0 4 2 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0
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
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
49 77 90744 87649 15454 65502 388 2368 45 3892 3095 2796 711 63 359 7 217 352 193 98 647 11 2 41 13 50 32 254 131 29 4 16 9 0 1 5 8 0 12 1 8 3 13 10 1 1 1 1 40 22 1 11 0 3 1 0 1 0 0 0 1 0 0 0 1 1 0 0 0 0 0 4 4 90744 10759 79985 77899 13017 61952 203 2338 24 365 2086 1913 562 43 343 7 21 306 179 93 309 11 1 0 12 16 10 150 80 22 4 6 8 0 0 3 3 0 7 0 1 2 9 3 1 0 0 1 22 17 1 1 0 2 1 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0
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
54 84 48196 46319 33297 6470 158 4519 21 1854 1877 1735 327 104 710 14 180 101 49 16 112 6 1 23 15 64 13 137 59 28 3 11 5 0 4 5 7 0 6 0 2 2 3 2 0 0 0 0 4 2 0 2 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 48196 6078 42118 40735 30066 5935 79 4451 15 189 1383 1293 265 62 690 11 34 85 46 11 24 4 1 2 15 43 0 88 36 21 3 5 2 0 3 5 5 0 5 0 1 1 1 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
55 88 51421 48902 18769 23376 238 3393 11 3115 2519 2236 628 72 504 16 266 234 143 21 230 8 3 24 12 65 10 261 137 48 3 16 9 2 3 8 9 0 9 1 4 0 4 7 0 0 1 0 20 17 0 2 0 1 0 0 0 0 0 0 0 0 0 0 2 1 1 0 0 0 0 0 0 51421 8093 43328 41581 15904 21986 126 3341 8 216 1747 1534 504 43 480 14 22 197 133 17 56 7 3 1 12 45 0 194 112 36 3 5 7 0 1 8 5 0 6 1 1 0 2 6 0 0 1 0 17 16 0 0 0 1 0 0 0 0 0 0 0 0 0 0 2 1 1 0 0 0 0 0 0
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
75 121 118708 114773 73769 16688 557 13217 78 10464 3935 3643 789 136 547 46 973 149 127 20 328 106 3 40 25 318 36 255 120 23 6 30 4 4 9 4 28 5 5 2 7 1 5 1 1 0 0 0 37 15 5 8 0 4 0 0 1 1 1 0 1 0 1 0 0 0 0 0 0 0 0 0 0 118708 27252 91456 89367 60934 14798 199 13050 43 343 2089 1949 570 93 479 39 97 115 113 18 56 93 1 2 24 242 7 121 62 15 6 5 2 4 2 4 9 0 5 2 1 1 2 0 1 0 0 0 19 10 3 3 0 1 0 0 1 0 0 0 0 0 1 0 0 0 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 189.847ms · Data license: CC BY-SA 4.0 · Data source: US Census & NYC Open Data Portal, combined by John Keefe