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

23 rows where P005006 = 14 sorted by DISTRICT

✎ View and edit SQL

This data as json, CSV (advanced)

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

P005013 ✖

  • 0 22
  • 1 1

P005006 ✖

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
68 68 1000000US110010059001008 Block 1008, Block Group 1, Census Tract 59, District of Columbia, District of Columbia 127 51 16 0 14 0 40 6 127 79 46 16 0 14 0 0 3 48 5 0 0 0 0 40 3 110010059001008 1 101 101 1 psa_20 1D1
2142 2142 1000000US110010110003001 Block 3001, Block Group 3, Census Tract 110, District of Columbia, District of Columbia 289 173 86 5 15 0 2 8 289 276 166 83 5 14 0 1 7 13 7 3 0 1 0 1 1 110010110003001 1 103 103 1 psa_12 1D1
5759 5759 1000000US110010058002016 Block 2016, Block Group 2, Census Tract 58, District of Columbia, District of Columbia 153 119 13 0 14 3 0 4 153 151 117 13 0 14 3 0 4 2 2 0 0 0 0 0 0 110010058002016 1 102 102 1 psa_18 1D1
326 326 1000000US110010004002012 Block 2012, Block Group 2, Census Tract 4, District of Columbia, District of Columbia 22 8 0 0 14 0 0 0 22 20 6 0 0 14 0 0 0 2 2 0 0 0 0 0 0 110010004002012 2 204 204 2 psa_44 2D2
2155 2155 1000000US110010012001004 Block 1004, Block Group 1, Census Tract 12, District of Columbia, District of Columbia 285 244 16 0 14 0 5 6 285 266 232 14 0 14 0 0 6 19 12 2 0 0 0 5 0 110010012001004 2 203 203 2 psa_50 2D1
2641 2641 1000000US110010002024026 Block 4026, Block Group 4, Census Tract 2.02, District of Columbia, District of Columbia 132 103 4 0 14 0 3 8 132 121 96 4 0 14 0 0 7 11 7 0 0 0 0 3 1 110010002024026 2 206 206 2 psa_29 2D2
3981 3981 1000000US110010041003014 Block 3014, Block Group 3, Census Tract 41, District of Columbia, District of Columbia 29 15 0 0 14 0 0 0 29 29 15 0 0 14 0 0 0 0 0 0 0 0 0 0 0 110010041003014 2 208 208 2 psa_33 2D3
4084 4084 1000000US110010001003002 Block 3002, Block Group 3, Census Tract 1, District of Columbia, District of Columbia 248 229 3 0 14 0 2 0 248 239 220 3 0 14 0 2 0 9 9 0 0 0 0 0 0 110010001003002 2 206 206 2 psa_29 2D2
4410 4410 1000000US110010107002002 Block 2002, Block Group 2, Census Tract 107, District of Columbia, District of Columbia 130 103 6 0 15 0 3 3 130 112 89 6 0 14 0 0 3 18 14 0 0 1 0 3 0 110010107002002 2 208 208 2 psa_33 2D3
6269 6269 1000000US110010052014004 Block 4004, Block Group 4, Census Tract 52.01, District of Columbia, District of Columbia 249 213 11 0 14 0 3 8 249 234 203 11 0 14 0 1 5 15 10 0 0 0 0 2 3 110010052014004 2 208 208 2 psa_33 2D3
870 870 1000000US110010048011011 Block 1011, Block Group 1, Census Tract 48.01, District of Columbia, District of Columbia 177 62 90 0 14 0 3 8 177 162 52 88 0 14 0 0 8 15 10 2 0 0 0 3 0 110010048011011 3 308 308 3 psa_27 3D2
1158 1158 1000000US110010052012002 Block 2002, Block Group 2, Census Tract 52.01, District of Columbia, District of Columbia 172 143 5 0 14 1 2 7 172 154 127 5 0 14 1 0 7 18 16 0 0 0 0 2 0 110010052012002 3 301 301 3 psa_31 3D3
1346 1346 1000000US110010050011003 Block 1003, Block Group 1, Census Tract 50.01, District of Columbia, District of Columbia 224 186 18 0 14 0 3 3 224 208 173 18 0 14 0 1 2 16 13 0 0 0 0 2 1 110010050011003 3 307 307 3 psa_28 3D3
2916 2916 1000000US110010037002003 Block 2003, Block Group 2, Census Tract 37, District of Columbia, District of Columbia 423 131 220 1 15 0 41 15 423 336 104 207 1 14 0 1 9 87 27 13 0 1 0 40 6 110010037002003 3 304 304 3 psa_36 3D1
3114 3114 1000000US110010052014000 Block 4000, Block Group 4, Census Tract 52.01, District of Columbia, District of Columbia 152 118 8 0 14 0 4 8 152 142 110 8 0 14 0 2 8 10 8 0 0 0 0 2 0 110010052014000 3 301 301 3 psa_31 3D3
3542 3542 1000000US110010039003002 Block 3002, Block Group 3, Census Tract 39, District of Columbia, District of Columbia 423 285 87 0 14 1 19 17 423 366 259 84 0 14 0 2 7 57 26 3 0 0 1 17 10 110010039003002 3 303 303 3 psa_37 3D3
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
6107 6107 1000000US110010044002015 Block 2015, Block Group 2, Census Tract 44, District of Columbia, District of Columbia 162 100 43 1 14 0 0 4 162 149 91 43 0 14 0 0 1 13 9 0 1 0 0 0 3 110010044002015 3 305 305 3 psa_32 3D2
6290 6290 1000000US110010027011002 Block 1002, Block Group 1, Census Tract 27.01, District of Columbia, District of Columbia 223 178 17 0 14 0 2 12 223 204 163 17 0 14 0 0 10 19 15 0 0 0 0 2 2 110010027011002 3 302 302 3 psa_42 3D1
6395 6395 1000000US110010034002026 Block 2026, Block Group 2, Census Tract 34, District of Columbia, District of Columbia 142 43 77 0 14 0 0 8 142 137 43 73 0 14 0 0 7 5 0 4 0 0 0 0 1 110010034002026 3 308 308 3 psa_27 3D2
2108 2108 1000000US110010095093004 Block 3004, Block Group 3, Census Tract 95.09, District of Columbia, District of Columbia 445 26 383 0 14 0 8 14 445 425 21 379 0 14 0 1 10 20 5 4 0 0 0 7 4 110010095093004 4 405 405 4 psa_49 4D2
1196 1196 1000000US110010106002010 Block 2010, Block Group 2, Census Tract 106, District of Columbia, District of Columbia 49 7 27 0 14 0 0 1 49 48 7 26 0 14 0 0 1 1 0 1 0 0 0 0 0 110010106002010 5 501 501 5 psa_35 5D1
115 115 1000000US110010073011014 Block 1014, Block Group 1, Census Tract 73.01, District of Columbia, District of Columbia 254 143 63 0 14 1 15 18 254 213 127 54 0 14 1 0 17 41 16 9 0 0 0 15 1 110010073011014 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
);