Dataset research report
City Air Quality research report
A reproducible data report with schema notes, generated chart evidence, suggested follow-up questions, and export-ready Helix queries.
Executive Summary
Monthly city climate and air-quality observations with coordinates, pollutants, temperature, and respiratory visits for maps, scatter plots, and correlations.
Research Context
City Air Quality: 96 rows by 11 columns. These exploratory charts are generated automatically from the data - open the dataset in Helix to ask your own questions.
Data Profile
Chart Evidence
These views are generated from the dataset profile. Each chart is paired with a Helix query so it can be opened, adjusted, and exported.
avg_temp_c over time
Trend of avg_temp_c, pm25_ug_m3, no2_ppb across month.
Open and export this chartTotal avg_temp_c by city
Top city values ranked by summed avg_temp_c.
Open and export this chartavg_temp_c vs pm25_ug_m3
avg_temp_c vs pm25_ug_m3, coloured by city.
Open and export this chartCorrelation of numeric columns
Pearson correlation between numeric columns.
Open and export this chartFollow-Up Queries
- map cities using latitude and longitude sized by pm25_ug_m3
- line chart of pm25_ug_m3 over month by city
- scatter pm25_ug_m3 vs respiratory_visits coloured by climate_zone
- correlation heatmap of pollutants temperature and respiratory visits
- boxplot respiratory_visits by climate_zone
- bar chart of average ozone_ppb by city
Preview Rows
| # | monthtext | citytext | countrytext | climate_zonetext | latitudefloat | longitudefloat | avg_temp_cfloat | pm25_ug_m3float |
|---|---|---|---|---|---|---|---|---|
| 1 | 2025-01-01 | Los Angeles | USA | coastal | 34.05 | -118.2 | 18 | 9 |
| 2 | 2025-01-01 | Chicago | USA | inland | 41.88 | -87.63 | 18.9 | 13.5 |
| 3 | 2025-01-01 | Mexico City | Mexico | highland | 19.43 | -99.13 | 19.7 | 18 |
| 4 | 2025-01-01 | Sao Paulo | Brazil | subtropical | -23.55 | -46.63 | 20.6 | 22.5 |
| 5 | 2025-01-01 | London | UK | temperate | 51.51 | -0.13 | 21.4 | 27 |
| 6 | 2025-01-01 | Cairo | Egypt | desert | 30.04 | 31.24 | 22.2 | 39.5 |
Data Dictionary
- month date Observation month
- city categorical City name
- country categorical Country name
- climate_zone categorical Broad climate zone
- latitude float City latitude
- longitude float City longitude
- avg_temp_c float Average temperature in Celsius
- pm25_ug_m3 float PM2.5 concentration
- no2_ppb float NO2 concentration
- ozone_ppb float Ozone concentration
- respiratory_visits int Respiratory-related healthcare visits
Method And Limits
- Load the catalog entry and preview rows from the processed dataset file.
- Infer numeric, categorical, time, and location fields from real columns.
- Generate a small set of defensive Plotly chart specifications from that profile.
- Expose each chart idea as a query link so the report can be rerun or exported in Helix.
This report is intentionally reproducible. It uses the local catalog metadata and generated chart specifications rather than claiming external conclusions beyond the dataset.