top of page
horizontal lines
Gigasheet Primary logo

Air Quality

What we breathe is important.

About This Data

AQI or Air Quality Index is the primary way to measure the current quality of the air. AQI values range from 0-500 with 0 being perfectly healthy and 500 being extremely hazardous. AQI values are derived from moving averages/current values of PM2.5 (particulate matter), PM10, Ozone, Carbon Monoxide, Sulfur Dioxide, and Nitrogen Dioxide levels. This dataset was created using Locational Data from the United States Cities Database and AQI Data from the United States Environmental Protection Agency. The dataset then became available here.

With this dataset, we can look at what areas are the most dangerous, how the air quality changes over time, and how an area’s pollution levels change over time.

Things to try in the data set:

Group Data

Roll data up into groups of values within a column to look for trends. Place groups inside of groups to drill down another level, then group again!

Filter Data

Use the filters to narrow down the file to the values that interest you most. Only show values that include, exclude, contain, or are greater than a value (to name a few). Then add another level of filtering with AND / OR logic to dive deeper.

Search Data

Not sure where to start? Use search to find values in the file and then go back and filter or group the entire data set down to just that value.

Cities with the worst air quality.

Proportion of air quality pie chart.

Here is the average air quality by state.

Data Highlights

  1. Login to Gigasheet. Don't have an account yet? Sign up!

  2. Click the button below to view the data in your account.

  3. Feel free to explore the data via sharing mode or save a copy to your own account by clicking the View Copy button at the top of the page.

Explore This Data


Hawaii is the state with the best average air quality in the US.


The state with the worst average air quality is the District of Columbia.


The worst air quality ever recorded was on May 2nd, 2001 in Bishop California.

Key Insights


Poor air quality can irritate the eyes, nose, and throat, cause shortness of breath, aggravate asthma and other respiratory conditions, and affect the heart and cardiovascular system. Breathing polluted air for long periods of time can cause more serious problems. A new study shows that most of us humans are likely inhaling more air pollution each year. WIth rising concerns for our air quality, we found it appropriate to publish an air quality dataset.

bottom of page