twoHelixestwoHelixes Start free

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

World food and health

Daily calories, meat eaten per person, GDP per capita and obesity by country and year. Empty cells mean missing, never zero.

7,485 rows7 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.

Meat eaten per person, latest year with data

A ranking, not a full map: only the latest year on record for each meat series is used, and countries with no observation that year are left out rather than plotted as zero.

Meat per person, latest year with data050100150TongaMarshall IslandsMacaoAustraliaBahamasNauruIsraelBrazilSpainPortugalMeat Kg Per Person
which countries eat the most meat per person in the latest year? — 20 rows charted from 7,485, drawn as a hbar
How it decided
Finding the data12 ms

World food and health: 7,485 rows, 7 columns. country, year and meat_kg_per_person; income, calories and obesity are not in this cut.

Shaping the data19 ms

7,485 rows in, 20 out across 2 columns. A ranking, not a full map: only the latest year on record for each meat series is used, and countries with no observation that year are left out rather than plotted as zero.

Choosing the chart5 ms

hbar. Country names are long labels and the question is a ranking, so horizontal bars sorted descending read best.

Applying defaults1 ms

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

Change in obesity since 1990, by country

The change is latest minus 1990 for each country separately, so a country that only appears late in the series cannot invent a change. Countries missing either endpoint stay out of the ranking.

Obesity change since 1990 (percentage points)0102030BruneiSaint Kitts and N…ChileTongaBelizeJamaicaArgentinaGeorgiaBarbadosQatarChange Pp
how has obesity changed since 1990 by country? — 20 rows charted from 7,485, drawn as a hbar
How it decided
Finding the data24 ms

World food and health: 7,485 rows, 7 columns. country, year and obesity_pct at the 1990 and latest endpoints.

Shaping the data30 ms

7,485 rows in, 20 out across 2 columns. The change is latest minus 1990 for each country separately, so a country that only appears late in the series cannot invent a change. Countries missing either endpoint stay out of the ranking.

Choosing the chart3 ms

hbar. One signed change per country is a ranking, and horizontal bars keep the country labels legible at this length.

Applying defaults1 ms

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

Income against obesity, latest year with both

Both measures come from the one latest year where a country has both an income and an obesity figure, so the scatter compares countries in the same year instead of mixing vintages.

GDP per capita against obesity0204060801964.452385448.0557072.79946664.227661.0945511.878Gdp Per Capita Ppp
does income track obesity in the latest year? — 186 rows charted from 7,485, drawn as a scatter
How it decided
Finding the data11 ms

World food and health: 7,485 rows, 7 columns. country, gdp_per_capita_ppp and obesity_pct in the latest shared year.

Shaping the data6 ms

7,485 rows in, 186 out across 3 columns. Both measures come from the one latest year where a country has both an income and an obesity figure, so the scatter compares countries in the same year instead of mixing vintages.

Choosing the chart4 ms

scatter. Two measures, no category and no time: a scatter of one point per country makes the relationship itself the chart.

Applying defaults1 ms

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

Daily calories over time, five countries

Five named countries only, so the lines stay distinguishable. Their different starting points and directions are the comparison; a country missing a year simply has no point there.

Daily calories per person, five countries01k2k3k4k199019931996199920022005200820112014201720202023YearUnited StatesAustraliaBrazilChinaSouth Africa
how have daily calories trended in five countries? — 170 rows charted from 7,485, drawn as a line
How it decided
Finding the data12 ms

World food and health: 7,485 rows, 7 columns. country, year and daily_calories for the five named countries.

Shaping the data11 ms

7,485 rows in, 170 out across 3 columns. Five named countries only, so the lines stay distinguishable. Their different starting points and directions are the comparison; a country missing a year simply has no point there.

Choosing the chart10 ms

line. A shared year axis with one line per country shows divergence and convergence; five lines stay under the eight-line limit.

Applying defaults1 ms

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

Schema

7 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
daily_caloriesnumber2253.5522
meat_kg_per_personnumber20.354
gdp_per_capita_pppnumber33146.67
obesity_pctnumber1.7234

First 8 rows

countrycodeyeardaily_caloriesmeat_kg_per_persongdp_per_capita_pppobesity_pct
ArubaABW1990nannan33146.67nan
ArubaABW1991nannan34079.23nan
ArubaABW1992nannan34458.14nan
ArubaABW1993nannan34627.742nan
ArubaABW1994nannan35580.535nan
ArubaABW1995nannan35476.41nan
ArubaABW1996nannan34506.53nan
ArubaABW1997nannan35534.273nan