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

19 rows where DISTRICT = 7 and P003008 = 3

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003001, P003002, P003004, P003005, P003006, P003007, P005001, P005003, P005005, P005006, P005007, P005008, P005009, P005010, P005011, P005012, P005013, P005016, P005017, PSA, NAME, GIS_ID, SECTOR

P003008 ✖

DISTRICT ✖

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
308 308 1000000US110010097002000 Block 2000, Block Group 2, Census Tract 97, District of Columbia, District of Columbia 508 2 501 0 2 0 0 3 508 507 2 500 0 2 0 0 3 1 0 1 0 0 0 0 0 110010097002000 7 706 706 7 psa_2 7D3
464 464 1000000US110010097002002 Block 2002, Block Group 2, Census Tract 97, District of Columbia, District of Columbia 253 3 245 0 1 0 1 3 253 251 2 245 0 1 0 0 3 2 1 0 0 0 0 1 0 110010097002002 7 706 706 7 psa_2 7D3
473 473 1000000US110010098111000 Block 1000, Block Group 1, Census Tract 98.11, District of Columbia, District of Columbia 673 4 665 0 0 0 1 3 673 668 3 662 0 0 0 0 3 5 1 3 0 0 0 1 0 110010098111000 7 708 708 7 psa_1 7D3
1126 1126 1000000US110010098022001 Block 2001, Block Group 2, Census Tract 98.02, District of Columbia, District of Columbia 118 3 112 0 0 0 0 3 118 115 3 109 0 0 0 0 3 3 0 3 0 0 0 0 0 110010098022001 7 706 706 7 psa_2 7D3
1619 1619 1000000US110010104002019 Block 2019, Block Group 2, Census Tract 104, District of Columbia, District of Columbia 176 4 168 1 0 0 0 3 176 172 4 165 0 0 0 0 3 4 0 3 1 0 0 0 0 110010104002019 7 707 707 7 psa_4 7D2
1675 1675 1000000US110010104002043 Block 2043, Block Group 2, Census Tract 104, District of Columbia, District of Columbia 109 6 99 0 1 0 0 3 109 109 6 99 0 1 0 0 3 0 0 0 0 0 0 0 0 110010104002043 7 707 707 7 psa_4 7D2
1695 1695 1000000US110010074071010 Block 1010, Block Group 1, Census Tract 74.07, District of Columbia, District of Columbia 290 0 287 0 0 0 0 3 290 283 0 281 0 0 0 0 2 7 0 6 0 0 0 0 1 110010074071010 7 702 702 7 psa_6 7D1
1739 1739 1000000US110010098011012 Block 1012, Block Group 1, Census Tract 98.01, District of Columbia, District of Columbia 168 0 163 0 2 0 0 3 168 166 0 163 0 2 0 0 1 2 0 0 0 0 0 0 2 110010098011012 7 706 706 7 psa_2 7D3
2217 2217 1000000US110010098102002 Block 2002, Block Group 2, Census Tract 98.10, District of Columbia, District of Columbia 363 0 358 1 1 0 0 3 363 361 0 356 1 1 0 0 3 2 0 2 0 0 0 0 0 110010098102002 7 708 708 7 psa_1 7D3
2247 2247 1000000US110010073042006 Block 2006, Block Group 2, Census Tract 73.04, District of Columbia, District of Columbia 133 1 128 1 0 0 0 3 133 132 1 128 0 0 0 0 3 1 0 0 1 0 0 0 0 110010073042006 7 705 705 7 psa_3 7D2
2344 2344 1000000US110010098031005 Block 1005, Block Group 1, Census Tract 98.03, District of Columbia, District of Columbia 247 1 243 0 0 0 0 3 247 245 1 241 0 0 0 0 3 2 0 2 0 0 0 0 0 110010098031005 7 707 707 7 psa_4 7D2
4056 4056 1000000US110010098033003 Block 3003, Block Group 3, Census Tract 98.03, District of Columbia, District of Columbia 117 1 113 0 0 0 0 3 117 116 1 113 0 0 0 0 2 1 0 0 0 0 0 0 1 110010098033003 7 707 707 7 psa_4 7D2
4180 4180 1000000US110010104002027 Block 2027, Block Group 2, Census Tract 104, District of Columbia, District of Columbia 323 35 284 0 0 1 0 3 323 320 34 282 0 0 1 0 3 3 1 2 0 0 0 0 0 110010104002027 7 703 703 7 psa_8 7D1
4224 4224 1000000US110010098112004 Block 2004, Block Group 2, Census Tract 98.11, District of Columbia, District of Columbia 109 0 105 0 0 0 1 3 109 108 0 105 0 0 0 0 3 1 0 0 0 0 0 1 0 110010098112004 7 706 706 7 psa_2 7D3
4262 4262 1000000US110010073043002 Block 3002, Block Group 3, Census Tract 73.04, District of Columbia, District of Columbia 51 4 42 0 0 0 2 3 51 47 4 42 0 0 0 1 0 4 0 0 0 0 0 1 3 110010073043002 7 705 705 7 psa_3 7D2
4297 4297 1000000US110010075041000 Block 1000, Block Group 1, Census Tract 75.04, District of Columbia, District of Columbia 197 1 193 0 0 0 0 3 197 197 1 193 0 0 0 0 3 0 0 0 0 0 0 0 0 110010075041000 7 701 701 7 psa_9 7D1
4416 4416 1000000US110010109002002 Block 2002, Block Group 2, Census Tract 109, District of Columbia, District of Columbia 129 0 125 0 0 0 1 3 129 129 0 125 0 0 0 1 3 0 0 0 0 0 0 0 0 110010109002002 7 708 708 7 psa_1 7D3
5728 5728 1000000US110010074041009 Block 1009, Block Group 1, Census Tract 74.04, District of Columbia, District of Columbia 179 4 172 0 0 0 0 3 179 179 4 172 0 0 0 0 3 0 0 0 0 0 0 0 0 110010074041009 7 704 704 7 psa_5 7D2
5797 5797 1000000US110010098021000 Block 1000, Block Group 1, Census Tract 98.02, District of Columbia, District of Columbia 358 1 353 1 0 0 0 3 358 357 1 352 1 0 0 0 3 1 0 1 0 0 0 0 0 110010098021000 7 706 706 7 psa_2 7D3

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