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

10 rows where P005013 = 5

View and edit SQL

Suggested facets: P003004, P003005, P003006, P005005, P005006, P005008, P005011, P005012, P005014, P005015, P005016, P005017, DISTRICT, PSA, NAME, POLDIST_ID, GIS_ID, SECTOR

P005013

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
506 1000000US110010110004002 Block 4002, Block Group 4, Census Tract 110, District of Columbia, District of Columbia 947 322 518 11 35 0 17 44 947 896 301 512 6 35 0 5 37 51 21 6 5 0 0 12 7 110010110004002 1 105 105 1 psa_22 1D3
777 1000000US110010023012007 Block 2007, Block Group 2, Census Tract 23.01, District of Columbia, District of Columbia 162 16 126 5 1 2 4 8 162 148 14 125 0 1 0 0 8 14 2 1 5 0 2 4 0 110010023012007 4 407 407 4 psa_47 4D2
1103 1000000US110010106002015 Block 2015, Block Group 2, Census Tract 106, District of Columbia, District of Columbia 152 44 94 5 3 0 6 0 152 134 38 93 0 3 0 0 0 18 6 1 5 0 0 6 0 110010106002015 5 501 501 5 psa_35 5D1
1291 1000000US110010024004003 Block 4003, Block Group 4, Census Tract 24, District of Columbia, District of Columbia 188 58 99 5 0 0 25 1 188 122 26 95 0 0 0 0 1 66 32 4 5 0 0 25 0 110010024004003 4 407 407 4 psa_47 4D2
1768 1000000US110010039004001 Block 4001, Block Group 4, Census Tract 39, District of Columbia, District of Columbia 330 233 39 6 12 0 30 10 330 276 214 39 1 12 0 0 10 54 19 0 5 0 0 30 0 110010039004001 3 303 303 3 psa_37 3D3
1813 1000000US110010012004026 Block 4026, Block Group 4, Census Tract 12, District of Columbia, District of Columbia 228 154 8 5 30 0 13 18 228 170 120 8 0 30 0 1 11 58 34 0 5 0 0 12 7 110010012004026 2 202 202 2 psa_52 2D1
3952 1000000US110010047012000 Block 2000, Block Group 2, Census Tract 47.01, District of Columbia, District of Columbia 974 26 924 7 4 0 1 12 974 959 23 917 2 4 0 1 12 15 3 7 5 0 0 0 0 110010047012000 1 102 102 1 psa_18 1D1
4019 1000000US110010068041011 Block 1011, Block Group 1, Census Tract 68.04, District of Columbia, District of Columbia 3630 180 3192 29 21 1 104 103 3630 3319 86 3107 24 21 0 8 73 311 94 85 5 0 1 96 30 110010068041011 1 107 107 1 psa_16 1D2
4250 1000000US110010023012012 Block 2012, Block Group 2, Census Tract 23.01, District of Columbia, District of Columbia 155 36 86 5 1 0 5 22 155 123 34 86 0 1 0 0 2 32 2 0 5 0 0 5 20 110010023012012 4 407 407 4 psa_47 4D2
4264 1000000US110010027014000 Block 4000, Block Group 4, Census Tract 27.01, District of Columbia, District of Columbia 1929 707 628 17 84 0 403 90 1929 1116 361 603 12 78 0 16 46 813 346 25 5 6 0 387 44 110010027014000 3 302 302 3 psa_42 3D1

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
);
Powered by Datasette · Query took 120.739ms · Data license: CC BY-SA 4.0 · Data source: US Census & DC Open Data Portal, combined by John Keefe