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

17 rows where P003007 = 1 and SECTOR = "5D1"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003004, P003005, P003008, P005002, P005003, P005005, P005006, P005008, P005009, P005010, P005011, P005012, P005013, P005014, P005016, P005017, PSA, NAME, GIS_ID

SECTOR ✖

  • 5D1 · 17 ✖

P003007 ✖

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
229 229 1000000US110010087011009 Block 1009, Block Group 1, Census Tract 87.01, District of Columbia, District of Columbia 183 61 117 0 3 0 1 1 183 169 60 104 0 3 0 1 1 14 1 13 0 0 0 0 0 110010087011009 5 502 502 5 psa_40 5D1
1202 1202 1000000US110010106001003 Block 1003, Block Group 1, Census Tract 106, District of Columbia, District of Columbia 177 69 83 0 8 0 1 16 177 171 65 82 0 8 0 0 16 6 4 1 0 0 0 1 0 110010106001003 5 501 501 5 psa_35 5D1
1681 1681 1000000US110010087011008 Block 1008, Block Group 1, Census Tract 87.01, District of Columbia, District of Columbia 54 10 43 0 0 0 1 0 54 51 8 43 0 0 0 0 0 3 2 0 0 0 0 1 0 110010087011008 5 502 502 5 psa_40 5D1
1994 1994 1000000US110010106002014 Block 2014, Block Group 2, Census Tract 106, District of Columbia, District of Columbia 179 75 94 1 2 0 1 6 179 170 69 94 0 2 0 1 4 9 6 0 1 0 0 0 2 110010106002014 5 501 501 5 psa_35 5D1
2139 2139 1000000US110010106001005 Block 1005, Block Group 1, Census Tract 106, District of Columbia, District of Columbia 175 80 85 0 1 0 1 8 175 171 79 84 0 1 0 0 7 4 1 1 0 0 0 1 1 110010106001005 5 501 501 5 psa_35 5D1
2389 2389 1000000US110010092032007 Block 2007, Block Group 2, Census Tract 92.03, District of Columbia, District of Columbia 66 12 53 0 0 0 1 0 66 65 12 53 0 0 0 0 0 1 0 0 0 0 0 1 0 110010092032007 5 502 502 5 psa_40 5D1
2742 2742 1000000US110010092011012 Block 1012, Block Group 1, Census Tract 92.01, District of Columbia, District of Columbia 28 25 1 0 1 0 1 0 28 26 24 1 0 1 0 0 0 2 1 0 0 0 0 1 0 110010092011012 5 502 502 5 psa_40 5D1
3357 3357 1000000US110010106001001 Block 1001, Block Group 1, Census Tract 106, District of Columbia, District of Columbia 103 21 80 1 0 0 1 0 103 102 21 80 1 0 0 0 0 1 0 0 0 0 0 1 0 110010106001001 5 501 501 5 psa_35 5D1
3815 3815 1000000US110010106002046 Block 2046, Block Group 2, Census Tract 106, District of Columbia, District of Columbia 96 20 70 1 2 0 1 2 96 91 17 70 1 2 0 0 1 5 3 0 0 0 0 1 1 110010106002046 5 501 501 5 psa_35 5D1
3916 3916 1000000US110010092011005 Block 1005, Block Group 1, Census Tract 92.01, District of Columbia, District of Columbia 90 81 3 0 5 0 1 0 90 87 79 3 0 5 0 0 0 3 2 0 0 0 0 1 0 110010092011005 5 502 502 5 psa_40 5D1
4033 4033 1000000US110010106002013 Block 2013, Block Group 2, Census Tract 106, District of Columbia, District of Columbia 194 50 136 6 1 0 1 0 194 187 50 136 0 1 0 0 0 7 0 0 6 0 0 1 0 110010106002013 5 501 501 5 psa_35 5D1
4305 4305 1000000US110010106002036 Block 2036, Block Group 2, Census Tract 106, District of Columbia, District of Columbia 49 29 14 0 2 0 1 3 49 47 28 14 0 2 0 0 3 2 1 0 0 0 0 1 0 110010106002036 5 501 501 5 psa_35 5D1
4349 4349 1000000US110010084101011 Block 1011, Block Group 1, Census Tract 84.10, District of Columbia, District of Columbia 91 40 46 0 3 0 1 1 91 89 40 46 0 3 0 0 0 2 0 0 0 0 0 1 1 110010084101011 5 501 501 5 psa_35 5D1
5793 5793 1000000US110010087022005 Block 2005, Block Group 2, Census Tract 87.02, District of Columbia, District of Columbia 150 9 131 2 1 0 1 6 150 147 9 129 2 1 0 0 6 3 0 2 0 0 0 1 0 110010087022005 5 502 502 5 psa_40 5D1
6160 6160 1000000US110010092032008 Block 2008, Block Group 2, Census Tract 92.03, District of Columbia, District of Columbia 95 16 73 0 0 0 1 5 95 93 15 73 0 0 0 0 5 2 1 0 0 0 0 1 0 110010092032008 5 502 502 5 psa_40 5D1
6348 6348 1000000US110010092011011 Block 1011, Block Group 1, Census Tract 92.01, District of Columbia, District of Columbia 37 3 32 0 1 0 1 0 37 36 3 32 0 1 0 0 0 1 0 0 0 0 0 1 0 110010092011011 5 502 502 5 psa_40 5D1
6373 6373 1000000US110010087021003 Block 1003, Block Group 1, Census Tract 87.02, District of Columbia, District of Columbia 176 13 149 0 7 0 1 6 176 163 8 149 0 6 0 0 0 13 5 0 0 1 0 1 6 110010087021003 5 502 502 5 psa_40 5D1

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