dc_2010blocks_2020policedistricts_population

2010 DC population by US Census block, with each block linked to the police district and public service area in which it sits. For details and column descriptions see this blog post.

Data license: CC BY-SA 4.0 · Data source: US Census & DC Open Data Portal, combined by John Keefe

19 rows where P005017 = 9 sorted by P005001

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003004, P003005, P003006, P003007, P003008, P005005, P005006, P005007, P005008, P005009, P005011, P005012, P005014, P005015, P005016, DISTRICT, PSA, NAME, POLDIST_ID, GIS_ID, SECTOR

P005013 ✖

P005017 ✖

Link rowid GEO_ID NAME_x P003001 P003002 P003003 P003004 P003005 P003006 P003007 P003008 P005001 ▼ P005002 P005003 P005004 P005005 P005006 P005007 P005008 P005009 P005010 P005011 P005012 P005013 P005014 P005015 P005016 P005017 GEOID10 DISTRICT PSA NAME POLDIST_ID GIS_ID SECTOR
1097 1097 1000000US110010071002013 Block 2013, Block Group 2, Census Tract 71, District of Columbia, District of Columbia 109 50 45 0 3 0 0 11 109 92 42 45 0 3 0 0 2 17 8 0 0 0 0 0 9 110010071002013 1 106 106 1 psa_13 1D3
1011 1011 1000000US110010017022016 Block 2016, Block Group 2, Census Tract 17.02, District of Columbia, District of Columbia 113 8 95 0 0 0 0 10 113 103 7 95 0 0 0 0 1 10 1 0 0 0 0 0 9 110010017022016 4 406 406 4 psa_54 4D2
595 595 1000000US110010027021006 Block 1006, Block Group 1, Census Tract 27.02, District of Columbia, District of Columbia 118 83 4 3 6 0 13 9 118 86 73 4 3 6 0 0 0 32 10 0 0 0 0 13 9 110010027021006 3 302 302 3 psa_42 3D1
1398 1398 1000000US110010018043003 Block 3003, Block Group 3, Census Tract 18.04, District of Columbia, District of Columbia 167 5 115 0 0 0 38 9 167 115 0 115 0 0 0 0 0 52 5 0 0 0 0 38 9 110010018043003 4 402 402 4 psa_53 4D1
1905 1905 1000000US110010088024001 Block 4001, Block Group 4, Census Tract 88.02, District of Columbia, District of Columbia 168 7 145 2 4 0 0 10 168 147 3 138 1 4 0 0 1 21 4 7 1 0 0 0 9 110010088024001 5 506 506 5 psa_26 5D3
2498 2498 1000000US110010019011004 Block 1004, Block Group 1, Census Tract 19.01, District of Columbia, District of Columbia 225 9 164 0 1 2 36 13 225 172 5 160 0 1 2 0 4 53 4 4 0 0 0 36 9 110010019011004 4 402 402 4 psa_53 4D1
1880 1880 1000000US110010031001010 Block 1010, Block Group 1, Census Tract 31, District of Columbia, District of Columbia 233 124 55 0 5 0 38 11 233 140 80 53 0 5 0 0 2 93 44 2 0 0 0 38 9 110010031001010 3 302 302 3 psa_42 3D1
1945 1945 1000000US110010028011001 Block 1001, Block Group 1, Census Tract 28.01, District of Columbia, District of Columbia 234 62 104 4 6 0 47 11 234 164 52 98 4 6 0 2 2 70 10 6 0 0 0 45 9 110010028011001 4 408 408 4 psa_39 4D3
2227 2227 1000000US110010028022002 Block 2002, Block Group 2, Census Tract 28.02, District of Columbia, District of Columbia 303 122 123 0 15 1 15 27 303 243 91 119 0 15 0 0 18 60 31 4 0 0 1 15 9 110010028022002 3 302 302 3 psa_42 3D1
1598 1598 1000000US110010037003001 Block 3001, Block Group 3, Census Tract 37, District of Columbia, District of Columbia 403 109 114 0 14 0 152 14 403 178 47 110 0 11 0 5 5 225 62 4 0 3 0 147 9 110010037003001 3 304 304 3 psa_36 3D1
2920 2920 1000000US110010036003003 Block 3003, Block Group 3, Census Tract 36, District of Columbia, District of Columbia 458 279 117 0 34 0 9 19 458 413 255 114 0 34 0 0 10 45 24 3 0 0 0 9 9 110010036003003 3 304 304 3 psa_36 3D1
3698 3698 1000000US110010006001003 Block 1003, Block Group 1, Census Tract 6, District of Columbia, District of Columbia 476 399 17 0 19 1 18 22 476 403 355 14 0 19 1 1 13 73 44 3 0 0 0 17 9 110010006001003 2 203 203 2 psa_50 2D1
449 449 1000000US110010037003002 Block 3002, Block Group 3, Census Tract 37, District of Columbia, District of Columbia 518 237 134 8 31 0 86 22 518 321 163 112 2 31 0 0 13 197 74 22 6 0 0 86 9 110010037003002 3 304 304 3 psa_36 3D1
4854 4854 1000000US110010028021001 Block 1001, Block Group 1, Census Tract 28.02, District of Columbia, District of Columbia 529 261 87 6 43 0 116 16 529 279 147 82 0 42 0 1 7 250 114 5 6 1 0 115 9 110010028021001 3 302 302 3 psa_42 3D1
5143 5143 1000000US110010028022000 Block 2000, Block Group 2, Census Tract 28.02, District of Columbia, District of Columbia 568 273 135 6 22 0 112 20 568 387 216 134 3 22 0 1 11 181 57 1 3 0 0 111 9 110010028022000 4 408 408 4 psa_39 4D3
35 35 1000000US110010050021001 Block 1001, Block Group 1, Census Tract 50.02, District of Columbia, District of Columbia 658 425 64 3 49 0 95 22 658 510 380 64 3 49 0 1 13 148 45 0 0 0 0 94 9 110010050021001 3 307 307 3 psa_28 3D3
5900 5900 1000000US110010101002001 Block 2001, Block Group 2, Census Tract 101, District of Columbia, District of Columbia 676 312 79 2 217 0 39 27 676 569 248 76 2 216 0 9 18 107 64 3 0 1 0 30 9 110010101002001 2 208 208 2 psa_33 2D3
6007 6007 1000000US110010108002009 Block 2009, Block Group 2, Census Tract 108.00, District of Columbia, District of Columbia 765 508 52 0 167 0 11 27 765 711 471 52 0 167 0 3 18 54 37 0 0 0 0 8 9 110010108002009 2 207 207 2 psa_24 2D3
4621 4621 1000000US110010023021018 Block 1018, Block Group 1, Census Tract 23.02, District of Columbia, District of Columbia 882 217 577 0 46 0 10 32 882 833 192 570 0 46 0 2 23 49 25 7 0 0 0 8 9 110010023021018 4 405 405 4 psa_49 4D2

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "dc_2010blocks_2020policedistricts_population" (
"GEO_ID" TEXT,
  "NAME_x" TEXT,
  "P003001" INTEGER,
  "P003002" INTEGER,
  "P003003" INTEGER,
  "P003004" INTEGER,
  "P003005" INTEGER,
  "P003006" INTEGER,
  "P003007" INTEGER,
  "P003008" INTEGER,
  "P005001" INTEGER,
  "P005002" INTEGER,
  "P005003" INTEGER,
  "P005004" INTEGER,
  "P005005" INTEGER,
  "P005006" INTEGER,
  "P005007" INTEGER,
  "P005008" INTEGER,
  "P005009" INTEGER,
  "P005010" INTEGER,
  "P005011" INTEGER,
  "P005012" INTEGER,
  "P005013" INTEGER,
  "P005014" INTEGER,
  "P005015" INTEGER,
  "P005016" INTEGER,
  "P005017" INTEGER,
  "GEOID10" INTEGER,
  "DISTRICT" INTEGER,
  "PSA" INTEGER,
  "NAME" INTEGER,
  "POLDIST_ID" INTEGER,
  "GIS_ID" TEXT,
  "SECTOR" TEXT
);