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

8 rows where P0020046 = 1

View and edit SQL

Suggested facets: P0010021, P0010028, P0010029, P0010030, P0010031, P0010032, P0010033, P0010034, P0010035, P0010036, P0010037, P0010038, P0010040, P0010042, P0010043, P0010044, P0010045, P0010046, P0010048, P0010049, P0010050, P0010051, P0010052, P0010053, P0010055, P0010056, P0010057, P0010058, P0010059, P0010060, P0010061, P0010062, P0010063, P0010064, P0010065, P0010070, P0010071, P0020016, P0020018, P0020023, P0020025, P0020028, P0020030, P0020031, P0020032, P0020033, P0020035, P0020036, P0020038, P0020039, P0020040, P0020041, P0020042, P0020043, P0020044, P0020045, P0020047, P0020048, P0020050, P0020051, P0020052, P0020053, P0020054, P0020055, P0020059, P0020060, P0020061, P0020062, P0020063, P0020065, P0020066, P0020067, P0020072, P0020073

P0020046

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
2 5 52568 51415 13436 2784 81 32795 18 2301 1153 1083 161 49 432 9 152 22 38 1 43 63 4 8 31 59 11 58 19 6 0 11 4 0 1 3 2 1 1 0 2 0 2 0 3 1 1 1 11 4 0 5 0 0 0 0 0 0 0 2 0 0 0 0 1 1 0 0 0 0 0 0 0 52568 5910 46658 45884 10739 2299 33 32708 13 92 774 742 89 37 412 7 17 18 33 1 3 60 2 0 30 33 0 27 9 6 0 0 4 0 0 2 1 0 1 0 0 0 0 0 3 1 0 0 4 2 0 0 0 0 0 0 0 0 0 2 0 0 0 0 1 1 0 0 0 0 0 0 0
22 34 113062 104866 47323 12314 1462 2911 65 40791 8196 7416 1379 200 456 30 2817 122 72 26 1292 41 13 423 8 244 293 717 222 55 4 185 11 3 36 9 31 31 8 0 17 1 6 26 0 52 17 3 55 19 0 21 0 2 3 0 1 1 0 0 4 2 0 2 7 7 0 0 0 0 0 1 1 113062 77808 35254 34101 25547 5335 115 2685 15 404 1153 1029 280 73 386 12 62 58 61 8 24 13 0 3 5 40 4 107 50 18 0 6 6 0 1 7 6 0 3 0 5 1 1 1 0 1 0 1 17 10 0 4 0 2 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0
30 47 152374 147258 21739 105538 1241 2982 89 15669 5116 4639 898 73 128 15 768 446 400 175 1001 70 9 116 25 342 173 441 172 36 1 64 4 0 3 1 18 7 18 4 29 8 36 21 0 6 10 3 32 13 0 6 4 1 0 0 0 0 0 0 3 4 1 0 2 2 0 0 0 0 0 2 2 152374 34919 117455 114957 10871 99102 587 2872 50 1475 2498 2266 456 28 111 4 44 333 373 164 338 55 3 17 19 266 55 216 90 21 1 24 0 0 0 0 5 1 7 2 10 6 30 14 0 1 1 3 14 7 0 1 4 0 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 2 2
32 49 114712 109631 50305 28570 997 8838 75 20846 5081 4668 834 136 361 24 1562 239 171 87 638 49 9 181 19 276 82 382 160 19 2 96 1 0 8 8 10 22 2 3 8 9 8 15 0 4 5 2 30 12 1 8 0 1 0 0 0 0 1 2 0 4 1 0 0 0 0 0 0 0 0 1 1 114712 48721 65991 64397 31212 23367 265 8697 34 822 1594 1487 277 42 314 14 115 139 148 82 86 36 1 10 19 189 15 94 52 8 2 7 1 0 1 2 2 0 1 2 0 5 4 3 0 1 1 2 13 6 0 0 0 0 0 0 0 0 1 2 0 3 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
46 73 86468 83795 5148 70679 675 633 35 6625 2673 2466 438 25 42 11 456 376 137 111 657 21 9 83 10 33 57 185 64 10 0 19 4 2 3 0 0 5 6 3 25 5 7 19 0 10 3 0 12 3 1 1 0 0 2 0 0 0 0 0 0 2 0 3 8 8 0 0 0 0 0 2 2 86468 17369 69099 67975 858 65930 287 604 16 280 1124 1032 224 12 27 4 13 299 123 100 177 12 8 9 9 13 2 82 43 5 0 3 1 0 0 0 0 0 6 3 7 3 7 2 0 1 1 0 5 3 1 1 0 0 0 0 0 0 0 0 0 0 0 0 5 5 0 0 0 0 0 0 0
67 109 247354 240457 95236 6596 555 122496 106 15468 6897 6559 513 143 2131 35 1780 77 189 16 246 305 0 110 152 781 81 279 82 36 1 44 7 0 23 12 30 8 4 3 3 1 9 7 2 6 0 1 53 25 0 8 0 11 0 0 0 0 4 0 0 0 5 0 4 4 0 0 0 0 0 2 2 247354 41164 206190 202136 73668 5512 215 122012 82 647 4054 3900 273 61 2030 31 120 58 181 10 64 298 0 2 147 619 6 120 38 25 0 1 6 0 0 11 18 0 4 2 0 1 6 4 2 1 0 1 30 20 0 1 0 3 0 0 0 0 1 0 0 0 5 0 4 4 0 0 0 0 0 0 0
76 122 138982 136452 119790 3397 330 8474 43 4418 2530 2358 469 166 658 29 649 52 52 9 85 32 0 18 23 99 17 154 52 8 0 17 17 0 3 10 29 5 4 1 0 1 4 0 0 3 0 0 17 10 1 3 0 2 1 0 0 0 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 138982 15903 123079 121540 109879 2863 168 8370 32 228 1539 1434 361 135 583 25 89 42 39 9 19 29 0 5 22 75 1 96 32 5 0 7 16 0 0 10 15 0 4 1 0 1 4 0 0 1 0 0 8 4 0 1 0 2 1 0 0 0 0 0 0 0 0 0 1 0 1 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 201.053ms · Data license: CC BY-SA 4.0 · Data source: US Census & NYC Open Data Portal, combined by John Keefe