dc_2010blocks_2020policedistricts_population

2010 DC population by US Census block, with each block linked to the police district and public service area in which it sits. For details and column descriptions see this blog post.

Data license: CC BY-SA 4.0 · Data source: US Census & DC Open Data Portal, combined by John Keefe

24 rows where P005016 = 1 and POLDIST_ID = 7

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003002, P003003, P003004, P003005, P003007, P003008, P005003, P005004, P005005, P005006, P005008, P005009, P005010, P005011, P005012, P005013, P005014, P005017, PSA, NAME, GIS_ID, SECTOR

POLDIST_ID ✖

P005016 ✖

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
134 134 1000000US110010074031002 Block 1002, Block Group 1, Census Tract 74.03, District of Columbia, District of Columbia 1322 9 1304 0 4 0 1 4 1322 1315 9 1300 0 3 0 0 3 7 0 4 0 1 0 1 1 110010074031002 7 704 704 7 psa_5 7D2
464 464 1000000US110010097002002 Block 2002, Block Group 2, Census Tract 97, District of Columbia, District of Columbia 253 3 245 0 1 0 1 3 253 251 2 245 0 1 0 0 3 2 1 0 0 0 0 1 0 110010097002002 7 706 706 7 psa_2 7D3
473 473 1000000US110010098111000 Block 1000, Block Group 1, Census Tract 98.11, District of Columbia, District of Columbia 673 4 665 0 0 0 1 3 673 668 3 662 0 0 0 0 3 5 1 3 0 0 0 1 0 110010098111000 7 708 708 7 psa_1 7D3
475 475 1000000US110010098112000 Block 2000, Block Group 2, Census Tract 98.11, District of Columbia, District of Columbia 1189 1 1153 2 3 0 7 23 1189 1181 1 1151 2 3 0 6 18 8 0 2 0 0 0 1 5 110010098112000 7 706 706 7 psa_2 7D3
490 490 1000000US110010104001021 Block 1021, Block Group 1, Census Tract 104, District of Columbia, District of Columbia 118 0 117 0 0 0 1 0 118 117 0 117 0 0 0 0 0 1 0 0 0 0 0 1 0 110010104001021 7 707 707 7 psa_4 7D2
845 845 1000000US110010098032006 Block 2006, Block Group 2, Census Tract 98.03, District of Columbia, District of Columbia 82 0 81 0 0 0 1 0 82 81 0 81 0 0 0 0 0 1 0 0 0 0 0 1 0 110010098032006 7 707 707 7 psa_4 7D2
1053 1053 1000000US110010074071009 Block 1009, Block Group 1, Census Tract 74.07, District of Columbia, District of Columbia 43 0 42 0 0 0 1 0 43 42 0 42 0 0 0 0 0 1 0 0 0 0 0 1 0 110010074071009 7 703 703 7 psa_8 7D1
1272 1272 1000000US110010104002033 Block 2033, Block Group 2, Census Tract 104, District of Columbia, District of Columbia 264 15 238 2 3 0 1 5 264 255 15 234 1 3 0 0 2 9 0 4 1 0 0 1 3 110010104002033 7 703 703 7 psa_8 7D1
1669 1669 1000000US110010098071006 Block 1006, Block Group 1, Census Tract 98.07, District of Columbia, District of Columbia 55 0 54 0 0 0 1 0 55 54 0 54 0 0 0 0 0 1 0 0 0 0 0 1 0 110010098071006 7 708 708 7 psa_1 7D3
1936 1936 1000000US110010075031018 Block 1018, Block Group 1, Census Tract 75.03, District of Columbia, District of Columbia 81 0 80 0 0 0 1 0 81 78 0 78 0 0 0 0 0 3 0 2 0 0 0 1 0 110010075031018 7 701 701 7 psa_9 7D1
2064 2064 1000000US110010098071009 Block 1009, Block Group 1, Census Tract 98.07, District of Columbia, District of Columbia 33 0 32 0 0 0 1 0 33 31 0 31 0 0 0 0 0 2 0 1 0 0 0 1 0 110010098071009 7 708 708 7 psa_1 7D3
3352 3352 1000000US110010104002016 Block 2016, Block Group 2, Census Tract 104, District of Columbia, District of Columbia 166 3 162 0 0 0 1 0 166 157 3 154 0 0 0 0 0 9 0 8 0 0 0 1 0 110010104002016 7 707 707 7 psa_4 7D2
3870 3870 1000000US110010075031012 Block 1012, Block Group 1, Census Tract 75.03, District of Columbia, District of Columbia 53 3 46 0 1 0 1 2 53 52 3 46 0 1 0 0 2 1 0 0 0 0 0 1 0 110010075031012 7 701 701 7 psa_9 7D1
3873 3873 1000000US110010074011033 Block 1033, Block Group 1, Census Tract 74.01, District of Columbia, District of Columbia 147 1 143 2 0 0 1 0 147 144 1 143 0 0 0 0 0 3 0 0 2 0 0 1 0 110010074011033 7 703 703 7 psa_8 7D1
3947 3947 1000000US110010074081001 Block 1001, Block Group 1, Census Tract 74.08, District of Columbia, District of Columbia 7 0 6 0 0 0 1 0 7 6 0 6 0 0 0 0 0 1 0 0 0 0 0 1 0 110010074081001 7 702 702 7 psa_6 7D1
4224 4224 1000000US110010098112004 Block 2004, Block Group 2, Census Tract 98.11, District of Columbia, District of Columbia 109 0 105 0 0 0 1 3 109 108 0 105 0 0 0 0 3 1 0 0 0 0 0 1 0 110010098112004 7 706 706 7 psa_2 7D3
4262 4262 1000000US110010073043002 Block 3002, Block Group 3, Census Tract 73.04, District of Columbia, District of Columbia 51 4 42 0 0 0 2 3 51 47 4 42 0 0 0 1 0 4 0 0 0 0 0 1 3 110010073043002 7 705 705 7 psa_3 7D2
4379 4379 1000000US110010098071005 Block 1005, Block Group 1, Census Tract 98.07, District of Columbia, District of Columbia 117 7 109 0 0 0 1 0 117 115 7 108 0 0 0 0 0 2 0 1 0 0 0 1 0 110010098071005 7 708 708 7 psa_1 7D3
5192 5192 1000000US110010073042003 Block 2003, Block Group 2, Census Tract 73.04, District of Columbia, District of Columbia 100 0 93 6 0 0 1 0 100 98 0 92 6 0 0 0 0 2 0 1 0 0 0 1 0 110010073042003 7 705 705 7 psa_3 7D2
5436 5436 1000000US110010098032003 Block 2003, Block Group 2, Census Tract 98.03, District of Columbia, District of Columbia 133 0 131 0 0 0 1 1 133 132 0 131 0 0 0 0 1 1 0 0 0 0 0 1 0 110010098032003 7 707 707 7 psa_4 7D2
5529 5529 1000000US110010104001017 Block 1017, Block Group 1, Census Tract 104, District of Columbia, District of Columbia 142 4 136 0 0 0 1 1 142 141 4 136 0 0 0 0 1 1 0 0 0 0 0 1 0 110010104001017 7 707 707 7 psa_4 7D2
5807 5807 1000000US110010074092002 Block 2002, Block Group 2, Census Tract 74.09, District of Columbia, District of Columbia 183 0 167 0 5 0 1 10 183 182 0 167 0 5 0 0 10 1 0 0 0 0 0 1 0 110010074092002 7 704 704 7 psa_5 7D2
6120 6120 1000000US110010098071007 Block 1007, Block Group 1, Census Tract 98.07, District of Columbia, District of Columbia 110 5 90 0 6 0 1 8 110 106 5 87 0 6 0 0 8 4 0 3 0 0 0 1 0 110010098071007 7 708 708 7 psa_1 7D3
6135 6135 1000000US110010073042005 Block 2005, Block Group 2, Census Tract 73.04, District of Columbia, District of Columbia 80 6 73 0 0 0 1 0 80 77 6 71 0 0 0 0 0 3 0 2 0 0 0 1 0 110010073042005 7 705 705 7 psa_3 7D2

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);