dc_2010blocks_2020policedistricts_population
Data license: CC BY-SA 4.0 · Data source: US Census & DC Open Data Portal, combined by John Keefe
26 rows where P003006 = 0, P005012 = 1 and P005017 = 3
This data as json, CSV (advanced)
Suggested facets: P003002, P003003, P003004, P003007, P003008, P005003, P005004, P005005, P005006, P005008, P005009, P005010, P005011, P005013, P005014, P005016, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
298 | 298 | 1000000US110010096022004 | Block 2004, Block Group 2, Census Tract 96.02, District of Columbia, District of Columbia | 841 | 0 | 826 | 0 | 0 | 0 | 6 | 9 | 841 | 831 | 0 | 825 | 0 | 0 | 0 | 0 | 6 | 10 | 0 | 1 | 0 | 0 | 0 | 6 | 3 | 110010096022004 | 6 | 601 | 601 | 6 | psa_30 | 6D1 |
343 | 343 | 1000000US110010008013022 | Block 3022, Block Group 3, Census Tract 8.01, District of Columbia, District of Columbia | 343 | 282 | 18 | 0 | 22 | 0 | 11 | 10 | 343 | 311 | 262 | 17 | 0 | 22 | 0 | 3 | 7 | 32 | 20 | 1 | 0 | 0 | 0 | 8 | 3 | 110010008013022 | 2 | 204 | 204 | 2 | psa_44 | 2D2 |
440 | 440 | 1000000US110010031001015 | Block 1015, Block Group 1, Census Tract 31, District of Columbia, District of Columbia | 111 | 38 | 30 | 0 | 2 | 0 | 38 | 3 | 111 | 47 | 16 | 29 | 0 | 2 | 0 | 0 | 0 | 64 | 22 | 1 | 0 | 0 | 0 | 38 | 3 | 110010031001015 | 3 | 302 | 302 | 3 | psa_42 | 3D1 |
498 | 498 | 1000000US110010107002008 | Block 2008, Block Group 2, Census Tract 107, District of Columbia, District of Columbia | 666 | 524 | 20 | 1 | 85 | 0 | 14 | 22 | 666 | 619 | 494 | 19 | 0 | 84 | 0 | 3 | 19 | 47 | 30 | 1 | 1 | 1 | 0 | 11 | 3 | 110010107002008 | 2 | 208 | 208 | 2 | psa_33 | 2D3 |
751 | 751 | 1000000US110010099022000 | Block 2000, Block Group 2, Census Tract 99.02, District of Columbia, District of Columbia | 349 | 0 | 328 | 1 | 0 | 0 | 2 | 18 | 349 | 343 | 0 | 327 | 1 | 0 | 0 | 0 | 15 | 6 | 0 | 1 | 0 | 0 | 0 | 2 | 3 | 110010099022000 | 6 | 605 | 605 | 6 | psa_11 | 6D2 |
1195 | 1195 | 1000000US110010052014005 | Block 4005, Block Group 4, Census Tract 52.01, District of Columbia, District of Columbia | 555 | 484 | 14 | 0 | 44 | 0 | 4 | 9 | 555 | 522 | 457 | 13 | 0 | 44 | 0 | 2 | 6 | 33 | 27 | 1 | 0 | 0 | 0 | 2 | 3 | 110010052014005 | 2 | 208 | 208 | 2 | psa_33 | 2D3 |
1649 | 1649 | 1000000US110010013013002 | Block 3002, Block Group 3, Census Tract 13.01, District of Columbia, District of Columbia | 736 | 478 | 112 | 2 | 108 | 0 | 16 | 20 | 736 | 668 | 426 | 111 | 2 | 108 | 0 | 4 | 17 | 68 | 52 | 1 | 0 | 0 | 0 | 12 | 3 | 110010013013002 | 2 | 203 | 203 | 2 | psa_50 | 2D1 |
2046 | 2046 | 1000000US110010110003000 | Block 3000, Block Group 3, Census Tract 110, District of Columbia, District of Columbia | 278 | 173 | 86 | 0 | 9 | 0 | 2 | 8 | 278 | 264 | 165 | 85 | 0 | 9 | 0 | 0 | 5 | 14 | 8 | 1 | 0 | 0 | 0 | 2 | 3 | 110010110003000 | 1 | 103 | 103 | 1 | psa_12 | 1D1 |
2325 | 2325 | 1000000US110010031001003 | Block 1003, Block Group 1, Census Tract 31, District of Columbia, District of Columbia | 168 | 39 | 96 | 0 | 7 | 0 | 21 | 5 | 168 | 130 | 26 | 95 | 0 | 7 | 0 | 0 | 2 | 38 | 13 | 1 | 0 | 0 | 0 | 21 | 3 | 110010031001003 | 4 | 409 | 409 | 4 | psa_41 | 4D3 |
2444 | 2444 | 1000000US110010089041005 | Block 1005, Block Group 1, Census Tract 89.04, District of Columbia, District of Columbia | 102 | 0 | 99 | 0 | 0 | 0 | 0 | 3 | 102 | 98 | 0 | 98 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 110010089041005 | 5 | 507 | 507 | 5 | psa_23 | 5D3 |
2676 | 2676 | 1000000US110010017021008 | Block 1008, Block Group 1, Census Tract 17.02, District of Columbia, District of Columbia | 117 | 44 | 49 | 1 | 5 | 0 | 11 | 7 | 117 | 92 | 34 | 48 | 1 | 5 | 0 | 0 | 4 | 25 | 10 | 1 | 0 | 0 | 0 | 11 | 3 | 110010017021008 | 4 | 401 | 401 | 4 | psa_56 | 4D1 |
2881 | 2881 | 1000000US110010053011001 | Block 1001, Block Group 1, Census Tract 53.01, District of Columbia, District of Columbia | 431 | 361 | 13 | 1 | 35 | 0 | 8 | 13 | 431 | 405 | 349 | 12 | 0 | 34 | 0 | 0 | 10 | 26 | 12 | 1 | 1 | 1 | 0 | 8 | 3 | 110010053011001 | 3 | 301 | 301 | 3 | psa_31 | 3D3 |
3188 | 3188 | 1000000US110010095053012 | Block 3012, Block Group 3, Census Tract 95.05, District of Columbia, District of Columbia | 59 | 3 | 49 | 0 | 0 | 0 | 0 | 7 | 59 | 54 | 2 | 48 | 0 | 0 | 0 | 0 | 4 | 5 | 1 | 1 | 0 | 0 | 0 | 0 | 3 | 110010095053012 | 4 | 406 | 406 | 4 | psa_54 | 4D2 |
3584 | 3584 | 1000000US110010053014004 | Block 4004, Block Group 4, Census Tract 53.01, District of Columbia, District of Columbia | 252 | 212 | 9 | 0 | 17 | 0 | 5 | 9 | 252 | 224 | 193 | 8 | 0 | 17 | 0 | 0 | 6 | 28 | 19 | 1 | 0 | 0 | 0 | 5 | 3 | 110010053014004 | 3 | 301 | 301 | 3 | psa_31 | 3D3 |
4029 | 4029 | 1000000US110010088023001 | Block 3001, Block Group 3, Census Tract 88.02, District of Columbia, District of Columbia | 223 | 17 | 188 | 1 | 6 | 0 | 5 | 6 | 223 | 211 | 14 | 187 | 1 | 6 | 0 | 0 | 3 | 12 | 3 | 1 | 0 | 0 | 0 | 5 | 3 | 110010088023001 | 5 | 506 | 506 | 5 | psa_26 | 5D3 |
4083 | 4083 | 1000000US110010067003009 | Block 3009, Block Group 3, Census Tract 67, District of Columbia, District of Columbia | 195 | 164 | 9 | 1 | 11 | 0 | 1 | 9 | 195 | 182 | 156 | 8 | 1 | 11 | 0 | 0 | 6 | 13 | 8 | 1 | 0 | 0 | 0 | 1 | 3 | 110010067003009 | 1 | 107 | 107 | 1 | psa_16 | 1D2 |
4170 | 4170 | 1000000US110010042011006 | Block 1006, Block Group 1, Census Tract 42.01, District of Columbia, District of Columbia | 270 | 194 | 27 | 0 | 23 | 0 | 15 | 11 | 270 | 233 | 176 | 26 | 0 | 23 | 0 | 0 | 8 | 37 | 18 | 1 | 0 | 0 | 0 | 15 | 3 | 110010042011006 | 3 | 301 | 301 | 3 | psa_31 | 3D3 |
4387 | 4387 | 1000000US110010078081009 | Block 1009, Block Group 1, Census Tract 78.08, District of Columbia, District of Columbia | 200 | 0 | 187 | 0 | 0 | 0 | 0 | 13 | 200 | 196 | 0 | 186 | 0 | 0 | 0 | 0 | 10 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 110010078081009 | 6 | 608 | 608 | 6 | psa_19 | 6D1 |
5336 | 5336 | 1000000US110010047021008 | Block 1008, Block Group 1, Census Tract 47.02, District of Columbia, District of Columbia | 371 | 225 | 47 | 0 | 80 | 0 | 5 | 14 | 371 | 359 | 218 | 46 | 0 | 80 | 0 | 4 | 11 | 12 | 7 | 1 | 0 | 0 | 0 | 1 | 3 | 110010047021008 | 1 | 101 | 101 | 1 | psa_20 | 1D1 |
5363 | 5363 | 1000000US110010079011001 | Block 1001, Block Group 1, Census Tract 79.01, District of Columbia, District of Columbia | 291 | 0 | 282 | 1 | 0 | 0 | 0 | 8 | 291 | 287 | 0 | 281 | 1 | 0 | 0 | 0 | 5 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 110010079011001 | 5 | 507 | 507 | 5 | psa_23 | 5D3 |
5490 | 5490 | 1000000US110010065002002 | Block 2002, Block Group 2, Census Tract 65, District of Columbia, District of Columbia | 120 | 78 | 22 | 4 | 5 | 0 | 4 | 7 | 120 | 109 | 75 | 21 | 4 | 5 | 0 | 0 | 4 | 11 | 3 | 1 | 0 | 0 | 0 | 4 | 3 | 110010065002002 | 1 | 107 | 107 | 1 | psa_16 | 1D2 |
5568 | 5568 | 1000000US110010010022006 | Block 2006, Block Group 2, Census Tract 10.02, District of Columbia, District of Columbia | 141 | 87 | 7 | 1 | 28 | 0 | 9 | 9 | 141 | 113 | 72 | 6 | 1 | 28 | 0 | 0 | 6 | 28 | 15 | 1 | 0 | 0 | 0 | 9 | 3 | 110010010022006 | 2 | 204 | 204 | 2 | psa_44 | 2D2 |
5761 | 5761 | 1000000US110010005021000 | Block 1000, Block Group 1, Census Tract 5.02, District of Columbia, District of Columbia | 377 | 279 | 17 | 8 | 34 | 0 | 26 | 13 | 377 | 308 | 247 | 16 | 1 | 34 | 0 | 0 | 10 | 69 | 32 | 1 | 7 | 0 | 0 | 26 | 3 | 110010005021000 | 2 | 204 | 204 | 2 | psa_44 | 2D2 |
6049 | 6049 | 1000000US110010016002010 | Block 2010, Block Group 2, Census Tract 16, District of Columbia, District of Columbia | 45 | 18 | 22 | 0 | 0 | 0 | 0 | 5 | 45 | 41 | 18 | 21 | 0 | 0 | 0 | 0 | 2 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 110010016002010 | 4 | 401 | 401 | 4 | psa_56 | 4D1 |
6071 | 6071 | 1000000US110010042022004 | Block 2004, Block Group 2, Census Tract 42.02, District of Columbia, District of Columbia | 492 | 424 | 33 | 1 | 23 | 0 | 3 | 8 | 492 | 471 | 409 | 32 | 1 | 23 | 0 | 1 | 5 | 21 | 15 | 1 | 0 | 0 | 0 | 2 | 3 | 110010042022004 | 2 | 208 | 208 | 2 | psa_33 | 2D3 |
6087 | 6087 | 1000000US110010105001003 | Block 1003, Block Group 1, Census Tract 105, District of Columbia, District of Columbia | 671 | 223 | 391 | 2 | 19 | 0 | 14 | 22 | 671 | 628 | 197 | 390 | 2 | 18 | 0 | 2 | 19 | 43 | 26 | 1 | 0 | 1 | 0 | 12 | 3 | 110010105001003 | 1 | 103 | 103 | 1 | psa_12 | 1D1 |
Advanced export
JSON shape: default, array, newline-delimited
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 );