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 P005012 = 1 and P005014 = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003001, P003003, P003004, P003005, P003007, P003008, P005001, P005004, P005005, P005006, P005008, P005009, P005010, P005011, P005013, 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
44 44 1000000US110010052011001 Block 1001, Block Group 1, Census Tract 52.01, District of Columbia, District of Columbia 495 381 35 2 49 0 12 16 495 451 354 34 1 48 0 2 12 44 27 1 1 1 0 10 4 110010052011001 2 208 208 2 psa_33 2D3
52 52 1000000US110010056001002 Block 1002, Block Group 1, Census Tract 56, District of Columbia, District of Columbia 369 298 17 1 31 0 6 16 369 339 277 16 1 30 0 1 14 30 21 1 0 1 0 5 2 110010056001002 2 207 207 2 psa_24 2D3
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
320 320 1000000US110010003002004 Block 2004, Block Group 2, Census Tract 3, District of Columbia, District of Columbia 615 514 18 4 36 0 18 25 615 564 484 17 4 35 0 3 21 51 30 1 0 1 0 15 4 110010003002004 2 204 204 2 psa_44 2D2
498 498 1000000US110010107002008 Block 2008, Block Group 2, Census Tract 107, District of Columbia, District of Columbia 666 524 20 1 85 0 14 22 666 619 494 19 0 84 0 3 19 47 30 1 1 1 0 11 3 110010107002008 2 208 208 2 psa_33 2D3
993 993 1000000US110010038003005 Block 3005, Block Group 3, Census Tract 38, District of Columbia, District of Columbia 123 95 4 0 13 0 9 2 123 104 86 3 0 12 0 1 2 19 9 1 0 1 0 8 0 110010038003005 3 303 303 3 psa_37 3D3
1168 1168 1000000US110010041002012 Block 2012, Block Group 2, Census Tract 41, District of Columbia, District of Columbia 202 174 5 2 16 0 0 5 202 186 162 4 0 15 0 0 5 16 12 1 2 1 0 0 0 110010041002012 2 208 208 2 psa_33 2D3
2033 2033 1000000US110010002024001 Block 4001, Block Group 4, Census Tract 2.02, District of Columbia, District of Columbia 123 75 11 1 21 0 7 8 123 109 73 10 1 20 0 1 4 14 2 1 0 1 0 6 4 110010002024001 2 206 206 2 psa_29 2D2
2289 2289 1000000US110010030002003 Block 2003, Block Group 2, Census Tract 30, District of Columbia, District of Columbia 397 209 132 0 11 0 25 20 397 347 192 131 0 10 0 1 13 50 17 1 0 1 0 24 7 110010030002003 3 302 302 3 psa_42 3D1
2881 2881 1000000US110010053011001 Block 1001, Block Group 1, Census Tract 53.01, District of Columbia, District of Columbia 431 361 13 1 35 0 8 13 431 405 349 12 0 34 0 0 10 26 12 1 1 1 0 8 3 110010053011001 3 301 301 3 psa_31 3D3
3435 3435 1000000US110010013023009 Block 3009, Block Group 3, Census Tract 13.02, District of Columbia, District of Columbia 474 363 38 0 40 0 13 20 474 427 331 37 0 39 0 2 18 47 32 1 0 1 0 11 2 110010013023009 2 203 203 2 psa_50 2D1
3744 3744 1000000US110010073011078 Block 1078, Block Group 1, Census Tract 73.01, District of Columbia, District of Columbia 67 36 22 0 1 0 4 4 67 59 35 21 0 0 0 0 3 8 1 1 0 1 0 4 1 110010073011078 7 707 707 7 psa_4 7D2
5262 5262 1000000US110010080013005 Block 3005, Block Group 3, Census Tract 80.01, District of Columbia, District of Columbia 83 40 29 0 3 0 8 3 83 69 36 28 0 2 0 0 3 14 4 1 0 1 0 8 0 110010080013005 1 108 108 1 psa_17 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
6025 6025 1000000US110010092011003 Block 1003, Block Group 1, Census Tract 92.01, District of Columbia, District of Columbia 324 279 12 0 10 0 12 11 324 298 264 11 0 9 0 3 11 26 15 1 0 1 0 9 0 110010092011003 5 502 502 5 psa_40 5D1
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
6485 6485 1000000US110010013011019 Block 1019, Block Group 1, Census Tract 13.01, District of Columbia, District of Columbia 979 728 70 0 142 0 13 26 979 914 677 69 0 141 0 3 24 65 51 1 0 1 0 10 2 110010013011019 2 203 203 2 psa_50 2D1

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