dc_2010blocks_2020policedistricts_population
Data license: CC BY-SA 4.0 · Data source: US Census & DC Open Data Portal, combined by John Keefe
19 rows where P003006 = 0, P005012 = 1 and P005017 = 4
This data as json, CSV (advanced)
Suggested facets: P003002, P003003, P003004, P003005, P003007, P003008, P005002, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
63 | 63 | 1000000US110010056004004 | Block 4004, Block Group 4, Census Tract 56, District of Columbia, District of Columbia | 360 | 233 | 16 | 0 | 93 | 0 | 0 | 18 | 360 | 341 | 219 | 15 | 0 | 93 | 0 | 0 | 14 | 19 | 14 | 1 | 0 | 0 | 0 | 0 | 4 | 110010056004004 | 2 | 207 | 207 | 2 | psa_24 | 2D3 |
320 | 320 | 1000000US110010003002004 | Block 2004, Block Group 2, Census Tract 3, District of Columbia, District of Columbia | 615 | 514 | 18 | 4 | 36 | 0 | 18 | 25 | 615 | 564 | 484 | 17 | 4 | 35 | 0 | 3 | 21 | 51 | 30 | 1 | 0 | 1 | 0 | 15 | 4 | 110010003002004 | 2 | 204 | 204 | 2 | psa_44 | 2D2 |
342 | 342 | 1000000US110010008013001 | Block 3001, Block Group 3, Census Tract 8.01, District of Columbia, District of Columbia | 370 | 339 | 4 | 0 | 18 | 0 | 1 | 8 | 370 | 341 | 316 | 3 | 0 | 18 | 0 | 0 | 4 | 29 | 23 | 1 | 0 | 0 | 0 | 1 | 4 | 110010008013001 | 2 | 205 | 205 | 2 | psa_46 | 2D2 |
433 | 433 | 1000000US110010027023001 | Block 3001, Block Group 3, Census Tract 27.02, District of Columbia, District of Columbia | 186 | 129 | 34 | 0 | 8 | 0 | 4 | 11 | 186 | 156 | 108 | 33 | 0 | 8 | 0 | 0 | 7 | 30 | 21 | 1 | 0 | 0 | 0 | 4 | 4 | 110010027023001 | 3 | 302 | 302 | 3 | psa_42 | 3D1 |
465 | 465 | 1000000US110010098041001 | Block 1001, Block Group 1, Census Tract 98.04, District of Columbia, District of Columbia | 1166 | 31 | 1092 | 4 | 1 | 0 | 13 | 25 | 1166 | 1131 | 11 | 1091 | 4 | 1 | 0 | 3 | 21 | 35 | 20 | 1 | 0 | 0 | 0 | 10 | 4 | 110010098041001 | 7 | 705 | 705 | 7 | psa_3 | 7D2 |
774 | 774 | 1000000US110010021024001 | Block 4001, Block Group 4, Census Tract 21.02, District of Columbia, District of Columbia | 96 | 1 | 77 | 0 | 0 | 0 | 8 | 10 | 96 | 83 | 1 | 76 | 0 | 0 | 0 | 0 | 6 | 13 | 0 | 1 | 0 | 0 | 0 | 8 | 4 | 110010021024001 | 4 | 406 | 406 | 4 | psa_54 | 4D2 |
846 | 846 | 1000000US110010058002010 | Block 2010, Block Group 2, Census Tract 58, District of Columbia, District of Columbia | 566 | 427 | 34 | 2 | 71 | 0 | 2 | 30 | 566 | 528 | 396 | 33 | 2 | 71 | 0 | 0 | 26 | 38 | 31 | 1 | 0 | 0 | 0 | 2 | 4 | 110010058002010 | 1 | 102 | 102 | 1 | psa_18 | 1D1 |
1375 | 1375 | 1000000US110010001002001 | Block 2001, Block Group 2, Census Tract 1, District of Columbia, District of Columbia | 273 | 237 | 9 | 0 | 13 | 0 | 3 | 11 | 273 | 248 | 219 | 8 | 0 | 13 | 0 | 1 | 7 | 25 | 18 | 1 | 0 | 0 | 0 | 2 | 4 | 110010001002001 | 2 | 206 | 206 | 2 | psa_29 | 2D2 |
1462 | 1462 | 1000000US110010005022006 | Block 2006, Block Group 2, Census Tract 5.02, District of Columbia, District of Columbia | 653 | 549 | 22 | 0 | 47 | 0 | 11 | 24 | 653 | 612 | 521 | 21 | 0 | 47 | 0 | 3 | 20 | 41 | 28 | 1 | 0 | 0 | 0 | 8 | 4 | 110010005022006 | 2 | 204 | 204 | 2 | psa_44 | 2D2 |
2033 | 2033 | 1000000US110010002024001 | Block 4001, Block Group 4, Census Tract 2.02, District of Columbia, District of Columbia | 123 | 75 | 11 | 1 | 21 | 0 | 7 | 8 | 123 | 109 | 73 | 10 | 1 | 20 | 0 | 1 | 4 | 14 | 2 | 1 | 0 | 1 | 0 | 6 | 4 | 110010002024001 | 2 | 206 | 206 | 2 | psa_29 | 2D2 |
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 |
4562 | 4562 | 1000000US110010093011011 | Block 1011, Block Group 1, Census Tract 93.01, District of Columbia, District of Columbia | 45 | 11 | 27 | 0 | 0 | 0 | 0 | 7 | 45 | 38 | 9 | 26 | 0 | 0 | 0 | 0 | 3 | 7 | 2 | 1 | 0 | 0 | 0 | 0 | 4 | 110010093011011 | 5 | 504 | 504 | 5 | psa_43 | 5D2 |
4634 | 4634 | 1000000US110010095071001 | Block 1001, Block Group 1, Census Tract 95.07, District of Columbia, District of Columbia | 341 | 19 | 292 | 10 | 1 | 0 | 9 | 10 | 341 | 299 | 0 | 291 | 1 | 1 | 0 | 0 | 6 | 42 | 19 | 1 | 9 | 0 | 0 | 9 | 4 | 110010095071001 | 4 | 406 | 406 | 4 | psa_54 | 4D2 |
4957 | 4957 | 1000000US110010007021000 | Block 1000, Block Group 1, Census Tract 7.02, District of Columbia, District of Columbia | 515 | 439 | 15 | 1 | 27 | 0 | 17 | 16 | 515 | 458 | 399 | 14 | 0 | 27 | 0 | 6 | 12 | 57 | 40 | 1 | 1 | 0 | 0 | 11 | 4 | 110010007021000 | 2 | 204 | 204 | 2 | psa_44 | 2D2 |
5002 | 5002 | 1000000US110010031001007 | Block 1007, Block Group 1, Census Tract 31, District of Columbia, District of Columbia | 251 | 97 | 93 | 1 | 11 | 0 | 42 | 7 | 251 | 176 | 70 | 92 | 1 | 7 | 0 | 3 | 3 | 75 | 27 | 1 | 0 | 4 | 0 | 39 | 4 | 110010031001007 | 4 | 409 | 409 | 4 | psa_41 | 4D3 |
5542 | 5542 | 1000000US110010110002000 | Block 2000, Block Group 2, Census Tract 110, District of Columbia, District of Columbia | 832 | 550 | 219 | 2 | 36 | 0 | 7 | 18 | 832 | 804 | 532 | 218 | 2 | 36 | 0 | 2 | 14 | 28 | 18 | 1 | 0 | 0 | 0 | 5 | 4 | 110010110002000 | 1 | 103 | 103 | 1 | psa_12 | 1D1 |
5801 | 5801 | 1000000US110010098042002 | Block 2002, Block Group 2, Census Tract 98.04, District of Columbia, District of Columbia | 136 | 0 | 130 | 0 | 0 | 0 | 0 | 6 | 136 | 131 | 0 | 129 | 0 | 0 | 0 | 0 | 2 | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 110010098042002 | 7 | 707 | 707 | 7 | psa_4 | 7D2 |
6080 | 6080 | 1000000US110010064001007 | Block 1007, Block Group 1, Census Tract 64, District of Columbia, District of Columbia | 122 | 0 | 116 | 0 | 0 | 0 | 0 | 6 | 122 | 117 | 0 | 115 | 0 | 0 | 0 | 0 | 2 | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 110010064001007 | 1 | 105 | 105 | 1 | psa_22 | 1D3 |
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 );