twoHelixestwoHelixes Start free

Datasets / Our World in Data (CC BY 4.0); built by scripts/build-world-fixtures.sh

World climate and energy

CO2 emissions per person, renewable share of electricity and electricity access by country and year.

8,037 rows6 columns Our World in Data (CC BY 4.0); built by scripts/build-world-fixtures.sh

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.

Highest CO2 per person, latest year per country

Each country contributes its own latest observed year, so the ranking compares most countries on recent data without filling missing years with zero.

CO2 per person by country010203040QatarBruneiTrinidad and Toba…United Arab Emira…Sint Maarten (Dut…AustraliaKazakhstanFaroe IslandsCO2 tonnes per person
which countries emit the most CO2 per person in the latest year? — 15 rows charted from 8,037, drawn as a hbar
How it decided
Finding the data13 ms

World climate and energy: 8,037 rows, 6 columns. country and co2_tonnes_per_person; the year is each country's latest observed year.

Shaping the data30 ms

8,037 rows in, 15 out across 2 columns. Each country contributes its own latest observed year, so the ranking compares most countries on recent data without filling missing years with zero.

Choosing the chart4 ms

hbar. Country names are long labels and emissions are one measure, so sorted horizontal bars read best.

Applying defaults1 ms

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

Change in CO2 per person since 1990

The latest observed value minus the 1990 value, shown for the countries with the largest absolute change in either direction.

Change in CO2 per person since 1990-30-20-1001020QatarOmanMongoliaBruneiUnited StatesSlovakiaGermanyNauruUkraineCuracaoCo2 Change
how has CO2 per person changed since 1990 by country? — 20 rows charted from 8,037, drawn as a hbar
How it decided
Finding the data14 ms

World climate and energy: 8,037 rows, 6 columns. country, year and co2_tonnes_per_person; only countries with both a 1990 and a later value appear.

Shaping the data34 ms

8,037 rows in, 20 out across 2 columns. The latest observed value minus the 1990 value, shown for the countries with the largest absolute change in either direction.

Choosing the chart3 ms

hbar. A signed change across named countries is a ranking, so horizontal bars keep the largest movers legible.

Applying defaults1 ms

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

Renewable share against CO2 per person, latest year per country

One point per country in its latest year with both indicators observed, so the relationship is read across countries rather than over time.

Renewable share against CO2 per person0102030400.09.70929722.93509343.7573.45972Renewable Electricity Pct
is a higher renewable electricity share linked to lower CO2 per person? — 201 rows charted from 8,037, drawn as a scatter
How it decided
Finding the data10 ms

World climate and energy: 8,037 rows, 6 columns. renewable_electricity_pct and co2_tonnes_per_person in each country's latest year with both values.

Shaping the data9 ms

8,037 rows in, 201 out across 3 columns. One point per country in its latest year with both indicators observed, so the relationship is read across countries rather than over time.

Choosing the chart4 ms

scatter. Two measures with no time axis is a scatter; no colour column keeps the palette to a single series.

Applying defaults1 ms

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

CO2 per person over time for five countries

Five named countries on the same year axis, so the shapes and starting points of the longer-run trends can be compared without a field of unreadable lines.

CO2 per person by country05101520Jan 90Jan 94Jan 98Jan 02Jan 06Jan 10Jan 14Jan 18Jan 22Year DateUnited StatesUnited KingdomChinaBrazilIndia
how has CO2 per person trended in China, the United States, India, the United Kingdom and Brazil? — 175 rows charted from 8,037, drawn as a line
How it decided
Finding the data11 ms

World climate and energy: 8,037 rows, 6 columns. country, year and co2_tonnes_per_person for the five named countries.

Shaping the data36 ms

8,037 rows in, 175 out across 3 columns. Five named countries on the same year axis, so the shapes and starting points of the longer-run trends can be compared without a field of unreadable lines.

Choosing the chart14 ms

line. Time on x with one line per country is the shared-axis line chart; five series stays inside the palette limit.

Applying defaults1 ms

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

Schema

6 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 TypeExample
countrytextAruba
codetextABW
yearnumber1990
co2_tonnes_per_personnumber7.5609
renewable_electricity_pctnumber0.0
electricity_access_pctnumber100.0

First 8 rows

countrycodeyearco2_tonnes_per_personrenewable_electricity_pctelectricity_access_pct
ArubaABW19907.5609nan100.0
ArubaABW19917.9815nan99.1537
ArubaABW19927.8185nan99.1971
ArubaABW19939.1225nan99.2399
ArubaABW19948.9761nan100.0
ArubaABW19959.3615nan100.0
ArubaABW19969.1954nan100.0
ArubaABW19979.3494nan100.0