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

9 rows where P005011 = 29 sorted by P005001

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003003, P003004, P003005, P003006, P003007, P003008, P005004, P005005, P005006, P005007, P005008, P005009, P005010, P005012, P005014, P005017, DISTRICT, PSA, NAME, POLDIST_ID, GIS_ID, SECTOR

P005013 ✖

P005011 ✖

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
4133 4133 1000000US110010032004006 Block 4006, Block Group 4, Census Tract 32, District of Columbia, District of Columbia 161 48 79 0 3 0 27 4 161 102 19 77 0 3 0 0 3 59 29 2 0 0 0 27 1 110010032004006 3 306 306 3 psa_38 3D2
1105 1105 1000000US110010024001000 Block 1000, Block Group 1, Census Tract 24, District of Columbia, District of Columbia 223 68 121 0 3 0 23 8 223 169 39 121 0 3 0 0 6 54 29 0 0 0 0 23 2 110010024001000 4 407 407 4 psa_47 4D2
1838 1838 1000000US110010027023008 Block 3008, Block Group 3, Census Tract 27.02, District of Columbia, District of Columbia 259 211 25 0 9 0 3 11 259 219 182 20 0 9 0 0 8 40 29 5 0 0 0 3 3 110010027023008 3 302 302 3 psa_42 3D1
5956 5956 1000000US110010039003003 Block 3003, Block Group 3, Census Tract 39, District of Columbia, District of Columbia 301 218 32 4 12 0 18 17 301 242 189 30 2 12 0 0 9 59 29 2 2 0 0 18 8 110010039003003 3 303 303 3 psa_37 3D3
2249 2249 1000000US110010018031005 Block 1005, Block Group 1, Census Tract 18.03, District of Columbia, District of Columbia 347 41 248 1 4 7 37 9 347 274 12 246 1 4 7 0 4 73 29 2 0 0 0 37 5 110010018031005 4 402 402 4 psa_53 4D1
5938 5938 1000000US110010050022005 Block 2005, Block Group 2, Census Tract 50.02, District of Columbia, District of Columbia 397 341 13 0 20 0 3 20 397 362 312 13 0 20 0 1 16 35 29 0 0 0 0 2 4 110010050022005 3 307 307 3 psa_28 3D3
4713 4713 1000000US110010055005003 Block 5003, Block Group 5, Census Tract 55, District of Columbia, District of Columbia 420 333 18 0 44 0 6 19 420 382 304 17 0 42 0 2 17 38 29 1 0 2 0 4 2 110010055005003 2 208 208 2 psa_33 2D3
1644 1644 1000000US110010027013000 Block 3000, Block Group 3, Census Tract 27.01, District of Columbia, District of Columbia 482 372 64 3 18 0 6 19 482 441 343 61 2 18 0 1 16 41 29 3 1 0 0 5 3 110010027013000 3 302 302 3 psa_42 3D1
2218 2218 1000000US110010014011018 Block 1018, Block Group 1, Census Tract 14.01, District of Columbia, District of Columbia 548 344 79 2 87 0 20 16 548 499 315 77 0 87 0 5 15 49 29 2 2 0 0 15 1 110010014011018 2 201 201 2 psa_55 2D1

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