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

11 rows where P003007 = 7 and POLDIST_ID = 5

View and edit SQL

Suggested facets: P003001, P003002, P003004, P003005, P003008, P005001, P005003, P005005, P005006, P005008, P005009, P005010, P005011, P005012, P005013, 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
493 1000000US110010106001000 Block 1000, Block Group 1, Census Tract 106, District of Columbia, District of Columbia 11 2 1 0 1 0 7 0 11 4 2 1 0 1 0 0 0 7 0 0 0 0 0 7 0 110010106001000 5 501 501 5 psa_35 5D1
946 1000000US110010091021013 Block 1013, Block Group 1, Census Tract 91.02, District of Columbia, District of Columbia 50 2 39 0 0 0 7 2 50 43 2 39 0 0 0 0 2 7 0 0 0 0 0 7 0 110010091021013 5 505 505 5 psa_34 5D2
1147 1000000US110010092032013 Block 2013, Block Group 2, Census Tract 92.03, District of Columbia, District of Columbia 131 6 102 0 12 0 7 4 131 125 6 102 0 12 0 1 4 6 0 0 0 0 0 6 0 110010092032013 5 502 502 5 psa_40 5D1
1360 1000000US110010088041005 Block 1005, Block Group 1, Census Tract 88.04, District of Columbia, District of Columbia 186 4 173 1 0 0 7 1 186 179 4 173 1 0 0 0 1 7 0 0 0 0 0 7 0 110010088041005 5 506 506 5 psa_26 5D3
1407 1000000US110010111002015 Block 2015, Block Group 2, Census Tract 111, District of Columbia, District of Columbia 55 5 41 0 0 0 7 2 55 47 5 41 0 0 0 0 1 8 0 0 0 0 0 7 1 110010111002015 5 503 503 5 psa_45 5D2
2700 1000000US110010088041000 Block 1000, Block Group 1, Census Tract 88.04, District of Columbia, District of Columbia 131 6 116 2 0 0 7 0 131 118 6 110 2 0 0 0 0 13 0 6 0 0 0 7 0 110010088041000 5 506 506 5 psa_26 5D3
2787 1000000US110010088031017 Block 1017, Block Group 1, Census Tract 88.03, District of Columbia, District of Columbia 91 8 75 0 0 0 7 1 91 69 0 69 0 0 0 0 0 22 8 6 0 0 0 7 1 110010088031017 5 501 501 5 psa_35 5D1
2835 1000000US110010088024004 Block 4004, Block Group 4, Census Tract 88.02, District of Columbia, District of Columbia 231 20 200 1 0 0 7 3 231 219 20 197 0 0 0 1 1 12 0 3 1 0 0 6 2 110010088024004 5 506 506 5 psa_26 5D3
3996 1000000US110010111003005 Block 3005, Block Group 3, Census Tract 111, District of Columbia, District of Columbia 61 10 44 0 0 0 7 0 61 49 5 44 0 0 0 0 0 12 5 0 0 0 0 7 0 110010111003005 5 503 503 5 psa_45 5D2
5854 1000000US110010111001037 Block 1037, Block Group 1, Census Tract 111, District of Columbia, District of Columbia 108 3 91 0 0 0 7 7 108 101 3 91 0 0 0 0 7 7 0 0 0 0 0 7 0 110010111001037 5 503 503 5 psa_45 5D2
6374 1000000US110010093013018 Block 3018, Block Group 3, Census Tract 93.01, District of Columbia, District of Columbia 89 14 56 2 6 0 7 4 89 76 8 56 2 6 0 0 4 13 6 0 0 0 0 7 0 110010093013018 5 504 504 5 psa_43 5D2

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