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

23 rows where P005005 = 2 and P005012 = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003002, P003003, P003004, P003005, P003007, P003008, P005003, P005004, P005006, P005008, P005009, P005010, P005011, P005013, P005014, 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
165 165 1000000US110010075022007 Block 2007, Block Group 2, Census Tract 75.02, District of Columbia, District of Columbia 146 0 142 2 1 0 0 1 146 145 0 141 2 1 0 0 1 1 0 1 0 0 0 0 0 110010075022007 7 702 702 7 psa_6 7D1
176 176 1000000US110010077031000 Block 1000, Block Group 1, Census Tract 77.03, District of Columbia, District of Columbia 302 3 291 2 0 0 0 6 302 301 3 290 2 0 0 0 6 1 0 1 0 0 0 0 0 110010077031000 6 603 603 6 psa_15 6D3
304 304 1000000US110010097001006 Block 1006, Block Group 1, Census Tract 97, District of Columbia, District of Columbia 119 2 115 2 0 0 0 0 119 118 2 114 2 0 0 0 0 1 0 1 0 0 0 0 0 110010097001006 7 706 706 7 psa_2 7D3
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
551 551 1000000US110010095013002 Block 3002, Block Group 3, Census Tract 95.01, District of Columbia, District of Columbia 81 3 62 2 0 0 9 5 81 70 2 61 2 0 0 0 5 11 1 1 0 0 0 9 0 110010095013002 4 405 405 4 psa_49 4D2
582 582 1000000US110010088023003 Block 3003, Block Group 3, Census Tract 88.02, District of Columbia, District of Columbia 89 2 82 2 1 0 2 0 89 86 2 81 2 1 0 0 0 3 0 1 0 0 0 2 0 110010088023003 5 506 506 5 psa_26 5D3
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
846 846 1000000US110010058002010 Block 2010, Block Group 2, Census Tract 58, District of Columbia, District of Columbia 566 427 34 2 71 0 2 30 566 528 396 33 2 71 0 0 26 38 31 1 0 0 0 2 4 110010058002010 1 102 102 1 psa_18 1D1
1649 1649 1000000US110010013013002 Block 3002, Block Group 3, Census Tract 13.01, District of Columbia, District of Columbia 736 478 112 2 108 0 16 20 736 668 426 111 2 108 0 4 17 68 52 1 0 0 0 12 3 110010013013002 2 203 203 2 psa_50 2D1
1740 1740 1000000US110010089041001 Block 1001, Block Group 1, Census Tract 89.04, District of Columbia, District of Columbia 311 0 302 2 0 0 4 3 311 306 0 301 2 0 0 0 3 5 0 1 0 0 0 4 0 110010089041001 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
2485 2485 1000000US110010064002003 Block 2003, Block Group 2, Census Tract 64, District of Columbia, District of Columbia 152 17 118 2 0 0 9 6 152 139 16 117 2 0 0 0 4 13 1 1 0 0 0 9 2 110010064002003 1 105 105 1 psa_22 1D3
4220 4220 1000000US110010077071007 Block 1007, Block Group 1, Census Tract 77.07, District of Columbia, District of Columbia 72 0 70 2 0 0 0 0 72 71 0 69 2 0 0 0 0 1 0 1 0 0 0 0 0 110010077071007 6 604 604 6 psa_14 6D3
4227 4227 1000000US110010083012005 Block 2005, Block Group 2, Census Tract 83.01, District of Columbia, District of Columbia 168 130 31 2 3 0 0 2 168 167 130 30 2 3 0 0 2 1 0 1 0 0 0 0 0 110010083012005 1 108 108 1 psa_17 1D2
4370 4370 1000000US110010098112002 Block 2002, Block Group 2, Census Tract 98.11, District of Columbia, District of Columbia 316 0 314 2 0 0 0 0 316 315 0 313 2 0 0 0 0 1 0 1 0 0 0 0 0 110010098112002 7 706 706 7 psa_2 7D3
5045 5045 1000000US110010021011007 Block 1007, Block Group 1, Census Tract 21.01, District of Columbia, District of Columbia 117 5 94 2 1 0 8 7 117 106 5 93 2 1 0 0 5 11 0 1 0 0 0 8 2 110010021011007 4 403 403 4 psa_51 4D1
5317 5317 1000000US110010066001001 Block 1001, Block Group 1, Census Tract 66, District of Columbia, District of Columbia 206 172 15 2 11 0 3 3 206 200 171 14 2 11 0 0 2 6 1 1 0 0 0 3 1 110010066001001 1 107 107 1 psa_16 1D2
5379 5379 1000000US110010080011000 Block 1000, Block Group 1, Census Tract 80.01, District of Columbia, District of Columbia 96 10 70 2 2 0 12 0 96 80 8 69 2 1 0 0 0 16 2 1 0 1 0 12 0 110010080011000 1 104 104 1 psa_21 1D2
5481 5481 1000000US110010048022001 Block 2001, Block Group 2, Census Tract 48.02, District of Columbia, District of Columbia 707 52 386 8 210 0 37 14 707 652 41 385 2 210 0 1 13 55 11 1 6 0 0 36 1 110010048022001 3 308 308 3 psa_27 3D2
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
5570 5570 1000000US110010078092002 Block 2002, Block Group 2, Census Tract 78.09, District of Columbia, District of Columbia 48 0 42 2 0 0 0 4 48 47 0 41 2 0 0 0 4 1 0 1 0 0 0 0 0 110010078092002 6 602 602 6 psa_25 6D1
5682 5682 1000000US110010079013000 Block 3000, Block Group 3, Census Tract 79.01, District of Columbia, District of Columbia 114 1 105 2 0 0 0 6 114 113 1 104 2 0 0 0 6 1 0 1 0 0 0 0 0 110010079013000 5 507 507 5 psa_23 5D3
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
);