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

42 rows where P005017 = 1 and POLDIST_ID = 6

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003002, P003004, P003005, P003006, P003007, P003008, P005003, P005005, P005006, P005008, P005009, P005010, P005011, P005012, P005013, P005015, P005016, 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
185 185 1000000US110010077082006 Block 2006, Block Group 2, Census Tract 77.08, District of Columbia, District of Columbia 303 1 289 0 1 0 0 12 303 302 1 289 0 1 0 0 11 1 0 0 0 0 0 0 1 110010077082006 6 603 603 6 psa_15 6D3
297 297 1000000US110010096022003 Block 2003, Block Group 2, Census Tract 96.02, District of Columbia, District of Columbia 679 2 663 1 1 0 6 6 679 672 2 663 1 1 0 0 5 7 0 0 0 0 0 6 1 110010096022003 6 601 601 6 psa_30 6D1
479 479 1000000US110010099053006 Block 3006, Block Group 3, Census Tract 99.05, District of Columbia, District of Columbia 195 1 185 1 0 0 3 5 195 188 1 182 1 0 0 0 4 7 0 3 0 0 0 3 1 110010099053006 6 604 604 6 psa_14 6D3
733 733 1000000US110010096041003 Block 1003, Block Group 1, Census Tract 96.04, District of Columbia, District of Columbia 133 4 122 0 0 0 1 6 133 129 2 122 0 0 0 0 5 4 2 0 0 0 0 1 1 110010096041003 6 603 603 6 psa_15 6D3
736 736 1000000US110010077081002 Block 1002, Block Group 1, Census Tract 77.08, District of Columbia, District of Columbia 227 0 217 0 0 0 0 10 227 226 0 217 0 0 0 0 9 1 0 0 0 0 0 0 1 110010077081002 6 603 603 6 psa_15 6D3
826 826 1000000US110010099032001 Block 2001, Block Group 2, Census Tract 99.03, District of Columbia, District of Columbia 199 0 190 0 0 0 0 9 199 194 0 186 0 0 0 0 8 5 0 4 0 0 0 0 1 110010099032001 6 604 604 6 psa_14 6D3
1059 1059 1000000US110010076033000 Block 3000, Block Group 3, Census Tract 76.03, District of Columbia, District of Columbia 115 7 103 1 0 0 0 4 115 113 7 102 1 0 0 0 3 2 0 1 0 0 0 0 1 110010076033000 6 606 606 6 psa_7 6D2
1200 1200 1000000US110010077071006 Block 1006, Block Group 1, Census Tract 77.07, District of Columbia, District of Columbia 390 0 375 2 0 0 12 1 390 373 0 371 2 0 0 0 0 17 0 4 0 0 0 12 1 110010077071006 6 604 604 6 psa_14 6D3
1289 1289 1000000US110010099042006 Block 2006, Block Group 2, Census Tract 99.04, District of Columbia, District of Columbia 152 3 136 3 0 0 6 4 152 134 1 128 2 0 0 0 3 18 2 8 1 0 0 6 1 110010099042006 6 604 604 6 psa_14 6D3
1418 1418 1000000US110010099061007 Block 1007, Block Group 1, Census Tract 99.06, District of Columbia, District of Columbia 349 7 333 0 2 0 1 6 349 342 4 331 0 2 0 0 5 7 3 2 0 0 0 1 1 110010099061007 6 604 604 6 psa_14 6D3
1694 1694 1000000US110010076043009 Block 3009, Block Group 3, Census Tract 76.04, District of Columbia, District of Columbia 98 1 93 0 3 0 0 1 98 95 0 92 0 3 0 0 0 3 1 1 0 0 0 0 1 110010076043009 6 607 607 6 psa_10 6D2
2297 2297 1000000US110010077072013 Block 2013, Block Group 2, Census Tract 77.07, District of Columbia, District of Columbia 73 1 67 0 0 0 0 5 73 72 1 67 0 0 0 0 4 1 0 0 0 0 0 0 1 110010077072013 6 605 605 6 psa_11 6D2
2396 2396 1000000US110010078061006 Block 1006, Block Group 1, Census Tract 78.06, District of Columbia, District of Columbia 40 0 39 0 0 0 0 1 40 39 0 39 0 0 0 0 0 1 0 0 0 0 0 0 1 110010078061006 6 602 602 6 psa_25 6D1
2549 2549 1000000US110010076043000 Block 3000, Block Group 3, Census Tract 76.04, District of Columbia, District of Columbia 175 15 152 3 0 0 1 4 175 171 13 152 3 0 0 0 3 4 2 0 0 0 0 1 1 110010076043000 6 607 607 6 psa_10 6D2
2555 2555 1000000US110010076041003 Block 1003, Block Group 1, Census Tract 76.04, District of Columbia, District of Columbia 136 4 126 1 0 0 0 5 136 135 4 126 1 0 0 0 4 1 0 0 0 0 0 0 1 110010076041003 6 607 607 6 psa_10 6D2
2608 2608 1000000US110010077071011 Block 1011, Block Group 1, Census Tract 77.07, District of Columbia, District of Columbia 165 4 151 0 0 0 0 10 165 164 4 151 0 0 0 0 9 1 0 0 0 0 0 0 1 110010077071011 6 604 604 6 psa_14 6D3
2919 2919 1000000US110010076011001 Block 1001, Block Group 1, Census Tract 76.01, District of Columbia, District of Columbia 61 1 57 0 0 0 0 3 61 60 1 57 0 0 0 0 2 1 0 0 0 0 0 0 1 110010076011001 6 607 607 6 psa_10 6D2
3180 3180 1000000US110010099042004 Block 2004, Block Group 2, Census Tract 99.04, District of Columbia, District of Columbia 136 0 129 1 0 0 1 5 136 134 0 129 0 0 0 1 4 2 0 0 1 0 0 0 1 110010099042004 6 604 604 6 psa_14 6D3
3312 3312 1000000US110010078082005 Block 2005, Block Group 2, Census Tract 78.08, District of Columbia, District of Columbia 54 0 48 0 0 0 5 1 54 53 0 48 0 0 0 5 0 1 0 0 0 0 0 0 1 110010078082005 6 608 608 6 psa_19 6D1
3339 3339 1000000US110010096042002 Block 2002, Block Group 2, Census Tract 96.04, District of Columbia, District of Columbia 74 0 72 0 0 0 0 2 74 73 0 72 0 0 0 0 1 1 0 0 0 0 0 0 1 110010096042002 6 603 603 6 psa_15 6D3
3388 3388 1000000US110010077092002 Block 2002, Block Group 2, Census Tract 77.09, District of Columbia, District of Columbia 94 0 91 0 0 0 1 2 94 92 0 91 0 0 0 0 1 2 0 0 0 0 0 1 1 110010077092002 6 605 605 6 psa_11 6D2
3530 3530 1000000US110010096042009 Block 2009, Block Group 2, Census Tract 96.04, District of Columbia, District of Columbia 129 1 124 0 0 0 0 4 129 128 1 124 0 0 0 0 3 1 0 0 0 0 0 0 1 110010096042009 6 603 603 6 psa_15 6D3
3583 3583 1000000US110010078043001 Block 3001, Block Group 3, Census Tract 78.04, District of Columbia, District of Columbia 35 0 34 0 0 0 0 1 35 32 0 32 0 0 0 0 0 3 0 2 0 0 0 0 1 110010078043001 6 602 602 6 psa_25 6D1
3623 3623 1000000US110010099031002 Block 1002, Block Group 1, Census Tract 99.03, District of Columbia, District of Columbia 86 2 75 0 0 0 5 4 86 79 2 74 0 0 0 0 3 7 0 1 0 0 0 5 1 110010099031002 6 604 604 6 psa_14 6D3
3858 3858 1000000US110010076031000 Block 1000, Block Group 1, Census Tract 76.03, District of Columbia, District of Columbia 545 16 508 3 2 1 1 14 545 537 14 504 3 2 0 1 13 8 2 4 0 0 1 0 1 110010076031000 6 606 606 6 psa_7 6D2
4047 4047 1000000US110010078082008 Block 2008, Block Group 2, Census Tract 78.08, District of Columbia, District of Columbia 75 0 72 0 0 0 0 3 75 74 0 72 0 0 0 0 2 1 0 0 0 0 0 0 1 110010078082008 6 608 608 6 psa_19 6D1
4090 4090 1000000US110010078033008 Block 3008, Block Group 3, Census Tract 78.03, District of Columbia, District of Columbia 81 0 77 0 1 0 2 1 81 78 0 77 0 1 0 0 0 3 0 0 0 0 0 2 1 110010078033008 6 608 608 6 psa_19 6D1
4386 4386 1000000US110010076011004 Block 1004, Block Group 1, Census Tract 76.01, District of Columbia, District of Columbia 272 10 251 2 1 0 0 8 272 269 10 249 2 1 0 0 7 3 0 2 0 0 0 0 1 110010076011004 6 607 607 6 psa_10 6D2
4455 4455 1000000US110010076015022 Block 5022, Block Group 5, Census Tract 76.01, District of Columbia, District of Columbia 80 8 69 1 0 0 0 2 80 77 8 68 0 0 0 0 1 3 0 1 1 0 0 0 1 110010076015022 6 607 607 6 psa_10 6D2
4594 4594 1000000US110010078083007 Block 3007, Block Group 3, Census Tract 78.08, District of Columbia, District of Columbia 150 2 127 0 0 0 18 3 150 130 0 127 0 0 0 1 2 20 2 0 0 0 0 17 1 110010078083007 6 608 608 6 psa_19 6D1
4715 4715 1000000US110010078041009 Block 1009, Block Group 1, Census Tract 78.04, District of Columbia, District of Columbia 152 1 141 0 0 0 5 5 152 146 1 141 0 0 0 0 4 6 0 0 0 0 0 5 1 110010078041009 6 602 602 6 psa_25 6D1
5046 5046 1000000US110010078043008 Block 3008, Block Group 3, Census Tract 78.04, District of Columbia, District of Columbia 72 6 64 0 1 0 0 1 72 66 1 64 0 1 0 0 0 6 5 0 0 0 0 0 1 110010078043008 6 608 608 6 psa_19 6D1
5057 5057 1000000US110010078034001 Block 4001, Block Group 4, Census Tract 78.03, District of Columbia, District of Columbia 163 1 154 0 1 0 6 1 163 151 1 149 0 1 0 0 0 12 0 5 0 0 0 6 1 110010078034001 6 602 602 6 psa_25 6D1
5072 5072 1000000US110010078092006 Block 2006, Block Group 2, Census Tract 78.09, District of Columbia, District of Columbia 70 1 65 0 0 0 0 4 70 69 1 65 0 0 0 0 3 1 0 0 0 0 0 0 1 110010078092006 6 602 602 6 psa_25 6D1
5107 5107 1000000US110010076014000 Block 4000, Block Group 4, Census Tract 76.01, District of Columbia, District of Columbia 31 1 28 0 0 0 0 2 31 29 0 28 0 0 0 0 1 2 1 0 0 0 0 0 1 110010076014000 6 607 607 6 psa_10 6D2
5319 5319 1000000US110010077032002 Block 2002, Block Group 2, Census Tract 77.03, District of Columbia, District of Columbia 193 3 186 0 0 0 0 4 193 189 1 185 0 0 0 0 3 4 2 1 0 0 0 0 1 110010077032002 6 603 603 6 psa_15 6D3
5614 5614 1000000US110010099042005 Block 2005, Block Group 2, Census Tract 99.04, District of Columbia, District of Columbia 180 0 176 1 0 0 0 3 180 174 0 171 1 0 0 0 2 6 0 5 0 0 0 0 1 110010099042005 6 604 604 6 psa_14 6D3
5697 5697 1000000US110010099061005 Block 1005, Block Group 1, Census Tract 99.06, District of Columbia, District of Columbia 161 0 149 2 1 0 0 9 161 156 0 147 0 1 0 0 8 5 0 2 2 0 0 0 1 110010099061005 6 604 604 6 psa_14 6D3
5879 5879 1000000US110010099012017 Block 2017, Block Group 2, Census Tract 99.01, District of Columbia, District of Columbia 32 0 29 0 0 0 0 3 32 31 0 29 0 0 0 0 2 1 0 0 0 0 0 0 1 110010099012017 6 605 605 6 psa_11 6D2
5921 5921 1000000US110010076033005 Block 3005, Block Group 3, Census Tract 76.03, District of Columbia, District of Columbia 31 5 22 0 0 0 3 1 31 26 5 21 0 0 0 0 0 5 0 1 0 0 0 3 1 110010076033005 6 606 606 6 psa_7 6D2
6304 6304 1000000US110010077033001 Block 3001, Block Group 3, Census Tract 77.03, District of Columbia, District of Columbia 832 2 813 2 0 0 2 13 832 826 2 810 2 0 0 0 12 6 0 3 0 0 0 2 1 110010077033001 6 603 603 6 psa_15 6D3
6491 6491 1000000US110010096031000 Block 1000, Block Group 1, Census Tract 96.03, District of Columbia, District of Columbia 923 8 886 0 3 0 12 14 923 905 4 883 0 3 0 2 13 18 4 3 0 0 0 10 1 110010096031000 6 603 603 6 psa_15 6D3

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