5,480 rows · 8 columns

City air quality

Daily pollutant readings for four cities over nearly four years, with strong seasonality, weekday effects, wildfire episodes, and genuine sensor outages.

What is in it, and what is wrong with it

Missing readings are blank, not zero — an important distinction, because a zero PM2.5 reading is physically implausible and will quietly drag your monthly averages down if you impute carelessly. Two multi-day wildfire episodes are embedded; they are real signal, not outliers to be clipped.

Schema

ColumnTypeDescription
reading_datedateCalendar date.
citycategoryAshfield, Bellmoor, Corvallis Bay, or Drayton.
pm25floatPM2.5, µg/m³. Blank when the monitor was offline.
pm10floatPM10, µg/m³.
no2_ppbfloatNitrogen dioxide, parts per billion.
o3_ppbfloatOzone, parts per billion.
temp_cfloatDaily mean temperature.
wind_kphfloatDaily mean wind speed.

First twelve rows

reading_datecitypm25pm10no2_ppbo3_ppbtemp_cwind_kph
2023-01-01Ashfield19.24216.523.71.78.9
2023-01-01Bellmoor32.768.729.113.1-0.87.7
2023-01-01Corvallis Bay5.510.74.59.95.414.3
2023-01-01Drayton25.856.825.314619.3
2023-01-02Ashfield24.944.429.843.417.2
2023-01-02Bellmoor42.591.337.511.34.914.2
2023-01-02Corvallis Bay18.43218.619.84.914.8
2023-01-02Drayton30.748.323.618.8110.6
2023-01-03Ashfield22.845.131.722.14.68.8
2023-01-03Bellmoor41.584.645.816.54.532.9
2023-01-03Corvallis Bay1428.72119.1-0.45.5
2023-01-03Drayton31.147.733.216.64.94.9