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

16 rows where P003004 = 2 and SECTOR = "1D2"

✎ 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

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