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

28 rows where DISTRICT = 1 and P003004 = 2

✎ View and edit SQL

This data as json, CSV (advanced)

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

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
18 18 1000000US110010047011002 Block 1002, Block Group 1, Census Tract 47.01, District of Columbia, District of Columbia 207 0 187 2 18 0 0 0 207 207 0 187 2 18 0 0 0 0 0 0 0 0 0 0 0 110010047011002 1 102 102 1 psa_18 1D1
754 754 1000000US110010071002001 Block 2001, Block Group 2, Census Tract 71, District of Columbia, District of Columbia 46 23 16 2 5 0 0 0 46 45 22 16 2 5 0 0 0 1 1 0 0 0 0 0 0 110010071002001 1 106 106 1 psa_13 1D3
846 846 1000000US110010058002010 Block 2010, Block Group 2, Census Tract 58, District of Columbia, District of Columbia 566 427 34 2 71 0 2 30 566 528 396 33 2 71 0 0 26 38 31 1 0 0 0 2 4 110010058002010 1 102 102 1 psa_18 1D1
856 856 1000000US110010082002004 Block 2004, Block Group 2, Census Tract 82, District of Columbia, District of Columbia 299 243 19 2 31 1 3 0 299 290 237 19 2 31 1 0 0 9 6 0 0 0 0 3 0 110010082002004 1 108 108 1 psa_17 1D2
1009 1009 1000000US110010080022002 Block 2002, Block Group 2, Census Tract 80.02, District of Columbia, District of Columbia 97 21 72 2 2 0 0 0 97 95 20 72 1 2 0 0 0 2 1 0 1 0 0 0 0 110010080022002 1 108 108 1 psa_17 1D2
2159 2159 1000000US110010102002038 Block 2038, Block Group 2, Census Tract 102, District of Columbia, District of Columbia 607 249 284 2 23 0 10 39 607 574 236 280 1 23 0 2 32 33 13 4 1 0 0 8 7 110010102002038 1 103 103 1 psa_12 1D1
2391 2391 1000000US110010080012006 Block 2006, Block Group 2, Census Tract 80.01, District of Columbia, District of Columbia 66 28 33 2 2 0 0 1 66 64 28 32 1 2 0 0 1 2 0 1 1 0 0 0 0 110010080012006 1 108 108 1 psa_17 1D2
2485 2485 1000000US110010064002003 Block 2003, Block Group 2, Census Tract 64, District of Columbia, District of Columbia 152 17 118 2 0 0 9 6 152 139 16 117 2 0 0 0 4 13 1 1 0 0 0 9 2 110010064002003 1 105 105 1 psa_22 1D3
2682 2682 1000000US110010070002019 Block 2019, Block Group 2, Census Tract 70, District of Columbia, District of Columbia 584 501 57 2 7 4 5 8 584 529 460 52 2 6 4 0 5 55 41 5 0 1 0 5 3 110010070002019 1 106 106 1 psa_13 1D3
2913 2913 1000000US110010084022001 Block 2001, Block Group 2, Census Tract 84.02, District of Columbia, District of Columbia 279 38 230 2 1 3 1 4 279 273 37 227 2 1 3 0 3 6 1 3 0 0 0 1 1 110010084022001 1 104 104 1 psa_21 1D2
3010 3010 1000000US110010082001002 Block 1002, Block Group 1, Census Tract 82, District of Columbia, District of Columbia 122 108 7 2 1 0 3 1 122 117 106 7 2 1 0 0 1 5 2 0 0 0 0 3 0 110010082001002 1 108 108 1 psa_17 1D2
3038 3038 1000000US110010067001004 Block 1004, Block Group 1, Census Tract 67, District of Columbia, District of Columbia 264 219 31 2 2 1 8 1 264 246 206 31 2 2 1 3 1 18 13 0 0 0 0 5 0 110010067001004 1 107 107 1 psa_16 1D2
3759 3759 1000000US110010082002014 Block 2014, Block Group 2, Census Tract 82, District of Columbia, District of Columbia 217 181 13 2 11 0 6 4 217 199 170 13 1 11 0 0 4 18 11 0 1 0 0 6 0 110010082002014 1 108 108 1 psa_17 1D2
4145 4145 1000000US110010081003010 Block 3010, Block Group 3, Census Tract 81, District of Columbia, District of Columbia 88 74 3 2 4 0 1 4 88 86 73 3 2 4 0 0 4 2 1 0 0 0 0 1 0 110010081003010 1 108 108 1 psa_17 1D2
4227 4227 1000000US110010083012005 Block 2005, Block Group 2, Census Tract 83.01, District of Columbia, District of Columbia 168 130 31 2 3 0 0 2 168 167 130 30 2 3 0 0 2 1 0 1 0 0 0 0 0 110010083012005 1 108 108 1 psa_17 1D2
4380 4380 1000000US110010102001016 Block 1016, Block Group 1, Census Tract 102, District of Columbia, District of Columbia 90 51 30 2 4 0 0 3 90 85 50 30 0 4 0 0 1 5 1 0 2 0 0 0 2 110010102001016 1 103 103 1 psa_12 1D1
4467 4467 1000000US110010068022003 Block 2003, Block Group 2, Census Tract 68.02, District of Columbia, District of Columbia 169 83 76 2 1 0 2 5 169 160 78 74 2 1 0 0 5 9 5 2 0 0 0 2 0 110010068022003 1 107 107 1 psa_16 1D2
4798 4798 1000000US110010081002008 Block 2008, Block Group 2, Census Tract 81, District of Columbia, District of Columbia 86 73 9 2 0 0 2 0 86 84 73 9 2 0 0 0 0 2 0 0 0 0 0 2 0 110010081002008 1 108 108 1 psa_17 1D2
5001 5001 1000000US110010082002017 Block 2017, Block Group 2, Census Tract 82, District of Columbia, District of Columbia 230 210 6 2 7 0 0 5 230 224 204 6 2 7 0 0 5 6 6 0 0 0 0 0 0 110010082002017 1 108 108 1 psa_17 1D2
5317 5317 1000000US110010066001001 Block 1001, Block Group 1, Census Tract 66, District of Columbia, District of Columbia 206 172 15 2 11 0 3 3 206 200 171 14 2 11 0 0 2 6 1 1 0 0 0 3 1 110010066001001 1 107 107 1 psa_16 1D2
5379 5379 1000000US110010080011000 Block 1000, Block Group 1, Census Tract 80.01, District of Columbia, District of Columbia 96 10 70 2 2 0 12 0 96 80 8 69 2 1 0 0 0 16 2 1 0 1 0 12 0 110010080011000 1 104 104 1 psa_21 1D2
5540 5540 1000000US110010105001001 Block 1001, Block Group 1, Census Tract 105, District of Columbia, District of Columbia 639 201 342 2 51 0 12 31 639 592 185 332 2 51 0 4 18 47 16 10 0 0 0 8 13 110010105001001 1 103 103 1 psa_12 1D1
5542 5542 1000000US110010110002000 Block 2000, Block Group 2, Census Tract 110, District of Columbia, District of Columbia 832 550 219 2 36 0 7 18 832 804 532 218 2 36 0 2 14 28 18 1 0 0 0 5 4 110010110002000 1 103 103 1 psa_12 1D1
5770 5770 1000000US110010083021011 Block 1011, Block Group 1, Census Tract 83.02, District of Columbia, District of Columbia 174 137 31 2 0 0 0 4 174 164 130 31 2 0 0 0 1 10 7 0 0 0 0 0 3 110010083021011 1 108 108 1 psa_17 1D2
6087 6087 1000000US110010105001003 Block 1003, Block Group 1, Census Tract 105, District of Columbia, District of Columbia 671 223 391 2 19 0 14 22 671 628 197 390 2 18 0 2 19 43 26 1 0 1 0 12 3 110010105001003 1 103 103 1 psa_12 1D1
6145 6145 1000000US110010072001010 Block 1010, Block Group 1, Census Tract 72, District of Columbia, District of Columbia 976 736 159 2 37 0 8 34 976 918 698 151 2 37 0 1 29 58 38 8 0 0 0 7 5 110010072001010 1 106 106 1 psa_13 1D3
6213 6213 1000000US110010072001023 Block 1023, Block Group 1, Census Tract 72, District of Columbia, District of Columbia 300 208 50 2 29 0 7 4 300 272 188 50 1 29 0 1 3 28 20 0 1 0 0 6 1 110010072001023 1 106 106 1 psa_13 1D3
6292 6292 1000000US110010080012007 Block 2007, Block Group 2, Census Tract 80.01, District of Columbia, District of Columbia 67 18 45 2 1 0 0 1 67 65 18 45 0 1 0 0 1 2 0 0 2 0 0 0 0 110010080012007 1 108 108 1 psa_17 1D2

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