Datasets / Curated (shared with askfelix)

City air quality

Monthly PM2.5, NO2 and ozone for world cities with temperature and respiratory visits.

Ask a question of it Download CSV Jupyter notebook

96 rows11 columns Curated (shared with askfelix)

Worked examples

Each of these is a real run: the pipeline picked the columns, shaped the rows and chose the form. Open the trace to see what it decided and why.

Cities ranked by average PM2.5

Monthly observations are averaged by city and sorted from the most polluted, so the ranking is not dominated by a single month.

which cities have the worst PM2.5? — 8 rows charted from 96, drawn as a hbar

Ask this yourself See the working

How it decided

Finding the data823 ms

City air quality: 96 rows, 11 columns. city and pm25_ug_m3; the ranking uses all twelve monthly observations.

Shaping the data3 ms

96 rows in, 8 out across 2 columns. Monthly observations are averaged by city and sorted from the most polluted, so the ranking is not dominated by a single month.

Choosing the chart3 ms

hbar. City names are labels and PM2.5 is one measure, so sorted horizontal bars read best.

Applying defaults1 ms

Palette, spacing, axis titles and legend placement applied. 0 issues found.

Schema

11 columns, typed as the pipeline sees them — which is how it knows what can go on a time axis and what can be summed.

Column	Type	Example
month	text	2025-01-01
city	text	Los Angeles
country	text	USA
climate_zone	text	coastal
latitude	number	34.05
longitude	number	-118.24
avg_temp_c	number	18.0
pm25_ug_m3	number	9.0
no2_ppb	number	19.0
ozone_ppb	number	28.0
respiratory_visits	number	47

First 8 rows

month	city	country	climate_zone	latitude	longitude	avg_temp_c	pm25_ug_m3	no2_ppb	ozone_ppb	respiratory_visits
2025-01-01	Los Angeles	USA	coastal	34.05	-118.24	18.0	9.0	19.0	28.0	47
2025-01-01	Chicago	USA	inland	41.88	-87.63	18.9	13.5	17.1	29.2	53
2025-01-01	Mexico City	Mexico	highland	19.43	-99.13	19.7	18.0	19.2	30.4	62
2025-01-01	Sao Paulo	Brazil	subtropical	-23.55	-46.63	20.6	22.5	21.3	31.6	70
2025-01-01	London	UK	temperate	51.51	-0.13	21.4	27.0	23.4	32.8	79
2025-01-01	Cairo	Egypt	desert	30.04	31.24	22.2	39.5	25.5	34.0	101
2025-01-01	Delhi	India	monsoon	28.61	77.21	23.1	54.0	31.6	35.2	128
2025-01-01	Tokyo	Japan	humid	35.68	139.69	23.9	40.5	33.7	36.4	107

Ask it something else

which cities have the worst PM2.5?does air pollution track respiratory visits?seasonality of ozone by climate zone

Start free