DataBrighten

    Electricity production from renewable sources, excluding hydroelectric (kWh)

    5,944 × 6rows × columns: 209 countries, 1990 to 2021

    Real data: World Bank, World Development Indicators, indicator EG.ELC.RNWX.KH, retrieved 19 November 2026. Values are as published; we only reshaped the file.

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

    What it measures

    Electricity production from renewable sources in kilowatt-hour (kWh), excluding hydroelectric, includes geothermal, solar, tides, wind, biomass, and biofuels.

    Limits and exceptions (World Bank note)

    IEA occasionally revises its time series to reflect political changes. For example, the IEA has constructed historical energy statistics for countries of the former Soviet Union. In addition, energy statistics for other countries have undergone continuous changes in coverage or methodology in recent years as more detailed energy accounts have become available. Breaks in series are therefore unavoidable.

    The numbers in 2021

    In 2021, 208 countries have a value. The highest is China (1.11 trillion); the lowest is Venezuela, RB (-5.23 billion). The median country value is 262.53 million. The World Bank's World aggregate for 2021 is 3.56 trillion.

    Top 10 countries, 2021

    kWh

    Source: World Bank, EG.ELC.RNWX.KH, retrieved 19 November 2026. Computed from electricity-production-from-renewable-sources-excluding-hydroelectric-kwh.csv.

    Highest, 2021

    #CountryValue
    1China1.11 trillion
    2United States612.80 billion
    3Germany211.14 billion
    4India150.63 billion
    5Brazil144.85 billion
    6Japan132.65 billion
    7United Kingdom116.76 billion
    8Spain96.12 billion
    9Italy70.96 billion
    10France62.84 billion

    Lowest, 2021

    #CountryValue
    1Venezuela, RB-5.23 billion
    2Lao PDR-4.49 billion
    3Nepal-1.46 billion
    4Congo, Dem. Rep.-1.21 billion
    5Sudan-753.86 million
    6Malaysia-504.09 million
    7Equatorial Guinea-342.77 million
    8Cameroon-329.43 million
    9Gabon-326.71 million
    10Nigeria-170.39 million
    How many countries report, by decade
    DecadeMost countries in one year
    1990s136
    2000s209
    2010s209
    2020s208

    World aggregate by year

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

    YearWorld
    20213.56 trillion
    20203.10 trillion
    20192.72 trillion
    20182.41 trillion
    20172.14 trillion
    20161.85 trillion
    20151.62 trillion
    20141.42 trillion
    20131.23 trillion
    20121.08 trillion
    2011889.94 billion
    2010747.02 billion

    By region, 2021

    World Bank regionValue
    East Asia & Pacific1.46 trillion
    Europe & Central Asia952.27 billion
    North America664.08 billion
    Latin America & Caribbean 259.74 billion
    South Asia151.32 billion
    Middle East, North Africa, Afghanistan & Pakistan55.32 billion
    Sub-Saharan Africa 21.62 billion

    First rows

    electricity-production-from-renewable-sources-excluding-hydroelectric-kwh.csv

    countrytextiso3textregiontextincome_grouptextyearnumbervaluenumber
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20000
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20010
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20020
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20030
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20040
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20050
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20060
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20070

    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
    valuenumberElectricity production from renewable sources, excluding hydroelectric (kWh), 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 2021?

    China, with 1.11 trillion.

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

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

    SQL (table wb = the CSV)

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

    pandas (df = pd.read_csv("electricity-production-from-renewable-sources-excluding-hydroelectric-kwh.csv"))

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

    File: electricity-production-from-renewable-sources-excluding-hydroelectric-kwh.csv

    How many countries report a value for 2021?

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

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

    =COUNTIF(E2:E100000,2021)

    SQL (table wb = the CSV)

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

    pandas (df = pd.read_csv("electricity-production-from-renewable-sources-excluding-hydroelectric-kwh.csv"))

    (df.year == 2021).sum()

    File: electricity-production-from-renewable-sources-excluding-hydroelectric-kwh.csv

    What is the median across countries in 2021?

    262.53 million (median of the 208 country values; not a World Bank aggregate).

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

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

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

    pandas (df = pd.read_csv("electricity-production-from-renewable-sources-excluding-hydroelectric-kwh.csv"))

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

    File: electricity-production-from-renewable-sources-excluding-hydroelectric-kwh.csv

    Which country rose the most between 2011 and 2021?

    China: from 95.00 billion to 1.11 trillion, a rise of 1.01 trillion (out of 208 countries with both years).

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

    Use the wide file (electricity-production-from-renewable-sources-excluding-hydroelectric-kwh-wide.csv): add a column = [2021] - [2011], 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 = 2011 AND b.year = 2021 ORDER BY rise DESC LIMIT 1;

    pandas (df = pd.read_csv("electricity-production-from-renewable-sources-excluding-hydroelectric-kwh.csv"))

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

    File: electricity-production-from-renewable-sources-excluding-hydroelectric-kwh.csv

    Which year has the most countries reporting?

    2015, with 209 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("electricity-production-from-renewable-sources-excluding-hydroelectric-kwh.csv"))

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

    File: electricity-production-from-renewable-sources-excluding-hydroelectric-kwh.csv