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

7 rows where P0020046 = 2

View and edit SQL

Suggested facets: P0010018, P0010021, P0010023, P0010029, P0010031, P0010032, P0010033, P0010034, P0010035, P0010036, P0010037, P0010038, P0010040, P0010042, P0010043, P0010044, P0010045, P0010046, P0010048, P0010049, P0010051, P0010052, P0010053, P0010054, P0010056, P0010057, P0010058, P0010059, P0010060, P0010061, P0010062, P0010063, P0010064, P0010065, P0010066, P0020009, P0020016, P0020023, P0020024, P0020025, P0020026, P0020031, P0020032, P0020033, P0020034, P0020035, P0020036, P0020038, P0020039, P0020040, P0020041, P0020042, P0020044, P0020045, P0020047, P0020048, P0020049, P0020050, P0020052, P0020053, P0020054, P0020056, P0020060, P0020063, P0020064, P0020065, P0020066, P0020067

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
17 26 49508 47048 23703 11610 326 6220 29 5160 2460 2229 485 108 661 11 356 98 70 9 228 10 3 61 21 76 32 213 97 26 1 36 10 1 2 5 8 0 4 2 8 0 4 2 0 3 4 0 15 7 0 3 1 1 0 1 0 0 0 1 1 0 0 0 3 3 0 0 0 0 0 0 0 49508 12277 37231 35842 19207 10158 113 6163 23 178 1389 1266 277 64 629 7 34 82 68 5 30 6 1 2 20 41 0 114 62 22 1 5 6 0 0 5 6 0 1 2 0 0 2 0 0 2 0 0 9 4 0 3 1 0 0 1 0 0 0 0 0 0 0 0 0 0 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
45 72 126230 120736 52711 5849 1573 33565 62 26976 5494 5080 710 508 770 34 1869 63 151 12 347 67 11 214 44 201 79 372 125 23 1 64 18 0 39 6 30 26 3 0 3 0 14 2 1 8 8 1 37 16 7 4 0 2 1 0 0 2 2 0 0 0 0 3 5 3 1 1 0 0 0 0 0 126230 57375 68855 67085 29464 3688 178 33288 33 434 1770 1643 316 88 723 24 51 42 143 12 52 53 1 3 40 94 1 109 49 12 0 3 7 0 0 5 15 1 1 0 0 0 11 2 1 2 0 0 17 16 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0
58 100 47913 46726 29895 12694 165 1347 17 2608 1187 1058 248 65 106 6 197 104 65 19 139 14 3 13 3 55 21 116 46 12 1 14 2 0 3 1 3 2 4 2 9 7 0 5 0 3 2 0 10 4 0 5 0 1 0 0 0 0 0 0 0 0 0 0 3 3 0 0 0 0 0 0 0 47913 7161 40752 40067 26793 11609 94 1320 14 237 685 623 170 50 92 5 22 77 56 19 71 10 0 3 3 41 4 53 14 4 1 3 2 0 0 1 3 0 3 2 4 7 0 5 0 2 2 0 6 4 0 2 0 0 0 0 0 0 0 0 0 0 0 0 3 3 0 0 0 0 0 0 0
59 101 67065 64391 19193 35263 533 1278 66 8058 2674 2485 371 37 102 9 654 262 135 64 505 35 4 74 3 135 95 178 74 9 2 35 1 0 7 3 4 3 12 0 5 2 7 8 0 3 2 1 9 6 0 0 0 0 1 0 0 0 0 1 0 1 0 0 2 2 0 0 0 0 0 0 0 67065 16941 50124 48859 13666 33054 215 1235 49 640 1265 1162 235 21 88 6 29 228 124 62 205 31 1 4 3 105 20 99 42 7 2 6 1 0 2 3 1 2 12 0 3 2 5 8 0 2 0 1 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2 0 0 0 0 0 0 0
69 111 116431 114018 61915 2633 101 45921 18 3430 2413 2270 271 84 819 18 576 16 88 4 41 70 2 16 63 189 13 131 32 35 0 13 4 0 0 14 15 0 1 0 1 3 10 1 0 2 0 0 11 4 0 7 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 116431 11676 104755 103197 54690 2400 62 45763 14 268 1558 1485 157 61 761 17 104 13 79 4 9 68 2 0 63 145 2 70 13 21 0 0 1 0 0 12 7 0 1 0 0 3 9 1 0 2 0 0 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0
71 113 120132 116234 3036 104953 696 2615 55 4879 3898 3477 570 39 23 2 188 637 513 214 823 40 13 67 22 243 83 387 166 64 1 24 1 0 3 0 4 5 18 0 19 7 45 12 0 5 3 10 25 13 0 8 0 0 0 0 0 0 0 0 0 0 2 2 9 8 1 0 0 0 0 0 0 120132 9783 110349 107371 1057 101721 511 2577 42 1463 2978 2660 434 27 21 2 9 578 498 207 493 34 13 35 21 227 61 294 127 57 1 8 1 0 0 0 2 0 17 0 12 6 38 11 0 2 3 9 15 6 0 5 0 0 0 0 0 0 0 0 0 0 2 2 9 8 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 560.352ms · Data license: CC BY-SA 4.0 · Data source: US Census & NYC Open Data Portal, combined by John Keefe