DataBrighten

    Public private partnerships investment in energy (current US$)

    985 × 6rows × columns: 113 countries, 1984 to 2024

    Real data: World Bank, World Development Indicators, indicator IE.PPN.ENGY.CD, retrieved 19 November 2026. Values are as published; we only reshaped the file.

    textnumberdateyes/no
    Rows985country-year values
    Countries113with at least one value
    Years1984 – 202441 years with data
    LicenceCC BY 4.0credit the World Bank

    What it measures

    The Private Participation In Infrastructure (PPI) Database records contractual arrangements for public infrastructure projects in low- and middle-income countries (as classified by the World Bank) that have reached financial closure, in which private parties assume operating risk. Public private partnerships in energy refers to commitments to infrastructure projects in energy (electricity and natural gas: generation, transmission, and distribution) that have reached financial closure and directly or indirectly serve the public. The types of projects included are management and lease…

    Read the full definition

    The Private Participation In Infrastructure (PPI) Database records contractual arrangements for public infrastructure projects in low- and middle-income countries (as classified by the World Bank) that have reached financial closure, in which private parties assume operating risk. Public private partnerships in energy refers to commitments to infrastructure projects in energy (electricity and natural gas: generation, transmission, and distribution) that have reached financial closure and directly or indirectly serve the public. The types of projects included are management and lease contracts, brownfield projects, and greenfield projects (in which a private entity or a public-private joint venture builds and operates a new facility). Divestitures and merchant projects are excluded. Investments are classified as one of two types: (1) Investments in physical assets: resources the project company commits to invest in expanding and modernizing facilities and (2) Payments to the government: to acquire state-owned enterprises or rights to provide services in a specific area or to use radio spectrum. Data is presented based on investment year. Data are in current U.S. dollars.

    Limits and exceptions (World Bank note)

    The data on investment in infrastructure projects with private participation refer to all investment commitments (public and private) in projects in which a private company assumes operating risk during the operating period or development and operating risk during the contract period. Investment refers to commitments not disbursements. Foreign state-owned companies are considered private entities for the purposes of this measure. Movable assets and small projects are excluded. The types of projects included are operations and management contracts, operations and management contracts with major capital expenditure, greenfield projects (in which a private entity or a public-private joint venture builds and operates a new facility), and divestitures. Investment commitments are the sum of investments in facilities and investments in government assets. Investments in facilities are the resources the project company commits to invest during the contract period either in new facilities or in expansion and modernization of existing facilities. Investments in government assets are the resources the project company spends on acquiring government assets such as state-owned enterprises, right

    The numbers in 2024

    In 2024, 46 countries have a value. The highest is China (36.35 billion); the lowest is Lesotho (2.30 million). The median country value is 226.51 million. The World Bank's World aggregate for 2017 is 51.03 billion.

    Top 10 countries, 2024

    current US$

    Source: World Bank, IE.PPN.ENGY.CD, retrieved 19 November 2026. Computed from public-private-partnerships-investment-in-energy-current-usd.csv.

    Highest, 2024

    #CountryValue
    1China36.35 billion
    2Brazil5.55 billion
    3Philippines4.14 billion
    4India3.42 billion
    5Thailand1.86 billion
    6South Africa1.79 billion
    7Turkiye1.70 billion
    8Viet Nam1.64 billion
    9Angola1.60 billion
    10Peru1.24 billion

    Lowest, 2024

    #CountryValue
    1Lesotho2.30 million
    2Rwanda7.30 million
    3Nicaragua12.50 million
    4Burundi12.70 million
    5Tanzania15.00 million
    6South Sudan20.00 million
    7Nigeria20.00 million
    8Namibia20.00 million
    9Bangladesh24.30 million
    10Burkina Faso27.70 million
    How many countries report, by decade
    DecadeMost countries in one year
    1980s2
    1990s24
    2000s31
    2010s45
    2020s53

    World aggregate by year

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

    YearWorld
    201751.03 billion

    By region, 2024

    World Bank regionValue
    East Asia & Pacific44.55 billion
    Latin America & Caribbean 8.20 billion
    South Asia3.45 billion

    First rows

    public-private-partnerships-investment-in-energy-current-usd.csv

    countrytextiso3textregiontextincome_grouptextyearnumbervaluenumber
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20031580000
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income201719000000
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income2019190490000
    AlbaniaALBEurope & Central AsiaUpper middle income20028000000
    AlbaniaALBEurope & Central AsiaUpper middle income2009244000000
    AlbaniaALBEurope & Central AsiaUpper middle income201028000000
    AlbaniaALBEurope & Central AsiaUpper middle income20114160000
    AlbaniaALBEurope & Central AsiaUpper middle income20121428600000

    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
    valuenumberPublic private partnerships investment in energy (current US$), 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?

    China, with 36.35 billion.

    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("public-private-partnerships-investment-in-energy-current-usd.csv"))

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

    File: public-private-partnerships-investment-in-energy-current-usd.csv

    How many countries report a value for 2024?

    46 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("public-private-partnerships-investment-in-energy-current-usd.csv"))

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

    File: public-private-partnerships-investment-in-energy-current-usd.csv

    What is the median across countries in 2024?

    226.51 million (median of the 46 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("public-private-partnerships-investment-in-energy-current-usd.csv"))

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

    File: public-private-partnerships-investment-in-energy-current-usd.csv

    Which year has the most countries reporting?

    2023, with 53 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("public-private-partnerships-investment-in-energy-current-usd.csv"))

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

    File: public-private-partnerships-investment-in-energy-current-usd.csv