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

14 rows where P005017 = 12 sorted by P005001

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003004, P003005, P003006, P003008, P005005, P005006, P005007, P005008, P005009, P005010, P005011, P005012, 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
1301 1301 1000000US110010111001035 Block 1035, Block Group 1, Census Tract 111, District of Columbia, District of Columbia 91 0 73 0 0 0 4 14 91 73 0 71 0 0 0 0 2 18 0 2 0 0 0 4 12 110010111001035 5 503 503 5 psa_45 5D2
2633 2633 1000000US110010020021012 Block 1012, Block Group 1, Census Tract 20.02, District of Columbia, District of Columbia 134 27 65 0 12 0 12 18 134 110 26 65 0 12 0 1 6 24 1 0 0 0 0 11 12 110010020021012 4 404 404 4 psa_48 4D3
447 447 1000000US110010037002001 Block 2001, Block Group 2, Census Tract 37, District of Columbia, District of Columbia 199 22 7 0 0 1 157 12 199 14 6 7 0 0 1 0 0 185 16 0 0 0 0 157 12 110010037002001 3 304 304 3 psa_36 3D1
2138 2138 1000000US110010094002018 Block 2018, Block Group 2, Census Tract 94, District of Columbia, District of Columbia 240 20 174 1 2 0 21 22 240 196 12 171 1 2 0 0 10 44 8 3 0 0 0 21 12 110010094002018 5 504 504 5 psa_43 5D2
2970 2970 1000000US110010021015005 Block 5005, Block Group 5, Census Tract 21.01, District of Columbia, District of Columbia 264 46 138 0 8 0 56 16 264 163 16 135 0 8 0 0 4 101 30 3 0 0 0 56 12 110010021015005 4 403 403 4 psa_51 4D1
942 942 1000000US110010025023001 Block 3001, Block Group 3, Census Tract 25.02, District of Columbia, District of Columbia 273 80 118 0 4 0 51 20 273 174 54 107 0 4 0 1 8 99 26 11 0 0 0 50 12 110010025023001 4 404 404 4 psa_48 4D3
1711 1711 1000000US110010036001002 Block 1002, Block Group 1, Census Tract 36, District of Columbia, District of Columbia 303 206 32 1 20 0 27 17 303 245 185 32 1 20 0 2 5 58 21 0 0 0 0 25 12 110010036001002 3 304 304 3 psa_36 3D1
2116 2116 1000000US110010038001003 Block 1003, Block Group 1, Census Tract 38, District of Columbia, District of Columbia 312 238 10 2 32 0 7 23 312 222 170 8 1 32 0 0 11 90 68 2 1 0 0 7 12 110010038001003 3 303 303 3 psa_37 3D3
5415 5415 1000000US110010073011109 Block 1109, Block Group 1, Census Tract 73.01, District of Columbia, District of Columbia 340 175 100 1 15 6 20 23 340 280 148 95 1 15 6 4 11 60 27 5 0 0 0 16 12 110010073011109 7 708 708 7 psa_1 7D3
1696 1696 1000000US110010103003011 Block 3011, Block Group 3, Census Tract 103, District of Columbia, District of Columbia 401 71 216 13 7 2 71 21 401 279 45 210 5 7 2 1 9 122 26 6 8 0 0 70 12 110010103003011 4 401 401 4 psa_56 4D1
2791 2791 1000000US110010018032000 Block 2000, Block Group 2, Census Tract 18.03, District of Columbia, District of Columbia 460 42 248 3 9 0 143 15 460 269 8 244 2 9 0 3 3 191 34 4 1 0 0 140 12 110010018032000 4 402 402 4 psa_53 4D1
3942 3942 1000000US110010037001002 Block 1002, Block Group 1, Census Tract 37, District of Columbia, District of Columbia 542 353 112 0 32 3 16 26 542 484 322 111 0 32 3 2 14 58 31 1 0 0 0 14 12 110010037001002 3 304 304 3 psa_36 3D1
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
5220 5220 1000000US110010052011000 Block 1000, Block Group 1, Census Tract 52.01, District of Columbia, District of Columbia 1113 611 214 10 84 16 134 44 1113 856 529 206 3 84 0 2 32 257 82 8 7 0 16 132 12 110010052011000 2 208 208 2 psa_33 2D3

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