DataBrighten

    Primary government expenditures as a proportion of original approved budget (%)

    2,368 × 6rows × columns: 170 countries, 2004 to 2024

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

    textnumberdateyes/no
    Rows2,368country-year values
    Countries170with at least one value
    Years2004 – 202421 years with data
    LicenceCC BY 4.0credit the World Bank

    What it measures

    Primary government expenditures as a proportion of original approved budget measures the extent to which aggregate budget expenditure outturn reflects the amount originally approved, as defined in government budget documentation and fiscal reports. The coverage is budgetary central government (BCG) and the time period covered is the last three completed fiscal years.

    Limits and exceptions (World Bank note)

    Although not all countries have used the PEFA methodology on an annual basis for the PEFA PI-1 indicator, the methodology relies on standard data sets for approved and final budget outturns which are commonly produced at least annually in every country. The countries that have not used the methodology to date are primarily highly developed countries which would have less difficulty in providing the necessary data than those in the lower and middle income categories that have been primary users of Public Expenditure and Financial Accountability (PEFA) to date. (As of: 2024-07-29) One limitation of the indicator is that it is an aggregate indicator of budget reliability. While it can be disaggregated across regions, it is not disaggregated across various budget subcomponents. Different indicators are used for assessing changes in expenditure composition in the PEFA framework. Also, while this indicator is intended to measure budget reliability it should be understood that actual expenditure outturns can deviate from the originally approved budget for reasons unrelated to the accuracy of forecasts—for example, as a result of a major macroeconomic shock. However, the calibration of t

    The numbers in 2022

    In 2022, 99 countries have a value. The highest is Ukraine (186.7); the lowest is Lesotho (72.35). The median country value is 102.4.

    Top 10 countries, 2022

    %

    Source: World Bank, GF.XPD.BUDG.ZS, retrieved 19 November 2026. Computed from primary-government-expenditures-as-a-proportion-of-original-approved-budget-percent.csv.

    Highest, 2022

    #CountryValue
    1Ukraine186.7
    2South Sudan168
    3Slovak Republic133.5
    4Burundi123.2
    5Japan123
    6Hungary122
    7Viet Nam120.9
    8Botswana118.6
    9Saudi Arabia118.5
    10Czechia117.4

    Lowest, 2022

    #CountryValue
    1Lesotho72.35
    2Angola74.86
    3Sudan76.37
    4Somalia, Fed. Rep.78.66
    5Haiti78.94
    6Comoros79.45
    7Nepal81.11
    8Zambia81.59
    9Bolivia82.65
    10Kenya84.57
    How many countries report, by decade
    DecadeMost countries in one year
    2000s134
    2010s155
    2020s136

    First rows

    primary-government-expenditures-as-a-proportion-of-original-approved-budget-percent.csv

    countrytextiso3textregiontextincome_grouptextyearnumbervaluenumber
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income200779.6951
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income200880.2058
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income201269.8331
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income201378.3247
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income201469.9229
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income201572.6947
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income201679.5346
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income2017100.3309

    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
    valuenumberPrimary government expenditures as a proportion of original approved budget (%), 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 2022?

    Ukraine, with 186.7.

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

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

    SQL (table wb = the CSV)

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

    pandas (df = pd.read_csv("primary-government-expenditures-as-a-proportion-of-original-approved-budget-percent.csv"))

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

    File: primary-government-expenditures-as-a-proportion-of-original-approved-budget-percent.csv

    How many countries report a value for 2022?

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

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

    =COUNTIF(E2:E100000,2022)

    SQL (table wb = the CSV)

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

    pandas (df = pd.read_csv("primary-government-expenditures-as-a-proportion-of-original-approved-budget-percent.csv"))

    (df.year == 2022).sum()

    File: primary-government-expenditures-as-a-proportion-of-original-approved-budget-percent.csv

    What is the median across countries in 2022?

    102.4 (median of the 99 country values; not a World Bank aggregate).

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

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

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

    pandas (df = pd.read_csv("primary-government-expenditures-as-a-proportion-of-original-approved-budget-percent.csv"))

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

    File: primary-government-expenditures-as-a-proportion-of-original-approved-budget-percent.csv

    Which country rose the most between 2012 and 2022?

    Lithuania: from 7.93 to 115.6, a rise of 107.7 (out of 84 countries with both years).

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

    Use the wide file (primary-government-expenditures-as-a-proportion-of-original-approved-budget-percent-wide.csv): add a column = [2022] - [2012], 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 = 2012 AND b.year = 2022 ORDER BY rise DESC LIMIT 1;

    pandas (df = pd.read_csv("primary-government-expenditures-as-a-proportion-of-original-approved-budget-percent.csv"))

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

    File: primary-government-expenditures-as-a-proportion-of-original-approved-budget-percent.csv

    Which year has the most countries reporting?

    2016, with 155 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("primary-government-expenditures-as-a-proportion-of-original-approved-budget-percent.csv"))

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

    File: primary-government-expenditures-as-a-proportion-of-original-approved-budget-percent.csv