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

33 rows where P003004 = 1 and SECTOR = "4D1"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003002, P003003, P003005, P003006, P003007, P003008, P005003, P005005, P005006, P005007, P005008, P005009, P005010, P005011, P005012, P005013, P005014, P005016, P005017, PSA, NAME, GIS_ID

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
377 377 1000000US110010016004010 Block 4010, Block Group 4, Census Tract 16, District of Columbia, District of Columbia 32 6 24 1 0 0 0 1 32 32 6 24 1 0 0 0 1 0 0 0 0 0 0 0 0 110010016004010 4 401 401 4 psa_56 4D1
379 379 1000000US110010016004019 Block 4019, Block Group 4, Census Tract 16, District of Columbia, District of Columbia 28 9 16 1 1 0 0 1 28 28 9 16 1 1 0 0 1 0 0 0 0 0 0 0 0 110010016004019 4 401 401 4 psa_56 4D1
397 397 1000000US110010021024007 Block 4007, Block Group 4, Census Tract 21.02, District of Columbia, District of Columbia 164 15 148 1 0 0 0 0 164 162 13 148 1 0 0 0 0 2 2 0 0 0 0 0 0 110010021024007 4 403 403 4 psa_51 4D1
713 713 1000000US110010021021015 Block 1015, Block Group 1, Census Tract 21.02, District of Columbia, District of Columbia 36 2 33 1 0 0 0 0 36 35 2 33 0 0 0 0 0 1 0 0 1 0 0 0 0 110010021021015 4 402 402 4 psa_53 4D1
765 765 1000000US110010018032005 Block 2005, Block Group 2, Census Tract 18.03, District of Columbia, District of Columbia 696 38 452 1 26 1 144 34 696 502 11 451 0 26 1 2 11 194 27 1 1 0 0 142 23 110010018032005 4 402 402 4 psa_53 4D1
1177 1177 1000000US110010020023005 Block 3005, Block Group 3, Census Tract 20.02, District of Columbia, District of Columbia 161 38 106 1 7 0 7 2 161 150 33 106 1 7 0 1 2 11 5 0 0 0 0 6 0 110010020023005 4 403 403 4 psa_51 4D1
1427 1427 1000000US110010103003001 Block 3001, Block Group 3, Census Tract 103, District of Columbia, District of Columbia 92 42 48 1 0 0 0 1 92 89 41 47 0 0 0 0 1 3 1 1 1 0 0 0 0 110010103003001 4 401 401 4 psa_56 4D1
1508 1508 1000000US110010021013004 Block 3004, Block Group 3, Census Tract 21.01, District of Columbia, District of Columbia 221 44 133 1 2 0 32 9 221 163 26 133 0 2 0 0 2 58 18 0 1 0 0 32 7 110010021013004 4 403 403 4 psa_51 4D1
1571 1571 1000000US110010019014015 Block 4015, Block Group 4, Census Tract 19.01, District of Columbia, District of Columbia 29 9 19 1 0 0 0 0 29 29 9 19 1 0 0 0 0 0 0 0 0 0 0 0 0 110010019014015 4 402 402 4 psa_53 4D1
1991 1991 1000000US110010021011003 Block 1003, Block Group 1, Census Tract 21.01, District of Columbia, District of Columbia 4 2 1 1 0 0 0 0 4 1 0 1 0 0 0 0 0 3 2 0 1 0 0 0 0 110010021011003 4 403 403 4 psa_51 4D1
2249 2249 1000000US110010018031005 Block 1005, Block Group 1, Census Tract 18.03, District of Columbia, District of Columbia 347 41 248 1 4 7 37 9 347 274 12 246 1 4 7 0 4 73 29 2 0 0 0 37 5 110010018031005 4 402 402 4 psa_53 4D1
2514 2514 1000000US110010019021004 Block 1004, Block Group 1, Census Tract 19.02, District of Columbia, District of Columbia 82 3 78 1 0 0 0 0 82 80 3 77 0 0 0 0 0 2 0 1 1 0 0 0 0 110010019021004 4 402 402 4 psa_53 4D1
2521 2521 1000000US110010016003011 Block 3011, Block Group 3, Census Tract 16, District of Columbia, District of Columbia 56 23 29 1 0 0 0 3 56 54 22 29 0 0 0 0 3 2 1 0 1 0 0 0 0 110010016003011 4 401 401 4 psa_56 4D1
2676 2676 1000000US110010017021008 Block 1008, Block Group 1, Census Tract 17.02, District of Columbia, District of Columbia 117 44 49 1 5 0 11 7 117 92 34 48 1 5 0 0 4 25 10 1 0 0 0 11 3 110010017021008 4 401 401 4 psa_56 4D1
2871 2871 1000000US110010018031002 Block 1002, Block Group 1, Census Tract 18.03, District of Columbia, District of Columbia 113 30 66 1 3 0 2 11 113 100 26 64 1 2 0 0 7 13 4 2 0 1 0 2 4 110010018031002 4 401 401 4 psa_56 4D1
3112 3112 1000000US110010021022005 Block 2005, Block Group 2, Census Tract 21.02, District of Columbia, District of Columbia 87 0 70 1 0 0 16 0 87 58 0 57 1 0 0 0 0 29 0 13 0 0 0 16 0 110010021022005 4 403 403 4 psa_51 4D1
3140 3140 1000000US110010019014008 Block 4008, Block Group 4, Census Tract 19.01, District of Columbia, District of Columbia 96 14 61 1 2 0 16 2 96 81 13 61 1 2 0 3 1 15 1 0 0 0 0 13 1 110010019014008 4 402 402 4 psa_53 4D1
3232 3232 1000000US110010017021019 Block 1019, Block Group 1, Census Tract 17.02, District of Columbia, District of Columbia 103 46 49 1 2 0 2 3 103 97 42 49 1 2 0 0 3 6 4 0 0 0 0 2 0 110010017021019 4 401 401 4 psa_56 4D1
3624 3624 1000000US110010017022006 Block 2006, Block Group 2, Census Tract 17.02, District of Columbia, District of Columbia 42 13 26 1 0 0 0 2 42 42 13 26 1 0 0 0 2 0 0 0 0 0 0 0 0 110010017022006 4 401 401 4 psa_56 4D1
3835 3835 1000000US110010021015000 Block 5000, Block Group 5, Census Tract 21.01, District of Columbia, District of Columbia 193 17 145 1 11 0 16 3 193 156 1 141 0 11 0 0 3 37 16 4 1 0 0 16 0 110010021015000 4 403 403 4 psa_51 4D1
4026 4026 1000000US110010019011008 Block 1008, Block Group 1, Census Tract 19.01, District of Columbia, District of Columbia 74 7 56 1 0 0 5 5 74 65 5 54 1 0 0 0 5 9 2 2 0 0 0 5 0 110010019011008 4 402 402 4 psa_53 4D1
4510 4510 1000000US110010016001009 Block 1009, Block Group 1, Census Tract 16, District of Columbia, District of Columbia 38 2 35 1 0 0 0 0 38 34 1 32 1 0 0 0 0 4 1 3 0 0 0 0 0 110010016001009 4 401 401 4 psa_56 4D1
4710 4710 1000000US110010019012005 Block 2005, Block Group 2, Census Tract 19.01, District of Columbia, District of Columbia 103 0 98 1 1 0 3 0 103 96 0 94 1 1 0 0 0 7 0 4 0 0 0 3 0 110010019012005 4 402 402 4 psa_53 4D1
4875 4875 1000000US110010017021001 Block 1001, Block Group 1, Census Tract 17.02, District of Columbia, District of Columbia 298 184 87 1 12 0 6 8 298 276 171 85 1 12 0 0 7 22 13 2 0 0 0 6 1 110010017021001 4 401 401 4 psa_56 4D1
5008 5008 1000000US110010019021003 Block 1003, Block Group 1, Census Tract 19.02, District of Columbia, District of Columbia 94 14 51 1 1 0 24 3 94 64 7 51 0 1 0 2 3 30 7 0 1 0 0 22 0 110010019021003 4 402 402 4 psa_53 4D1
5024 5024 1000000US110010019013008 Block 3008, Block Group 3, Census Tract 19.01, District of Columbia, District of Columbia 184 25 117 1 1 0 38 2 184 131 12 117 1 1 0 0 0 53 13 0 0 0 0 38 2 110010019013008 4 402 402 4 psa_53 4D1
5383 5383 1000000US110010019012008 Block 2008, Block Group 2, Census Tract 19.01, District of Columbia, District of Columbia 146 17 113 1 0 0 10 5 146 122 7 113 1 0 0 0 1 24 10 0 0 0 0 10 4 110010019012008 4 402 402 4 psa_53 4D1
5444 5444 1000000US110010016001002 Block 1002, Block Group 1, Census Tract 16, District of Columbia, District of Columbia 67 17 48 1 0 0 1 0 67 59 11 46 1 0 0 1 0 8 6 2 0 0 0 0 0 110010016001002 4 401 401 4 psa_56 4D1
5609 5609 1000000US110010018031003 Block 1003, Block Group 1, Census Tract 18.03, District of Columbia, District of Columbia 130 13 112 1 0 0 2 2 130 125 13 110 0 0 0 0 2 5 0 2 1 0 0 2 0 110010018031003 4 402 402 4 psa_53 4D1
6018 6018 1000000US110010103002005 Block 2005, Block Group 2, Census Tract 103, District of Columbia, District of Columbia 57 5 45 1 6 0 0 0 57 56 4 45 1 6 0 0 0 1 1 0 0 0 0 0 0 110010103002005 4 401 401 4 psa_56 4D1
6166 6166 1000000US110010018041006 Block 1006, Block Group 1, Census Tract 18.04, District of Columbia, District of Columbia 192 53 98 1 0 0 26 14 192 105 8 97 0 0 0 0 0 87 45 1 1 0 0 26 14 110010018041006 4 402 402 4 psa_53 4D1
6372 6372 1000000US110010019011011 Block 1011, Block Group 1, Census Tract 19.01, District of Columbia, District of Columbia 96 2 58 1 2 0 33 0 96 63 2 58 1 2 0 0 0 33 0 0 0 0 0 33 0 110010019011011 4 402 402 4 psa_53 4D1
6423 6423 1000000US110010103001016 Block 1016, Block Group 1, Census Tract 103, District of Columbia, District of Columbia 118 18 78 1 0 0 16 5 118 96 14 78 1 0 0 0 3 22 4 0 0 0 0 16 2 110010103001016 4 401 401 4 psa_56 4D1

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