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

23 rows where DISTRICT = 3 and P005012 = 3

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003001, P003002, P003003, P003004, P003005, P003006, P003007, P003008, P005001, P005004, P005005, P005006, P005007, P005008, P005009, P005010, P005011, P005013, P005014, P005015, P005016, P005017, PSA, NAME, 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
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
684 684 1000000US110010050023005 Block 3005, Block Group 3, Census Tract 50.02, District of Columbia, District of Columbia 212 104 50 3 10 0 41 4 212 150 90 47 0 10 0 1 2 62 14 3 3 0 0 40 2 110010050023005 3 307 307 3 psa_28 3D3
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
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
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
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
1602 1602 1000000US110010050012002 Block 2002, Block Group 2, Census Tract 50.01, District of Columbia, District of Columbia 295 134 136 0 12 0 2 11 295 277 122 133 0 12 0 1 9 18 12 3 0 0 0 1 2 110010050012002 3 307 307 3 psa_28 3D3
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
1726 1726 1000000US110010050022002 Block 2002, Block Group 2, Census Tract 50.02, District of Columbia, District of Columbia 349 279 24 1 23 0 4 18 349 308 251 21 1 23 0 0 12 41 28 3 0 0 0 4 6 110010050022002 3 307 307 3 psa_28 3D3
1996 1996 1000000US110010046002002 Block 2002, Block Group 2, Census Tract 46, District of Columbia, District of Columbia 55 10 40 0 3 0 0 2 55 52 10 37 0 3 0 0 2 3 0 3 0 0 0 0 0 110010046002002 3 308 308 3 psa_27 3D2
2239 2239 1000000US110010033021005 Block 1005, Block Group 1, Census Tract 33.02, District of Columbia, District of Columbia 161 43 105 1 0 0 0 12 161 158 43 102 1 0 0 0 12 3 0 3 0 0 0 0 0 110010033021005 3 308 308 3 psa_27 3D2
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
2547 2547 1000000US110010046001003 Block 1003, Block Group 1, Census Tract 46, District of Columbia, District of Columbia 147 31 111 0 2 0 1 2 147 137 25 108 0 2 0 0 2 10 6 3 0 0 0 1 0 110010046001003 3 308 308 3 psa_27 3D2
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
3542 3542 1000000US110010039003002 Block 3002, Block Group 3, Census Tract 39, District of Columbia, District of Columbia 423 285 87 0 14 1 19 17 423 366 259 84 0 14 0 2 7 57 26 3 0 0 1 17 10 110010039003002 3 303 303 3 psa_37 3D3
3738 3738 1000000US110010033012003 Block 2003, Block Group 2, Census Tract 33.01, District of Columbia, District of Columbia 147 64 75 0 0 0 0 8 147 142 62 72 0 0 0 0 8 5 2 3 0 0 0 0 0 110010033012003 3 306 306 3 psa_38 3D2
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
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
4472 4472 1000000US110010040011002 Block 1002, Block Group 1, Census Tract 40.01, District of Columbia, District of Columbia 518 431 17 0 16 0 20 34 518 424 366 14 0 16 0 0 28 94 65 3 0 0 0 20 6 110010040011002 3 303 303 3 psa_37 3D3
5087 5087 1000000US110010048011013 Block 1013, Block Group 1, Census Tract 48.01, District of Columbia, District of Columbia 129 74 41 0 6 0 1 7 129 122 72 38 0 6 0 0 6 7 2 3 0 0 0 1 1 110010048011013 3 308 308 3 psa_27 3D2
6147 6147 1000000US110010046001004 Block 1004, Block Group 1, Census Tract 46, District of Columbia, District of Columbia 384 99 246 1 13 0 9 16 384 347 77 243 1 13 0 1 12 37 22 3 0 0 0 8 4 110010046001004 3 308 308 3 psa_27 3D2
6450 6450 1000000US110010033021002 Block 1002, Block Group 1, Census Tract 33.02, District of Columbia, District of Columbia 83 34 45 0 3 0 0 1 83 79 34 42 0 3 0 0 0 4 0 3 0 0 0 0 1 110010033021002 3 308 308 3 psa_27 3D2

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