dc_2010blocks_2020policedistricts_population
Data license: CC BY-SA 4.0 · Data source: US Census & DC Open Data Portal, combined by John Keefe
21 rows where P005009 = 4 and POLDIST_ID = 7
This data as json, CSV (advanced)
Suggested facets: P003001, P003002, P003004, P003005, P003006, P003007, P003008, P005001, P005003, P005005, P005006, P005007, P005008, P005010, P005011, P005012, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
127 | 127 | 1000000US110010074011037 | Block 1037, Block Group 1, Census Tract 74.01, District of Columbia, District of Columbia | 429 | 2 | 421 | 2 | 0 | 0 | 0 | 4 | 429 | 429 | 2 | 421 | 2 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 110010074011037 | 7 | 703 | 703 | 7 | psa_8 | 7D1 |
154 | 154 | 1000000US110010074071005 | Block 1005, Block Group 1, Census Tract 74.07, District of Columbia, District of Columbia | 176 | 2 | 169 | 1 | 0 | 0 | 0 | 4 | 176 | 176 | 2 | 169 | 1 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 110010074071005 | 7 | 702 | 702 | 7 | psa_6 | 7D1 |
159 | 159 | 1000000US110010074081012 | Block 1012, Block Group 1, Census Tract 74.08, District of Columbia, District of Columbia | 533 | 0 | 527 | 1 | 0 | 0 | 1 | 4 | 533 | 531 | 0 | 525 | 1 | 0 | 0 | 1 | 4 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 110010074081012 | 7 | 702 | 702 | 7 | psa_6 | 7D1 |
160 | 160 | 1000000US110010074091000 | Block 1000, Block Group 1, Census Tract 74.09, District of Columbia, District of Columbia | 372 | 2 | 361 | 1 | 0 | 0 | 4 | 4 | 372 | 372 | 2 | 361 | 1 | 0 | 0 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 110010074091000 | 7 | 704 | 704 | 7 | psa_5 | 7D2 |
305 | 305 | 1000000US110010097001009 | Block 1009, Block Group 1, Census Tract 97, District of Columbia, District of Columbia | 105 | 0 | 100 | 1 | 0 | 0 | 0 | 4 | 105 | 105 | 0 | 100 | 1 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 110010097001009 | 7 | 706 | 706 | 7 | psa_2 | 7D3 |
469 | 469 | 1000000US110010098072009 | Block 2009, Block Group 2, Census Tract 98.07, District of Columbia, District of Columbia | 247 | 2 | 240 | 0 | 0 | 0 | 1 | 4 | 247 | 247 | 2 | 240 | 0 | 0 | 0 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 110010098072009 | 7 | 708 | 708 | 7 | psa_1 | 7D3 |
489 | 489 | 1000000US110010104001016 | Block 1016, Block Group 1, Census Tract 104, District of Columbia, District of Columbia | 160 | 2 | 154 | 0 | 0 | 0 | 0 | 4 | 160 | 159 | 2 | 153 | 0 | 0 | 0 | 0 | 4 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 110010104001016 | 7 | 707 | 707 | 7 | psa_4 | 7D2 |
504 | 504 | 1000000US110010109002000 | Block 2000, Block Group 2, Census Tract 109, District of Columbia, District of Columbia | 266 | 3 | 259 | 0 | 0 | 0 | 0 | 4 | 266 | 265 | 3 | 258 | 0 | 0 | 0 | 0 | 4 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 110010109002000 | 7 | 708 | 708 | 7 | psa_1 | 7D3 |
1593 | 1593 | 1000000US110010098033000 | Block 3000, Block Group 3, Census Tract 98.03, District of Columbia, District of Columbia | 53 | 0 | 49 | 0 | 0 | 0 | 0 | 4 | 53 | 53 | 0 | 49 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 110010098033000 | 7 | 707 | 707 | 7 | psa_4 | 7D2 |
1993 | 1993 | 1000000US110010097001016 | Block 1016, Block Group 1, Census Tract 97, District of Columbia, District of Columbia | 232 | 3 | 225 | 0 | 0 | 0 | 0 | 4 | 232 | 231 | 3 | 224 | 0 | 0 | 0 | 0 | 4 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 110010097001016 | 7 | 706 | 706 | 7 | psa_2 | 7D3 |
2365 | 2365 | 1000000US110010104002040 | Block 2040, Block Group 2, Census Tract 104, District of Columbia, District of Columbia | 157 | 2 | 150 | 0 | 0 | 0 | 0 | 5 | 157 | 155 | 1 | 150 | 0 | 0 | 0 | 0 | 4 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 110010104002040 | 7 | 707 | 707 | 7 | psa_4 | 7D2 |
3011 | 3011 | 1000000US110010097001012 | Block 1012, Block Group 1, Census Tract 97, District of Columbia, District of Columbia | 739 | 7 | 713 | 1 | 1 | 5 | 5 | 7 | 739 | 720 | 1 | 709 | 1 | 0 | 5 | 0 | 4 | 19 | 6 | 4 | 0 | 1 | 0 | 5 | 3 | 110010097001012 | 7 | 706 | 706 | 7 | psa_2 | 7D3 |
3603 | 3603 | 1000000US110010098011003 | Block 1003, Block Group 1, Census Tract 98.01, District of Columbia, District of Columbia | 301 | 0 | 295 | 2 | 0 | 0 | 0 | 4 | 301 | 298 | 0 | 292 | 2 | 0 | 0 | 0 | 4 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 110010098011003 | 7 | 706 | 706 | 7 | psa_2 | 7D3 |
3894 | 3894 | 1000000US110010098033005 | Block 3005, Block Group 3, Census Tract 98.03, District of Columbia, District of Columbia | 202 | 7 | 190 | 0 | 0 | 0 | 0 | 5 | 202 | 200 | 7 | 189 | 0 | 0 | 0 | 0 | 4 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 110010098033005 | 7 | 707 | 707 | 7 | psa_4 | 7D2 |
4611 | 4611 | 1000000US110010075022003 | Block 2003, Block Group 2, Census Tract 75.02, District of Columbia, District of Columbia | 144 | 3 | 134 | 0 | 0 | 0 | 3 | 4 | 144 | 141 | 2 | 132 | 0 | 0 | 0 | 3 | 4 | 3 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 110010075022003 | 7 | 702 | 702 | 7 | psa_6 | 7D1 |
4658 | 4658 | 1000000US110010109001002 | Block 1002, Block Group 1, Census Tract 109, District of Columbia, District of Columbia | 146 | 2 | 139 | 0 | 1 | 0 | 0 | 4 | 146 | 145 | 2 | 138 | 0 | 1 | 0 | 0 | 4 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 110010109001002 | 7 | 708 | 708 | 7 | psa_1 | 7D3 |
4694 | 4694 | 1000000US110010073041004 | Block 1004, Block Group 1, Census Tract 73.04, District of Columbia, District of Columbia | 230 | 4 | 221 | 0 | 0 | 0 | 0 | 5 | 230 | 227 | 4 | 219 | 0 | 0 | 0 | 0 | 4 | 3 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 110010073041004 | 7 | 705 | 705 | 7 | psa_3 | 7D2 |
5638 | 5638 | 1000000US110010074042002 | Block 2002, Block Group 2, Census Tract 74.04, District of Columbia, District of Columbia | 77 | 0 | 73 | 0 | 0 | 0 | 0 | 4 | 77 | 77 | 0 | 73 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 110010074042002 | 7 | 704 | 704 | 7 | psa_5 | 7D2 |
5802 | 5802 | 1000000US110010098072005 | Block 2005, Block Group 2, Census Tract 98.07, District of Columbia, District of Columbia | 230 | 0 | 226 | 0 | 0 | 0 | 0 | 4 | 230 | 230 | 0 | 226 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 110010098072005 | 7 | 708 | 708 | 7 | psa_1 | 7D3 |
6233 | 6233 | 1000000US110010104002042 | Block 2042, Block Group 2, Census Tract 104, District of Columbia, District of Columbia | 132 | 3 | 124 | 1 | 0 | 0 | 0 | 4 | 132 | 132 | 3 | 124 | 1 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 110010104002042 | 7 | 707 | 707 | 7 | psa_4 | 7D2 |
6288 | 6288 | 1000000US110010073011138 | Block 1138, Block Group 1, Census Tract 73.01, District of Columbia, District of Columbia | 64 | 36 | 15 | 1 | 2 | 1 | 0 | 9 | 64 | 55 | 32 | 15 | 1 | 2 | 1 | 0 | 4 | 9 | 4 | 0 | 0 | 0 | 0 | 0 | 5 | 110010073011138 | 7 | 707 | 707 | 7 | psa_4 | 7D2 |
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 );