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

31 rows where P005012 = 3 and POLDIST_ID = 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, P005007, P005008, P005009, P005010, P005011, P005013, P005016, P005017, PSA, NAME, GIS_ID, SECTOR

POLDIST_ID ✖

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
207 207 1000000US110010079031013 Block 1013, Block Group 1, Census Tract 79.03, District of Columbia, District of Columbia 35 4 29 0 0 0 0 2 35 30 4 26 0 0 0 0 0 5 0 3 0 0 0 0 2 110010079031013 5 507 507 5 psa_23 5D3
243 243 1000000US110010090002002 Block 2002, Block Group 2, Census Tract 90, District of Columbia, District of Columbia 630 7 588 0 0 0 16 19 630 613 6 585 0 0 0 3 19 17 1 3 0 0 0 13 0 110010090002002 5 503 503 5 psa_45 5D2
252 252 1000000US110010094001003 Block 1003, Block Group 1, Census Tract 94, District of Columbia, District of Columbia 58 8 49 1 0 0 0 0 58 54 8 46 0 0 0 0 0 4 0 3 1 0 0 0 0 110010094001003 5 503 503 5 psa_45 5D2
583 583 1000000US110010088021004 Block 1004, Block Group 1, Census Tract 88.02, District of Columbia, District of Columbia 117 4 109 3 0 0 0 1 117 109 2 106 0 0 0 0 1 8 2 3 3 0 0 0 0 110010088021004 5 506 506 5 psa_26 5D3
1109 1109 1000000US110010094003000 Block 3000, Block Group 3, Census Tract 94, District of Columbia, District of Columbia 144 28 83 2 16 0 14 1 144 112 14 80 2 16 0 0 0 32 14 3 0 0 0 14 1 110010094003000 5 503 503 5 psa_45 5D2
1298 1298 1000000US110010079013001 Block 3001, Block Group 3, Census Tract 79.01, District of Columbia, District of Columbia 480 28 421 3 2 0 4 22 480 464 22 418 3 2 0 3 16 16 6 3 0 0 0 1 6 110010079013001 5 507 507 5 psa_23 5D3
1574 1574 1000000US110010088022000 Block 2000, Block Group 2, Census Tract 88.02, District of Columbia, District of Columbia 105 6 93 0 1 0 0 5 105 102 6 90 0 1 0 0 5 3 0 3 0 0 0 0 0 110010088022000 5 506 506 5 psa_26 5D3
1762 1762 1000000US110010111002012 Block 2012, Block Group 2, Census Tract 111, District of Columbia, District of Columbia 69 1 47 0 0 0 21 0 69 45 1 44 0 0 0 0 0 24 0 3 0 0 0 21 0 110010111002012 5 503 503 5 psa_45 5D2
1922 1922 1000000US110010089032000 Block 2000, Block Group 2, Census Tract 89.03, District of Columbia, District of Columbia 162 1 152 0 2 0 3 4 162 154 1 149 0 2 0 0 2 8 0 3 0 0 0 3 2 110010089032000 5 507 507 5 psa_23 5D3
2070 2070 1000000US110010111001003 Block 1003, Block Group 1, Census Tract 111, District of Columbia, District of Columbia 54 1 48 0 0 0 0 5 54 50 1 45 0 0 0 0 4 4 0 3 0 0 0 0 1 110010111001003 5 503 503 5 psa_45 5D2
2138 2138 1000000US110010094002018 Block 2018, Block Group 2, Census Tract 94, District of Columbia, District of Columbia 240 20 174 1 2 0 21 22 240 196 12 171 1 2 0 0 10 44 8 3 0 0 0 21 12 110010094002018 5 504 504 5 psa_43 5D2
2152 2152 1000000US110010093012023 Block 2023, Block Group 2, Census Tract 93.01, District of Columbia, District of Columbia 94 20 69 0 1 0 0 4 94 90 19 66 0 1 0 0 4 4 1 3 0 0 0 0 0 110010093012023 5 504 504 5 psa_43 5D2
2835 2835 1000000US110010088024004 Block 4004, Block Group 4, Census Tract 88.02, District of Columbia, District of Columbia 231 20 200 1 0 0 7 3 231 219 20 197 0 0 0 1 1 12 0 3 1 0 0 6 2 110010088024004 5 506 506 5 psa_26 5D3
2861 2861 1000000US110010106001002 Block 1002, Block Group 1, Census Tract 106, District of Columbia, District of Columbia 163 56 101 0 5 0 0 1 163 160 56 98 0 5 0 0 1 3 0 3 0 0 0 0 0 110010106001002 5 501 501 5 psa_35 5D1
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
3222 3222 1000000US110010088024005 Block 4005, Block Group 4, Census Tract 88.02, District of Columbia, District of Columbia 192 0 182 3 1 0 0 6 192 188 0 179 3 1 0 0 5 4 0 3 0 0 0 0 1 110010088024005 5 506 506 5 psa_26 5D3
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
4037 4037 1000000US110010094001005 Block 1005, Block Group 1, Census Tract 94, District of Columbia, District of Columbia 90 9 69 1 2 0 5 4 90 82 9 66 1 2 0 0 4 8 0 3 0 0 0 5 0 110010094001005 5 503 503 5 psa_45 5D2
4066 4066 1000000US110010092032003 Block 2003, Block Group 2, Census Tract 92.03, District of Columbia, District of Columbia 107 10 86 0 0 0 11 0 107 95 9 83 0 0 0 3 0 12 1 3 0 0 0 8 0 110010092032003 5 502 502 5 psa_40 5D1
4154 4154 1000000US110010087021006 Block 1006, Block Group 1, Census Tract 87.02, District of Columbia, District of Columbia 117 8 99 0 1 0 6 3 117 106 7 96 0 1 0 0 2 11 1 3 0 0 0 6 1 110010087021006 5 502 502 5 psa_40 5D1
4280 4280 1000000US110010093021013 Block 1013, Block Group 1, Census Tract 93.02, District of Columbia, District of Columbia 71 2 62 1 3 0 0 3 71 68 2 59 1 3 0 0 3 3 0 3 0 0 0 0 0 110010093021013 5 504 504 5 psa_43 5D2
4337 4337 1000000US110010111003023 Block 3023, Block Group 3, Census Tract 111, District of Columbia, District of Columbia 261 0 236 0 0 0 1 24 261 249 0 233 0 0 0 0 16 12 0 3 0 0 0 1 8 110010111003023 5 503 503 5 psa_45 5D2
4372 4372 1000000US110010088024000 Block 4000, Block Group 4, Census Tract 88.02, District of Columbia, District of Columbia 268 23 227 0 1 4 4 9 268 250 12 224 0 1 4 0 9 18 11 3 0 0 0 4 0 110010088024000 5 506 506 5 psa_26 5D3
4557 4557 1000000US110010095032007 Block 2007, Block Group 2, Census Tract 95.03, District of Columbia, District of Columbia 84 10 57 0 1 0 4 12 84 75 7 54 0 1 0 1 12 9 3 3 0 0 0 3 0 110010095032007 5 504 504 5 psa_43 5D2
4665 4665 1000000US110010093013005 Block 3005, Block Group 3, Census Tract 93.01, District of Columbia, District of Columbia 45 13 32 0 0 0 0 0 45 39 10 29 0 0 0 0 0 6 3 3 0 0 0 0 0 110010093013005 5 504 504 5 psa_43 5D2
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
5137 5137 1000000US110010093011007 Block 1007, Block Group 1, Census Tract 93.01, District of Columbia, District of Columbia 42 9 30 0 3 0 0 0 42 38 8 27 0 3 0 0 0 4 1 3 0 0 0 0 0 110010093011007 5 504 504 5 psa_43 5D2
5271 5271 1000000US110010111002021 Block 2021, Block Group 2, Census Tract 111, District of Columbia, District of Columbia 29 7 18 0 0 0 3 1 29 25 7 15 0 0 0 2 1 4 0 3 0 0 0 1 0 110010111002021 5 503 503 5 psa_45 5D2
5401 5401 1000000US110010106003003 Block 3003, Block Group 3, Census Tract 106, District of Columbia, District of Columbia 180 53 118 0 4 0 0 5 180 176 52 115 0 4 0 0 5 4 1 3 0 0 0 0 0 110010106003003 5 501 501 5 psa_35 5D1
5455 5455 1000000US110010091021007 Block 1007, Block Group 1, Census Tract 91.02, District of Columbia, District of Columbia 91 4 81 1 3 0 0 2 91 85 1 78 1 3 0 0 2 6 3 3 0 0 0 0 0 110010091021007 5 505 505 5 psa_34 5D2
6064 6064 1000000US110010091021005 Block 1005, Block Group 1, Census Tract 91.02, District of Columbia, District of Columbia 253 15 207 4 0 0 13 14 253 225 15 204 1 0 0 2 3 28 0 3 3 0 0 11 11 110010091021005 5 505 505 5 psa_34 5D2

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