Must high human development mean high CO₂ emissions?
Practice joining HDI with per-person CO₂ emissions by country and year, then inspect the exceptions.
01 / THE QUESTION
Question
Do countries with higher Human Development Index values always emit more CO₂ per person? Which countries combine relatively high HDI with lower emissions?
undp_human_development_index.country_iso_alpha3 = worldbank_co2_emissions_per_capita.country_iso_alpha3 + year · one HDI observation to one CO₂ observation for each country and year
04 / ANALYST GUIDE
Guide
Analysis requirements
Join undp_human_development_index and worldbank_co2_emissions_per_capita on both country_iso_alpha3 and year.
Start with each country's latest year with non-null observations in both datasets. Retain year, since that year may differ between countries; filter to one common year before drawing a same-year comparison.
Plot human_development_index against co2_emissions_tco2e_per_capita and inspect exceptions to the overall pattern.
The CO₂ measure excludes land use, land-use change and forestry (LULUCF), uses EDGAR estimates and is not the archived World Bank CO₂ series. HDI combines health, education and living standards; association does not prove causation.
Suggested query
Expand suggested query
SQL / STARTER QUERY
WITH paired AS (
SELECT h.country_iso_alpha3, h.country_name, h.year,
h.human_development_index, e.co2_emissions_tco2e_per_capita,
ROW_NUMBER() OVER (PARTITION BY h.country_iso_alpha3 ORDER BY h.year DESC) AS recency
FROM undp_human_development_index AS h
JOIN worldbank_co2_emissions_per_capita AS e
ON h.country_iso_alpha3 = e.country_iso_alpha3
AND h.year = e.year
WHERE h.human_development_index IS NOT NULL
AND e.co2_emissions_tco2e_per_capita IS NOT NULL
)
SELECT country_iso_alpha3, country_name, year,
human_development_index, co2_emissions_tco2e_per_capita
FROM paired
WHERE recency = 1
ORDER BY human_development_index DESC;