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 P003004 = 0 and P005012 = 7
This data as json, CSV (advanced)
Suggested facets: P003002, P003003, P003005, P003006, P003007, P003008, P005002, P005003, P005004, P005006, P005007, P005008, P005009, P005010, P005011, P005014, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19 | 19 | 1000000US110010047011003 | Block 1003, Block Group 1, Census Tract 47.01, District of Columbia, District of Columbia | 169 | 0 | 169 | 0 | 0 | 0 | 0 | 0 | 169 | 162 | 0 | 162 | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 110010047011003 | 1 | 102 | 102 | 1 | psa_18 | 1D1 |
470 | 470 | 1000000US110010098072010 | Block 2010, Block Group 2, Census Tract 98.07, District of Columbia, District of Columbia | 705 | 7 | 682 | 0 | 0 | 0 | 2 | 14 | 705 | 694 | 6 | 675 | 0 | 0 | 0 | 0 | 13 | 11 | 1 | 7 | 0 | 0 | 0 | 2 | 1 | 110010098072010 | 7 | 708 | 708 | 7 | psa_1 | 7D3 |
480 | 480 | 1000000US110010101001005 | Block 1005, Block Group 1, Census Tract 101, District of Columbia, District of Columbia | 541 | 395 | 92 | 0 | 37 | 2 | 7 | 8 | 541 | 506 | 374 | 85 | 0 | 36 | 2 | 1 | 8 | 35 | 21 | 7 | 0 | 1 | 0 | 6 | 0 | 110010101001005 | 2 | 209 | 209 | 2 | psa_57 | 2D3 |
703 | 703 | 1000000US110010020011007 | Block 1007, Block Group 1, Census Tract 20.01, District of Columbia, District of Columbia | 192 | 32 | 110 | 0 | 0 | 0 | 36 | 14 | 192 | 121 | 11 | 103 | 0 | 0 | 0 | 0 | 7 | 71 | 21 | 7 | 0 | 0 | 0 | 36 | 7 | 110010020011007 | 4 | 403 | 403 | 4 | psa_51 | 4D1 |
711 | 711 | 1000000US110010024004007 | Block 4007, Block Group 4, Census Tract 24, District of Columbia, District of Columbia | 186 | 39 | 130 | 0 | 2 | 0 | 9 | 6 | 186 | 164 | 34 | 123 | 0 | 2 | 0 | 0 | 5 | 22 | 5 | 7 | 0 | 0 | 0 | 9 | 1 | 110010024004007 | 4 | 407 | 407 | 4 | psa_47 | 4D2 |
939 | 939 | 1000000US110010073041006 | Block 1006, Block Group 1, Census Tract 73.04, District of Columbia, District of Columbia | 564 | 1 | 563 | 0 | 0 | 0 | 0 | 0 | 564 | 557 | 1 | 556 | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 110010073041006 | 7 | 705 | 705 | 7 | psa_3 | 7D2 |
1127 | 1127 | 1000000US110010019013012 | Block 3012, Block Group 3, Census Tract 19.01, District of Columbia, District of Columbia | 143 | 17 | 114 | 0 | 1 | 0 | 5 | 6 | 143 | 123 | 12 | 107 | 0 | 1 | 0 | 0 | 3 | 20 | 5 | 7 | 0 | 0 | 0 | 5 | 3 | 110010019013012 | 4 | 402 | 402 | 4 | psa_53 | 4D1 |
1512 | 1512 | 1000000US110010074072006 | Block 2006, Block Group 2, Census Tract 74.07, District of Columbia, District of Columbia | 586 | 3 | 573 | 0 | 0 | 0 | 2 | 8 | 586 | 575 | 3 | 566 | 0 | 0 | 0 | 0 | 6 | 11 | 0 | 7 | 0 | 0 | 0 | 2 | 2 | 110010074072006 | 7 | 703 | 703 | 7 | psa_8 | 7D1 |
1806 | 1806 | 1000000US110010024002017 | Block 2017, Block Group 2, Census Tract 24, District of Columbia, District of Columbia | 42 | 1 | 31 | 0 | 0 | 0 | 9 | 1 | 42 | 26 | 1 | 24 | 0 | 0 | 0 | 0 | 1 | 16 | 0 | 7 | 0 | 0 | 0 | 9 | 0 | 110010024002017 | 4 | 407 | 407 | 4 | psa_47 | 4D2 |
1847 | 1847 | 1000000US110010025022001 | Block 2001, Block Group 2, Census Tract 25.02, District of Columbia, District of Columbia | 139 | 24 | 65 | 0 | 3 | 0 | 43 | 4 | 139 | 82 | 20 | 58 | 0 | 3 | 0 | 0 | 1 | 57 | 4 | 7 | 0 | 0 | 0 | 43 | 3 | 110010025022001 | 4 | 404 | 404 | 4 | psa_48 | 4D3 |
2115 | 2115 | 1000000US110010019013007 | Block 3007, Block Group 3, Census Tract 19.01, District of Columbia, District of Columbia | 166 | 11 | 103 | 0 | 5 | 0 | 47 | 0 | 166 | 105 | 9 | 96 | 0 | 0 | 0 | 0 | 0 | 61 | 2 | 7 | 0 | 5 | 0 | 47 | 0 | 110010019013007 | 4 | 402 | 402 | 4 | psa_53 | 4D1 |
2421 | 2421 | 1000000US110010018031000 | Block 1000, Block Group 1, Census Tract 18.03, District of Columbia, District of Columbia | 176 | 22 | 137 | 0 | 1 | 0 | 10 | 6 | 176 | 145 | 11 | 130 | 0 | 1 | 0 | 0 | 3 | 31 | 11 | 7 | 0 | 0 | 0 | 10 | 3 | 110010018031000 | 4 | 401 | 401 | 4 | psa_56 | 4D1 |
2639 | 2639 | 1000000US110010079031015 | Block 1015, Block Group 1, Census Tract 79.03, District of Columbia, District of Columbia | 123 | 6 | 115 | 0 | 1 | 0 | 0 | 1 | 123 | 115 | 6 | 108 | 0 | 0 | 0 | 0 | 1 | 8 | 0 | 7 | 0 | 1 | 0 | 0 | 0 | 110010079031015 | 5 | 507 | 507 | 5 | psa_23 | 5D3 |
3368 | 3368 | 1000000US110010098022003 | Block 2003, Block Group 2, Census Tract 98.02, District of Columbia, District of Columbia | 365 | 5 | 357 | 0 | 0 | 0 | 1 | 2 | 365 | 357 | 4 | 350 | 0 | 0 | 0 | 1 | 2 | 8 | 1 | 7 | 0 | 0 | 0 | 0 | 0 | 110010098022003 | 7 | 706 | 706 | 7 | psa_2 | 7D3 |
4621 | 4621 | 1000000US110010023021018 | Block 1018, Block Group 1, Census Tract 23.02, District of Columbia, District of Columbia | 882 | 217 | 577 | 0 | 46 | 0 | 10 | 32 | 882 | 833 | 192 | 570 | 0 | 46 | 0 | 2 | 23 | 49 | 25 | 7 | 0 | 0 | 0 | 8 | 9 | 110010023021018 | 4 | 405 | 405 | 4 | psa_49 | 4D2 |
4672 | 4672 | 1000000US110010024001003 | Block 1003, Block Group 1, Census Tract 24, District of Columbia, District of Columbia | 211 | 44 | 104 | 0 | 13 | 0 | 34 | 16 | 211 | 147 | 28 | 97 | 0 | 13 | 0 | 4 | 5 | 64 | 16 | 7 | 0 | 0 | 0 | 30 | 11 | 110010024001003 | 4 | 407 | 407 | 4 | psa_47 | 4D2 |
5206 | 5206 | 1000000US110010074072000 | Block 2000, Block Group 2, Census Tract 74.07, District of Columbia, District of Columbia | 88 | 0 | 88 | 0 | 0 | 0 | 0 | 0 | 88 | 81 | 0 | 81 | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 110010074072000 | 7 | 703 | 703 | 7 | psa_8 | 7D1 |
5350 | 5350 | 1000000US110010103002002 | Block 2002, Block Group 2, Census Tract 103, District of Columbia, District of Columbia | 73 | 4 | 69 | 0 | 0 | 0 | 0 | 0 | 73 | 66 | 4 | 62 | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 110010103002002 | 4 | 401 | 401 | 4 | psa_56 | 4D1 |
5547 | 5547 | 1000000US110010025012009 | Block 2009, Block Group 2, Census Tract 25.01, District of Columbia, District of Columbia | 144 | 39 | 72 | 0 | 1 | 0 | 32 | 0 | 144 | 104 | 36 | 65 | 0 | 1 | 0 | 2 | 0 | 40 | 3 | 7 | 0 | 0 | 0 | 30 | 0 | 110010025012009 | 4 | 404 | 404 | 4 | psa_48 | 4D3 |
5703 | 5703 | 1000000US110010022011000 | Block 1000, Block Group 1, Census Tract 22.01, District of Columbia, District of Columbia | 227 | 35 | 151 | 0 | 2 | 0 | 33 | 6 | 227 | 162 | 12 | 144 | 0 | 2 | 0 | 2 | 2 | 65 | 23 | 7 | 0 | 0 | 0 | 31 | 4 | 110010022011000 | 4 | 407 | 407 | 4 | psa_47 | 4D2 |
5898 | 5898 | 1000000US110010021026005 | Block 6005, Block Group 6, Census Tract 21.02, District of Columbia, District of Columbia | 114 | 7 | 92 | 0 | 0 | 0 | 15 | 0 | 114 | 86 | 1 | 85 | 0 | 0 | 0 | 0 | 0 | 28 | 6 | 7 | 0 | 0 | 0 | 15 | 0 | 110010021026005 | 4 | 403 | 403 | 4 | psa_51 | 4D1 |
6347 | 6347 | 1000000US110010075032005 | Block 2005, Block Group 2, Census Tract 75.03, District of Columbia, District of Columbia | 287 | 2 | 274 | 0 | 0 | 0 | 0 | 11 | 287 | 277 | 1 | 267 | 0 | 0 | 0 | 0 | 9 | 10 | 1 | 7 | 0 | 0 | 0 | 0 | 2 | 110010075032005 | 7 | 701 | 701 | 7 | psa_9 | 7D1 |
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 );