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

9 rows where P005009 = 4 and SECTOR = "5D2"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: P003002, P003003, P003004, P003005, P003007, P003008, P005004, P005005, P005006, P005008, P005010, P005011, P005012, P005016, P005017, PSA, NAME, GIS_ID

SECTOR ✖

P005009 ✖

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
2070 2070 1000000US110010111001003 Block 1003, Block Group 1, Census Tract 111, District of Columbia, District of Columbia 54 1 48 0 0 0 0 5 54 50 1 45 0 0 0 0 4 4 0 3 0 0 0 0 1 110010111001003 5 503 503 5 psa_45 5D2
2152 2152 1000000US110010093012023 Block 2023, Block Group 2, Census Tract 93.01, District of Columbia, District of Columbia 94 20 69 0 1 0 0 4 94 90 19 66 0 1 0 0 4 4 1 3 0 0 0 0 0 110010093012023 5 504 504 5 psa_43 5D2
2761 2761 1000000US110010094002012 Block 2012, Block Group 2, Census Tract 94, District of Columbia, District of Columbia 119 19 96 0 0 0 0 4 119 116 16 96 0 0 0 0 4 3 3 0 0 0 0 0 0 110010094002012 5 504 504 5 psa_43 5D2
3215 3215 1000000US110010094004015 Block 4015, Block Group 4, Census Tract 94, District of Columbia, District of Columbia 31 0 26 0 0 0 1 4 31 30 0 26 0 0 0 0 4 1 0 0 0 0 0 1 0 110010094004015 5 503 503 5 psa_45 5D2
4037 4037 1000000US110010094001005 Block 1005, Block Group 1, Census Tract 94, District of Columbia, District of Columbia 90 9 69 1 2 0 5 4 90 82 9 66 1 2 0 0 4 8 0 3 0 0 0 5 0 110010094001005 5 503 503 5 psa_45 5D2
5144 5144 1000000US110010093014006 Block 4006, Block Group 4, Census Tract 93.01, District of Columbia, District of Columbia 80 33 40 0 2 0 1 4 80 79 32 40 0 2 0 1 4 1 1 0 0 0 0 0 0 110010093014006 5 504 504 5 psa_43 5D2
6207 6207 1000000US110010093021003 Block 1003, Block Group 1, Census Tract 93.02, District of Columbia, District of Columbia 75 14 57 0 0 0 0 4 75 74 13 57 0 0 0 0 4 1 1 0 0 0 0 0 0 110010093021003 5 504 504 5 psa_43 5D2
6318 6318 1000000US110010111002025 Block 2025, Block Group 2, Census Tract 111, District of Columbia, District of Columbia 79 7 64 3 1 0 0 4 79 77 5 64 3 1 0 0 4 2 2 0 0 0 0 0 0 110010111002025 5 503 503 5 psa_45 5D2
6374 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
);