Datasets / Curated (shared with askfelix)

City air quality

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

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.

Averaged over the year, the ranking is stable - the worst city is not the one with the worst single month.

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

How it decided

Finding the data70 ms

City air quality: 96 rows, 11 columns. city and pm25_ug_m3, averaged over the months present.

Shaping the data28 ms

96 rows in, 8 out across 2 columns. Averaged over the year, the ranking is stable - the worst city is not the one with the worst single month.

Choosing the chart8 ms

bar. Named categories ranked on one measure: horizontal bars if the names are long, vertical here - twelve cities fit either way.

Applying defaults1 ms

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

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.

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