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 P005007 = 1 and POLDIST_ID = 2

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003002, P003003, P003004, P003005, P003006, P003007, P003008, P005002, P005003, P005004, P005005, P005006, P005008, P005009, P005010, P005011, P005012, P005013, P005014, P005015, P005016, P005017, PSA, NAME, GIS_ID, SECTOR

POLDIST_ID ✖

P005007 ✖

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
366 366 1000000US110010013022001 Block 2001, Block Group 2, Census Tract 13.02, District of Columbia, District of Columbia 2280 1905 94 6 190 1 24 60 2280 2124 1788 89 2 187 1 3 54 156 117 5 4 3 0 21 6 110010013022001 2 203 203 2 psa_50 2D1
1012 1012 1000000US110010053013001 Block 3001, Block Group 3, Census Tract 53.01, District of Columbia, District of Columbia 1102 856 51 1 137 2 21 34 1102 986 770 48 0 136 1 5 26 116 86 3 1 1 1 16 8 110010053013001 2 208 208 2 psa_33 2D3
1256 1256 1000000US110010010014021 Block 4021, Block Group 4, Census Tract 10.01, District of Columbia, District of Columbia 248 196 22 0 25 1 3 1 248 238 189 22 0 25 1 0 1 10 7 0 0 0 0 3 0 110010010014021 2 202 202 2 psa_52 2D1
1584 1584 1000000US110010002024003 Block 4003, Block Group 4, Census Tract 2.02, District of Columbia, District of Columbia 93 84 2 0 4 1 2 0 93 84 76 1 0 4 1 2 0 9 8 1 0 0 0 0 0 110010002024003 2 206 206 2 psa_29 2D2
1930 1930 1000000US110010011001010 Block 1010, Block Group 1, Census Tract 11, District of Columbia, District of Columbia 294 225 25 0 35 1 0 8 294 285 220 25 0 34 1 0 5 9 5 0 0 1 0 0 3 110010011001010 2 201 201 2 psa_55 2D1
2366 2366 1000000US110010042021001 Block 1001, Block Group 1, Census Tract 42.02, District of Columbia, District of Columbia 263 222 7 0 27 1 1 5 263 251 211 7 0 27 1 0 5 12 11 0 0 0 0 1 0 110010042021001 2 208 208 2 psa_33 2D3
2432 2432 1000000US110010007023001 Block 3001, Block Group 3, Census Tract 7.02, District of Columbia, District of Columbia 715 597 34 0 39 1 20 24 715 653 558 34 0 38 1 5 17 62 39 0 0 1 0 15 7 110010007023001 2 204 204 2 psa_44 2D2
2667 2667 1000000US110010013021001 Block 1001, Block Group 1, Census Tract 13.02, District of Columbia, District of Columbia 2196 1703 178 4 224 1 24 62 2196 2023 1561 176 2 221 1 4 58 173 142 2 2 3 0 20 4 110010013021001 2 203 203 2 psa_50 2D1
2758 2758 1000000US110010011001014 Block 1014, Block Group 1, Census Tract 11, District of Columbia, District of Columbia 58 56 1 0 0 1 0 0 58 57 55 1 0 0 1 0 0 1 1 0 0 0 0 0 0 110010011001014 2 202 202 2 psa_52 2D1
2793 2793 1000000US110010008013028 Block 3028, Block Group 3, Census Tract 8.01, District of Columbia, District of Columbia 22 21 0 0 0 1 0 0 22 22 21 0 0 0 1 0 0 0 0 0 0 0 0 0 0 110010008013028 2 205 205 2 psa_46 2D2
3131 3131 1000000US110010005011012 Block 1012, Block Group 1, Census Tract 5.01, District of Columbia, District of Columbia 672 543 51 5 39 1 18 15 672 622 517 49 1 39 1 3 12 50 26 2 4 0 0 15 3 110010005011012 2 204 204 2 psa_44 2D2
3157 3157 1000000US110010002024004 Block 4004, Block Group 4, Census Tract 2.02, District of Columbia, District of Columbia 774 606 51 0 87 1 9 20 774 725 569 50 0 87 1 3 15 49 37 1 0 0 0 6 5 110010002024004 2 206 206 2 psa_29 2D2
3191 3191 1000000US110010012003004 Block 3004, Block Group 3, Census Tract 12, District of Columbia, District of Columbia 55 53 0 0 0 1 0 1 55 53 51 0 0 0 1 0 1 2 2 0 0 0 0 0 0 110010012003004 2 202 202 2 psa_52 2D1
3375 3375 1000000US110010012003007 Block 3007, Block Group 3, Census Tract 12, District of Columbia, District of Columbia 65 56 0 0 4 1 1 3 65 63 55 0 0 4 1 0 3 2 1 0 0 0 0 1 0 110010012003007 2 202 202 2 psa_52 2D1
3486 3486 1000000US110010008022020 Block 2020, Block Group 2, Census Tract 8.02, District of Columbia, District of Columbia 47 43 0 0 2 1 0 1 47 42 38 0 0 2 1 0 1 5 5 0 0 0 0 0 0 110010008022020 2 205 205 2 psa_46 2D2
3564 3564 1000000US110010042021006 Block 1006, Block Group 1, Census Tract 42.02, District of Columbia, District of Columbia 200 173 5 0 8 1 8 5 200 177 157 5 0 8 1 1 5 23 16 0 0 0 0 7 0 110010042021006 2 208 208 2 psa_33 2D3
3698 3698 1000000US110010006001003 Block 1003, Block Group 1, Census Tract 6, District of Columbia, District of Columbia 476 399 17 0 19 1 18 22 476 403 355 14 0 19 1 1 13 73 44 3 0 0 0 17 9 110010006001003 2 203 203 2 psa_50 2D1
3701 3701 1000000US110010006004002 Block 4002, Block Group 4, Census Tract 6, District of Columbia, District of Columbia 182 79 96 1 3 1 1 1 182 176 74 96 1 3 1 0 1 6 5 0 0 0 0 1 0 110010006004002 2 203 203 2 psa_50 2D1
3963 3963 1000000US110010001001004 Block 1004, Block Group 1, Census Tract 1, District of Columbia, District of Columbia 78 65 5 1 6 1 0 0 78 74 61 5 1 6 1 0 0 4 4 0 0 0 0 0 0 110010001001004 2 206 206 2 psa_29 2D2
4300 4300 1000000US110010015004015 Block 4015, Block Group 4, Census Tract 15, District of Columbia, District of Columbia 59 48 6 1 0 1 0 3 59 57 47 6 1 0 1 0 2 2 1 0 0 0 0 0 1 110010015004015 2 201 201 2 psa_55 2D1
4489 4489 1000000US110010002021001 Block 1001, Block Group 1, Census Tract 2.02, District of Columbia, District of Columbia 174 152 11 0 7 1 2 1 174 167 146 11 0 7 1 1 1 7 6 0 0 0 0 1 0 110010002021001 2 206 206 2 psa_29 2D2
4779 4779 1000000US110010015001028 Block 1028, Block Group 1, Census Tract 15, District of Columbia, District of Columbia 52 31 10 0 0 1 10 0 52 40 29 10 0 0 1 0 0 12 2 0 0 0 0 10 0 110010015001028 2 201 201 2 psa_55 2D1
5071 5071 1000000US110010009022024 Block 2024, Block Group 2, Census Tract 9.02, District of Columbia, District of Columbia 124 98 5 0 9 1 4 7 124 117 95 4 0 9 1 3 5 7 3 1 0 0 0 1 2 110010009022024 2 205 205 2 psa_46 2D2
5129 5129 1000000US110010003003002 Block 3002, Block Group 3, Census Tract 3, District of Columbia, District of Columbia 42 38 0 0 0 1 3 0 42 38 37 0 0 0 1 0 0 4 1 0 0 0 0 3 0 110010003003002 2 206 206 2 psa_29 2D2
5524 5524 1000000US110010001002000 Block 2000, Block Group 2, Census Tract 1, District of Columbia, District of Columbia 609 553 13 0 27 1 4 11 609 582 531 13 0 25 1 2 10 27 22 0 0 2 0 2 1 110010001002000 2 206 206 2 psa_29 2D2
5740 5740 1000000US110010010014008 Block 4008, Block Group 4, Census Tract 10.01, District of Columbia, District of Columbia 63 49 3 0 4 1 0 6 63 54 43 3 0 3 1 0 4 9 6 0 0 1 0 0 2 110010010014008 2 202 202 2 psa_52 2D1
5827 5827 1000000US110010012002002 Block 2002, Block Group 2, Census Tract 12, District of Columbia, District of Columbia 74 60 6 1 3 1 1 2 74 70 57 6 1 3 1 0 2 4 3 0 0 0 0 1 0 110010012002002 2 202 202 2 psa_52 2D1
5933 5933 1000000US110010041003013 Block 3013, Block Group 3, Census Tract 41, District of Columbia, District of Columbia 67 56 0 0 8 1 0 2 67 65 54 0 0 8 1 0 2 2 2 0 0 0 0 0 0 110010041003013 2 208 208 2 psa_33 2D3
6151 6151 1000000US110010055005001 Block 5001, Block Group 5, Census Tract 55, District of Columbia, District of Columbia 258 188 10 1 41 1 4 13 258 235 176 10 1 40 1 0 7 23 12 0 0 1 0 4 6 110010055005001 2 208 208 2 psa_33 2D3
6313 6313 1000000US110010008021003 Block 1003, Block Group 1, Census Tract 8.02, District of Columbia, District of Columbia 168 119 16 0 25 1 2 5 168 151 107 16 0 25 1 0 2 17 12 0 0 0 0 2 3 110010008021003 2 205 205 2 psa_46 2D2
6438 6438 1000000US110010011003007 Block 3007, Block Group 3, Census Tract 11, District of Columbia, District of Columbia 226 190 9 0 18 1 4 4 226 210 179 9 0 18 1 1 2 16 11 0 0 0 0 3 2 110010011003007 2 201 201 2 psa_55 2D1

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