twoHelixestwoHelixes Start free

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

World prosperity

GDP per capita (PPP), internet use, happiness, extreme poverty and life expectancy by country and year.

8,415 rows8 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.

GDP per capita in the latest year, top 20

Each country contributes a single row: its most recent year with a GDP per capita value, so the ranking compares like with like instead of mixing years.

GDP per capita in the latest year050k100k150kSingaporeLuxembourgQatarNorwayGuyanaBruneiDenmarkNetherlandsSan MarinoHong KongGdp Per Capita Ppp
which countries have the highest GDP per capita in the latest year? — 20 rows charted from 8,415, drawn as a hbar
How it decided
Finding the data14 ms

World prosperity: 8,415 rows, 8 columns. country, year and gdp_per_capita_ppp; missing values are dropped, never read as zero.

Shaping the data14 ms

8,415 rows in, 20 out across 2 columns. Each country contributes a single row: its most recent year with a GDP per capita value, so the ranking compares like with like instead of mixing years.

Choosing the chart6 ms

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

Applying defaults1 ms

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

Change in GDP per capita since 1990, top 20

Every bar is a difference between a country's 1990 value and its most recent value, so the chart shows how far each country moved over the period rather than where it ended up.

Change in GDP per capita since 1990025k50k75k100kIrelandGuyanaLuxembourgSouth KoreaHong KongPolandUnited StatesLithuaniaDenmarkTurkeyChange
how much has GDP per capita changed since 1990 by country? — 20 rows charted from 8,415, drawn as a hbar
How it decided
Finding the data11 ms

World prosperity: 8,415 rows, 8 columns. country, year and gdp_per_capita_ppp for 1990 and the latest year; missing values are dropped.

Shaping the data26 ms

8,415 rows in, 20 out across 2 columns. Every bar is a difference between a country's 1990 value and its most recent value, so the chart shows how far each country moved over the period rather than where it ended up.

Choosing the chart4 ms

hbar. A difference per country is one measure with text labels, so sorted horizontal bars are clearest.

Applying defaults1 ms

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

Life expectancy against GDP per capita, latest year

One point per country, each at its most recent year where both measures are present, so gaps in either series cannot masquerade as zeros and pull a country to the corner of the plot.

Life expectancy against GDP per capita0204060801983.81269228.4612963.598611330.26994364.961401.6473Gdp Per Capita Ppp
is life expectancy related to GDP per capita in the latest year? — 198 rows charted from 8,415, drawn as a scatter
How it decided
Finding the data9 ms

World prosperity: 8,415 rows, 8 columns. gdp_per_capita_ppp and life_expectancy in each country's latest year with both; missing values are dropped.

Shaping the data7 ms

8,415 rows in, 198 out across 2 columns. One point per country, each at its most recent year where both measures are present, so gaps in either series cannot masquerade as zeros and pull a country to the corner of the plot.

Choosing the chart2 ms

scatter. Two measures with no grouping is a scatter: one point per country shows the relationship directly.

Applying defaults1 ms

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

GDP per capita over time for five countries

The same five countries are followed across every year they report, so the lines stay comparable and no country enters or leaves the story halfway through.

GDP per capita over time020k40k60kJan 90Jan 94Jan 98Jan 02Jan 06Jan 10Jan 14Jan 18Jan 22Year DateCanadaChileSouth AfricaChinaZimbabwe
how has GDP per capita changed over time in Canada, China, Chile, South Africa and Zimbabwe? — 180 rows charted from 8,415, drawn as a line
How it decided
Finding the data9 ms

World prosperity: 8,415 rows, 8 columns. country, year and gdp_per_capita_ppp for Canada, China, Chile, South Africa and Zimbabwe; missing values are dropped.

Shaping the data20 ms

8,415 rows in, 180 out across 3 columns. The same five countries are followed across every year they report, so the lines stay comparable and no country enters or leaves the story halfway through.

Choosing the chart10 ms

line. A measure over time with one line per country is a shared-axis line chart.

Applying defaults1 ms

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

Schema

8 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
gdp_per_capita_pppnumber33146.67
internet_users_pctnumber0.0
happiness_scorenumber4.258
extreme_poverty_pctnumber26.9546
life_expectancynumber72.546

First 8 rows

countrycodeyeargdp_per_capita_pppinternet_users_pcthappiness_scoreextreme_poverty_pctlife_expectancy
ArubaABW199033146.670.0nannan72.546
ArubaABW199134079.23nannannan72.5921
ArubaABW199234458.14nannannan72.7174
ArubaABW199334627.742nannannan72.7767
ArubaABW199435580.535nannannan72.796
ArubaABW199535476.41nannannan72.8322
ArubaABW199634506.532.77nannan72.8561
ArubaABW199735534.273nannannan72.904