EPA

Air quality

Annual county air-quality summaries from EPA monitors.

Published by EPA Finest detail county Tables 4

How we use this · on 2 desks

“How clean is the air in this county?”

Region Brief: Disasters, Energy costs, County dossier
Business & Site Planning: Pick a site
AI & Spreadsheets: at Level 3, link it into Excel or Google Sheets, download it, or ask your AI assistant about it

Matched to the same county codes as every other source, so it lines up cleanly with all of them
Connecticut's new planning regions filled in, where the agency still reports the old counties
Refreshed every week

By metro, yearly Sample of 25 rows out of about 22,001 · 18 columns

cbsa_code	year	cbsa_name	days_with_aqi	good_days	moderate_days	usg_days	unhealthy_days	very_unhealthy_days	hazardous_days	max_aqi	p90_aqi	median_aqi	days_pm25	days_pm10
10100	1985	Aberdeen, SD	65	62	3	0	0	0	0	64	42	26	0	65
10100	1986	Aberdeen, SD	97	94	3	0	0	0	0	54	41	21	0	97
10100	1987	Aberdeen, SD	83	81	2	0	0	0	0	54	40	21	0	83
10100	2000	Aberdeen, SD	103	73	30	0	0	0	0	80	60	40	92	11
10100	2001	Aberdeen, SD	127	87	40	0	0	0	0	82	61	40	113	14
10100	2002	Aberdeen, SD	122	88	34	0	0	0	0	71	57	38	113	9
10100	2003	Aberdeen, SD	121	80	41	0	0	0	0	74	60	43	112	9
10100	2004	Aberdeen, SD	123	85	38	0	0	0	0	86	59	39	122	1
10100	2005	Aberdeen, SD	122	75	47	0	0	0	0	83	65	43	122	0
10100	2006	Aberdeen, SD	122	79	43	0	0	0	0	75	58	40	118	4
10100	2007	Aberdeen, SD	121	86	35	0	0	0	0	74	56	42	117	4
10100	2008	Aberdeen, SD	122	90	32	0	0	0	0	89	58	38	112	10
10100	2009	Aberdeen, SD	122	86	36	0	0	0	0	90	58	39	117	5
10100	2010	Aberdeen, SD	119	80	39	0	0	0	0	92	61	41	116	3
10100	2011	Aberdeen, SD	122	94	28	0	0	0	0	70	59	33	119	3
10100	2012	Aberdeen, SD	123	86	37	0	0	0	0	80	58	37	117	6
10100	2013	Aberdeen, SD	121	90	31	0	0	0	0	77	60	34	115	6
10100	2014	Aberdeen, SD	119	103	16	0	0	0	0	85	53	29	117	2
10100	2015	Aberdeen, SD	121	102	19	0	0	0	0	94	54	32	120	1
10100	2016	Aberdeen, SD	119	104	15	0	0	0	0	79	53	26	111	8
10100	2017	Aberdeen, SD	122	108	14	0	0	0	0	97	52	31	119	3
10100	2018	Aberdeen, SD	121	104	15	1	0	0	1	421	53	32	118	3
10100	2019	Aberdeen, SD	122	104	18	0	0	0	0	80	53	25	119	3
10100	2020	Aberdeen, SD	364	308	56	0	0	0	0	78	54	28	258	106
10100	2021	Aberdeen, SD	356	301	52	0	2	1	0	208	58	26	210	146

Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.

See pricing