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 P0020031 = 1 and P0020052 = 0 sorted by P0020006

View and edit SQL

Suggested facets: P0010014, P0010021, P0010029, P0010032, P0010034, P0010035, P0010036, P0010037, P0010038, P0010039, P0010040, P0010042, P0010043, P0010044, P0010045, P0010046, P0010048, P0010049, P0010050, P0010051, P0010052, P0010053, P0010054, P0010055, P0010056, P0010057, P0010058, P0010059, P0010060, P0010061, P0010062, P0010063, P0010064, P0010065, P0010067, P0010070, P0010071, P0020009, P0020014, P0020016, P0020020, P0020023, P0020024, P0020027, P0020030, P0020032, P0020033, P0020034, P0020036, P0020037, P0020038, P0020039, P0020040, P0020041, P0020042, P0020044, P0020045, P0020046, P0020047, P0020048, P0020049, P0020050, P0020051, P0020053, P0020054, P0020055, P0020056, P0020060, P0020061, P0020063, P0020065, P0020066, P0020067, P0020069, P0020072, P0020073

P0020035

P0020052

P0020031

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
77 123 98032 96794 89264 1399 122 4551 33 1425 1238 1170 268 87 332 25 328 11 7 1 18 8 5 4 4 68 4 67 29 12 1 5 1 0 2 1 12 0 0 0 0 0 2 2 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 98032 7982 90050 89245 83295 1216 64 4521 25 124 805 768 218 70 319 23 57 8 6 0 4 8 5 1 3 46 0 37 15 7 1 3 1 0 2 1 3 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 0 0 0 0 0 0
8 14 20651 20019 12868 1481 56 4964 13 637 632 586 91 31 196 13 92 29 16 0 34 18 0 10 19 31 6 42 26 1 1 4 4 0 0 2 2 0 1 0 1 0 0 0 0 0 0 0 4 0 0 3 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20651 2198 18453 18005 11605 1353 34 4933 11 69 448 414 45 25 188 11 34 25 14 0 7 18 0 1 16 27 3 33 19 1 1 3 4 0 0 2 2 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
41 68 124491 121140 85271 2288 329 25884 39 7329 3351 3196 527 168 1170 60 761 33 79 7 105 35 0 38 20 183 10 135 59 21 2 14 6 2 9 7 11 0 0 1 1 0 1 0 1 0 0 0 19 8 0 5 0 4 0 0 1 0 0 1 0 0 0 0 1 0 0 0 1 0 0 0 0 124491 17868 106623 104486 76537 1757 97 25743 23 329 2137 2071 347 109 1110 57 118 27 73 4 36 35 0 1 19 133 2 59 18 15 1 3 4 2 0 6 7 0 0 1 0 0 1 0 1 0 0 0 6 5 0 0 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 1 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
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
15 24 106460 102158 72133 14662 458 7063 55 7787 4302 3859 876 176 994 32 801 192 100 19 362 24 4 96 21 116 46 402 209 34 1 56 10 3 20 12 11 4 4 0 13 4 10 0 2 5 2 2 36 16 0 15 0 4 0 0 0 0 0 0 1 0 0 0 3 3 0 0 0 0 0 2 2 106460 22738 83722 81494 61970 11979 134 6975 30 406 2228 2026 499 100 937 20 74 139 89 17 47 22 1 5 20 54 2 188 121 24 1 5 5 1 0 12 7 1 2 0 0 4 4 0 0 0 0 1 13 11 0 0 0 2 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0
35 60 104278 101803 66276 14998 558 12372 32 7567 2475 2331 333 73 479 56 618 118 67 16 303 49 6 36 5 142 30 123 65 13 1 9 3 0 4 5 4 2 0 1 0 1 7 2 0 1 3 2 18 8 0 4 4 0 0 0 0 0 0 2 0 0 0 0 2 2 0 0 0 0 0 1 1 104278 17423 86855 85553 59405 13401 183 12294 16 254 1302 1230 178 36 461 53 111 105 66 11 40 47 1 1 5 113 2 61 34 6 1 2 2 0 1 3 4 0 0 0 0 1 3 0 0 0 2 2 10 8 0 0 0 0 0 0 0 0 0 2 0 0 0 0 1 1 0 0 0 0 0 0 0
34 52 139307 130239 37395 35034 2243 9458 117 45992 9068 8374 1395 137 270 32 2979 296 181 103 1613 166 19 500 51 358 274 638 181 45 7 138 2 14 27 0 24 42 8 3 23 11 27 31 0 30 25 0 46 15 0 19 0 3 1 0 3 1 0 1 1 1 1 0 4 4 0 0 0 0 0 6 6 139307 90981 48326 46654 10034 26171 317 9156 33 943 1672 1551 284 29 205 21 67 142 147 76 159 121 4 33 47 187 29 110 24 24 1 6 1 8 0 0 2 0 5 2 5 8 14 2 0 6 2 0 11 8 0 0 0 0 1 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0
63 105 188582 180965 33672 107918 941 27881 157 10396 7617 7046 849 130 471 9 752 480 1041 184 1063 330 5 114 71 1436 111 513 169 81 1 57 7 0 1 2 24 2 14 2 5 5 89 9 2 8 22 13 54 23 1 6 4 8 2 1 5 0 1 1 0 0 1 1 3 3 0 0 0 0 0 1 1 188582 22337 166245 160557 24611 104029 670 27688 125 3434 5688 5306 587 64 419 8 87 418 999 178 658 319 3 47 71 1360 88 352 112 65 1 20 1 0 0 2 20 0 9 2 0 5 83 9 2 7 3 11 27 16 1 0 2 5 0 1 0 0 0 1 0 0 1 0 3 3 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
);