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

18 rows where P003004 = 2 and P005008 = 2

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003002, P003003, P003005, P003006, P003007, P003008, P005002, P005004, P005005, P005006, P005009, P005010, P005011, P005012, P005013, P005014, P005015, P005016, P005017, DISTRICT, PSA, NAME, POLDIST_ID, GIS_ID, SECTOR

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
11 11 1000000US110010043002000 Block 2000, Block Group 2, Census Tract 43, District of Columbia, District of Columbia 147 63 15 2 6 0 60 1 147 68 44 15 1 6 0 2 0 79 19 0 1 0 0 58 1 110010043002000 3 301 301 3 psa_31 3D3
31 31 1000000US110010049022007 Block 2007, Block Group 2, Census Tract 49.02, District of Columbia, District of Columbia 521 336 97 2 45 4 18 19 521 471 313 97 2 45 0 2 12 50 23 0 0 0 4 16 7 110010049022007 3 307 307 3 psa_28 3D3
44 44 1000000US110010052011001 Block 1001, Block Group 1, Census Tract 52.01, District of Columbia, District of Columbia 495 381 35 2 49 0 12 16 495 451 354 34 1 48 0 2 12 44 27 1 1 1 0 10 4 110010052011001 2 208 208 2 psa_33 2D3
47 47 1000000US110010052013001 Block 3001, Block Group 3, Census Tract 52.01, District of Columbia, District of Columbia 661 537 38 2 54 0 11 19 661 597 487 36 2 53 0 2 17 64 50 2 0 1 0 9 2 110010052013001 2 208 208 2 psa_33 2D3
409 409 1000000US110010023011017 Block 1017, Block Group 1, Census Tract 23.01, District of Columbia, District of Columbia 144 36 93 2 0 0 8 5 144 129 29 92 2 0 0 2 4 15 7 1 0 0 0 6 1 110010023011017 4 407 407 4 psa_47 4D2
688 688 1000000US110010022021008 Block 1008, Block Group 1, Census Tract 22.02, District of Columbia, District of Columbia 143 24 104 2 0 0 5 8 143 133 19 103 2 0 0 2 7 10 5 1 0 0 0 3 1 110010022021008 4 407 407 4 psa_47 4D2
1505 1505 1000000US110010008021006 Block 1006, Block Group 1, Census Tract 8.02, District of Columbia, District of Columbia 503 398 26 2 53 0 9 15 503 459 368 21 2 53 0 2 13 44 30 5 0 0 0 7 2 110010008021006 2 205 205 2 psa_46 2D2
1538 1538 1000000US110010079013003 Block 3003, Block Group 3, Census Tract 79.01, District of Columbia, District of Columbia 138 29 98 2 0 0 5 4 138 129 23 98 2 0 0 2 4 9 6 0 0 0 0 3 0 110010079013003 5 507 507 5 psa_23 5D3
2141 2141 1000000US110010020012014 Block 2014, Block Group 2, Census Tract 20.01, District of Columbia, District of Columbia 159 63 52 2 3 0 31 8 159 112 51 51 2 3 0 2 3 47 12 1 0 0 0 29 5 110010020012014 4 403 403 4 psa_51 4D1
2159 2159 1000000US110010102002038 Block 2038, Block Group 2, Census Tract 102, District of Columbia, District of Columbia 607 249 284 2 23 0 10 39 607 574 236 280 1 23 0 2 32 33 13 4 1 0 0 8 7 110010102002038 1 103 103 1 psa_12 1D1
3989 3989 1000000US110010006002007 Block 2007, Block Group 2, Census Tract 6, District of Columbia, District of Columbia 205 176 6 2 13 0 4 4 205 192 167 6 1 12 0 2 4 13 9 0 1 1 0 2 0 110010006002007 2 204 204 2 psa_44 2D2
4110 4110 1000000US110010010021000 Block 1000, Block Group 1, Census Tract 10.02, District of Columbia, District of Columbia 1255 969 74 2 165 0 11 34 1255 1156 889 69 1 165 0 2 30 99 80 5 1 0 0 9 4 110010010021000 2 204 204 2 psa_44 2D2
4478 4478 1000000US110010011002004 Block 2004, Block Group 2, Census Tract 11, District of Columbia, District of Columbia 98 67 5 2 12 0 3 9 98 82 62 5 0 12 0 2 1 16 5 0 2 0 0 1 8 110010011002004 2 202 202 2 psa_52 2D1
5157 5157 1000000US110010036001000 Block 1000, Block Group 1, Census Tract 36, District of Columbia, District of Columbia 543 262 178 2 21 0 58 22 543 434 228 172 1 21 0 2 10 109 34 6 1 0 0 56 12 110010036001000 3 304 304 3 psa_36 3D1
5502 5502 1000000US110010002021006 Block 1006, Block Group 1, Census Tract 2.02, District of Columbia, District of Columbia 126 110 5 2 2 0 3 4 126 114 103 5 0 2 0 2 2 12 7 0 2 0 0 1 2 110010002021006 2 206 206 2 psa_29 2D2
5542 5542 1000000US110010110002000 Block 2000, Block Group 2, Census Tract 110, District of Columbia, District of Columbia 832 550 219 2 36 0 7 18 832 804 532 218 2 36 0 2 14 28 18 1 0 0 0 5 4 110010110002000 1 103 103 1 psa_12 1D1
5571 5571 1000000US110010010023006 Block 3006, Block Group 3, Census Tract 10.02, District of Columbia, District of Columbia 637 550 31 2 29 0 6 19 637 596 514 31 1 29 0 2 19 41 36 0 1 0 0 4 0 110010010023006 2 204 204 2 psa_44 2D2
6087 6087 1000000US110010105001003 Block 1003, Block Group 1, Census Tract 105, District of Columbia, District of Columbia 671 223 391 2 19 0 14 22 671 628 197 390 2 18 0 2 19 43 26 1 0 1 0 12 3 110010105001003 1 103 103 1 psa_12 1D1

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