Dataset: 1980-2021 Daily Air Quality Index From The EPA

About this Dataset

1980-2021 Daily Air Quality Index From The EPA

Content

This set includes daily reports of air quality index from various US Metro areas, as well as geographic data for the collection locations. This set has over 10 million rows.

Want a smaller set? I also have ANNUAL metrics available here. The yearly dataset is ~34k rows.

Acknowledgements

Data sourced directly from the Environmental Protection Agency
Banner: Photo by Maxim Tolchinskiy on Unsplash

Inspiration

This data offers opportunities for historical evaluation and visualization. What trends do we see in air quality over the years? Are there any predictions to be make for future air quality based on recent trends?

Like this dataset? See my other datasets!

Tables

Aqi Daily 1980 To 2021

@kaggle.threnjen_40_years_of_air_quality_index_from_the_epa_daily.aqi_daily_1980_to_2021

18.79 MB
10158527 rows
8 columns


CREATE TABLE aqi_daily_1980_to_2021 (
  "state_name" VARCHAR,
  "date" TIMESTAMP,
  "aqi" BIGINT,
  "category" VARCHAR,
  "defining_parameter" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "county_name" VARCHAR
);