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

22 rows where P003004 = 1 and SECTOR = "1D3"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003001, P003002, P003005, P003006, P003007, P003008, P005001, P005003, P005005, P005006, P005007, P005008, P005009, P005010, P005011, P005012, P005013, 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
103 103 1000000US110010070001008 Block 1008, Block Group 1, Census Tract 70, District of Columbia, District of Columbia 142 125 6 1 3 0 0 7 142 139 122 6 1 3 0 0 7 3 3 0 0 0 0 0 0 110010070001008 1 106 106 1 psa_13 1D3
538 538 1000000US110010065001007 Block 1007, Block Group 1, Census Tract 65, District of Columbia, District of Columbia 121 102 3 1 7 0 0 8 121 115 99 3 0 7 0 0 6 6 3 0 1 0 0 0 2 110010065001007 1 106 106 1 psa_13 1D3
665 665 1000000US110010064002002 Block 2002, Block Group 2, Census Tract 64, District of Columbia, District of Columbia 202 0 198 1 3 0 0 0 202 202 0 198 1 3 0 0 0 0 0 0 0 0 0 0 0 110010064002002 1 105 105 1 psa_22 1D3
1213 1213 1000000US110010064001000 Block 1000, Block Group 1, Census Tract 64, District of Columbia, District of Columbia 71 16 33 1 18 0 0 3 71 71 16 33 1 18 0 0 3 0 0 0 0 0 0 0 0 110010064001000 1 105 105 1 psa_22 1D3
1341 1341 1000000US110010071002004 Block 2004, Block Group 2, Census Tract 71, District of Columbia, District of Columbia 753 22 712 1 6 0 0 12 753 749 21 711 1 6 0 0 10 4 1 1 0 0 0 0 2 110010071002004 1 106 106 1 psa_13 1D3
1718 1718 1000000US110010065002006 Block 2006, Block Group 2, Census Tract 65, District of Columbia, District of Columbia 213 183 8 1 17 0 1 3 213 199 171 7 1 17 0 0 3 14 12 1 0 0 0 1 0 110010065002006 1 106 106 1 psa_13 1D3
1809 1809 1000000US110010064001003 Block 1003, Block Group 1, Census Tract 64, District of Columbia, District of Columbia 77 0 72 1 1 0 0 3 77 70 0 65 1 1 0 0 3 7 0 7 0 0 0 0 0 110010064001003 1 105 105 1 psa_22 1D3
2767 2767 1000000US110010102002042 Block 2042, Block Group 2, Census Tract 102, District of Columbia, District of Columbia 278 149 88 1 28 0 4 8 278 265 143 85 1 28 0 0 8 13 6 3 0 0 0 4 0 110010102002042 1 105 105 1 psa_22 1D3
3265 3265 1000000US110010065002012 Block 2012, Block Group 2, Census Tract 65, District of Columbia, District of Columbia 142 116 11 1 9 0 0 5 142 136 111 11 0 9 0 0 5 6 5 0 1 0 0 0 0 110010065002012 1 106 106 1 psa_13 1D3
3302 3302 1000000US110010070002011 Block 2011, Block Group 2, Census Tract 70, District of Columbia, District of Columbia 98 59 30 1 3 0 0 5 98 90 52 30 0 3 0 0 5 8 7 0 1 0 0 0 0 110010070002011 1 106 106 1 psa_13 1D3
3431 3431 1000000US110010071001009 Block 1009, Block Group 1, Census Tract 71, District of Columbia, District of Columbia 243 44 190 1 3 0 0 5 243 234 35 190 1 3 0 0 5 9 9 0 0 0 0 0 0 110010071001009 1 106 106 1 psa_13 1D3
3459 3459 1000000US110010069002006 Block 2006, Block Group 2, Census Tract 69, District of Columbia, District of Columbia 204 127 49 1 11 2 3 11 204 191 120 49 1 11 2 2 6 13 7 0 0 0 0 1 5 110010069002006 1 106 106 1 psa_13 1D3
3709 3709 1000000US110010070002013 Block 2013, Block Group 2, Census Tract 70, District of Columbia, District of Columbia 23 19 0 1 3 0 0 0 23 23 19 0 1 3 0 0 0 0 0 0 0 0 0 0 0 110010070002013 1 106 106 1 psa_13 1D3
3885 3885 1000000US110010070002010 Block 2010, Block Group 2, Census Tract 70, District of Columbia, District of Columbia 181 123 51 1 2 0 0 4 181 179 122 51 1 2 0 0 3 2 1 0 0 0 0 0 1 110010070002010 1 106 106 1 psa_13 1D3
4028 4028 1000000US110010071002011 Block 2011, Block Group 2, Census Tract 71, District of Columbia, District of Columbia 192 112 55 1 4 0 11 9 192 177 109 55 1 4 0 1 7 15 3 0 0 0 0 10 2 110010071002011 1 106 106 1 psa_13 1D3
4124 4124 1000000US110010065002014 Block 2014, Block Group 2, Census Tract 65, District of Columbia, District of Columbia 155 135 5 1 10 0 0 4 155 151 131 5 1 10 0 0 4 4 4 0 0 0 0 0 0 110010065002014 1 106 106 1 psa_13 1D3
4223 4223 1000000US110010064001001 Block 1001, Block Group 1, Census Tract 64, District of Columbia, District of Columbia 126 36 76 1 8 0 0 5 126 121 34 73 1 8 0 0 5 5 2 3 0 0 0 0 0 110010064001001 1 105 105 1 psa_22 1D3
4913 4913 1000000US110010110004001 Block 4001, Block Group 4, Census Tract 110, District of Columbia, District of Columbia 374 183 156 1 19 0 3 12 374 363 178 154 1 19 0 0 11 11 5 2 0 0 0 3 1 110010110004001 1 105 105 1 psa_22 1D3
4946 4946 1000000US110010070002014 Block 2014, Block Group 2, Census Tract 70, District of Columbia, District of Columbia 161 103 36 1 17 0 4 0 161 154 98 36 1 17 0 2 0 7 5 0 0 0 0 2 0 110010070002014 1 106 106 1 psa_13 1D3
5264 5264 1000000US110010102002043 Block 2043, Block Group 2, Census Tract 102, District of Columbia, District of Columbia 230 69 122 1 10 0 11 17 230 205 59 115 1 10 0 5 15 25 10 7 0 0 0 6 2 110010102002043 1 105 105 1 psa_22 1D3
5316 5316 1000000US110010065001008 Block 1008, Block Group 1, Census Tract 65, District of Columbia, District of Columbia 70 45 21 1 0 0 3 0 70 56 34 20 1 0 0 1 0 14 11 1 0 0 0 2 0 110010065001008 1 106 106 1 psa_13 1D3
5777 5777 1000000US110010070002016 Block 2016, Block Group 2, Census Tract 70, District of Columbia, District of Columbia 203 177 17 1 3 0 2 3 203 190 171 14 1 3 0 1 0 13 6 3 0 0 0 1 3 110010070002016 1 106 106 1 psa_13 1D3

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