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

37 rows where P003004 = 1 and P005012 = 3

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003002, P003005, P003006, P003007, P003008, P005003, P005005, P005006, P005007, P005008, P005009, P005010, P005011, P005013, P005014, P005015, 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
171 171 1000000US110010076041005 Block 1005, Block Group 1, Census Tract 76.04, District of Columbia, District of Columbia 111 6 104 1 0 0 0 0 111 105 3 101 1 0 0 0 0 6 3 3 0 0 0 0 0 110010076041005 6 607 607 6 psa_10 6D2
182 182 1000000US110010077072005 Block 2005, Block Group 2, Census Tract 77.07, District of Columbia, District of Columbia 191 2 188 1 0 0 0 0 191 188 2 185 1 0 0 0 0 3 0 3 0 0 0 0 0 110010077072005 6 605 605 6 psa_11 6D2
252 252 1000000US110010094001003 Block 1003, Block Group 1, Census Tract 94, District of Columbia, District of Columbia 58 8 49 1 0 0 0 0 58 54 8 46 0 0 0 0 0 4 0 3 1 0 0 0 0 110010094001003 5 503 503 5 psa_45 5D2
418 418 1000000US110010024002002 Block 2002, Block Group 2, Census Tract 24, District of Columbia, District of Columbia 19 7 10 1 0 0 0 1 19 10 3 7 0 0 0 0 0 9 4 3 1 0 0 0 1 110010024002002 4 407 407 4 psa_47 4D2
430 430 1000000US110010027013001 Block 3001, Block Group 3, Census Tract 27.01, District of Columbia, District of Columbia 248 191 26 1 11 0 7 12 248 218 179 23 0 11 0 0 5 30 12 3 1 0 0 7 7 110010027013001 3 302 302 3 psa_42 3D1
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
620 620 1000000US110010025024001 Block 4001, Block Group 4, Census Tract 25.02, District of Columbia, District of Columbia 129 47 57 1 5 0 10 9 129 107 43 54 1 5 0 0 4 22 4 3 0 0 0 10 5 110010025024001 4 404 404 4 psa_48 4D3
936 936 1000000US110010074092001 Block 2001, Block Group 2, Census Tract 74.09, District of Columbia, District of Columbia 487 0 484 1 0 0 0 2 487 484 0 481 1 0 0 0 2 3 0 3 0 0 0 0 0 110010074092001 7 704 704 7 psa_5 7D2
1012 1012 1000000US110010053013001 Block 3001, Block Group 3, Census Tract 53.01, District of Columbia, District of Columbia 1102 856 51 1 137 2 21 34 1102 986 770 48 0 136 1 5 26 116 86 3 1 1 1 16 8 110010053013001 2 208 208 2 psa_33 2D3
1185 1185 1000000US110010095082005 Block 2005, Block Group 2, Census Tract 95.08, District of Columbia, District of Columbia 435 20 376 1 6 0 25 7 435 400 15 373 0 6 0 0 6 35 5 3 1 0 0 25 1 110010095082005 4 406 406 4 psa_54 4D2
1235 1235 1000000US110010036003002 Block 3002, Block Group 3, Census Tract 36, District of Columbia, District of Columbia 328 192 83 1 12 0 28 12 328 278 174 80 1 11 0 1 11 50 18 3 0 1 0 27 1 110010036003002 3 304 304 3 psa_36 3D1
1619 1619 1000000US110010104002019 Block 2019, Block Group 2, Census Tract 104, District of Columbia, District of Columbia 176 4 168 1 0 0 0 3 176 172 4 165 0 0 0 0 3 4 0 3 1 0 0 0 0 110010104002019 7 707 707 7 psa_4 7D2
1726 1726 1000000US110010050022002 Block 2002, Block Group 2, Census Tract 50.02, District of Columbia, District of Columbia 349 279 24 1 23 0 4 18 349 308 251 21 1 23 0 0 12 41 28 3 0 0 0 4 6 110010050022002 3 307 307 3 psa_28 3D3
1729 1729 1000000US110010099022009 Block 2009, Block Group 2, Census Tract 99.02, District of Columbia, District of Columbia 142 3 138 1 0 0 0 0 142 138 3 135 0 0 0 0 0 4 0 3 1 0 0 0 0 110010099022009 6 605 605 6 psa_11 6D2
2138 2138 1000000US110010094002018 Block 2018, Block Group 2, Census Tract 94, District of Columbia, District of Columbia 240 20 174 1 2 0 21 22 240 196 12 171 1 2 0 0 10 44 8 3 0 0 0 21 12 110010094002018 5 504 504 5 psa_43 5D2
2149 2149 1000000US110010073043003 Block 3003, Block Group 3, Census Tract 73.04, District of Columbia, District of Columbia 254 3 243 1 0 0 0 7 254 250 3 240 1 0 0 0 6 4 0 3 0 0 0 0 1 110010073043003 7 705 705 7 psa_3 7D2
2239 2239 1000000US110010033021005 Block 1005, Block Group 1, Census Tract 33.02, District of Columbia, District of Columbia 161 43 105 1 0 0 0 12 161 158 43 102 1 0 0 0 12 3 0 3 0 0 0 0 0 110010033021005 3 308 308 3 psa_27 3D2
2318 2318 1000000US110010022023007 Block 3007, Block Group 3, Census Tract 22.02, District of Columbia, District of Columbia 162 18 114 1 1 0 18 10 162 127 11 111 1 1 0 0 3 35 7 3 0 0 0 18 7 110010022023007 4 407 407 4 psa_47 4D2
2592 2592 1000000US110010077081001 Block 1001, Block Group 1, Census Tract 77.08, District of Columbia, District of Columbia 270 2 267 1 0 0 0 0 270 267 2 264 1 0 0 0 0 3 0 3 0 0 0 0 0 110010077081001 6 603 603 6 psa_15 6D3
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
2835 2835 1000000US110010088024004 Block 4004, Block Group 4, Census Tract 88.02, District of Columbia, District of Columbia 231 20 200 1 0 0 7 3 231 219 20 197 0 0 0 1 1 12 0 3 1 0 0 6 2 110010088024004 5 506 506 5 psa_26 5D3
2981 2981 1000000US110010102001021 Block 1021, Block Group 1, Census Tract 102, District of Columbia, District of Columbia 440 220 177 1 22 0 0 20 440 416 203 174 1 22 0 0 16 24 17 3 0 0 0 0 4 110010102001021 1 103 103 1 psa_12 1D1
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
4037 4037 1000000US110010094001005 Block 1005, Block Group 1, Census Tract 94, District of Columbia, District of Columbia 90 9 69 1 2 0 5 4 90 82 9 66 1 2 0 0 4 8 0 3 0 0 0 5 0 110010094001005 5 503 503 5 psa_45 5D2
4168 4168 1000000US110010098102004 Block 2004, Block Group 2, Census Tract 98.10, District of Columbia, District of Columbia 127 0 126 1 0 0 0 0 127 124 0 123 1 0 0 0 0 3 0 3 0 0 0 0 0 110010098102004 7 708 708 7 psa_1 7D3
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
4280 4280 1000000US110010093021013 Block 1013, Block Group 1, Census Tract 93.02, District of Columbia, District of Columbia 71 2 62 1 3 0 0 3 71 68 2 59 1 3 0 0 3 3 0 3 0 0 0 0 0 110010093021013 5 504 504 5 psa_43 5D2
4407 4407 1000000US110010106002049 Block 2049, Block Group 2, Census Tract 106, District of Columbia, District of Columbia 123 77 37 1 3 0 0 5 123 114 74 34 1 2 0 0 3 9 3 3 0 1 0 0 2 110010106002049 1 104 104 1 psa_21 1D2
4432 4432 1000000US110010076034004 Block 4004, Block Group 4, Census Tract 76.03, District of Columbia, District of Columbia 267 19 235 1 0 0 4 8 267 258 19 232 1 0 0 0 6 9 0 3 0 0 0 4 2 110010076034004 6 606 606 6 psa_7 6D2
4510 4510 1000000US110010016001009 Block 1009, Block Group 1, Census Tract 16, District of Columbia, District of Columbia 38 2 35 1 0 0 0 0 38 34 1 32 1 0 0 0 0 4 1 3 0 0 0 0 0 110010016001009 4 401 401 4 psa_56 4D1
4789 4789 1000000US110010089032002 Block 2002, Block Group 2, Census Tract 89.03, District of Columbia, District of Columbia 658 1 644 1 0 0 4 8 658 654 1 641 1 0 0 3 8 4 0 3 0 0 0 1 0 110010089032002 5 507 507 5 psa_23 5D3
4942 4942 1000000US110010099041003 Block 1003, Block Group 1, Census Tract 99.04, District of Columbia, District of Columbia 79 2 76 1 0 0 0 0 79 76 2 73 1 0 0 0 0 3 0 3 0 0 0 0 0 110010099041003 6 604 604 6 psa_14 6D3
5455 5455 1000000US110010091021007 Block 1007, Block Group 1, Census Tract 91.02, District of Columbia, District of Columbia 91 4 81 1 3 0 0 2 91 85 1 78 1 3 0 0 2 6 3 3 0 0 0 0 0 110010091021007 5 505 505 5 psa_34 5D2
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
5844 5844 1000000US110010077031005 Block 1005, Block Group 1, Census Tract 77.03, District of Columbia, District of Columbia 151 18 34 1 0 0 91 7 151 31 0 31 0 0 0 0 0 120 18 3 1 0 0 91 7 110010077031005 6 603 603 6 psa_15 6D3
6147 6147 1000000US110010046001004 Block 1004, Block Group 1, Census Tract 46, District of Columbia, District of Columbia 384 99 246 1 13 0 9 16 384 347 77 243 1 13 0 1 12 37 22 3 0 0 0 8 4 110010046001004 3 308 308 3 psa_27 3D2
6262 6262 1000000US110010107001032 Block 1032, Block Group 1, Census Tract 107, District of Columbia, District of Columbia 53 15 32 1 0 0 3 2 53 44 13 29 1 0 0 0 1 9 2 3 0 0 0 3 1 110010107001032 2 207 207 2 psa_24 2D3

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