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

24 rows where P003005 = 1 and SECTOR = "6D2"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003002, P003003, P003004, P003007, P003008, P005003, P005004, P005005, P005009, P005010, P005011, P005012, 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
168 168 1000000US110010076034008 Block 4008, Block Group 4, Census Tract 76.03, District of Columbia, District of Columbia 110 18 87 1 1 0 2 1 110 97 7 87 1 1 0 0 1 13 11 0 0 0 0 2 0 110010076034008 6 606 606 6 psa_7 6D2
175 175 1000000US110010076052002 Block 2002, Block Group 2, Census Tract 76.05, District of Columbia, District of Columbia 199 1 195 0 1 0 0 2 199 199 1 195 0 1 0 0 2 0 0 0 0 0 0 0 0 110010076052002 6 607 607 6 psa_10 6D2
625 625 1000000US110010099011006 Block 1006, Block Group 1, Census Tract 99.01, District of Columbia, District of Columbia 22 0 21 0 1 0 0 0 22 22 0 21 0 1 0 0 0 0 0 0 0 0 0 0 0 110010099011006 6 605 605 6 psa_11 6D2
645 645 1000000US110010099011009 Block 1009, Block Group 1, Census Tract 99.01, District of Columbia, District of Columbia 99 1 84 3 1 0 0 10 99 99 1 84 3 1 0 0 10 0 0 0 0 0 0 0 0 110010099011009 6 605 605 6 psa_11 6D2
1238 1238 1000000US110010076012009 Block 2009, Block Group 2, Census Tract 76.01, District of Columbia, District of Columbia 91 11 79 0 1 0 0 0 91 91 11 79 0 1 0 0 0 0 0 0 0 0 0 0 0 110010076012009 6 607 607 6 psa_10 6D2
1543 1543 1000000US110010076043010 Block 3010, Block Group 3, Census Tract 76.04, District of Columbia, District of Columbia 103 4 97 0 1 0 0 1 103 102 3 97 0 1 0 0 1 1 1 0 0 0 0 0 0 110010076043010 6 607 607 6 psa_10 6D2
1551 1551 1000000US110010099071002 Block 1002, Block Group 1, Census Tract 99.07, District of Columbia, District of Columbia 222 2 214 3 1 0 0 2 222 217 1 210 3 1 0 0 2 5 1 4 0 0 0 0 0 110010099071002 6 605 605 6 psa_11 6D2
1797 1797 1000000US110010076053004 Block 3004, Block Group 3, Census Tract 76.05, District of Columbia, District of Columbia 125 2 116 1 1 0 0 5 125 125 2 116 1 1 0 0 5 0 0 0 0 0 0 0 0 110010076053004 6 607 607 6 psa_10 6D2
2320 2320 1000000US110010076042031 Block 2031, Block Group 2, Census Tract 76.04, District of Columbia, District of Columbia 40 0 39 0 1 0 0 0 40 40 0 39 0 1 0 0 0 0 0 0 0 0 0 0 0 110010076042031 6 606 606 6 psa_7 6D2
2869 2869 1000000US110010076033011 Block 3011, Block Group 3, Census Tract 76.03, District of Columbia, District of Columbia 63 5 56 0 1 0 0 1 63 63 5 56 0 1 0 0 1 0 0 0 0 0 0 0 0 110010076033011 6 606 606 6 psa_7 6D2
2948 2948 1000000US110010099021015 Block 1015, Block Group 1, Census Tract 99.02, District of Columbia, District of Columbia 49 2 44 0 1 0 0 2 49 49 2 44 0 1 0 0 2 0 0 0 0 0 0 0 0 110010099021015 6 605 605 6 psa_11 6D2
4072 4072 1000000US110010099011008 Block 1008, Block Group 1, Census Tract 99.01, District of Columbia, District of Columbia 84 8 75 0 1 0 0 0 84 84 8 75 0 1 0 0 0 0 0 0 0 0 0 0 0 110010099011008 6 605 605 6 psa_11 6D2
4199 4199 1000000US110010076051004 Block 1004, Block Group 1, Census Tract 76.05, District of Columbia, District of Columbia 13 1 11 0 1 0 0 0 13 13 1 11 0 1 0 0 0 0 0 0 0 0 0 0 0 110010076051004 6 607 607 6 psa_10 6D2
4319 4319 1000000US110010076032005 Block 2005, Block Group 2, Census Tract 76.03, District of Columbia, District of Columbia 192 5 183 0 1 0 0 3 192 192 5 183 0 1 0 0 3 0 0 0 0 0 0 0 0 110010076032005 6 606 606 6 psa_7 6D2
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
4600 4600 1000000US110010076041009 Block 1009, Block Group 1, Census Tract 76.04, District of Columbia, District of Columbia 236 7 227 0 1 0 0 1 236 233 6 225 0 1 0 0 1 3 1 2 0 0 0 0 0 110010076041009 6 607 607 6 psa_10 6D2
5185 5185 1000000US110010076012005 Block 2005, Block Group 2, Census Tract 76.01, District of Columbia, District of Columbia 74 4 69 0 1 0 0 0 74 74 4 69 0 1 0 0 0 0 0 0 0 0 0 0 0 110010076012005 6 607 607 6 psa_10 6D2
5235 5235 1000000US110010076015018 Block 5018, Block Group 5, Census Tract 76.01, District of Columbia, District of Columbia 165 0 164 0 1 0 0 0 165 160 0 159 0 1 0 0 0 5 0 5 0 0 0 0 0 110010076015018 6 607 607 6 psa_10 6D2
5250 5250 1000000US110010076043006 Block 3006, Block Group 3, Census Tract 76.04, District of Columbia, District of Columbia 78 1 75 0 1 0 0 1 78 77 1 74 0 1 0 0 1 1 0 1 0 0 0 0 0 110010076043006 6 607 607 6 psa_10 6D2
5414 5414 1000000US110010076032004 Block 2004, Block Group 2, Census Tract 76.03, District of Columbia, District of Columbia 156 4 145 1 1 0 0 5 156 156 4 145 1 1 0 0 5 0 0 0 0 0 0 0 0 110010076032004 6 606 606 6 psa_7 6D2
5768 5768 1000000US110010076051006 Block 1006, Block Group 1, Census Tract 76.05, District of Columbia, District of Columbia 151 5 141 0 1 0 0 4 151 149 5 139 0 1 0 0 4 2 0 2 0 0 0 0 0 110010076051006 6 607 607 6 psa_10 6D2
5998 5998 1000000US110010076053001 Block 3001, Block Group 3, Census Tract 76.05, District of Columbia, District of Columbia 39 0 37 0 1 0 0 1 39 39 0 37 0 1 0 0 1 0 0 0 0 0 0 0 0 110010076053001 6 607 607 6 psa_10 6D2
6029 6029 1000000US110010099072006 Block 2006, Block Group 2, Census Tract 99.07, District of Columbia, District of Columbia 44 1 42 0 1 0 0 0 44 44 1 42 0 1 0 0 0 0 0 0 0 0 0 0 0 110010099072006 6 605 605 6 psa_11 6D2
6286 6286 1000000US110010076013000 Block 3000, Block Group 3, Census Tract 76.01, District of Columbia, District of Columbia 98 6 87 0 1 0 0 4 98 95 6 84 0 1 0 0 4 3 0 3 0 0 0 0 0 110010076013000 6 607 607 6 psa_10 6D2

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