DataBrighten

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

    5,145 × 6rows × columns: 176 countries, 1990 to 2025

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

    textnumberdateyes/no
    Rows5,145country-year values
    Countries176with 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 constant 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 constant 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. The core indicator has been divided by the general population to achieve a per capita estimate. This indicator is expressed in constant prices, meaning the series has been adjusted to account for price changes over time. The reference year for this adjustment is 2021. 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, 130 countries have a value. The highest is Hong Kong SAR, China (41,249); the lowest is Burundi (578.5). The median country value is 11,455. The World Bank's World aggregate for 2024 is 11,301.

    Top 10 countries, 2025

    constant 2021 international $

    Source: World Bank, NE.CON.PCAP.PP.KD, retrieved 19 November 2026. Computed from households-and-npishs-final-consumption-expenditure-per-capita-ppp-constant-2021-internati.csv.

    Highest, 2025

    #CountryValue
    1Hong Kong SAR, China41,249
    2Luxembourg39,202
    3Switzerland35,998
    4Norway35,679
    5Singapore33,083
    6Puerto Rico (US)32,097
    7Germany32,093
    8Bulgaria31,938
    9Macao SAR, China31,773
    10Iceland31,749

    Lowest, 2025

    #CountryValue
    1Burundi578.5
    2Congo, Dem. Rep.681.1
    3Central African Republic900.9
    4Mozambique1,023
    5Madagascar1,257
    6Niger1,277
    7Sudan1,358
    8Malawi1,389
    9Chad1,442
    10Burkina Faso1,731
    How many countries report, by decade
    DecadeMost countries in one year
    1990s123
    2000s154
    2010s168
    2020s176

    World aggregate by year

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

    YearWorld
    202411,301
    202311,005
    202210,673
    202110,332
    20209,666
    201910,191
    201810,000
    20179,745
    20169,481
    20159,273
    20149,103
    20138,924

    By region, 2025

    World Bank regionValue
    Europe & Central Asia22,676
    Latin America & Caribbean 12,534
    Middle East, North Africa, Afghanistan & Pakistan8,519
    South Asia6,300
    Sub-Saharan Africa 3,198

    First rows

    households-and-npishs-final-consumption-expenditure-per-capita-ppp-constant-2021-internati.csv

    countrytextiso3textregiontextincome_grouptextyearnumbervaluenumber
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20202358.70110057546
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20211730.80008344903
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20221716.29720109652
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20231787.19403854043
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20241992.35697113363
    AlbaniaALBEurope & Central AsiaUpper middle income19953449.54258009477
    AlbaniaALBEurope & Central AsiaUpper middle income19964002.71120320669
    AlbaniaALBEurope & Central AsiaUpper middle income19973297.96326079945

    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 (constant 2021 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?

    Hong Kong SAR, China, with 41,249.

    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-constant-2021-internati.csv"))

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

    File: households-and-npishs-final-consumption-expenditure-per-capita-ppp-constant-2021-internati.csv

    How many countries report a value for 2025?

    130 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-constant-2021-internati.csv"))

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

    File: households-and-npishs-final-consumption-expenditure-per-capita-ppp-constant-2021-internati.csv

    What is the median across countries in 2025?

    11,455 (median of the 130 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-constant-2021-internati.csv"))

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

    File: households-and-npishs-final-consumption-expenditure-per-capita-ppp-constant-2021-internati.csv

    Which country rose the most between 2015 and 2025?

    Bulgaria: from 12,160 to 31,938, a rise of 19,778 (out of 129 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-constant-2021-internati-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-constant-2021-internati.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-constant-2021-internati.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-constant-2021-internati.csv"))

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

    File: households-and-npishs-final-consumption-expenditure-per-capita-ppp-constant-2021-internati.csv