Ozone layer recovery (Part 1)

Atmospheric Science
Environmental Science
Sustainability
Data Science
Spreadsheets

Is the Ozone layer recovering? Let’s look at the data to find out!

Our goal today (Part 1) is to obtain Ozone concentration data above the South Pole from the NASA Earth System Data Explorer. Later in Part 2 we will analyze the data.

Dislcaimer: This is not an “official” NASA data analysis activity. This is a STEMcoding activity that uses NASA data.

Step 1. Geek out on the Ozone layer

There are some great websites and youtube videos to learn about the Ozone layer. Take some time to check it out before we get down to business. Be curious!

Basic facts about the Ozone layer

  • Ozone is the chemical name for when three Oxygen atoms become bonded together to form a molecule, which is why the chemical symbol for Ozone is O3
  • Ozone is a good absorber of ultraviolet (UV) light, and its presence in the upper part of the atmosphere helps to reduce the UV light reaching the earth’s surface
  • Ozone reacts with chemicals that exist in some hairsprays and refrigerants, which has dramatically reduced the amount of Ozone directly above the south pole (and to a lesser extent the north pole)
  • International agreements have steadily reduced the amount of chemicals in the air that react with Ozone

Here is another important fact: The Ozone layer affects how much UV light reaches the ground but the Ozone concentration does not have a net warming or cooling effect on the earth. The Ozone concentration is unrelated to climate change or global warming.

Step 2. Behold the amazingness of the NASA Earth System Data Explorer

The fine folks at NASA have made a great website where you can download data from different Earth-observing satellites. It’s called the Earth System Data Explorer Go ahead and try it out!

Ultimately we are going to download a data set from that site for Ozone data at the South Pole that is a lot like this dataset. In fact you could just go on to the next activity with that dataset, but why would you do that when you can get the very latest data from the Earth System Data Explorer?

Getting South Pole Ozone layer data

There is SO MUCH DATA that you can download from the Earth System Data Explorer that you will need to follow these directions VERY closely to get the right dataset

Under “1. Select a Sphere of the Earth System” choose “Atmosphere”

Under “2. Select a Category” choose “Atmospheric Chemistry”

Under “3. Select a Dataset” choose “Monthly Air Column Concentration of Ozone”

Under “4. Select the Data” choose “2005” and “January” (it is a long story but even though we could select 2004 and December, there is a bug later that we can avoid by selecting 2005 and January – just trust us! As of June 2026 the bug is still there)

After you select 2005 and January, the options on the left and right will change and your screen will look something like this:

On the Right: Click Time Series Data Table Now your screen will look like this:

Step 3. What is the latitude and longitude of the South Pole?

The NASA Earth System Data Explorer needs a latitude and longitude in order to give you data from 2005 to the present day. We want to know about the Ozone concentration above the South Pole. What is the latitude and longitude of the exact South Pole?

Hint #1: The equator is at 0 degrees latitude. So 0 degrees is definitely the wrong answer for the latitude of the exact South Pole.

Hint #2: At the exact location of the South Pole, is it really so important what the degrees longitude is? Focus on the latitude!

Step 4. Put in the current year and month for the “End Date”

Go ahead and put in the current year and month (or whatever is the most recent month available on the list) into the “End Date” under “Select the Start and End Dates” then click “Generate Data Table”. At the time of this writing the most recent data available for Ozone concentration is April 2026. After clicking “Generate Data Table” your screen will look like this:

Step 5. Click the top right to open the data into a new tab

Now click the top right icon on the page like this:

This will open a new tab. Wait 20 seconds and a button will appear in the top right that says “Download CSV”

When you click “Download CSV” it should download a file called ee-chart.csv

Go to your favorite spreadsheet program and import ee-chart.csv

CC BY-NC License