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

25 rows where P005008 = 0 and P005017 = 5

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003001, P003002, P003003, P003004, P003005, P003006, P003007, P003008, P005001, P005003, P005004, P005005, P005006, P005009, P005010, P005011, P005012, P005013, P005014, P005016, DISTRICT, PSA, NAME, POLDIST_ID, GIS_ID, SECTOR

P005007 ✖

P005017 ✖

P005008 ✖

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
149 149 1000000US110010074043000 Block 3000, Block Group 3, Census Tract 74.04, District of Columbia, District of Columbia 296 2 279 0 0 0 5 10 296 286 2 279 0 0 0 0 5 10 0 0 0 0 0 5 5 110010074043000 7 704 704 7 psa_5 7D2
186 186 1000000US110010077082017 Block 2017, Block Group 2, Census Tract 77.08, District of Columbia, District of Columbia 49 2 42 0 0 0 0 5 49 39 0 39 0 0 0 0 0 10 2 3 0 0 0 0 5 110010077082017 6 605 605 6 psa_11 6D2
239 239 1000000US110010090001002 Block 1002, Block Group 1, Census Tract 90, District of Columbia, District of Columbia 23 1 17 0 0 0 0 5 23 13 1 12 0 0 0 0 0 10 0 5 0 0 0 0 5 110010090001002 5 503 503 5 psa_45 5D2
505 505 1000000US110010109002008 Block 2008, Block Group 2, Census Tract 109, District of Columbia, District of Columbia 1077 47 985 3 10 0 6 26 1077 1054 39 981 3 10 0 0 21 23 8 4 0 0 0 6 5 110010109002008 7 708 708 7 psa_1 7D3
620 620 1000000US110010025024001 Block 4001, Block Group 4, Census Tract 25.02, District of Columbia, District of Columbia 129 47 57 1 5 0 10 9 129 107 43 54 1 5 0 0 4 22 4 3 0 0 0 10 5 110010025024001 4 404 404 4 psa_48 4D3
1150 1150 1000000US110010016002009 Block 2009, Block Group 2, Census Tract 16, District of Columbia, District of Columbia 48 9 26 0 0 0 4 9 48 38 8 26 0 0 0 0 4 10 1 0 0 0 0 4 5 110010016002009 4 401 401 4 psa_56 4D1
1284 1284 1000000US110010093012018 Block 2018, Block Group 2, Census Tract 93.01, District of Columbia, District of Columbia 98 28 60 1 0 0 2 7 98 85 23 59 1 0 0 0 2 13 5 1 0 0 0 2 5 110010093012018 5 504 504 5 psa_43 5D2
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
2216 2216 1000000US110010018043001 Block 3001, Block Group 3, Census Tract 18.04, District of Columbia, District of Columbia 192 31 152 0 0 0 0 9 192 179 27 148 0 0 0 0 4 13 4 4 0 0 0 0 5 110010018043001 4 402 402 4 psa_53 4D1
2249 2249 1000000US110010018031005 Block 1005, Block Group 1, Census Tract 18.03, District of Columbia, District of Columbia 347 41 248 1 4 7 37 9 347 274 12 246 1 4 7 0 4 73 29 2 0 0 0 37 5 110010018031005 4 402 402 4 psa_53 4D1
2371 2371 1000000US110010019021000 Block 1000, Block Group 1, Census Tract 19.02, District of Columbia, District of Columbia 18 5 8 0 0 0 0 5 18 9 1 8 0 0 0 0 0 9 4 0 0 0 0 0 5 110010019021000 4 406 406 4 psa_54 4D2
2598 2598 1000000US110010093021012 Block 1012, Block Group 1, Census Tract 93.02, District of Columbia, District of Columbia 130 23 60 7 0 0 35 5 130 61 2 56 3 0 0 0 0 69 21 4 4 0 0 35 5 110010093021012 5 504 504 5 psa_43 5D2
3111 3111 1000000US110010021025002 Block 5002, Block Group 5, Census Tract 21.02, District of Columbia, District of Columbia 184 13 133 0 0 0 33 5 184 136 4 132 0 0 0 0 0 48 9 1 0 0 0 33 5 110010021025002 4 403 403 4 psa_51 4D1
3148 3148 1000000US110010099051008 Block 1008, Block Group 1, Census Tract 99.05, District of Columbia, District of Columbia 156 0 147 3 0 0 0 6 156 148 0 144 3 0 0 0 1 8 0 3 0 0 0 0 5 110010099051008 6 604 604 6 psa_14 6D3
3577 3577 1000000US110010028012004 Block 2004, Block Group 2, Census Tract 28.01, District of Columbia, District of Columbia 241 53 66 1 0 0 116 5 241 96 31 65 0 0 0 0 0 145 22 1 1 0 0 116 5 110010028012004 4 408 408 4 psa_39 4D3
3732 3732 1000000US110010027011000 Block 1000, Block Group 1, Census Tract 27.01, District of Columbia, District of Columbia 253 182 46 1 14 0 0 10 253 224 159 45 1 14 0 0 5 29 23 1 0 0 0 0 5 110010027011000 3 302 302 3 psa_42 3D1
3954 3954 1000000US110010111003038 Block 3038, Block Group 3, Census Tract 111, District of Columbia, District of Columbia 54 6 43 0 0 0 0 5 54 44 4 40 0 0 0 0 0 10 2 3 0 0 0 0 5 110010111003038 5 503 503 5 psa_45 5D2
4308 4308 1000000US110010019022005 Block 2005, Block Group 2, Census Tract 19.02, District of Columbia, District of Columbia 48 9 31 0 0 0 0 8 48 42 8 31 0 0 0 0 3 6 1 0 0 0 0 0 5 110010019022005 4 406 406 4 psa_54 4D2
4507 4507 1000000US110010073011142 Block 1142, Block Group 1, Census Tract 73.01, District of Columbia, District of Columbia 97 55 16 0 12 0 0 14 97 83 51 14 0 9 0 0 9 14 4 2 0 3 0 0 5 110010073011142 7 707 707 7 psa_4 7D2
4733 4733 1000000US110010095052011 Block 2011, Block Group 2, Census Tract 95.05, District of Columbia, District of Columbia 105 8 80 0 3 0 9 5 105 90 7 80 0 3 0 0 0 15 1 0 0 0 0 9 5 110010095052011 4 406 406 4 psa_54 4D2
4984 4984 1000000US110010078034002 Block 4002, Block Group 4, Census Tract 78.03, District of Columbia, District of Columbia 157 4 148 0 0 0 0 5 157 150 2 148 0 0 0 0 0 7 2 0 0 0 0 0 5 110010078034002 6 602 602 6 psa_25 6D1
5443 5443 1000000US110010099072005 Block 2005, Block Group 2, Census Tract 99.07, District of Columbia, District of Columbia 451 0 430 0 4 1 0 16 451 446 0 430 0 4 1 0 11 5 0 0 0 0 0 0 5 110010099072005 6 604 604 6 psa_14 6D3
6169 6169 1000000US110010075022001 Block 2001, Block Group 2, Census Tract 75.02, District of Columbia, District of Columbia 159 2 146 0 0 0 0 11 159 149 2 141 0 0 0 0 6 10 0 5 0 0 0 0 5 110010075022001 7 702 702 7 psa_6 7D1
6258 6258 1000000US110010029002002 Block 2002, Block Group 2, Census Tract 29, District of Columbia, District of Columbia 178 47 44 6 7 0 69 5 178 75 32 36 0 7 0 0 0 103 15 8 6 0 0 69 5 110010029002002 4 408 408 4 psa_39 4D3
6288 6288 1000000US110010073011138 Block 1138, Block Group 1, Census Tract 73.01, District of Columbia, District of Columbia 64 36 15 1 2 1 0 9 64 55 32 15 1 2 1 0 4 9 4 0 0 0 0 0 5 110010073011138 7 707 707 7 psa_4 7D2

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