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

19 rows where P003004 = 1 and P003006 = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003002, P003003, P003005, P003007, P003008, P005002, P005004, P005005, P005006, P005007, P005008, P005009, P005010, P005011, P005012, P005013, P005014, P005015, P005016, P005017, DISTRICT, PSA, NAME, POLDIST_ID, GIS_ID, SECTOR

P003006 ✖

P003004 ✖

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
24 24 1000000US110010048021006 Block 1006, Block Group 1, Census Tract 48.02, District of Columbia, District of Columbia 407 282 55 1 41 1 17 10 407 375 269 55 1 41 0 0 9 32 13 0 0 0 1 17 1 110010048021006 3 308 308 3 psa_27 3D2
85 85 1000000US110010067002004 Block 2004, Block Group 2, Census Tract 67, District of Columbia, District of Columbia 158 125 14 1 6 1 0 11 158 154 123 14 1 6 1 0 9 4 2 0 0 0 0 0 2 110010067002004 1 107 107 1 psa_16 1D2
765 765 1000000US110010018032005 Block 2005, Block Group 2, Census Tract 18.03, District of Columbia, District of Columbia 696 38 452 1 26 1 144 34 696 502 11 451 0 26 1 2 11 194 27 1 1 0 0 142 23 110010018032005 4 402 402 4 psa_53 4D1
1000 1000 1000000US110010083021005 Block 1005, Block Group 1, Census Tract 83.02, District of Columbia, District of Columbia 162 126 19 1 6 1 2 7 162 154 118 19 1 6 1 2 7 8 8 0 0 0 0 0 0 110010083021005 1 104 104 1 psa_21 1D2
2994 2994 1000000US110010088031002 Block 1002, Block Group 1, Census Tract 88.03, District of Columbia, District of Columbia 154 10 132 1 4 1 4 2 154 143 5 129 1 4 1 1 2 11 5 3 0 0 0 3 0 110010088031002 5 506 506 5 psa_26 5D3
3159 3159 1000000US110010033012000 Block 2000, Block Group 2, Census Tract 33.01, District of Columbia, District of Columbia 271 83 165 1 5 1 9 7 271 259 81 164 1 5 0 1 7 12 2 1 0 0 1 8 0 110010033012000 3 306 306 3 psa_38 3D2
3286 3286 1000000US110010052012000 Block 2000, Block Group 2, Census Tract 52.01, District of Columbia, District of Columbia 338 278 16 1 28 1 0 14 338 325 265 16 1 28 1 0 14 13 13 0 0 0 0 0 0 110010052012000 3 301 301 3 psa_31 3D3
3538 3538 1000000US110010066001010 Block 1010, Block Group 1, Census Tract 66, District of Columbia, District of Columbia 230 206 9 1 8 1 4 1 230 225 203 9 1 8 1 2 1 5 3 0 0 0 0 2 0 110010066001010 1 107 107 1 psa_16 1D2
3701 3701 1000000US110010006004002 Block 4002, Block Group 4, Census Tract 6, District of Columbia, District of Columbia 182 79 96 1 3 1 1 1 182 176 74 96 1 3 1 0 1 6 5 0 0 0 0 1 0 110010006004002 2 203 203 2 psa_50 2D1
3963 3963 1000000US110010001001004 Block 1004, Block Group 1, Census Tract 1, District of Columbia, District of Columbia 78 65 5 1 6 1 0 0 78 74 61 5 1 6 1 0 0 4 4 0 0 0 0 0 0 110010001001004 2 206 206 2 psa_29 2D2
4300 4300 1000000US110010015004015 Block 4015, Block Group 4, Census Tract 15, District of Columbia, District of Columbia 59 48 6 1 0 1 0 3 59 57 47 6 1 0 1 0 2 2 1 0 0 0 0 0 1 110010015004015 2 201 201 2 psa_55 2D1
4420 4420 1000000US110010042021003 Block 1003, Block Group 1, Census Tract 42.02, District of Columbia, District of Columbia 82 67 3 1 6 1 0 4 82 79 64 3 1 6 1 0 4 3 3 0 0 0 0 0 0 110010042021003 3 301 301 3 psa_31 3D3
4702 4702 1000000US110010105002027 Block 2027, Block Group 2, Census Tract 105, District of Columbia, District of Columbia 436 101 242 1 59 1 13 19 436 398 87 236 1 58 1 2 13 38 14 6 0 1 0 11 6 110010105002027 1 103 103 1 psa_12 1D1
4743 4743 1000000US110010034002004 Block 2004, Block Group 2, Census Tract 34, District of Columbia, District of Columbia 242 10 208 1 8 1 1 13 242 228 10 196 1 8 1 1 11 14 0 12 0 0 0 0 2 110010034002004 3 306 306 3 psa_38 3D2
5827 5827 1000000US110010012002002 Block 2002, Block Group 2, Census Tract 12, District of Columbia, District of Columbia 74 60 6 1 3 1 1 2 74 70 57 6 1 3 1 0 2 4 3 0 0 0 0 1 0 110010012002002 2 202 202 2 psa_52 2D1
5940 5940 1000000US110010027012002 Block 2002, Block Group 2, Census Tract 27.01, District of Columbia, District of Columbia 327 154 79 1 30 1 42 20 327 248 129 77 0 29 1 0 12 79 25 2 1 1 0 42 8 110010027012002 3 302 302 3 psa_42 3D1
6151 6151 1000000US110010055005001 Block 5001, Block Group 5, Census Tract 55, District of Columbia, District of Columbia 258 188 10 1 41 1 4 13 258 235 176 10 1 40 1 0 7 23 12 0 0 1 0 4 6 110010055005001 2 208 208 2 psa_33 2D3
6167 6167 1000000US110010039004000 Block 4000, Block Group 4, Census Tract 39, District of Columbia, District of Columbia 537 420 58 1 20 1 11 26 537 486 384 57 1 20 1 3 20 51 36 1 0 0 0 8 6 110010039004000 3 303 303 3 psa_37 3D3
6288 6288 1000000US110010073011138 Block 1138, Block Group 1, Census Tract 73.01, District of Columbia, District of Columbia 64 36 15 1 2 1 0 9 64 55 32 15 1 2 1 0 4 9 4 0 0 0 0 0 5 110010073011138 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
);