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

10 rows where P005006 = 4 and SECTOR = "3D2"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003002, P003004, P003007, P003008, P005005, P005008, P005009, P005010, P005011, P005012, P005013, P005016, P005017, PSA, GIS_ID

NAME ✖

SECTOR ✖

  • 3D2 · 10 ✖

P005006 ✖

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
557 557 1000000US110010034002000 Block 2000, Block Group 2, Census Tract 34, District of Columbia, District of Columbia 1191 6 1125 2 4 0 7 47 1191 1146 6 1086 2 4 0 4 44 45 0 39 0 0 0 3 3 110010034002000 3 306 306 3 psa_38 3D2
629 629 1000000US110010046001000 Block 1000, Block Group 1, Census Tract 46, District of Columbia, District of Columbia 204 51 138 0 4 0 4 7 204 194 50 136 0 4 0 0 4 10 1 2 0 0 0 4 3 110010046001000 3 308 308 3 psa_27 3D2
911 911 1000000US110010033013001 Block 3001, Block Group 3, Census Tract 33.01, District of Columbia, District of Columbia 147 25 110 0 4 0 3 5 147 139 21 109 0 4 0 1 4 8 4 1 0 0 0 2 1 110010033013001 3 306 306 3 psa_38 3D2
1535 1535 1000000US110010046002018 Block 2018, Block Group 2, Census Tract 46, District of Columbia, District of Columbia 86 37 37 0 4 0 4 4 86 81 33 37 0 4 0 3 4 5 4 0 0 0 0 1 0 110010046002018 3 308 308 3 psa_27 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
3769 3769 1000000US110010048011014 Block 1014, Block Group 1, Census Tract 48.01, District of Columbia, District of Columbia 134 43 46 1 4 0 23 17 134 108 43 46 1 4 0 0 14 26 0 0 0 0 0 23 3 110010048011014 3 308 308 3 psa_27 3D2
4711 4711 1000000US110010048011005 Block 1005, Block Group 1, Census Tract 48.01, District of Columbia, District of Columbia 232 48 154 3 4 0 18 5 232 211 44 154 1 4 0 3 5 21 4 0 2 0 0 15 0 110010048011005 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
5115 5115 1000000US110010033022001 Block 2001, Block Group 2, Census Tract 33.02, District of Columbia, District of Columbia 261 99 140 0 4 0 0 18 261 258 96 140 0 4 0 0 18 3 3 0 0 0 0 0 0 110010033022001 3 308 308 3 psa_27 3D2
5863 5863 1000000US110010044001005 Block 1005, Block Group 1, Census Tract 44, District of Columbia, District of Columbia 69 43 17 0 4 0 0 5 69 63 39 15 0 4 0 0 5 6 4 2 0 0 0 0 0 110010044001005 3 305 305 3 psa_32 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
);