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

17 rows where P005010 = 32

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003002, P003004, P003005, P003006, P003007, P003008, P005006, P005008, P005009, P005011, P005012, P005013, P005014, P005015, P005016, P005017, DISTRICT, PSA, NAME, POLDIST_ID, GIS_ID, SECTOR

P005005 ✖

P005010 ✖

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
12 12 1000000US110010043002001 Block 2001, Block Group 2, Census Tract 43, District of Columbia, District of Columbia 225 43 147 0 8 0 21 6 225 193 38 144 0 8 0 2 1 32 5 3 0 0 0 19 5 110010043002001 3 301 301 3 psa_31 3D3
24 24 1000000US110010048021006 Block 1006, Block Group 1, Census Tract 48.02, District of Columbia, District of Columbia 407 282 55 1 41 1 17 10 407 375 269 55 1 41 0 0 9 32 13 0 0 0 1 17 1 110010048021006 3 308 308 3 psa_27 3D2
66 66 1000000US110010058001026 Block 1026, Block Group 1, Census Tract 58, District of Columbia, District of Columbia 299 239 25 0 19 0 5 11 299 267 219 24 0 18 0 1 5 32 20 1 0 1 0 4 6 110010058001026 1 102 102 1 psa_18 1D1
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
343 343 1000000US110010008013022 Block 3022, Block Group 3, Census Tract 8.01, District of Columbia, District of Columbia 343 282 18 0 22 0 11 10 343 311 262 17 0 22 0 3 7 32 20 1 0 0 0 8 3 110010008013022 2 204 204 2 psa_44 2D2
595 595 1000000US110010027021006 Block 1006, Block Group 1, Census Tract 27.02, District of Columbia, District of Columbia 118 83 4 3 6 0 13 9 118 86 73 4 3 6 0 0 0 32 10 0 0 0 0 13 9 110010027021006 3 302 302 3 psa_42 3D1
598 598 1000000US110010039002001 Block 2001, Block Group 2, Census Tract 39, District of Columbia, District of Columbia 246 180 24 2 17 0 11 12 246 214 162 23 1 17 0 1 10 32 18 1 1 0 0 10 2 110010039002001 3 303 303 3 psa_37 3D3
798 798 1000000US110010018032002 Block 2002, Block Group 2, Census Tract 18.03, District of Columbia, District of Columbia 146 18 90 0 13 0 25 0 146 114 11 90 0 13 0 0 0 32 7 0 0 0 0 25 0 110010018032002 4 402 402 4 psa_53 4D1
834 834 1000000US110010020021026 Block 1026, Block Group 1, Census Tract 20.02, District of Columbia, District of Columbia 120 16 74 0 0 0 23 7 120 88 10 73 0 0 0 0 5 32 6 1 0 0 0 23 2 110010020021026 4 404 404 4 psa_48 4D3
1109 1109 1000000US110010094003000 Block 3000, Block Group 3, Census Tract 94, District of Columbia, District of Columbia 144 28 83 2 16 0 14 1 144 112 14 80 2 16 0 0 0 32 14 3 0 0 0 14 1 110010094003000 5 503 503 5 psa_45 5D2
1277 1277 1000000US110010053012001 Block 2001, Block Group 2, Census Tract 53.01, District of Columbia, District of Columbia 553 485 14 0 34 0 6 14 553 521 459 14 0 34 0 0 14 32 26 0 0 0 0 6 0 110010053012001 2 208 208 2 psa_33 2D3
2278 2278 1000000US110010012002008 Block 2008, Block Group 2, Census Tract 12, District of Columbia, District of Columbia 335 274 11 2 33 0 4 11 335 303 246 11 2 33 0 0 11 32 28 0 0 0 0 4 0 110010012002008 2 203 203 2 psa_50 2D1
2766 2766 1000000US110010027023000 Block 3000, Block Group 3, Census Tract 27.02, District of Columbia, District of Columbia 249 172 32 1 7 0 21 16 249 217 164 31 1 7 0 0 14 32 8 1 0 0 0 21 2 110010027023000 3 302 302 3 psa_42 3D1
3429 3429 1000000US110010022022001 Block 2001, Block Group 2, Census Tract 22.02, District of Columbia, District of Columbia 164 7 122 0 0 0 16 19 164 132 6 122 0 0 0 0 4 32 1 0 0 0 0 16 15 110010022022001 4 407 407 4 psa_47 4D2
4250 4250 1000000US110010023012012 Block 2012, Block Group 2, Census Tract 23.01, District of Columbia, District of Columbia 155 36 86 5 1 0 5 22 155 123 34 86 0 1 0 0 2 32 2 0 5 0 0 5 20 110010023012012 4 407 407 4 psa_47 4D2
4836 4836 1000000US110010095071007 Block 1007, Block Group 1, Census Tract 95.07, District of Columbia, District of Columbia 136 10 102 0 0 0 22 2 136 104 0 101 0 0 0 1 2 32 10 1 0 0 0 21 0 110010095071007 4 406 406 4 psa_54 4D2
5120 5120 1000000US110010039003000 Block 3000, Block Group 3, Census Tract 39, District of Columbia, District of Columbia 308 225 39 1 19 0 11 13 308 276 209 33 1 19 0 2 12 32 16 6 0 0 0 9 1 110010039003000 3 303 303 3 psa_37 3D3

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