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 P003007 = 21

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003004, P003005, P003006, P003008, P005003, P005005, P005006, P005007, P005008, 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
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
278 278 1000000US110010095083000 Block 3000, Block Group 3, Census Tract 95.08, District of Columbia, District of Columbia 300 6 268 0 0 0 21 5 300 266 2 260 0 0 0 0 4 34 4 8 0 0 0 21 1 110010095083000 4 406 406 4 psa_54 4D2
1012 1012 1000000US110010053013001 Block 3001, Block Group 3, Census Tract 53.01, District of Columbia, District of Columbia 1102 856 51 1 137 2 21 34 1102 986 770 48 0 136 1 5 26 116 86 3 1 1 1 16 8 110010053013001 2 208 208 2 psa_33 2D3
1297 1297 1000000US110010095011004 Block 1004, Block Group 1, Census Tract 95.01, District of Columbia, District of Columbia 344 32 278 0 2 0 21 11 344 315 31 274 0 2 0 1 7 29 1 4 0 0 0 20 4 110010095011004 4 405 405 4 psa_49 4D2
1762 1762 1000000US110010111002012 Block 2012, Block Group 2, Census Tract 111, District of Columbia, District of Columbia 69 1 47 0 0 0 21 0 69 45 1 44 0 0 0 0 0 24 0 3 0 0 0 21 0 110010111002012 5 503 503 5 psa_45 5D2
1965 1965 1000000US110010095013010 Block 3010, Block Group 3, Census Tract 95.01, District of Columbia, District of Columbia 1890 1693 44 3 73 1 21 55 1890 1750 1590 39 3 69 1 3 45 140 103 5 0 4 0 18 10 110010095013010 4 405 405 4 psa_49 4D2
2010 2010 1000000US110010021012002 Block 2002, Block Group 2, Census Tract 21.01, District of Columbia, District of Columbia 114 30 60 0 3 0 21 0 114 78 15 60 0 3 0 0 0 36 15 0 0 0 0 21 0 110010021012002 4 403 403 4 psa_51 4D1
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
2325 2325 1000000US110010031001003 Block 1003, Block Group 1, Census Tract 31, District of Columbia, District of Columbia 168 39 96 0 7 0 21 5 168 130 26 95 0 7 0 0 2 38 13 1 0 0 0 21 3 110010031001003 4 409 409 4 psa_41 4D3
2727 2727 1000000US110010078034006 Block 4006, Block Group 4, Census Tract 78.03, District of Columbia, District of Columbia 463 7 419 0 1 0 21 15 463 437 6 416 0 1 0 4 10 26 1 3 0 0 0 17 5 110010078034006 6 602 602 6 psa_25 6D1
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
2985 2985 1000000US110010080012012 Block 2012, Block Group 2, Census Tract 80.01, District of Columbia, District of Columbia 191 59 101 0 4 0 21 6 191 162 58 98 0 4 0 1 1 29 1 3 0 0 0 20 5 110010080012012 1 104 104 1 psa_21 1D2
4315 4315 1000000US110010025022006 Block 2006, Block Group 2, Census Tract 25.02, District of Columbia, District of Columbia 206 86 87 1 1 0 21 10 206 176 82 83 1 1 0 1 8 30 4 4 0 0 0 20 2 110010025022006 4 404 404 4 psa_48 4D3
4402 4402 1000000US110010050022003 Block 2003, Block Group 2, Census Tract 50.02, District of Columbia, District of Columbia 575 427 48 0 49 2 21 28 575 499 380 45 0 49 2 1 22 76 47 3 0 0 0 20 6 110010050022003 3 307 307 3 psa_28 3D3
4791 4791 1000000US110010022012015 Block 2015, Block Group 2, Census Tract 22.01, District of Columbia, District of Columbia 173 31 112 1 6 0 21 2 173 139 19 111 1 6 0 0 2 34 12 1 0 0 0 21 0 110010022012015 4 407 407 4 psa_47 4D2
5017 5017 1000000US110010101001004 Block 1004, Block Group 1, Census Tract 101, District of Columbia, District of Columbia 553 354 98 1 50 0 21 29 553 469 300 96 1 49 0 0 23 84 54 2 0 1 0 21 6 110010101001004 2 209 209 2 psa_57 2D3
6156 6156 1000000US110010022011003 Block 1003, Block Group 1, Census Tract 22.01, District of Columbia, District of Columbia 184 8 154 0 0 0 21 1 184 157 2 154 0 0 0 0 1 27 6 0 0 0 0 21 0 110010022011003 4 407 407 4 psa_47 4D2

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