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

9 rows where P005012 = 3 and SECTOR = "3D1" sorted by NAME_x

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003003, P003004, P003006, P003007, P003008, P005004, P005005, P005006, P005007, P005008, P005011, P005013, P005014, P005016, P005017, PSA, NAME, GIS_ID

SECTOR ✖

P005012 ✖

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
2417 2417 1000000US110010028021000 Block 1000, Block Group 1, Census Tract 28.02, District of Columbia, District of Columbia 680 371 83 8 22 1 135 60 680 395 269 80 1 22 1 0 22 285 102 3 7 0 0 135 38 110010028021000 3 302 302 3 psa_42 3D1
1563 1563 1000000US110010036002000 Block 2000, Block Group 2, Census Tract 36, District of Columbia, District of Columbia 356 46 230 2 2 0 61 15 356 268 32 227 1 0 0 0 8 88 14 3 1 2 0 61 7 110010036002000 3 304 304 3 psa_36 3D1
1456 1456 1000000US110010027022003 Block 2003, Block Group 2, Census Tract 27.02, District of Columbia, District of Columbia 183 125 31 0 13 0 6 8 183 157 112 28 0 13 0 1 3 26 13 3 0 0 0 5 5 110010027022003 3 302 302 3 psa_42 3D1
1413 1413 1000000US110010028022003 Block 2003, Block Group 2, Census Tract 28.02, District of Columbia, District of Columbia 202 7 153 0 3 0 36 3 202 155 2 150 0 3 0 0 0 47 5 3 0 0 0 36 3 110010028022003 3 302 302 3 psa_42 3D1
4191 4191 1000000US110010027022007 Block 2007, Block Group 2, Census Tract 27.02, District of Columbia, District of Columbia 295 147 129 2 4 0 2 11 295 283 142 126 2 4 0 0 9 12 5 3 0 0 0 2 2 110010027022007 3 302 302 3 psa_42 3D1
1644 1644 1000000US110010027013000 Block 3000, Block Group 3, Census Tract 27.01, District of Columbia, District of Columbia 482 372 64 3 18 0 6 19 482 441 343 61 2 18 0 1 16 41 29 3 1 0 0 5 3 110010027013000 3 302 302 3 psa_42 3D1
430 430 1000000US110010027013001 Block 3001, Block Group 3, Census Tract 27.01, District of Columbia, District of Columbia 248 191 26 1 11 0 7 12 248 218 179 23 0 11 0 0 5 30 12 3 1 0 0 7 7 110010027013001 3 302 302 3 psa_42 3D1
1235 1235 1000000US110010036003002 Block 3002, Block Group 3, Census Tract 36, District of Columbia, District of Columbia 328 192 83 1 12 0 28 12 328 278 174 80 1 11 0 1 11 50 18 3 0 1 0 27 1 110010036003002 3 304 304 3 psa_36 3D1
2920 2920 1000000US110010036003003 Block 3003, Block Group 3, Census Tract 36, District of Columbia, District of Columbia 458 279 117 0 34 0 9 19 458 413 255 114 0 34 0 0 10 45 24 3 0 0 0 9 9 110010036003003 3 304 304 3 psa_36 3D1

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