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

32 rows where P003007 = 12

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003002, P003004, P003005, P003008, P005003, P005004, P005005, P005006, P005008, P005009, P005010, P005011, P005012, P005013, P005014, P005016, P005017, DISTRICT, PSA, NAME, POLDIST_ID, 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
44 44 1000000US110010052011001 Block 1001, Block Group 1, Census Tract 52.01, District of Columbia, District of Columbia 495 381 35 2 49 0 12 16 495 451 354 34 1 48 0 2 12 44 27 1 1 1 0 10 4 110010052011001 2 208 208 2 psa_33 2D3
434 434 1000000US110010027023007 Block 3007, Block Group 3, Census Tract 27.02, District of Columbia, District of Columbia 228 178 30 0 3 0 12 5 228 209 168 30 0 3 0 4 4 19 10 0 0 0 0 8 1 110010027023007 3 302 302 3 psa_42 3D1
634 634 1000000US110010096011027 Block 1027, Block Group 1, Census Tract 96.01, District of Columbia, District of Columbia 52 5 35 0 0 0 12 0 52 38 3 35 0 0 0 0 0 14 2 0 0 0 0 12 0 110010096011027 6 601 601 6 psa_30 6D1
1054 1054 1000000US110010039003001 Block 3001, Block Group 3, Census Tract 39, District of Columbia, District of Columbia 116 61 34 0 9 0 12 0 116 95 50 34 0 9 0 2 0 21 11 0 0 0 0 10 0 110010039003001 3 303 303 3 psa_37 3D3
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
1262 1262 1000000US110010032001006 Block 1006, Block Group 1, Census Tract 32, District of Columbia, District of Columbia 152 23 109 0 3 0 12 5 152 132 21 107 0 3 0 0 1 20 2 2 0 0 0 12 4 110010032001006 4 409 409 4 psa_41 4D3
1782 1782 1000000US110010095013004 Block 3004, Block Group 3, Census Tract 95.01, District of Columbia, District of Columbia 65 3 46 0 0 0 12 4 65 50 1 45 0 0 0 0 4 15 2 1 0 0 0 12 0 110010095013004 4 405 405 4 psa_49 4D2
2464 2464 1000000US110010012003000 Block 3000, Block Group 3, Census Tract 12, District of Columbia, District of Columbia 198 120 9 2 50 0 12 5 198 167 104 9 0 50 0 1 3 31 16 0 2 0 0 11 2 110010012003000 2 203 203 2 psa_50 2D1
2633 2633 1000000US110010020021012 Block 1012, Block Group 1, Census Tract 20.02, District of Columbia, District of Columbia 134 27 65 0 12 0 12 18 134 110 26 65 0 12 0 1 6 24 1 0 0 0 0 11 12 110010020021012 4 404 404 4 psa_48 4D3
2655 2655 1000000US110010092011010 Block 1010, Block Group 1, Census Tract 92.01, District of Columbia, District of Columbia 87 15 59 0 0 0 12 1 87 70 10 59 0 0 0 0 1 17 5 0 0 0 0 12 0 110010092011010 5 502 502 5 psa_40 5D1
3651 3651 1000000US110010029002003 Block 2003, Block Group 2, Census Tract 29, District of Columbia, District of Columbia 109 48 41 1 2 0 12 5 109 70 30 35 0 2 0 0 3 39 18 6 1 0 0 12 2 110010029002003 4 408 408 4 psa_39 4D3
3739 3739 1000000US110010095091005 Block 1005, Block Group 1, Census Tract 95.09, District of Columbia, District of Columbia 181 8 154 0 0 0 12 7 181 165 7 153 0 0 0 2 3 16 1 1 0 0 0 10 4 110010095091005 4 405 405 4 psa_49 4D2
3882 3882 1000000US110010078062019 Block 2019, Block Group 2, Census Tract 78.06, District of Columbia, District of Columbia 61 0 49 0 0 0 12 0 61 49 0 49 0 0 0 0 0 12 0 0 0 0 0 12 0 110010078062019 6 602 602 6 psa_25 6D1
4074 4074 1000000US110010023011010 Block 1010, Block Group 1, Census Tract 23.01, District of Columbia, District of Columbia 81 17 52 0 0 0 12 0 81 68 16 52 0 0 0 0 0 13 1 0 0 0 0 12 0 110010023011010 4 407 407 4 psa_47 4D2
4126 4126 1000000US110010074062000 Block 2000, Block Group 2, Census Tract 74.06, District of Columbia, District of Columbia 1624 7 1584 4 2 0 12 15 1624 1595 2 1574 4 2 0 2 11 29 5 10 0 0 0 10 4 110010074062000 7 703 703 7 psa_8 7D1
4627 4627 1000000US110010103002009 Block 2009, Block Group 2, Census Tract 103, District of Columbia, District of Columbia 149 43 88 0 1 0 12 5 149 135 42 87 0 1 0 1 4 14 1 1 0 0 0 11 1 110010103002009 4 401 401 4 psa_56 4D1
4631 4631 1000000US110010007014004 Block 4004, Block Group 4, Census Tract 7.01, District of Columbia, District of Columbia 362 295 16 0 27 0 12 12 362 327 271 16 0 26 0 4 10 35 24 0 0 1 0 8 2 110010007014004 2 204 204 2 psa_44 2D2
4828 4828 1000000US110010048011020 Block 1020, Block Group 1, Census Tract 48.01, District of Columbia, District of Columbia 97 53 23 0 6 0 12 3 97 84 51 23 0 6 0 1 3 13 2 0 0 0 0 11 0 110010048011020 3 308 308 3 psa_27 3D2
5254 5254 1000000US110010033021000 Block 1000, Block Group 1, Census Tract 33.02, District of Columbia, District of Columbia 179 70 89 0 8 0 12 0 179 158 63 87 0 8 0 0 0 21 7 2 0 0 0 12 0 110010033021000 3 308 308 3 psa_27 3D2
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
5393 5393 1000000US110010080022008 Block 2008, Block Group 2, Census Tract 80.02, District of Columbia, District of Columbia 202 105 82 0 3 0 12 0 202 188 103 82 0 3 0 0 0 14 2 0 0 0 0 12 0 110010080022008 1 108 108 1 psa_17 1D2
5540 5540 1000000US110010105001001 Block 1001, Block Group 1, Census Tract 105, District of Columbia, District of Columbia 639 201 342 2 51 0 12 31 639 592 185 332 2 51 0 4 18 47 16 10 0 0 0 8 13 110010105001001 1 103 103 1 psa_12 1D1
5541 5541 1000000US110010099041008 Block 1008, Block Group 1, Census Tract 99.04, District of Columbia, District of Columbia 31 0 19 0 0 0 12 0 31 15 0 15 0 0 0 0 0 16 0 4 0 0 0 12 0 110010099041008 6 604 604 6 psa_14 6D3
5695 5695 1000000US110010024002006 Block 2006, Block Group 2, Census Tract 24, District of Columbia, District of Columbia 73 7 54 0 0 0 12 0 73 60 6 54 0 0 0 0 0 13 1 0 0 0 0 12 0 110010024002006 4 407 407 4 psa_47 4D2
5733 5733 1000000US110010093021017 Block 1017, Block Group 1, Census Tract 93.02, District of Columbia, District of Columbia 63 9 42 0 0 0 12 0 63 51 9 42 0 0 0 0 0 12 0 0 0 0 0 12 0 110010093021017 5 504 504 5 psa_43 5D2
5896 5896 1000000US110010008014002 Block 4002, Block Group 4, Census Tract 8.01, District of Columbia, District of Columbia 76 63 0 0 1 0 12 0 76 62 56 0 0 1 0 5 0 14 7 0 0 0 0 7 0 110010008014002 2 205 205 2 psa_46 2D2
6025 6025 1000000US110010092011003 Block 1003, Block Group 1, Census Tract 92.01, District of Columbia, District of Columbia 324 279 12 0 10 0 12 11 324 298 264 11 0 9 0 3 11 26 15 1 0 1 0 9 0 110010092011003 5 502 502 5 psa_40 5D1
6056 6056 1000000US110010094002020 Block 2020, Block Group 2, Census Tract 94, District of Columbia, District of Columbia 59 2 45 0 0 0 12 0 59 47 2 45 0 0 0 0 0 12 0 0 0 0 0 12 0 110010094002020 5 504 504 5 psa_43 5D2
6365 6365 1000000US110010024001005 Block 1005, Block Group 1, Census Tract 24, District of Columbia, District of Columbia 83 20 51 0 0 0 12 0 83 56 5 51 0 0 0 0 0 27 15 0 0 0 0 12 0 110010024001005 4 407 407 4 psa_47 4D2
6387 6387 1000000US110010055002011 Block 2011, Block Group 2, Census Tract 55, District of Columbia, District of Columbia 693 563 17 0 78 0 12 23 693 632 512 16 0 78 0 5 21 61 51 1 0 0 0 7 2 110010055002011 2 207 207 2 psa_24 2D3
6483 6483 1000000US110010092011014 Block 1014, Block Group 1, Census Tract 92.01, District of Columbia, District of Columbia 164 19 132 0 1 0 12 0 164 142 13 128 0 1 0 0 0 22 6 4 0 0 0 12 0 110010092011014 5 502 502 5 psa_40 5D1
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
);