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

111 rows where P005012 = 4 sorted by NAME_x

✎ View and edit SQL

This data as json, CSV (advanced)

P005012 ✖

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
6435 6435 1000000US110010002024002 Block 4002, Block Group 4, Census Tract 2.02, District of Columbia, District of Columbia 400 308 25 0 46 0 5 16 400 363 283 21 0 45 0 0 14 37 25 4 0 1 0 5 2 110010002024002 2 206 206 2 psa_29 2D2
1291 1291 1000000US110010024004003 Block 4003, Block Group 4, Census Tract 24, District of Columbia, District of Columbia 188 58 99 5 0 0 25 1 188 122 26 95 0 0 0 0 1 66 32 4 5 0 0 25 0 110010024004003 4 407 407 4 psa_47 4D2
2478 2478 1000000US110010032004003 Block 4003, Block Group 4, Census Tract 32, District of Columbia, District of Columbia 149 30 103 0 7 0 4 5 149 128 18 99 0 7 0 0 4 21 12 4 0 0 0 4 1 110010032004003 4 409 409 4 psa_41 4D3
1867 1867 1000000US110010024004008 Block 4008, Block Group 4, Census Tract 24, District of Columbia, District of Columbia 124 14 107 0 0 0 2 1 124 117 14 103 0 0 0 0 0 7 0 4 0 0 0 2 1 110010024004008 4 407 407 4 psa_47 4D2
5326 5326 1000000US110010019014009 Block 4009, Block Group 4, Census Tract 19.01, District of Columbia, District of Columbia 91 4 73 0 0 0 11 3 91 74 3 69 0 0 0 0 2 17 1 4 0 0 0 11 1 110010019014009 4 402 402 4 psa_53 4D1
5359 5359 1000000US110010021024009 Block 4009, Block Group 4, Census Tract 21.02, District of Columbia, District of Columbia 281 30 199 0 1 0 42 9 281 209 10 195 0 1 0 0 3 72 20 4 0 0 0 42 6 110010021024009 4 403 403 4 psa_51 4D1
1476 1476 1000000US110010032004010 Block 4010, Block Group 4, Census Tract 32, District of Columbia, District of Columbia 117 13 86 1 17 0 0 0 117 113 13 82 1 17 0 0 0 4 0 4 0 0 0 0 0 110010032004010 3 306 306 3 psa_38 3D2
3835 3835 1000000US110010021015000 Block 5000, Block Group 5, Census Tract 21.01, District of Columbia, District of Columbia 193 17 145 1 11 0 16 3 193 156 1 141 0 11 0 0 3 37 16 4 1 0 0 16 0 110010021015000 4 403 403 4 psa_51 4D1
1136 1136 1000000US110010021025000 Block 5000, Block Group 5, Census Tract 21.02, District of Columbia, District of Columbia 124 23 95 5 0 0 1 0 124 110 14 91 5 0 0 0 0 14 9 4 0 0 0 1 0 110010021025000 4 403 403 4 psa_51 4D1
4688 4688 1000000US110010076015017 Block 5017, Block Group 5, Census Tract 76.01, District of Columbia, District of Columbia 128 0 120 0 0 0 1 7 128 122 0 116 0 0 0 1 5 6 0 4 0 0 0 0 2 110010076015017 6 607 607 6 psa_10 6D2
5662 5662 1000000US110010076015019 Block 5019, Block Group 5, Census Tract 76.01, District of Columbia, District of Columbia 158 1 157 0 0 0 0 0 158 154 1 153 0 0 0 0 0 4 0 4 0 0 0 0 0 110010076015019 6 607 607 6 psa_10 6D2

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