washington_dc: dc_2010blocks_2020policedistricts_population: 20 rows where where P005012 = 2 and SECTOR = "4D2"

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

20 rows where P005012 = 2 and SECTOR = "4D2"

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	rowid ▼	GEO_ID	NAME_x	P003001	P003002	P003003	P003004	P003005	P003006	P003007	P003008	P005001	P005002	P005003	P005004	P005005	P005006	P005008	P005009	P005010	P005011	P005012	P005013	P005014	P005015	P005016	P005017	GEOID10	DISTRICT	PSA	NAME	POLDIST_ID	GIS_ID	SECTOR
400	400	1000000US110010022011008	Block 1008, Block Group 1, Census Tract 22.01, District of Columbia, District of Columbia	135	17	84	0	1	0	32	1	135	90	6	82	0	1	1	0	45	11	2	0	0	0	31	1	110010022011008	4	407	407	4	psa_47	4D2
406	406	1000000US110010023011005	Block 1005, Block Group 1, Census Tract 23.01, District of Columbia, District of Columbia	76	9	63	2	2	0	0	0	76	74	9	61	2	2	0	0	2	0	2	0	0	0	0	0	110010023011005	4	407	407	4	psa_47	4D2
415	415	1000000US110010024001001	Block 1001, Block Group 1, Census Tract 24, District of Columbia, District of Columbia	85	24	61	0	0	0	0	0	85	73	14	59	0	0	0	0	12	10	2	0	0	0	0	0	110010024001001	4	407	407	4	psa_47	4D2
419	419	1000000US110010024003000	Block 3000, Block Group 3, Census Tract 24, District of Columbia, District of Columbia	92	23	54	0	0	0	13	2	92	70	17	52	0	0	0	1	22	6	2	0	0	0	13	1	110010024003000	4	407	407	4	psa_47	4D2
734	734	1000000US110010022021004	Block 1004, Block Group 1, Census Tract 22.02, District of Columbia, District of Columbia	121	8	88	4	0	0	20	1	121	94	6	86	1	0	0	1	27	2	2	3	0	0	20	0	110010022021004	4	407	407	4	psa_47	4D2
1777	1777	1000000US110010095031002	Block 1002, Block Group 1, Census Tract 95.03, District of Columbia, District of Columbia	197	0	184	1	1	0	0	11	197	195	0	182	1	1	0	11	2	0	2	0	0	0	0	0	110010095031002	4	405	405	4	psa_49	4D2
1863	1863	1000000US110010022022006	Block 2006, Block Group 2, Census Tract 22.02, District of Columbia, District of Columbia	206	18	171	0	3	0	8	6	206	188	9	169	0	3	1	6	18	9	2	0	0	0	7	0	110010022022006	4	407	407	4	psa_47	4D2
2932	2932	1000000US110010022021003	Block 1003, Block Group 1, Census Tract 22.02, District of Columbia, District of Columbia	177	27	114	1	1	0	22	12	177	134	18	112	1	1	0	2	43	9	2	0	0	0	22	10	110010022021003	4	407	407	4	psa_47	4D2
3586	3586	1000000US110010095032002	Block 2002, Block Group 2, Census Tract 95.03, District of Columbia, District of Columbia	71	9	55	0	2	0	2	3	71	67	9	53	0	2	0	3	4	0	2	0	0	0	2	0	110010095032002	4	405	405	4	psa_49	4D2
3588	3588	1000000US110010095091004	Block 1004, Block Group 1, Census Tract 95.09, District of Columbia, District of Columbia	111	7	86	2	0	0	14	2	111	88	2	84	1	0	1	0	23	5	2	1	0	0	13	2	110010095091004	4	405	405	4	psa_49	4D2
4374	4374	1000000US110010023021019	Block 1019, Block Group 1, Census Tract 23.02, District of Columbia, District of Columbia	136	23	102	0	5	0	1	5	136	132	23	100	0	5	0	4	4	0	2	0	0	0	1	1	110010023021019	4	405	405	4	psa_49	4D2
4509	4509	1000000US110010095012003	Block 2003, Block Group 2, Census Tract 95.01, District of Columbia, District of Columbia	144	16	117	0	2	0	1	8	144	135	13	115	0	1	1	5	9	3	2	0	1	0	0	3	110010095012003	4	405	405	4	psa_49	4D2
4660	4660	1000000US110010023012010	Block 2010, Block Group 2, Census Tract 23.01, District of Columbia, District of Columbia	158	30	80	0	5	0	41	2	158	109	25	78	0	5	0	1	49	5	2	0	0	0	41	1	110010023012010	4	407	407	4	psa_47	4D2
4827	4827	1000000US110010022021002	Block 1002, Block Group 1, Census Tract 22.02, District of Columbia, District of Columbia	134	8	73	0	0	1	40	12	134	84	2	71	0	0	0	11	50	6	2	0	0	1	40	1	110010022021002	4	407	407	4	psa_47	4D2
5152	5152	1000000US110010095041001	Block 1001, Block Group 1, Census Tract 95.04, District of Columbia, District of Columbia	37	23	14	0	0	0	0	0	37	34	22	12	0	0	0	0	3	1	2	0	0	0	0	0	110010095041001	4	405	405	4	psa_49	4D2
5179	5179	1000000US110010095051006	Block 1006, Block Group 1, Census Tract 95.05, District of Columbia, District of Columbia	50	1	39	0	2	0	8	0	50	40	1	37	0	2	0	0	10	0	2	0	0	0	8	0	110010095051006	4	406	406	4	psa_54	4D2
5327	5327	1000000US110010023012008	Block 2008, Block Group 2, Census Tract 23.01, District of Columbia, District of Columbia	94	10	84	0	0	0	0	0	94	91	9	82	0	0	0	0	3	1	2	0	0	0	0	0	110010023012008	4	407	407	4	psa_47	4D2
5361	5361	1000000US110010022022004	Block 2004, Block Group 2, Census Tract 22.02, District of Columbia, District of Columbia	94	7	64	0	0	0	17	6	94	65	0	62	0	0	0	3	29	7	2	0	0	0	17	3	110010022022004	4	407	407	4	psa_47	4D2
5861	5861	1000000US110010021021008	Block 1008, Block Group 1, Census Tract 21.02, District of Columbia, District of Columbia	82	0	73	0	4	0	1	4	82	79	0	71	0	4	0	4	3	0	2	0	0	0	1	0	110010021021008	4	406	406	4	psa_54	4D2
6229	6229	1000000US110010024002009	Block 2009, Block Group 2, Census Tract 24, District of Columbia, District of Columbia	110	18	65	1	4	0	20	2	110	83	14	63	1	4	0	1	27	4	2	0	0	0	20	1	110010024002009	4	407	407	4	psa_47	4D2

Advanced export

JSON shape: default, array, newline-delimited

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