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

28 rows where P005012 = 1 and SECTOR = "5D2"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003001, P003002, P003003, P003004, P003005, P003007, P003008, P005001, P005003, P005004, P005005, P005006, P005008, P005009, P005010, P005011, P005013, P005016, P005017, PSA, NAME, GIS_ID

SECTOR ✖

  • 5D2 · 28 ✖

P005012 ✖

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
250 250 1000000US110010094001000 Block 1000, Block Group 1, Census Tract 94, District of Columbia, District of Columbia 21 0 21 0 0 0 0 0 21 20 0 20 0 0 0 0 0 1 0 1 0 0 0 0 0 110010094001000 5 503 503 5 psa_45 5D2
257 257 1000000US110010094003009 Block 3009, Block Group 3, Census Tract 94, District of Columbia, District of Columbia 97 9 80 1 0 0 1 6 97 94 8 79 1 0 0 0 6 3 1 1 0 0 0 1 0 110010094003009 5 503 503 5 psa_45 5D2
270 270 1000000US110010095041020 Block 1020, Block Group 1, Census Tract 95.04, District of Columbia, District of Columbia 62 25 30 2 0 0 1 4 62 48 16 29 0 0 0 0 3 14 9 1 2 0 0 1 1 110010095041020 5 504 504 5 psa_43 5D2
509 509 1000000US110010111001006 Block 1006, Block Group 1, Census Tract 111, District of Columbia, District of Columbia 31 5 26 0 0 0 0 0 31 29 4 25 0 0 0 0 0 2 1 1 0 0 0 0 0 110010111001006 5 503 503 5 psa_45 5D2
519 519 1000000US110010111003007 Block 3007, Block Group 3, Census Tract 111, District of Columbia, District of Columbia 502 13 469 0 2 0 10 8 502 493 11 468 0 2 0 4 8 9 2 1 0 0 0 6 0 110010111003007 5 505 505 5 psa_34 5D2
591 591 1000000US110010094003010 Block 3010, Block Group 3, Census Tract 94, District of Columbia, District of Columbia 53 1 48 0 0 0 0 4 53 50 1 47 0 0 0 0 2 3 0 1 0 0 0 0 2 110010094003010 5 503 503 5 psa_45 5D2
1284 1284 1000000US110010093012018 Block 2018, Block Group 2, Census Tract 93.01, District of Columbia, District of Columbia 98 28 60 1 0 0 2 7 98 85 23 59 1 0 0 0 2 13 5 1 0 0 0 2 5 110010093012018 5 504 504 5 psa_43 5D2
1522 1522 1000000US110010093021002 Block 1002, Block Group 1, Census Tract 93.02, District of Columbia, District of Columbia 102 26 72 0 1 0 0 3 102 97 22 71 0 1 0 0 3 5 4 1 0 0 0 0 0 110010093021002 5 504 504 5 psa_43 5D2
1657 1657 1000000US110010111002010 Block 2010, Block Group 2, Census Tract 111, District of Columbia, District of Columbia 56 3 53 0 0 0 0 0 56 55 3 52 0 0 0 0 0 1 0 1 0 0 0 0 0 110010111002010 5 503 503 5 psa_45 5D2
2102 2102 1000000US110010091022004 Block 2004, Block Group 2, Census Tract 91.02, District of Columbia, District of Columbia 80 8 59 0 0 0 11 2 80 61 1 58 0 0 0 0 2 19 7 1 0 0 0 11 0 110010091022004 5 505 505 5 psa_34 5D2
2657 2657 1000000US110010094003020 Block 3020, Block Group 3, Census Tract 94, District of Columbia, District of Columbia 35 0 35 0 0 0 0 0 35 34 0 34 0 0 0 0 0 1 0 1 0 0 0 0 0 110010094003020 5 503 503 5 psa_45 5D2
2726 2726 1000000US110010111002017 Block 2017, Block Group 2, Census Tract 111, District of Columbia, District of Columbia 18 1 17 0 0 0 0 0 18 17 1 16 0 0 0 0 0 1 0 1 0 0 0 0 0 110010111002017 5 505 505 5 psa_34 5D2
2884 2884 1000000US110010093014000 Block 4000, Block Group 4, Census Tract 93.01, District of Columbia, District of Columbia 44 19 21 0 3 0 0 1 44 42 18 20 0 3 0 0 1 2 1 1 0 0 0 0 0 110010093014000 5 504 504 5 psa_43 5D2
3203 3203 1000000US110010093013002 Block 3002, Block Group 3, Census Tract 93.01, District of Columbia, District of Columbia 12 0 12 0 0 0 0 0 12 11 0 11 0 0 0 0 0 1 0 1 0 0 0 0 0 110010093013002 5 504 504 5 psa_43 5D2
3842 3842 1000000US110010091022006 Block 2006, Block Group 2, Census Tract 91.02, District of Columbia, District of Columbia 84 2 72 0 0 0 5 5 84 75 2 71 0 0 0 2 0 9 0 1 0 0 0 3 5 110010091022006 5 505 505 5 psa_34 5D2
3928 3928 1000000US110010095032010 Block 2010, Block Group 2, Census Tract 95.03, District of Columbia, District of Columbia 29 8 18 0 0 0 0 3 29 28 8 17 0 0 0 0 3 1 0 1 0 0 0 0 0 110010095032010 5 504 504 5 psa_43 5D2
4392 4392 1000000US110010094002002 Block 2002, Block Group 2, Census Tract 94, District of Columbia, District of Columbia 34 0 34 0 0 0 0 0 34 33 0 33 0 0 0 0 0 1 0 1 0 0 0 0 0 110010094002002 5 504 504 5 psa_43 5D2
4562 4562 1000000US110010093011011 Block 1011, Block Group 1, Census Tract 93.01, District of Columbia, District of Columbia 45 11 27 0 0 0 0 7 45 38 9 26 0 0 0 0 3 7 2 1 0 0 0 0 4 110010093011011 5 504 504 5 psa_43 5D2
4578 4578 1000000US110010093012000 Block 2000, Block Group 2, Census Tract 93.01, District of Columbia, District of Columbia 35 14 20 0 1 0 0 0 35 31 11 19 0 1 0 0 0 4 3 1 0 0 0 0 0 110010093012000 5 504 504 5 psa_43 5D2
4596 4596 1000000US110010093013003 Block 3003, Block Group 3, Census Tract 93.01, District of Columbia, District of Columbia 42 10 23 0 7 0 0 2 42 41 10 22 0 7 0 0 2 1 0 1 0 0 0 0 0 110010093013003 5 504 504 5 psa_43 5D2
4695 4695 1000000US110010094002010 Block 2010, Block Group 2, Census Tract 94, District of Columbia, District of Columbia 53 7 46 0 0 0 0 0 53 47 2 45 0 0 0 0 0 6 5 1 0 0 0 0 0 110010094002010 5 503 503 5 psa_45 5D2
5212 5212 1000000US110010093011013 Block 1013, Block Group 1, Census Tract 93.01, District of Columbia, District of Columbia 39 2 34 0 0 0 0 3 39 36 2 33 0 0 0 0 1 3 0 1 0 0 0 0 2 110010093011013 5 504 504 5 psa_43 5D2
5311 5311 1000000US110010093011009 Block 1009, Block Group 1, Census Tract 93.01, District of Columbia, District of Columbia 45 7 35 1 0 0 0 2 45 43 7 34 0 0 0 0 2 2 0 1 1 0 0 0 0 110010093011009 5 504 504 5 psa_43 5D2
5482 5482 1000000US110010095033010 Block 3010, Block Group 3, Census Tract 95.03, District of Columbia, District of Columbia 54 5 46 0 0 0 0 3 54 52 5 45 0 0 0 0 2 2 0 1 0 0 0 0 1 110010095033010 5 504 504 5 psa_43 5D2
5710 5710 1000000US110010093012009 Block 2009, Block Group 2, Census Tract 93.01, District of Columbia, District of Columbia 99 55 38 1 4 0 0 1 99 89 46 37 1 4 0 0 1 10 9 1 0 0 0 0 0 110010093012009 5 504 504 5 psa_43 5D2
5983 5983 1000000US110010093021006 Block 1006, Block Group 1, Census Tract 93.02, District of Columbia, District of Columbia 70 25 43 0 0 0 0 2 70 67 23 42 0 0 0 0 2 3 2 1 0 0 0 0 0 110010093021006 5 504 504 5 psa_43 5D2
6419 6419 1000000US110010093012019 Block 2019, Block Group 2, Census Tract 93.01, District of Columbia, District of Columbia 93 20 67 0 2 0 1 3 93 88 17 66 0 2 0 0 3 5 3 1 0 0 0 1 0 110010093012019 5 504 504 5 psa_43 5D2
6484 6484 1000000US110010093014008 Block 4008, Block Group 4, Census Tract 93.01, District of Columbia, District of Columbia 55 18 34 0 3 0 0 0 55 54 18 33 0 3 0 0 0 1 0 1 0 0 0 0 0 110010093014008 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
);