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

21 rows where P005005 = 1 and SECTOR = "5D3" sorted by NAME_x

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003002, P003004, P003005, P003006, P003007, P003008, P005003, P005004, P005006, P005007, P005008, P005009, P005010, P005011, P005012, P005013, P005016, P005017, PSA, NAME, GIS_ID

SECTOR ✖

  • 5D3 · 21 ✖

P005005 ✖

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
5363 5363 1000000US110010079011001 Block 1001, Block Group 1, Census Tract 79.01, District of Columbia, District of Columbia 291 0 282 1 0 0 0 8 291 287 0 281 1 0 0 0 5 4 0 1 0 0 0 0 3 110010079011001 5 507 507 5 psa_23 5D3
2994 2994 1000000US110010088031002 Block 1002, Block Group 1, Census Tract 88.03, District of Columbia, District of Columbia 154 10 132 1 4 1 4 2 154 143 5 129 1 4 1 1 2 11 5 3 0 0 0 3 0 110010088031002 5 506 506 5 psa_26 5D3
1639 1639 1000000US110010089031002 Block 1002, Block Group 1, Census Tract 89.03, District of Columbia, District of Columbia 129 3 117 2 2 0 4 1 129 123 3 116 1 2 0 0 1 6 0 1 1 0 0 4 0 110010089031002 5 507 507 5 psa_23 5D3
6418 6418 1000000US110010079031003 Block 1003, Block Group 1, Census Tract 79.03, District of Columbia, District of Columbia 191 30 155 1 1 0 3 1 191 171 18 149 1 1 0 1 1 20 12 6 0 0 0 2 0 110010079031003 5 507 507 5 psa_23 5D3
1360 1360 1000000US110010088041005 Block 1005, Block Group 1, Census Tract 88.04, District of Columbia, District of Columbia 186 4 173 1 0 0 7 1 186 179 4 173 1 0 0 0 1 7 0 0 0 0 0 7 0 110010088041005 5 506 506 5 psa_26 5D3
5263 5263 1000000US110010089041006 Block 1006, Block Group 1, Census Tract 89.04, District of Columbia, District of Columbia 94 0 85 1 3 0 4 1 94 90 0 85 1 3 0 0 1 4 0 0 0 0 0 4 0 110010089041006 5 507 507 5 psa_23 5D3
815 815 1000000US110010089031009 Block 1009, Block Group 1, Census Tract 89.03, District of Columbia, District of Columbia 164 6 157 1 0 0 0 0 164 159 1 157 1 0 0 0 0 5 5 0 0 0 0 0 0 110010089031009 5 507 507 5 psa_23 5D3
1734 1734 1000000US110010088031013 Block 1013, Block Group 1, Census Tract 88.03, District of Columbia, District of Columbia 82 2 71 1 0 0 8 0 82 74 2 71 1 0 0 0 0 8 0 0 0 0 0 8 0 110010088031013 5 506 506 5 psa_26 5D3
4723 4723 1000000US110010088031014 Block 1014, Block Group 1, Census Tract 88.03, District of Columbia, District of Columbia 84 2 78 1 1 0 0 2 84 84 2 78 1 1 0 0 2 0 0 0 0 0 0 0 0 110010088031014 5 506 506 5 psa_26 5D3
1974 1974 1000000US110010079031016 Block 1016, Block Group 1, Census Tract 79.03, District of Columbia, District of Columbia 125 8 113 1 0 0 1 2 125 124 8 113 1 0 0 0 2 1 0 0 0 0 0 1 0 110010079031016 5 507 507 5 psa_23 5D3
1142 1142 1000000US110010079012001 Block 2001, Block Group 2, Census Tract 79.01, District of Columbia, District of Columbia 127 16 102 1 0 0 0 8 127 125 14 102 1 0 0 0 8 2 2 0 0 0 0 0 0 110010079012001 5 507 507 5 psa_23 5D3
6426 6426 1000000US110010079012002 Block 2002, Block Group 2, Census Tract 79.01, District of Columbia, District of Columbia 113 4 96 1 1 0 6 5 113 107 4 96 1 1 0 0 5 6 0 0 0 0 0 6 0 110010079012002 5 507 507 5 psa_23 5D3
4789 4789 1000000US110010089032002 Block 2002, Block Group 2, Census Tract 89.03, District of Columbia, District of Columbia 658 1 644 1 0 0 4 8 658 654 1 641 1 0 0 3 8 4 0 3 0 0 0 1 0 110010089032002 5 507 507 5 psa_23 5D3
4559 4559 1000000US110010079012005 Block 2005, Block Group 2, Census Tract 79.01, District of Columbia, District of Columbia 124 33 88 1 1 0 0 1 124 117 26 88 1 1 0 0 1 7 7 0 0 0 0 0 0 110010079012005 5 507 507 5 psa_23 5D3
4640 4640 1000000US110010089042005 Block 2005, Block Group 2, Census Tract 89.04, District of Columbia, District of Columbia 90 1 87 1 0 0 0 1 90 86 0 85 1 0 0 0 0 4 1 2 0 0 0 0 1 110010089042005 5 507 507 5 psa_23 5D3
3995 3995 1000000US110010089042006 Block 2006, Block Group 2, Census Tract 89.04, District of Columbia, District of Columbia 146 3 138 1 0 0 4 0 146 142 3 138 1 0 0 0 0 4 0 0 0 0 0 4 0 110010089042006 5 507 507 5 psa_23 5D3
5820 5820 1000000US110010088022008 Block 2008, Block Group 2, Census Tract 88.02, District of Columbia, District of Columbia 200 8 187 1 1 0 0 3 200 198 8 185 1 1 0 0 3 2 0 2 0 0 0 0 0 110010088022008 5 506 506 5 psa_26 5D3
236 236 1000000US110010088042011 Block 2011, Block Group 2, Census Tract 88.04, District of Columbia, District of Columbia 296 13 269 1 1 0 6 6 296 289 13 268 1 1 0 0 6 7 0 1 0 0 0 6 0 110010088042011 5 506 506 5 psa_26 5D3
4424 4424 1000000US110010088042012 Block 2012, Block Group 2, Census Tract 88.04, District of Columbia, District of Columbia 201 10 179 1 0 0 4 7 201 197 10 179 1 0 0 0 7 4 0 0 0 0 0 4 0 110010088042012 5 506 506 5 psa_26 5D3
4029 4029 1000000US110010088023001 Block 3001, Block Group 3, Census Tract 88.02, District of Columbia, District of Columbia 223 17 188 1 6 0 5 6 223 211 14 187 1 6 0 0 3 12 3 1 0 0 0 5 3 110010088023001 5 506 506 5 psa_26 5D3
1905 1905 1000000US110010088024001 Block 4001, Block Group 4, Census Tract 88.02, District of Columbia, District of Columbia 168 7 145 2 4 0 0 10 168 147 3 138 1 4 0 0 1 21 4 7 1 0 0 0 9 110010088024001 5 506 506 5 psa_26 5D3

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