DataBrighten

    Over-age students, primary (% of enrollment)

    4,487 × 6rows × columns: 203 countries, 1970 to 2019

    Real data: World Bank, World Development Indicators, indicator SE.PRM.OENR.ZS, retrieved 19 November 2026. Values are as published; we only reshaped the file.

    textnumberdateyes/no
    Rows4,487country-year values
    Countries203with at least one value
    Years1970 – 201950 years with data
    LicenceCC BY 4.0credit the World Bank

    What it measures

    Over-age students are the percentage of those enrolled who are older than the official school-age range for primary education.

    The numbers in 2017

    In 2017, 148 countries have a value. The highest is Liberia (46.96); at the bottom, 3 countries tie at 0 (e.g. Canada, Japan, Norway). The median country value is 4.79.

    Top 10 countries, 2017

    % of enrollment

    Source: World Bank, SE.PRM.OENR.ZS, retrieved 19 November 2026. Computed from over-age-students-primary-percent-of-enrollment.csv.

    Highest, 2017

    #CountryValue
    1Liberia46.96
    2Solomon Islands36.33
    3Nepal28.52
    4Eswatini28.27
    5Pakistan26.39
    6Rwanda26.34
    7Eritrea24.35
    8Lesotho21.08
    9Malawi19.69
    10Mauritania19.49

    Lowest, 2017

    Ties are listed A to Z.

    #CountryValue
    1Norway0
    2Japan0
    3Canada0
    4Iceland0.0344
    5Tajikistan0.0754
    6Malaysia0.243
    7Kazakhstan0.314
    8New Zealand0.386
    9Uzbekistan0.449
    10Singapore0.53
    How many countries report, by decade
    DecadeMost countries in one year
    1970s66
    1980s71
    1990s126
    2000s147
    2010s149

    First rows

    over-age-students-primary-percent-of-enrollment.csv

    countrytextiso3textregiontextincome_grouptextyearnumbervaluenumber
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income197418.43234
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income19937.13143
    AlbaniaALBEurope & Central AsiaUpper middle income19998.4579
    AlbaniaALBEurope & Central AsiaUpper middle income20008.45793
    AlbaniaALBEurope & Central AsiaUpper middle income20018.83956
    AlbaniaALBEurope & Central AsiaUpper middle income20038.30601
    AlbaniaALBEurope & Central AsiaUpper middle income20047.38917
    AlbaniaALBEurope & Central AsiaUpper middle income20089.11137

    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
    valuenumberOver-age students, primary (% of enrollment), 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 2017?

    Liberia, with 46.96.

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

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

    SQL (table wb = the CSV)

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

    pandas (df = pd.read_csv("over-age-students-primary-percent-of-enrollment.csv"))

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

    File: over-age-students-primary-percent-of-enrollment.csv

    How many countries report a value for 2017?

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

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

    =COUNTIF(E2:E100000,2017)

    SQL (table wb = the CSV)

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

    pandas (df = pd.read_csv("over-age-students-primary-percent-of-enrollment.csv"))

    (df.year == 2017).sum()

    File: over-age-students-primary-percent-of-enrollment.csv

    What is the median across countries in 2017?

    4.79 (median of the 148 country values; not a World Bank aggregate).

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

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

    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 = 2017 ORDER BY value
      LIMIT 2 - (SELECT COUNT(*) FROM wb WHERE year = 2017) % 2
      OFFSET (SELECT (COUNT(*) - 1) / 2 FROM wb WHERE year = 2017));

    pandas (df = pd.read_csv("over-age-students-primary-percent-of-enrollment.csv"))

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

    File: over-age-students-primary-percent-of-enrollment.csv

    Which country rose the most between 2007 and 2017?

    Pakistan: from 1e-05 to 26.39, a rise of 26.39 (out of 119 countries with both years).

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

    Use the wide file (over-age-students-primary-percent-of-enrollment-wide.csv): add a column = [2017] - [2007], 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 = 2007 AND b.year = 2017 ORDER BY rise DESC LIMIT 1;

    pandas (df = pd.read_csv("over-age-students-primary-percent-of-enrollment.csv"))

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

    File: over-age-students-primary-percent-of-enrollment.csv

    Which year has the most countries reporting?

    2016, with 149 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("over-age-students-primary-percent-of-enrollment.csv"))

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

    File: over-age-students-primary-percent-of-enrollment.csv