What this warehouse answers
Six analyses built on public data, each ending in a decision somebody has to make. Every figure is a live query, so the numbers move when the data does.
CO₂ per person, tonnes (20 or more shown as 20)
Nine Findings →
Rich countries peaked decades ago; China and India have not. What six decades of national emissions and energy data support.
CBAM Exposure →
Between the cheapest and the dearest of these six sources, the same tonne of steel carries €568 more in gross CBAM cost in 2026.
What the CBAM defaults put on imports of steel, cement, aluminium, fertiliser and hydrogen, before deductions.
Scope 2 Factors →
An identical site reports a very different Scope 2 figure on its address alone. The factor for every country, with its vintage and lineage.
Retail Transactions →
Where the revenue sits, who comes back, and three definitions that each change the answer by six figures.
Currency →
The same price rose by very different amounts depending on the currency it was counted in, and when to use an average rate rather than a spot one.
Weather →
Before crediting an energy number to policy, rule out a cold year. Weather moves Europe's emissions, and none of its electricity prices.
To check a specific country or year rather than read a conclusion, use the Country Explorer.
Before you quote a number
The engineering is built and measured; the analysis has not had the same scrutiny. Treat the conclusions here as illustrative. The Scope 2 worked example runs on fabricated sites, and coverage thins unevenly between measures. What this is not, yet.
- Coverage: which countries and years each measure covers, and where two sources disagree.
- Restatements: figures revised since this warehouse first recorded them.
- Pipeline: the operational state of the load itself.
- Data catalogue: every model and column, its contract, its tests and its lineage back to the source.
Seven public sources and one retailer's transaction log, loaded, modelled, tested and released each month as a DuckDB file, with the published tables also as Parquet.
Sources: OWID CO₂, OWID Energy, World Bank WDI, Eurostat electricity prices, ECB reference rates via Frankfurter, Open-Meteo (ERA5-Land and ERA5, Copernicus/ECMWF), Implementing Regulation (EU) 2025/2621, UCI Online Retail II. Country outlines from Natural Earth. Built with dlt, dbt, DuckDB, Polars, Dagster & Evidence — every model, test and workflow behind these numbers is on GitHub, along with a monthly release of the whole warehouse as DuckDB and Parquet.