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

15 rows where P005017 = 10 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
6010 6010 1000000US110010071002008 Block 2008, Block Group 2, Census Tract 71, District of Columbia, District of Columbia 76 33 23 0 1 0 0 19 76 62 29 23 0 1 0 0 9 14 4 0 0 0 0 0 10 110010071002008 1 106 106 1 psa_13 1D3
2799 2799 1000000US110010022012008 Block 2008, Block Group 2, Census Tract 22.01, District of Columbia, District of Columbia 140 20 67 0 0 0 42 11 140 69 6 62 0 0 0 0 1 71 14 5 0 0 0 42 10 110010022012008 4 407 407 4 psa_47 4D2
838 838 1000000US110010027022008 Block 2008, Block Group 2, Census Tract 27.02, District of Columbia, District of Columbia 166 102 10 0 12 0 31 11 166 96 74 9 0 12 0 0 1 70 28 1 0 0 0 31 10 110010027022008 3 302 302 3 psa_42 3D1
441 441 1000000US110010032003004 Block 3004, Block Group 3, Census Tract 32, District of Columbia, District of Columbia 172 39 94 0 0 0 29 10 172 114 22 91 0 0 0 1 0 58 17 3 0 0 0 28 10 110010032003004 4 409 409 4 psa_41 4D3
2932 2932 1000000US110010022021003 Block 1003, Block Group 1, Census Tract 22.02, District of Columbia, District of Columbia 177 27 114 1 1 0 22 12 177 134 18 112 1 1 0 0 2 43 9 2 0 0 0 22 10 110010022021003 4 407 407 4 psa_47 4D2
2335 2335 1000000US110010031001017 Block 1017, Block Group 1, Census Tract 31, District of Columbia, District of Columbia 203 66 108 0 12 0 0 17 203 178 51 108 0 12 0 0 7 25 15 0 0 0 0 0 10 110010031001017 3 304 304 3 psa_36 3D1
4245 4245 1000000US110010021012001 Block 2001, Block Group 2, Census Tract 21.01, District of Columbia, District of Columbia 284 42 140 2 9 0 75 16 284 172 20 134 2 9 0 1 6 112 22 6 0 0 0 74 10 110010021012001 4 403 403 4 psa_51 4D1
5203 5203 1000000US110010025021004 Block 1004, Block Group 1, Census Tract 25.02, District of Columbia, District of Columbia 286 55 162 0 6 0 49 14 286 208 40 158 0 6 0 0 4 78 15 4 0 0 0 49 10 110010025021004 4 404 404 4 psa_48 4D3
3542 3542 1000000US110010039003002 Block 3002, Block Group 3, Census Tract 39, District of Columbia, District of Columbia 423 285 87 0 14 1 19 17 423 366 259 84 0 14 0 2 7 57 26 3 0 0 1 17 10 110010039003002 3 303 303 3 psa_37 3D3
5491 5491 1000000US110010018032001 Block 2001, Block Group 2, Census Tract 18.03, District of Columbia, District of Columbia 530 56 322 0 1 0 138 13 530 341 17 318 0 1 0 2 3 189 39 4 0 0 0 136 10 110010018032001 4 402 402 4 psa_53 4D1
2844 2844 1000000US110010018043002 Block 3002, Block Group 3, Census Tract 18.04, District of Columbia, District of Columbia 554 105 293 7 6 0 129 14 554 344 33 292 4 6 0 5 4 210 72 1 3 0 0 124 10 110010018043002 4 402 402 4 psa_53 4D1
2507 2507 1000000US110010038001000 Block 1000, Block Group 1, Census Tract 38, District of Columbia, District of Columbia 680 461 109 0 34 0 41 35 680 588 421 104 0 33 0 5 25 92 40 5 0 1 0 36 10 110010038001000 3 303 303 3 psa_37 3D3
153 153 1000000US110010074061001 Block 1001, Block Group 1, Census Tract 74.06, District of Columbia, District of Columbia 731 10 700 0 0 0 5 16 731 699 7 684 0 0 0 2 6 32 3 16 0 0 0 3 10 110010074061001 7 703 703 7 psa_8 7D1
1965 1965 1000000US110010095013010 Block 3010, Block Group 3, Census Tract 95.01, District of Columbia, District of Columbia 1890 1693 44 3 73 1 21 55 1890 1750 1590 39 3 69 1 3 45 140 103 5 0 4 0 18 10 110010095013010 4 405 405 4 psa_49 4D2
336 336 1000000US110010008011000 Block 1000, Block Group 1, Census Tract 8.01, District of Columbia, District of Columbia 2303 1897 133 3 147 0 55 68 2303 2014 1672 127 2 145 0 10 58 289 225 6 1 2 0 45 10 110010008011000 2 205 205 2 psa_46 2D2

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