DataBrighten

    Households and NPISHs Final consumption expenditure per capita, PPP (current international $)

    5,332 × 6rows × columns: 186 countries, 1990 to 2025

    Real data: World Bank, World Development Indicators, indicator NE.CON.PCAP.PP.CD, retrieved 19 November 2026. Values are as published; we only reshaped the file.

    textnumberdateyes/no
    Rows5,332country-year values
    Countries186with at least one value
    Years1990 – 202536 years with data
    LicenceCC BY 4.0credit the World Bank

    What it measures

    This indicator provides values for final consumption expenditure per person expressed in current international dollars, converted by purchasing power parities (PPPs). PPPs account for the different price levels across countries and thus PPP-based comparisons of economic output are more appropriate for comparing the output of economies and the average material well-being of their inhabitants than exchange-rate based comparisons. Households and NPISHs final consumption expenditure includes expenditure on goods and services by the Household and NPISH sector for the direct satisfaction of human…

    Read the full definition

    This indicator provides values for final consumption expenditure per person expressed in current international dollars, converted by purchasing power parities (PPPs). PPPs account for the different price levels across countries and thus PPP-based comparisons of economic output are more appropriate for comparing the output of economies and the average material well-being of their inhabitants than exchange-rate based comparisons. Households and NPISHs final consumption expenditure includes expenditure on goods and services by the Household and NPISH sector for the direct satisfaction of human needs or wants, whether individual or collective. This series has been linked to produce a consistent time series to counteract breaks in series over time due to changes in base years, source data and methodologies. Thus, it may not be comparable with other national accounts series in the database for historical years. The core indicator has been divided by the general population to achieve a per capita estimate. This indicator is expressed in current prices, meaning no adjustment has been made to account for price changes over time. The PPP conversion factor is a currency conversion factor and a spatial price deflator. PPPs convert different currencies to a common currency and, in the process of conversion, equalize their purchasing power by eliminating the differences in price levels between countries, thereby allowing volume or output comparisons of GDP and its expenditure components.

    The numbers in 2025

    In 2025, 124 countries have a value. The highest is United States (61,250); the lowest is Burundi (474). The median country value is 14,656. The World Bank's World aggregate for 2025 is 13,693.

    Top 10 countries, 2025

    current international $

    Source: World Bank, NE.CON.PCAP.PP.CD, retrieved 19 November 2026. Computed from households-and-npishs-final-consumption-expenditure-per-capita-ppp-current-international.csv.

    Highest, 2025

    #CountryValue
    1United States61,250
    2Hong Kong SAR, China51,005
    3Luxembourg49,995
    4Switzerland44,348
    5Norway41,813
    6Germany39,617
    7Singapore39,231
    8Austria38,480
    9United Kingdom37,689
    10Iceland37,615

    Lowest, 2025

    #CountryValue
    1Burundi474
    2Mozambique1,117
    3Central African Republic1,182
    4Madagascar1,503
    5Chad1,524
    6Niger1,541
    7Malawi1,577
    8Burkina Faso2,075
    9Guinea-Bissau2,090
    10Uganda2,163
    How many countries report, by decade
    DecadeMost countries in one year
    1990s133
    2000s158
    2010s176
    2020s176

    World aggregate by year

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

    YearWorld
    202513,693
    202413,131
    202312,445
    202211,495
    202110,313
    20209,265
    20199,584
    20189,175
    20178,709
    20168,357
    20158,082
    20147,907

    By region, 2025

    World Bank regionValue
    North America58,338
    Europe & Central Asia27,737
    Latin America & Caribbean 15,062
    Middle East, North Africa, Afghanistan & Pakistan9,965
    South Asia6,763
    Sub-Saharan Africa 3,859

    First rows

    households-and-npishs-final-consumption-expenditure-per-capita-ppp-current-international.csv

    countrytextiso3textregiontextincome_grouptextyearnumbervaluenumber
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20202297.09644102618
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20211730.80008344903
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20221833.84675527432
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20232072.77666322485
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20242362.76974863272
    AlbaniaALBEurope & Central AsiaUpper middle income19911134.45273634706
    AlbaniaALBEurope & Central AsiaUpper middle income19921958.07991062959
    AlbaniaALBEurope & Central AsiaUpper middle income19932028.22747977525

    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
    valuenumberHouseholds and NPISHs Final consumption expenditure per capita, PPP (current international $), 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 2025?

    United States, with 61,250.

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

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

    SQL (table wb = the CSV)

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

    pandas (df = pd.read_csv("households-and-npishs-final-consumption-expenditure-per-capita-ppp-current-international.csv"))

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

    File: households-and-npishs-final-consumption-expenditure-per-capita-ppp-current-international.csv

    How many countries report a value for 2025?

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

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

    =COUNTIF(E2:E100000,2025)

    SQL (table wb = the CSV)

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

    pandas (df = pd.read_csv("households-and-npishs-final-consumption-expenditure-per-capita-ppp-current-international.csv"))

    (df.year == 2025).sum()

    File: households-and-npishs-final-consumption-expenditure-per-capita-ppp-current-international.csv

    What is the median across countries in 2025?

    14,656 (median of the 124 country values; not a World Bank aggregate).

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

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

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

    pandas (df = pd.read_csv("households-and-npishs-final-consumption-expenditure-per-capita-ppp-current-international.csv"))

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

    File: households-and-npishs-final-consumption-expenditure-per-capita-ppp-current-international.csv

    Which country rose the most between 2015 and 2025?

    United States: from 38,213 to 61,250, a rise of 23,037 (out of 123 countries with both years).

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

    Use the wide file (households-and-npishs-final-consumption-expenditure-per-capita-ppp-current-international-wide.csv): add a column = [2025] - [2015], 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 = 2015 AND b.year = 2025 ORDER BY rise DESC LIMIT 1;

    pandas (df = pd.read_csv("households-and-npishs-final-consumption-expenditure-per-capita-ppp-current-international.csv"))

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

    File: households-and-npishs-final-consumption-expenditure-per-capita-ppp-current-international.csv

    Which year has the most countries reporting?

    2021, with 176 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("households-and-npishs-final-consumption-expenditure-per-capita-ppp-current-international.csv"))

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

    File: households-and-npishs-final-consumption-expenditure-per-capita-ppp-current-international.csv