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

32 rows where DISTRICT = 7 and P005017 = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003001, P003002, P003004, P003005, P003006, P003007, P003008, P005001, P005003, P005005, P005006, P005007, P005008, P005009, P005010, P005011, P005012, P005013, P005014, P005016, 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
115 115 1000000US110010073011014 Block 1014, Block Group 1, Census Tract 73.01, District of Columbia, District of Columbia 254 143 63 0 14 1 15 18 254 213 127 54 0 14 1 0 17 41 16 9 0 0 0 15 1 110010073011014 7 707 707 7 psa_4 7D2
134 134 1000000US110010074031002 Block 1002, Block Group 1, Census Tract 74.03, District of Columbia, District of Columbia 1322 9 1304 0 4 0 1 4 1322 1315 9 1300 0 3 0 0 3 7 0 4 0 1 0 1 1 110010074031002 7 704 704 7 psa_5 7D2
152 152 1000000US110010074061000 Block 1000, Block Group 1, Census Tract 74.06, District of Columbia, District of Columbia 708 3 700 1 0 0 0 4 708 698 2 692 1 0 0 0 3 10 1 8 0 0 0 0 1 110010074061000 7 703 703 7 psa_8 7D1
161 161 1000000US110010074091002 Block 1002, Block Group 1, Census Tract 74.09, District of Columbia, District of Columbia 222 0 216 0 0 0 0 6 222 218 0 213 0 0 0 0 5 4 0 3 0 0 0 0 1 110010074091002 7 704 704 7 psa_5 7D2
470 470 1000000US110010098072010 Block 2010, Block Group 2, Census Tract 98.07, District of Columbia, District of Columbia 705 7 682 0 0 0 2 14 705 694 6 675 0 0 0 0 13 11 1 7 0 0 0 2 1 110010098072010 7 708 708 7 psa_1 7D3
474 474 1000000US110010098111003 Block 1003, Block Group 1, Census Tract 98.11, District of Columbia, District of Columbia 737 0 704 3 1 0 6 23 737 731 0 699 3 1 0 6 22 6 0 5 0 0 0 0 1 110010098111003 7 708 708 7 psa_1 7D3
484 484 1000000US110010104001005 Block 1005, Block Group 1, Census Tract 104, District of Columbia, District of Columbia 45 0 44 0 0 0 0 1 45 41 0 41 0 0 0 0 0 4 0 3 0 0 0 0 1 110010104001005 7 705 705 7 psa_3 7D2
622 622 1000000US110010075031010 Block 1010, Block Group 1, Census Tract 75.03, District of Columbia, District of Columbia 67 6 59 0 0 0 1 1 67 66 6 59 0 0 0 1 0 1 0 0 0 0 0 0 1 110010075031010 7 701 701 7 psa_9 7D1
1024 1024 1000000US110010098102001 Block 2001, Block Group 2, Census Tract 98.10, District of Columbia, District of Columbia 80 2 74 0 0 0 2 2 80 77 2 74 0 0 0 0 1 3 0 0 0 0 0 2 1 110010098102001 7 708 708 7 psa_1 7D3
1171 1171 1000000US110010097001015 Block 1015, Block Group 1, Census Tract 97, District of Columbia, District of Columbia 172 0 170 0 0 0 0 2 172 171 0 170 0 0 0 0 1 1 0 0 0 0 0 0 1 110010097001015 7 706 706 7 psa_2 7D3
1211 1211 1000000US110010075041009 Block 1009, Block Group 1, Census Tract 75.04, District of Columbia, District of Columbia 165 2 153 0 0 0 0 10 165 164 2 153 0 0 0 0 9 1 0 0 0 0 0 0 1 110010075041009 7 701 701 7 psa_9 7D1
1239 1239 1000000US110010098022002 Block 2002, Block Group 2, Census Tract 98.02, District of Columbia, District of Columbia 118 2 114 0 0 0 0 2 118 116 2 113 0 0 0 0 1 2 0 1 0 0 0 0 1 110010098022002 7 706 706 7 psa_2 7D3
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
2149 2149 1000000US110010073043003 Block 3003, Block Group 3, Census Tract 73.04, District of Columbia, District of Columbia 254 3 243 1 0 0 0 7 254 250 3 240 1 0 0 0 6 4 0 3 0 0 0 0 1 110010073043003 7 705 705 7 psa_3 7D2
2161 2161 1000000US110010074092004 Block 2004, Block Group 2, Census Tract 74.09, District of Columbia, District of Columbia 177 2 169 0 0 0 4 2 177 168 2 165 0 0 0 0 1 9 0 4 0 0 0 4 1 110010074092004 7 704 704 7 psa_5 7D2
2288 2288 1000000US110010098072001 Block 2001, Block Group 2, Census Tract 98.07, District of Columbia, District of Columbia 252 7 234 1 3 0 3 4 252 245 7 232 0 3 0 0 3 7 0 2 1 0 0 3 1 110010098072001 7 708 708 7 psa_1 7D3
2365 2365 1000000US110010104002040 Block 2040, Block Group 2, Census Tract 104, District of Columbia, District of Columbia 157 2 150 0 0 0 0 5 157 155 1 150 0 0 0 0 4 2 1 0 0 0 0 0 1 110010104002040 7 707 707 7 psa_4 7D2
3027 3027 1000000US110010098011013 Block 1013, Block Group 1, Census Tract 98.01, District of Columbia, District of Columbia 214 5 206 1 0 0 0 2 214 206 3 201 1 0 0 0 1 8 2 5 0 0 0 0 1 110010098011013 7 706 706 7 psa_2 7D3
3064 3064 1000000US110010073011035 Block 1035, Block Group 1, Census Tract 73.01, District of Columbia, District of Columbia 31 17 4 0 0 0 0 10 31 27 14 4 0 0 0 0 9 4 3 0 0 0 0 0 1 110010073011035 7 707 707 7 psa_4 7D2
3348 3348 1000000US110010074093003 Block 3003, Block Group 3, Census Tract 74.09, District of Columbia, District of Columbia 361 0 358 1 0 0 0 2 361 359 0 357 1 0 0 0 1 2 0 1 0 0 0 0 1 110010074093003 7 704 704 7 psa_5 7D2
3707 3707 1000000US110010074011035 Block 1035, Block Group 1, Census Tract 74.01, District of Columbia, District of Columbia 80 0 78 0 0 0 0 2 80 78 0 77 0 0 0 0 1 2 0 1 0 0 0 0 1 110010074011035 7 703 703 7 psa_8 7D1
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
3894 3894 1000000US110010098033005 Block 3005, Block Group 3, Census Tract 98.03, District of Columbia, District of Columbia 202 7 190 0 0 0 0 5 202 200 7 189 0 0 0 0 4 2 0 1 0 0 0 0 1 110010098033005 7 707 707 7 psa_4 7D2
3913 3913 1000000US110010098032005 Block 2005, Block Group 2, Census Tract 98.03, District of Columbia, District of Columbia 272 5 252 3 2 0 2 8 272 261 3 246 3 2 0 0 7 11 2 6 0 0 0 2 1 110010098032005 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
4212 4212 1000000US110010074041008 Block 1008, Block Group 1, Census Tract 74.04, District of Columbia, District of Columbia 118 1 114 0 0 0 2 1 118 110 1 109 0 0 0 0 0 8 0 5 0 0 0 2 1 110010074041008 7 704 704 7 psa_5 7D2
4694 4694 1000000US110010073041004 Block 1004, Block Group 1, Census Tract 73.04, District of Columbia, District of Columbia 230 4 221 0 0 0 0 5 230 227 4 219 0 0 0 0 4 3 0 2 0 0 0 0 1 110010073041004 7 705 705 7 psa_3 7D2
5470 5470 1000000US110010098033001 Block 3001, Block Group 3, Census Tract 98.03, District of Columbia, District of Columbia 359 3 349 2 1 0 0 4 359 358 3 349 2 1 0 0 3 1 0 0 0 0 0 0 1 110010098033001 7 707 707 7 psa_4 7D2
5671 5671 1000000US110010075041005 Block 1005, Block Group 1, Census Tract 75.04, District of Columbia, District of Columbia 278 1 276 0 0 0 0 1 278 276 0 276 0 0 0 0 0 2 1 0 0 0 0 0 1 110010075041005 7 701 701 7 psa_9 7D1
5883 5883 1000000US110010098072000 Block 2000, Block Group 2, Census Tract 98.07, District of Columbia, District of Columbia 408 23 367 2 0 0 2 14 408 379 6 358 2 0 0 0 13 29 17 9 0 0 0 2 1 110010098072000 7 708 708 7 psa_1 7D3
6345 6345 1000000US110010075041007 Block 1007, Block Group 1, Census Tract 75.04, District of Columbia, District of Columbia 102 3 97 0 0 0 0 2 102 101 3 97 0 0 0 0 1 1 0 0 0 0 0 0 1 110010075041007 7 701 701 7 psa_9 7D1
6481 6481 1000000US110010098112001 Block 2001, Block Group 2, Census Tract 98.11, District of Columbia, District of Columbia 314 0 310 2 0 0 0 2 314 311 0 308 2 0 0 0 1 3 0 2 0 0 0 0 1 110010098112001 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
);