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

8 rows where P005007 = 3

View and edit SQL

Suggested facets: P003004, P003005, P003007, P003008, P005005, P005006, P005008, P005009, P005010, P005011, P005012, P005013, P005014, P005016, P005017, DISTRICT, POLDIST_ID, SECTOR

P005007

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
121 1000000US110010073011097 Block 1097, Block Group 1, Census Tract 73.01, District of Columbia, District of Columbia 132 75 36 0 9 3 0 9 132 110 57 36 0 7 3 0 7 22 18 0 0 2 0 0 2 110010073011097 7 708 708 7 psa_1 7D3
857 1000000US110010033013004 Block 3004, Block Group 3, Census Tract 33.01, District of Columbia, District of Columbia 135 25 103 0 0 3 0 4 135 134 24 103 0 0 3 0 4 1 1 0 0 0 0 0 0 110010033013004 3 306 306 3 psa_38 3D2
2039 1000000US110010009013011 Block 3011, Block Group 3, Census Tract 9.01, District of Columbia, District of Columbia 3169 2535 134 14 304 3 49 130 3169 2961 2399 131 11 300 3 11 106 208 136 3 3 4 0 38 24 110010009013011 2 205 205 2 psa_46 2D2
2913 1000000US110010084022001 Block 2001, Block Group 2, Census Tract 84.02, District of Columbia, District of Columbia 279 38 230 2 1 3 1 4 279 273 37 227 2 1 3 0 3 6 1 3 0 0 0 1 1 110010084022001 1 104 104 1 psa_21 1D2
3477 1000000US110010096011010 Block 1010, Block Group 1, Census Tract 96.01, District of Columbia, District of Columbia 367 5 351 0 4 3 0 4 367 366 4 351 0 4 3 0 4 1 1 0 0 0 0 0 0 110010096011010 6 601 601 6 psa_30 6D1
3942 1000000US110010037001002 Block 1002, Block Group 1, Census Tract 37, District of Columbia, District of Columbia 542 353 112 0 32 3 16 26 542 484 322 111 0 32 3 2 14 58 31 1 0 0 0 14 12 110010037001002 3 304 304 3 psa_36 3D1
5758 1000000US110010080022012 Block 2012, Block Group 2, Census Tract 80.02, District of Columbia, District of Columbia 239 205 20 1 4 3 1 5 239 232 203 18 1 4 3 1 2 7 2 2 0 0 0 0 3 110010080022012 1 108 108 1 psa_17 1D2
5759 1000000US110010058002016 Block 2016, Block Group 2, Census Tract 58, District of Columbia, District of Columbia 153 119 13 0 14 3 0 4 153 151 117 13 0 14 3 0 4 2 2 0 0 0 0 0 0 110010058002016 1 102 102 1 psa_18 1D1

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 105.648ms · Data license: CC BY-SA 4.0 · Data source: US Census & DC Open Data Portal, combined by John Keefe