DataBrighten

    Cereal yield (kg per hectare)

    10,440 × 6rows × columns: 181 countries, 1961 to 2024

    Real data: World Bank, World Development Indicators, indicator AG.YLD.CREL.KG, retrieved 19 November 2026. Values are as published; we only reshaped the file.

    textnumberdateyes/no
    Rows10,440country-year values
    Countries181with at least one value
    Years1961 – 202464 years with data
    LicenceCC BY 4.0credit the World Bank

    What it measures

    Cereal yield, measured as kilograms per hectare of harvested land, includes wheat, rice, maize, barley, oats, rye, millet, sorghum, buckwheat, and mixed grains. Production data on cereals relate to crops harvested for dry grain only. Cereal crops harvested for hay or harvested green for food, feed, or silage and those used for grazing are excluded. The FAO allocates production data to the calendar year in which the bulk of the harvest took place. Most of a crop harvested near the end of a year will be used in the following year.

    Limits and exceptions (World Bank note)

    Cereals production data relate to crops harvested for dry grain only. Cereal crops harvested for hay or harvested green for food, feed, or silage and those used for grazing are excluded. The FAO allocates production data to the calendar year in which the bulk of the harvest took place. Most of a crop harvested near the end of a year will be used in the following year. The data are collected by the Food and Agriculture Organization of the United Nations (FAO) through annual questionnaires. The FAO tries to impose standard definitions and reporting methods, but complete consistency across countries and over time is not possible. Thus, data on agricultural land in different climates may not be comparable. For example, permanent pastures are quite different in nature and intensity in African countries and dry Middle Eastern countries. Data on cereal yield may be affected by a variety of reporting and timing differences. Millet and sorghum, which are grown as feed for livestock and poultry in Europe and North America, are used as food in Africa, Asia, and countries of the former Soviet Union. So some cereal crops are excluded from the data for some countrie

    The numbers in 2024

    In 2024, 176 countries have a value. The highest is Oman (27,672); the lowest is Cabo Verde (40.3). The median country value is 3,240. The World Bank's World aggregate for 2023 is 4,229.

    Top 10 countries, 2024

    kg per hectare

    Source: World Bank, AG.YLD.CREL.KG, retrieved 19 November 2026. Computed from cereal-yield-kg-per-hectare.csv.

    Highest, 2024

    #CountryValue
    1Oman27,672
    2United Arab Emirates22,474
    3Qatar14,976
    4Kuwait14,196
    5St. Vincent and the Grenadines13,344
    6Mauritius11,890
    7New Caledonia11,650
    8New Zealand9,102
    9United States8,414
    10Bahamas, The7,737

    Lowest, 2024

    #CountryValue
    1Cabo Verde40.3
    2Namibia184.4
    3Somalia, Fed. Rep.362.1
    4Niger577.4
    5Sudan580.3
    6Lesotho603.5
    7Vanuatu636.2
    8Eritrea638
    9Libya659.7
    10Yemen, Rep.768.7
    How many countries report, by decade
    DecadeMost countries in one year
    1960s148
    1970s150
    1980s150
    1990s174
    2000s178
    2010s180
    2020s179

    World aggregate by year

    As published by the World Bank (in the regions file, not the country file).

    YearWorld
    20234,229
    20224,186
    20214,176
    20204,118
    20194,122
    20184,022
    20174,067
    20164,018
    20153,932
    20143,893
    20133,830
    20123,612

    By region, 2024

    World Bank regionValue
    North America8,414
    Latin America & Caribbean 4,828
    South Asia3,814
    Sub-Saharan Africa 1,453

    First rows

    cereal-yield-kg-per-hectare.csv

    countrytextiso3textregiontextincome_grouptextyearnumbervaluenumber
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income19611115.1
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income19621079
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income1963985.8
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income19641082.8
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income19651098.9
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income19661012.3
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income19671224.5
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income19681287.5

    Data dictionary

    ColumnTypeMeaning
    countrytextCountry or economy, World Bank name
    iso3textISO 3166-1 alpha-3 code
    regiontextWorld Bank region
    income_grouptextWorld Bank income group
    yearnumberCalendar year of the value
    valuenumberCereal yield (kg per hectare), exactly as the World Bank API returns it (not rounded)

    Only country-years with a value are in the long file; blank cells in the wide file mean no value was published.

    Practice questions

    answers computed from the file

    Which country has the highest value in 2024?

    Oman, with 27,672.

    Excel (on the long CSV: E = year, F = value)

    =FILTER(A2:A100000,(E2:E100000=2024)*(F2:F100000=MAXIFS(F2:F100000,E2:E100000,2024)))

    SQL (table wb = the CSV)

    SELECT country, value FROM wb WHERE year = 2024
      AND value = (SELECT MAX(value) FROM wb WHERE year = 2024);

    pandas (df = pd.read_csv("cereal-yield-kg-per-hectare.csv"))

    y = df[df.year == 2024]
    y[y.value == y.value.max()][["country", "value"]]

    File: cereal-yield-kg-per-hectare.csv

    How many countries report a value for 2024?

    176 of the 217 economies in the file's country list.

    Excel (on the long CSV: E = year, F = value)

    =COUNTIF(E2:E100000,2024)

    SQL (table wb = the CSV)

    SELECT COUNT(*) FROM wb WHERE year = 2024;

    pandas (df = pd.read_csv("cereal-yield-kg-per-hectare.csv"))

    (df.year == 2024).sum()

    File: cereal-yield-kg-per-hectare.csv

    What is the median across countries in 2024?

    3,240 (median of the 176 country values; not a World Bank aggregate).

    Excel (on the long CSV: E = year, F = value)

    =MEDIAN(FILTER(F2:F100000,E2:E100000=2024))

    SQL (table wb = the CSV)

    -- SQLite has no MEDIAN(); this picks the middle value(s)
    SELECT AVG(value) FROM (SELECT value FROM wb WHERE year = 2024 ORDER BY value
      LIMIT 2 - (SELECT COUNT(*) FROM wb WHERE year = 2024) % 2
      OFFSET (SELECT (COUNT(*) - 1) / 2 FROM wb WHERE year = 2024));

    pandas (df = pd.read_csv("cereal-yield-kg-per-hectare.csv"))

    df[df.year == 2024]["value"].median()

    File: cereal-yield-kg-per-hectare.csv

    Which country rose the most between 2014 and 2024?

    Oman: from 7,750 to 27,672, a rise of 19,922 (out of 175 countries with both years).

    Excel (on the long CSV: E = year, F = value)

    Use the wide file (cereal-yield-kg-per-hectare-wide.csv): add a column = [2024] - [2014], then sort it largest to smallest.

    SQL (table wb = the CSV)

    SELECT a.country, b.value - a.value AS rise FROM wb a JOIN wb b ON a.iso3 = b.iso3
    WHERE a.year = 2014 AND b.year = 2024 ORDER BY rise DESC LIMIT 1;

    pandas (df = pd.read_csv("cereal-yield-kg-per-hectare.csv"))

    w = df.pivot(index="country", columns="year", values="value")
    (w[2024] - w[2014]).dropna().nlargest(1)

    File: cereal-yield-kg-per-hectare.csv

    Which year has the most countries reporting?

    2017, with 180 countries. (Later years are still filling in as countries report.)

    Excel (on the long CSV: E = year, F = value)

    Make a pivot table: year in Rows, Count of value in Values, then sort by the count.

    SQL (table wb = the CSV)

    SELECT year, COUNT(*) AS n FROM wb GROUP BY year ORDER BY n DESC, year DESC LIMIT 1;

    pandas (df = pd.read_csv("cereal-yield-kg-per-hectare.csv"))

    df.groupby("year").size().sort_values(ascending=False).head(1)

    File: cereal-yield-kg-per-hectare.csv