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

111 rows where P005012 = 4 sorted by P005003

✎ View and edit SQL

This data as json, CSV (advanced)

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
2227 2227 1000000US110010028022002 Block 2002, Block Group 2, Census Tract 28.02, District of Columbia, District of Columbia 303 122 123 0 15 1 15 27 303 243 91 119 0 15 0 0 18 60 31 4 0 0 1 15 9 110010028022002 3 302 302 3 psa_42 3D1
1488 1488 1000000US110010015001031 Block 1031, Block Group 1, Census Tract 15, District of Columbia, District of Columbia 170 111 37 1 3 0 8 10 170 146 101 33 1 3 0 2 6 24 10 4 0 0 0 6 4 110010015001031 2 201 201 2 psa_55 2D1
4504 4504 1000000US110010027012003 Block 2003, Block Group 2, Census Tract 27.01, District of Columbia, District of Columbia 396 225 66 3 26 0 58 18 396 294 197 62 0 24 0 1 10 102 28 4 3 2 0 57 8 110010027012003 3 302 302 3 psa_42 3D1
3156 3156 1000000US110010083011005 Block 1005, Block Group 1, Census Tract 83.01, District of Columbia, District of Columbia 287 216 56 1 4 0 4 6 287 268 206 52 1 4 0 0 5 19 10 4 0 0 0 4 1 110010083011005 1 104 104 1 psa_21 1D2
335 335 1000000US110010007021005 Block 1005, Block Group 1, Census Tract 7.02, District of Columbia, District of Columbia 248 221 8 0 11 0 3 5 248 227 207 4 0 11 0 1 4 21 14 4 0 0 0 2 1 110010007021005 2 204 204 2 psa_44 2D2
2159 2159 1000000US110010102002038 Block 2038, Block Group 2, Census Tract 102, District of Columbia, District of Columbia 607 249 284 2 23 0 10 39 607 574 236 280 1 23 0 2 32 33 13 4 1 0 0 8 7 110010102002038 1 103 103 1 psa_12 1D1
6435 6435 1000000US110010002024002 Block 4002, Block Group 4, Census Tract 2.02, District of Columbia, District of Columbia 400 308 25 0 46 0 5 16 400 363 283 21 0 45 0 0 14 37 25 4 0 1 0 5 2 110010002024002 2 206 206 2 psa_29 2D2
332 332 1000000US110010007012000 Block 2000, Block Group 2, Census Tract 7.01, District of Columbia, District of Columbia 408 307 39 0 35 0 18 9 408 365 285 35 0 35 0 6 4 43 22 4 0 0 0 12 5 110010007012000 2 205 205 2 psa_46 2D2
2 2 1000000US110010040021001 Block 1001, Block Group 1, Census Tract 40.02, District of Columbia, District of Columbia 407 346 27 1 17 0 9 7 407 362 313 23 1 17 0 1 7 45 33 4 0 0 0 8 0 110010040021001 3 303 303 3 psa_37 3D3
5918 5918 1000000US110010012001003 Block 1003, Block Group 1, Census Tract 12, District of Columbia, District of Columbia 534 366 55 2 75 0 13 23 534 489 345 51 2 72 0 0 19 45 21 4 0 3 0 13 4 110010012001003 2 203 203 2 psa_50 2D1
2564 2564 1000000US110010059001010 Block 1010, Block Group 1, Census Tract 59, District of Columbia, District of Columbia 1281 882 208 1 145 0 17 28 1281 1205 831 204 1 145 0 2 22 76 51 4 0 0 0 15 6 110010059001010 1 101 101 1 psa_20 1D1

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