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

15 rows where P003007 = 2 and SECTOR = "3D2" sorted by DISTRICT

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003002, P003004, P003005, P003008, P005005, P005006, P005008, P005009, P005010, P005011, P005012, P005013, P005014, P005016, P005017, PSA, NAME, GIS_ID

SECTOR ✖

  • 3D2 · 15 ✖

P003007 ✖

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
15 15 1000000US110010044002012 Block 2012, Block Group 2, Census Tract 44, District of Columbia, District of Columbia 34 22 8 0 0 0 2 2 34 31 20 8 0 0 0 1 2 3 2 0 0 0 0 1 0 110010044002012 3 305 305 3 psa_32 3D2
997 997 1000000US110010035002004 Block 2004, Block Group 2, Census Tract 35, District of Columbia, District of Columbia 828 64 713 3 12 0 2 34 828 802 59 698 3 12 0 0 30 26 5 15 0 0 0 2 4 110010035002004 3 305 305 3 psa_32 3D2
1369 1369 1000000US110010033012001 Block 2001, Block Group 2, Census Tract 33.01, District of Columbia, District of Columbia 293 117 155 1 7 0 2 11 293 273 110 150 0 7 0 0 6 20 7 5 1 0 0 2 5 110010033012001 3 306 306 3 psa_38 3D2
1896 1896 1000000US110010046002001 Block 2001, Block Group 2, Census Tract 46, District of Columbia, District of Columbia 105 47 47 0 4 0 2 5 105 76 27 41 0 4 0 0 4 29 20 6 0 0 0 2 1 110010046002001 3 308 308 3 psa_27 3D2
2617 2617 1000000US110010048011010 Block 1010, Block Group 1, Census Tract 48.01, District of Columbia, District of Columbia 29 9 17 0 0 0 2 1 29 27 9 17 0 0 0 0 1 2 0 0 0 0 0 2 0 110010048011010 3 308 308 3 psa_27 3D2
3105 3105 1000000US110010033013002 Block 3002, Block Group 3, Census Tract 33.01, District of Columbia, District of Columbia 161 47 106 0 0 0 2 6 161 157 44 106 0 0 0 2 5 4 3 0 0 0 0 0 1 110010033013002 3 306 306 3 psa_38 3D2
3472 3472 1000000US110010044002000 Block 2000, Block Group 2, Census Tract 44, District of Columbia, District of Columbia 10 6 1 0 0 0 2 1 10 5 3 1 0 0 0 1 0 5 3 0 0 0 0 1 1 110010044002000 3 305 305 3 psa_32 3D2
3639 3639 1000000US110010044001015 Block 1015, Block Group 1, Census Tract 44, District of Columbia, District of Columbia 224 166 36 1 17 0 2 2 224 213 158 35 1 17 0 0 2 11 8 1 0 0 0 2 0 110010044001015 3 305 305 3 psa_32 3D2
4174 4174 1000000US110010034002012 Block 2012, Block Group 2, Census Tract 34, District of Columbia, District of Columbia 64 16 40 0 0 0 2 6 64 63 16 40 0 0 0 2 5 1 0 0 0 0 0 0 1 110010034002012 3 306 306 3 psa_38 3D2
4839 4839 1000000US110010046001005 Block 1005, Block Group 1, Census Tract 46, District of Columbia, District of Columbia 144 32 98 1 9 0 2 2 144 142 32 98 1 9 0 0 2 2 0 0 0 0 0 2 0 110010046001005 3 308 308 3 psa_27 3D2
4848 4848 1000000US110010034002016 Block 2016, Block Group 2, Census Tract 34, District of Columbia, District of Columbia 63 7 45 0 4 0 2 5 63 60 7 45 0 4 0 1 3 3 0 0 0 0 0 1 2 110010034002016 3 306 306 3 psa_38 3D2
5067 5067 1000000US110010046002015 Block 2015, Block Group 2, Census Tract 46, District of Columbia, District of Columbia 219 37 167 0 3 0 2 10 219 203 34 161 0 2 0 1 5 16 3 6 0 1 0 1 5 110010046002015 3 308 308 3 psa_27 3D2
6093 6093 1000000US110010044001007 Block 1007, Block Group 1, Census Tract 44, District of Columbia, District of Columbia 94 77 7 1 7 0 2 0 94 90 75 7 1 7 0 0 0 4 2 0 0 0 0 2 0 110010044001007 3 305 305 3 psa_32 3D2
6176 6176 1000000US110010033013005 Block 3005, Block Group 3, Census Tract 33.01, District of Columbia, District of Columbia 177 93 66 0 13 0 2 3 177 170 88 65 0 13 0 1 3 7 5 1 0 0 0 1 0 110010033013005 3 306 306 3 psa_38 3D2
6381 6381 1000000US110010048011009 Block 1009, Block Group 1, Census Tract 48.01, District of Columbia, District of Columbia 58 39 13 0 0 0 2 4 58 53 38 13 0 0 0 0 2 5 1 0 0 0 0 2 2 110010048011009 3 308 308 3 psa_27 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
);