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

12 rows where P005008 = 0 and P005009 = 12

View and edit SQL

Suggested facets: P003004, P003005, P003006, P003007, P003008, P005003, P005005, P005006, P005007, P005010, P005011, P005012, P005013, P005014, P005016, P005017, DISTRICT, PSA, NAME, POLDIST_ID, GIS_ID, SECTOR

P005009

P005008

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
302 1000000US110010097001003 Block 1003, Block Group 1, Census Tract 97, District of Columbia, District of Columbia 360 0 345 1 0 0 2 12 360 357 0 344 1 0 0 0 12 3 0 1 0 0 0 2 0 110010097001003 7 706 706 7 psa_2 7D3
429 1000000US110010027012004 Block 2004, Block Group 2, Census Tract 27.01, District of Columbia, District of Columbia 385 159 191 0 15 1 6 13 385 367 148 191 0 15 1 0 12 18 11 0 0 0 0 6 1 110010027012004 3 302 302 3 psa_42 3D1
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
1989 1000000US110010074042007 Block 2007, Block Group 2, Census Tract 74.04, District of Columbia, District of Columbia 153 8 130 0 1 0 0 14 153 145 2 130 0 1 0 0 12 8 6 0 0 0 0 0 2 110010074042007 7 704 704 7 psa_5 7D2
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
2660 1000000US110010019014000 Block 4000, Block Group 4, Census Tract 19.01, District of Columbia, District of Columbia 50 7 27 0 4 0 0 12 50 50 7 27 0 4 0 0 12 0 0 0 0 0 0 0 0 110010019014000 4 402 402 4 psa_53 4D1
3307 1000000US110010006002005 Block 2005, Block Group 2, Census Tract 6, District of Columbia, District of Columbia 175 152 7 0 4 0 0 12 175 169 146 7 0 4 0 0 12 6 6 0 0 0 0 0 0 110010006002005 2 203 203 2 psa_50 2D1
3355 1000000US110010072002026 Block 2026, Block Group 2, Census Tract 72, District of Columbia, District of Columbia 337 185 107 0 22 0 4 19 337 309 169 106 0 22 0 0 12 28 16 1 0 0 0 4 7 110010072002026 1 106 106 1 psa_13 1D3
4775 1000000US110010010022001 Block 2001, Block Group 2, Census Tract 10.02, District of Columbia, District of Columbia 215 175 12 0 13 0 2 13 215 194 157 12 0 13 0 0 12 21 18 0 0 0 0 2 1 110010010022001 2 204 204 2 psa_44 2D2
5940 1000000US110010027012002 Block 2002, Block Group 2, Census Tract 27.01, District of Columbia, District of Columbia 327 154 79 1 30 1 42 20 327 248 129 77 0 29 1 0 12 79 25 2 1 1 0 42 8 110010027012002 3 302 302 3 psa_42 3D1
6304 1000000US110010077033001 Block 3001, Block Group 3, Census Tract 77.03, District of Columbia, District of Columbia 832 2 813 2 0 0 2 13 832 826 2 810 2 0 0 0 12 6 0 3 0 0 0 2 1 110010077033001 6 603 603 6 psa_15 6D3
6306 1000000US110010033013000 Block 3000, Block Group 3, Census Tract 33.01, District of Columbia, District of Columbia 233 56 154 0 5 0 6 12 233 222 52 153 0 5 0 0 12 11 4 1 0 0 0 6 0 110010033013000 3 306 306 3 psa_38 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
);