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

9 rows where P0020035 = 1 and P0020042 = 0 sorted by P0010031

View and edit SQL

Suggested facets: P0010014, P0010018, P0010020, P0010021, P0010022, P0010023, P0010025, P0010028, P0010029, P0010031, P0010032, P0010033, P0010034, P0010035, P0010036, P0010037, P0010038, P0010039, P0010040, P0010041, P0010042, P0010043, P0010044, P0010045, P0010046, P0010048, P0010049, P0010050, P0010051, P0010052, P0010053, P0010054, P0010055, P0010056, P0010057, P0010059, P0010062, P0010063, P0010064, P0010065, P0010067, P0010068, P0010070, P0010071, P0020009, P0020017, P0020020, P0020022, P0020024, P0020027, P0020030, P0020031, P0020032, P0020033, P0020034, P0020036, P0020037, P0020038, P0020039, P0020040, P0020041, P0020043, P0020044, P0020047, P0020048, P0020049, P0020050, P0020051, P0020052, P0020053, P0020054, P0020056, P0020057, P0020059, P0020065, P0020066, P0020067, P0020069, P0020072, P0020073

P0020023

P0020042

P0020035

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
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
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
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
10 18 54066 52216 37624 3106 168 8462 27 2829 1850 1721 262 98 570 14 407 32 61 5 95 21 0 24 25 98 9 121 59 4 0 17 9 0 2 13 12 2 2 0 1 0 0 0 0 0 0 0 7 2 1 2 0 0 0 0 1 0 0 0 1 0 0 0 1 1 0 0 0 0 0 0 0 54066 8883 45183 44019 32682 2637 68 8389 25 218 1164 1088 179 60 537 13 65 25 60 5 30 20 0 1 24 68 1 73 40 2 0 2 6 0 1 12 8 0 2 0 0 0 0 0 0 0 0 0 3 1 0 2 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
5 9 76443 73259 48175 6904 361 10946 45 6828 3184 2877 534 155 912 31 590 123 63 6 199 25 5 73 31 88 42 275 139 28 2 24 11 0 5 17 13 8 6 6 6 0 5 1 0 0 4 0 28 16 4 4 1 1 0 0 2 0 0 0 0 0 0 0 3 2 1 0 0 0 0 1 1 76443 18291 58152 56307 39560 5466 127 10831 28 295 1845 1693 370 112 858 24 62 81 51 5 25 23 0 2 30 49 1 136 74 22 1 4 9 0 1 14 4 0 5 1 0 0 1 0 0 0 0 0 14 12 0 1 0 0 0 0 1 0 0 0 0 0 0 0 2 1 1 0 0 0 0 0 0
3 6 62226 60490 53227 1316 80 5023 21 823 1736 1596 286 121 883 13 120 23 41 1 29 7 0 6 27 37 2 119 53 10 0 10 14 0 2 12 12 1 1 0 2 0 1 1 0 0 0 0 18 14 0 3 0 0 0 1 0 0 0 0 0 0 0 0 3 3 0 0 0 0 0 0 0 62226 3781 58445 56956 50468 1214 47 4983 20 224 1489 1384 244 92 863 8 45 20 35 1 9 7 0 0 27 32 1 90 41 8 0 5 12 0 1 12 8 1 1 0 0 0 1 0 0 0 0 0 13 11 0 1 0 0 0 1 0 0 0 0 0 0 0 0 2 2 0 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
7 13 93640 90828 70786 4864 194 12883 39 2062 2812 2562 429 108 1268 21 295 71 64 6 82 24 0 21 34 127 12 223 104 32 2 9 16 2 7 14 17 4 1 0 2 0 6 1 0 0 0 6 24 11 1 8 1 0 0 1 0 0 2 0 0 0 0 0 2 2 0 0 0 0 0 1 1 93640 8565 85075 82936 65354 4369 100 12785 31 297 2139 1975 287 84 1208 19 69 59 59 6 26 20 0 1 33 99 5 151 75 22 2 3 13 2 1 13 10 0 1 0 0 0 3 0 0 0 0 6 12 9 0 0 1 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 1 1

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
);