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

36 rows where P005012 = 2 and POLDIST_ID = 6

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003002, P003004, P003005, P003006, P003007, P003008, P005003, P005005, P005006, P005007, P005008, P005009, P005010, P005011, P005013, 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
300 300 1000000US110010096032009 Block 2009, Block Group 2, Census Tract 96.03, District of Columbia, District of Columbia 89 0 88 0 0 0 0 1 89 87 0 86 0 0 0 0 1 2 0 2 0 0 0 0 0 110010096032009 6 603 603 6 psa_15 6D3
642 642 1000000US110010099061008 Block 1008, Block Group 1, Census Tract 99.06, District of Columbia, District of Columbia 165 2 159 0 0 0 0 4 165 161 2 157 0 0 0 0 2 4 0 2 0 0 0 0 2 110010099061008 6 604 604 6 psa_14 6D3
789 789 1000000US110010099071003 Block 1003, Block Group 1, Census Tract 99.07, District of Columbia, District of Columbia 52 0 51 1 0 0 0 0 52 49 0 49 0 0 0 0 0 3 0 2 1 0 0 0 0 110010099071003 6 605 605 6 psa_11 6D2
811 811 1000000US110010076014010 Block 4010, Block Group 4, Census Tract 76.01, District of Columbia, District of Columbia 83 0 81 0 0 0 0 2 83 81 0 79 0 0 0 0 2 2 0 2 0 0 0 0 0 110010076014010 6 607 607 6 psa_10 6D2
888 888 1000000US110010076042032 Block 2032, Block Group 2, Census Tract 76.04, District of Columbia, District of Columbia 71 5 65 0 0 0 0 1 71 69 5 63 0 0 0 0 1 2 0 2 0 0 0 0 0 110010076042032 6 606 606 6 psa_7 6D2
901 901 1000000US110010076015021 Block 5021, Block Group 5, Census Tract 76.01, District of Columbia, District of Columbia 43 0 43 0 0 0 0 0 43 41 0 41 0 0 0 0 0 2 0 2 0 0 0 0 0 110010076015021 6 607 607 6 psa_10 6D2
1268 1268 1000000US110010099012024 Block 2024, Block Group 2, Census Tract 99.01, District of Columbia, District of Columbia 47 5 39 0 0 0 2 1 47 42 4 37 0 0 0 0 1 5 1 2 0 0 0 2 0 110010099012024 6 605 605 6 psa_11 6D2
1353 1353 1000000US110010078061001 Block 1001, Block Group 1, Census Tract 78.06, District of Columbia, District of Columbia 146 0 142 0 0 0 4 0 146 140 0 140 0 0 0 0 0 6 0 2 0 0 0 4 0 110010078061001 6 602 602 6 psa_25 6D1
1418 1418 1000000US110010099061007 Block 1007, Block Group 1, Census Tract 99.06, District of Columbia, District of Columbia 349 7 333 0 2 0 1 6 349 342 4 331 0 2 0 0 5 7 3 2 0 0 0 1 1 110010099061007 6 604 604 6 psa_14 6D3
1431 1431 1000000US110010099041004 Block 1004, Block Group 1, Census Tract 99.04, District of Columbia, District of Columbia 48 1 47 0 0 0 0 0 48 46 1 45 0 0 0 0 0 2 0 2 0 0 0 0 0 110010099041004 6 604 604 6 psa_14 6D3
1665 1665 1000000US110010099021013 Block 1013, Block Group 1, Census Tract 99.02, District of Columbia, District of Columbia 73 0 73 0 0 0 0 0 73 71 0 71 0 0 0 0 0 2 0 2 0 0 0 0 0 110010099021013 6 605 605 6 psa_11 6D2
2058 2058 1000000US110010099053004 Block 3004, Block Group 3, Census Tract 99.05, District of Columbia, District of Columbia 227 0 218 0 0 0 0 9 227 225 0 216 0 0 0 0 9 2 0 2 0 0 0 0 0 110010099053004 6 604 604 6 psa_14 6D3
2073 2073 1000000US110010078072001 Block 2001, Block Group 2, Census Tract 78.07, District of Columbia, District of Columbia 91 0 91 0 0 0 0 0 91 89 0 89 0 0 0 0 0 2 0 2 0 0 0 0 0 110010078072001 6 608 608 6 psa_19 6D1
2522 2522 1000000US110010099021016 Block 1016, Block Group 1, Census Tract 99.02, District of Columbia, District of Columbia 80 1 77 0 0 0 0 2 80 78 1 75 0 0 0 0 2 2 0 2 0 0 0 0 0 110010099021016 6 605 605 6 psa_11 6D2
2530 2530 1000000US110010076013002 Block 3002, Block Group 3, Census Tract 76.01, District of Columbia, District of Columbia 368 1 360 0 2 0 1 4 368 366 1 358 0 2 0 1 4 2 0 2 0 0 0 0 0 110010076013002 6 607 607 6 psa_10 6D2
2865 2865 1000000US110010099052004 Block 2004, Block Group 2, Census Tract 99.05, District of Columbia, District of Columbia 191 0 183 0 0 0 8 0 191 182 0 181 0 0 0 1 0 9 0 2 0 0 0 7 0 110010099052004 6 604 604 6 psa_14 6D3
2967 2967 1000000US110010099052000 Block 2000, Block Group 2, Census Tract 99.05, District of Columbia, District of Columbia 214 5 206 0 0 0 0 3 214 212 5 204 0 0 0 0 3 2 0 2 0 0 0 0 0 110010099052000 6 604 604 6 psa_14 6D3
3032 3032 1000000US110010099042002 Block 2002, Block Group 2, Census Tract 99.04, District of Columbia, District of Columbia 96 1 89 0 0 0 0 6 96 90 1 87 0 0 0 0 2 6 0 2 0 0 0 0 4 110010099042002 6 604 604 6 psa_14 6D3
3494 3494 1000000US110010076041007 Block 1007, Block Group 1, Census Tract 76.04, District of Columbia, District of Columbia 41 1 40 0 0 0 0 0 41 39 1 38 0 0 0 0 0 2 0 2 0 0 0 0 0 110010076041007 6 607 607 6 psa_10 6D2
3568 3568 1000000US110010077082011 Block 2011, Block Group 2, Census Tract 77.08, District of Columbia, District of Columbia 120 3 114 0 0 0 0 3 120 118 3 112 0 0 0 0 3 2 0 2 0 0 0 0 0 110010077082011 6 603 603 6 psa_15 6D3
3583 3583 1000000US110010078043001 Block 3001, Block Group 3, Census Tract 78.04, District of Columbia, District of Columbia 35 0 34 0 0 0 0 1 35 32 0 32 0 0 0 0 0 3 0 2 0 0 0 0 1 110010078043001 6 602 602 6 psa_25 6D1
3782 3782 1000000US110010076031001 Block 1001, Block Group 1, Census Tract 76.03, District of Columbia, District of Columbia 92 2 88 0 0 0 2 0 92 87 1 86 0 0 0 0 0 5 1 2 0 0 0 2 0 110010076031001 6 606 606 6 psa_7 6D2
3855 3855 1000000US110010078092011 Block 2011, Block Group 2, Census Tract 78.09, District of Columbia, District of Columbia 84 2 82 0 0 0 0 0 84 82 2 80 0 0 0 0 0 2 0 2 0 0 0 0 0 110010078092011 6 602 602 6 psa_25 6D1
4386 4386 1000000US110010076011004 Block 1004, Block Group 1, Census Tract 76.01, District of Columbia, District of Columbia 272 10 251 2 1 0 0 8 272 269 10 249 2 1 0 0 7 3 0 2 0 0 0 0 1 110010076011004 6 607 607 6 psa_10 6D2
4600 4600 1000000US110010076041009 Block 1009, Block Group 1, Census Tract 76.04, District of Columbia, District of Columbia 236 7 227 0 1 0 0 1 236 233 6 225 0 1 0 0 1 3 1 2 0 0 0 0 0 110010076041009 6 607 607 6 psa_10 6D2
4679 4679 1000000US110010096041002 Block 1002, Block Group 1, Census Tract 96.04, District of Columbia, District of Columbia 154 0 154 0 0 0 0 0 154 152 0 152 0 0 0 0 0 2 0 2 0 0 0 0 0 110010096041002 6 603 603 6 psa_15 6D3
5006 5006 1000000US110010077082008 Block 2008, Block Group 2, Census Tract 77.08, District of Columbia, District of Columbia 56 0 56 0 0 0 0 0 56 54 0 54 0 0 0 0 0 2 0 2 0 0 0 0 0 110010077082008 6 603 603 6 psa_15 6D3
5011 5011 1000000US110010077034003 Block 4003, Block Group 4, Census Tract 77.03, District of Columbia, District of Columbia 439 8 424 0 0 0 1 6 439 432 6 422 0 0 0 0 4 7 2 2 0 0 0 1 2 110010077034003 6 603 603 6 psa_15 6D3
5255 5255 1000000US110010099071000 Block 1000, Block Group 1, Census Tract 99.07, District of Columbia, District of Columbia 374 0 364 0 0 0 0 10 374 372 0 362 0 0 0 0 10 2 0 2 0 0 0 0 0 110010099071000 6 604 604 6 psa_14 6D3
5377 5377 1000000US110010096042005 Block 2005, Block Group 2, Census Tract 96.04, District of Columbia, District of Columbia 161 1 152 0 0 0 2 6 161 151 1 150 0 0 0 0 0 10 0 2 0 0 0 2 6 110010096042005 6 603 603 6 psa_15 6D3
5469 5469 1000000US110010077091013 Block 1013, Block Group 1, Census Tract 77.09, District of Columbia, District of Columbia 66 0 65 1 0 0 0 0 66 64 0 63 1 0 0 0 0 2 0 2 0 0 0 0 0 110010077091013 6 605 605 6 psa_11 6D2
5697 5697 1000000US110010099061005 Block 1005, Block Group 1, Census Tract 99.06, District of Columbia, District of Columbia 161 0 149 2 1 0 0 9 161 156 0 147 0 1 0 0 8 5 0 2 2 0 0 0 1 110010099061005 6 604 604 6 psa_14 6D3
5768 5768 1000000US110010076051006 Block 1006, Block Group 1, Census Tract 76.05, District of Columbia, District of Columbia 151 5 141 0 1 0 0 4 151 149 5 139 0 1 0 0 4 2 0 2 0 0 0 0 0 110010076051006 6 607 607 6 psa_10 6D2
5843 5843 1000000US110010099053002 Block 3002, Block Group 3, Census Tract 99.05, District of Columbia, District of Columbia 118 4 106 0 0 1 2 5 118 114 4 104 0 0 1 0 5 4 0 2 0 0 0 2 0 110010099053002 6 604 604 6 psa_14 6D3
6061 6061 1000000US110010078041000 Block 1000, Block Group 1, Census Tract 78.04, District of Columbia, District of Columbia 202 2 199 0 0 0 1 0 202 199 2 197 0 0 0 0 0 3 0 2 0 0 0 1 0 110010078041000 6 602 602 6 psa_25 6D1
6417 6417 1000000US110010077032008 Block 2008, Block Group 2, Census Tract 77.03, District of Columbia, District of Columbia 147 0 146 0 0 0 0 1 147 145 0 144 0 0 0 0 1 2 0 2 0 0 0 0 0 110010077032008 6 603 603 6 psa_15 6D3

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