dc_2010blocks_2020policedistricts_population
Data license: CC BY-SA 4.0 · Data source: US Census & DC Open Data Portal, combined by John Keefe
22 rows where DISTRICT = 1 and P005007 = 1
This data as json, CSV (advanced)
Suggested facets: P003002, P003003, P003004, P003005, P003007, P003008, P005002, P005003, P005004, P005005, P005006, P005008, P005009, P005010, P005011, P005012, P005013, P005014, P005016, P005017, PSA, NAME, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20 | 20 | 1000000US110010047021012 | Block 1012, Block Group 1, Census Tract 47.02, District of Columbia, District of Columbia | 427 | 307 | 46 | 0 | 59 | 1 | 3 | 11 | 427 | 401 | 285 | 46 | 0 | 59 | 1 | 1 | 9 | 26 | 22 | 0 | 0 | 0 | 0 | 2 | 2 | 110010047021012 | 1 | 101 | 101 | 1 | psa_20 | 1D1 |
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 |
224 | 224 | 1000000US110010084021005 | Block 1005, Block Group 1, Census Tract 84.02, District of Columbia, District of Columbia | 245 | 118 | 103 | 3 | 10 | 1 | 1 | 9 | 245 | 236 | 113 | 101 | 2 | 10 | 1 | 0 | 9 | 9 | 5 | 2 | 1 | 0 | 0 | 1 | 0 | 110010084021005 | 1 | 104 | 104 | 1 | psa_21 | 1D2 |
574 | 574 | 1000000US110010105002028 | Block 2028, Block Group 2, Census Tract 105, District of Columbia, District of Columbia | 1005 | 575 | 273 | 7 | 97 | 1 | 16 | 36 | 1005 | 930 | 530 | 264 | 5 | 96 | 1 | 2 | 32 | 75 | 45 | 9 | 2 | 1 | 0 | 14 | 4 | 110010105002028 | 1 | 103 | 103 | 1 | psa_12 | 1D1 |
856 | 856 | 1000000US110010082002004 | Block 2004, Block Group 2, Census Tract 82, District of Columbia, District of Columbia | 299 | 243 | 19 | 2 | 31 | 1 | 3 | 0 | 299 | 290 | 237 | 19 | 2 | 31 | 1 | 0 | 0 | 9 | 6 | 0 | 0 | 0 | 0 | 3 | 0 | 110010082002004 | 1 | 108 | 108 | 1 | psa_17 | 1D2 |
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 |
1366 | 1366 | 1000000US110010080011003 | Block 1003, Block Group 1, Census Tract 80.01, District of Columbia, District of Columbia | 143 | 66 | 60 | 0 | 10 | 1 | 0 | 6 | 143 | 139 | 63 | 59 | 0 | 10 | 1 | 0 | 6 | 4 | 3 | 1 | 0 | 0 | 0 | 0 | 0 | 110010080011003 | 1 | 104 | 104 | 1 | psa_21 | 1D2 |
1559 | 1559 | 1000000US110010083021004 | Block 1004, Block Group 1, Census Tract 83.02, District of Columbia, District of Columbia | 214 | 159 | 46 | 0 | 4 | 1 | 0 | 4 | 214 | 205 | 152 | 45 | 0 | 4 | 1 | 0 | 3 | 9 | 7 | 1 | 0 | 0 | 0 | 0 | 1 | 110010083021004 | 1 | 104 | 104 | 1 | psa_21 | 1D2 |
1728 | 1728 | 1000000US110010058001024 | Block 1024, Block Group 1, Census Tract 58, District of Columbia, District of Columbia | 11 | 10 | 0 | 0 | 0 | 1 | 0 | 0 | 11 | 10 | 9 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 110010058001024 | 1 | 101 | 101 | 1 | psa_20 | 1D1 |
1934 | 1934 | 1000000US110010083011006 | Block 1006, Block Group 1, Census Tract 83.01, District of Columbia, District of Columbia | 164 | 122 | 28 | 0 | 7 | 1 | 0 | 6 | 164 | 163 | 122 | 28 | 0 | 6 | 1 | 0 | 6 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 110010083011006 | 1 | 104 | 104 | 1 | psa_21 | 1D2 |
2103 | 2103 | 1000000US110010102002023 | Block 2023, Block Group 2, Census Tract 102, District of Columbia, District of Columbia | 41 | 29 | 9 | 0 | 2 | 1 | 0 | 0 | 41 | 39 | 27 | 9 | 0 | 2 | 1 | 0 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 110010102002023 | 1 | 103 | 103 | 1 | psa_12 | 1D1 |
2319 | 2319 | 1000000US110010110001002 | Block 1002, Block Group 1, Census Tract 110, District of Columbia, District of Columbia | 517 | 29 | 423 | 7 | 8 | 1 | 29 | 20 | 517 | 482 | 27 | 416 | 7 | 8 | 1 | 4 | 19 | 35 | 2 | 7 | 0 | 0 | 0 | 25 | 1 | 110010110001002 | 1 | 105 | 105 | 1 | psa_22 | 1D3 |
3006 | 3006 | 1000000US110010081001004 | Block 1004, Block Group 1, Census Tract 81, District of Columbia, District of Columbia | 201 | 156 | 38 | 0 | 3 | 1 | 0 | 3 | 201 | 195 | 150 | 38 | 0 | 3 | 1 | 0 | 3 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 110010081001004 | 1 | 108 | 108 | 1 | psa_17 | 1D2 |
3021 | 3021 | 1000000US110010047012010 | Block 2010, Block Group 2, Census Tract 47.01, District of Columbia, District of Columbia | 1580 | 532 | 486 | 8 | 496 | 1 | 13 | 44 | 1580 | 1512 | 493 | 479 | 7 | 493 | 1 | 1 | 38 | 68 | 39 | 7 | 1 | 3 | 0 | 12 | 6 | 110010047012010 | 1 | 101 | 101 | 1 | psa_20 | 1D1 |
3038 | 3038 | 1000000US110010067001004 | Block 1004, Block Group 1, Census Tract 67, District of Columbia, District of Columbia | 264 | 219 | 31 | 2 | 2 | 1 | 8 | 1 | 264 | 246 | 206 | 31 | 2 | 2 | 1 | 3 | 1 | 18 | 13 | 0 | 0 | 0 | 0 | 5 | 0 | 110010067001004 | 1 | 107 | 107 | 1 | psa_16 | 1D2 |
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 |
4291 | 4291 | 1000000US110010110002005 | Block 2005, Block Group 2, Census Tract 110, District of Columbia, District of Columbia | 58 | 50 | 5 | 0 | 1 | 1 | 1 | 0 | 58 | 55 | 48 | 5 | 0 | 1 | 1 | 0 | 0 | 3 | 2 | 0 | 0 | 0 | 0 | 1 | 0 | 110010110002005 | 1 | 105 | 105 | 1 | psa_22 | 1D3 |
4293 | 4293 | 1000000US110010110002007 | Block 2007, Block Group 2, Census Tract 110, District of Columbia, District of Columbia | 26 | 22 | 3 | 0 | 0 | 1 | 0 | 0 | 26 | 25 | 21 | 3 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 110010110002007 | 1 | 105 | 105 | 1 | psa_22 | 1D3 |
4356 | 4356 | 1000000US110010084101020 | Block 1020, Block Group 1, Census Tract 84.10, District of Columbia, District of Columbia | 57 | 23 | 30 | 0 | 3 | 1 | 0 | 0 | 57 | 54 | 23 | 27 | 0 | 3 | 1 | 0 | 0 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 110010084101020 | 1 | 104 | 104 | 1 | psa_21 | 1D2 |
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 |
4766 | 4766 | 1000000US110010065001006 | Block 1006, Block Group 1, Census Tract 65, District of Columbia, District of Columbia | 171 | 147 | 8 | 0 | 8 | 1 | 5 | 2 | 171 | 163 | 142 | 8 | 0 | 8 | 1 | 2 | 2 | 8 | 5 | 0 | 0 | 0 | 0 | 3 | 0 | 110010065001006 | 1 | 106 | 106 | 1 | psa_13 | 1D3 |
5978 | 5978 | 1000000US110010059001018 | Block 1018, Block Group 1, Census Tract 59, District of Columbia, District of Columbia | 283 | 209 | 26 | 0 | 37 | 1 | 1 | 9 | 283 | 271 | 202 | 25 | 0 | 37 | 1 | 0 | 6 | 12 | 7 | 1 | 0 | 0 | 0 | 1 | 3 | 110010059001018 | 1 | 101 | 101 | 1 | psa_20 | 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 );