Access to electricity, urban (% of urban population)
Real data: World Bank, World Development Indicators, indicator EG.ELC.ACCS.UR.ZS, retrieved 19 November 2026. Values are as published; we only reshaped the file.
What it measures
Access to electricity, urban is the percentage of urban population with access to electricity.
The numbers in 2024
In 2024, 213 countries have a value. At the top, 135 countries tie at 100 (e.g. Albania, Algeria, Andorra); the lowest is South Sudan (22.8). The median country value is 100. The World Bank's World aggregate for 2024 is 97.76.
Highest, 2024
Ties are listed A to Z.
| # | Country | Value |
|---|---|---|
| 1 | Albania | 100 |
| 2 | Algeria | 100 |
| 3 | Andorra | 100 |
| 4 | Antigua and Barbuda | 100 |
| 5 | Argentina | 100 |
| 6 | Armenia | 100 |
| 7 | Aruba | 100 |
| 8 | Australia | 100 |
| 9 | Austria | 100 |
| 10 | Azerbaijan | 100 |
Lowest, 2024
| # | Country | Value |
|---|---|---|
| 1 | South Sudan | 22.8 |
| 2 | Central African Republic | 38.8 |
| 3 | Chad | 51 |
| 4 | Congo, Dem. Rep. | 55 |
| 5 | Liberia | 55.5 |
| 6 | Sierra Leone | 56.4 |
| 7 | Malawi | 59.5 |
| 8 | Guinea-Bissau | 65.6 |
| 9 | Papua New Guinea | 66.8 |
| 10 | Niger | 69.1 |
How many countries report, by decade
| Decade | Most countries in one year |
|---|---|
| 1990s | 170 |
| 2000s | 212 |
| 2010s | 212 |
| 2020s | 213 |
World aggregate by year
As published by the World Bank (in the regions file, not the country file).
| Year | World |
|---|---|
| 2024 | 97.76 |
| 2023 | 97.78 |
| 2022 | 97.65 |
| 2021 | 97.64 |
| 2020 | 97.26 |
| 2019 | 97.29 |
| 2018 | 97.04 |
| 2017 | 97.15 |
| 2016 | 96.91 |
| 2015 | 96.44 |
| 2014 | 96.57 |
| 2013 | 96.5 |
By region, 2024
| World Bank region | Value |
|---|---|
| North America | 100 |
| Europe & Central Asia | 100 |
| South Asia | 99.94 |
| East Asia & Pacific | 99.9 |
| Latin America & Caribbean | 99.66 |
| Middle East, North Africa, Afghanistan & Pakistan | 99.37 |
| Sub-Saharan Africa | 82.87 |
First rows
access-to-electricity-urban-percent-of-urban-population.csv
| countrytext | iso3text | regiontext | income_grouptext | yearnumber | valuenumber |
|---|---|---|---|---|---|
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2000 | 73.4 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2001 | 74.8 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2002 | 76.1 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2003 | 77.5 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2004 | 78.8 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2005 | 74 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2006 | 81.6 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2007 | 83 |
Data dictionary
| Column | Type | Meaning |
|---|---|---|
| country | text | Country or economy, World Bank name |
| iso3 | text | ISO 3166-1 alpha-3 code |
| region | text | World Bank region |
| income_group | text | World Bank income group |
| year | number | Calendar year of the value |
| value | number | Access to electricity, urban (% of urban population), 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?
There is a tie: 135 countries share the highest value, 100 (for example Albania, Algeria, Andorra).
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("access-to-electricity-urban-percent-of-urban-population.csv"))
y = df[df.year == 2024]
y[y.value == y.value.max()][["country", "value"]]File: access-to-electricity-urban-percent-of-urban-population.csv
How many countries report a value for 2024?
213 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("access-to-electricity-urban-percent-of-urban-population.csv"))
(df.year == 2024).sum()File: access-to-electricity-urban-percent-of-urban-population.csv
What is the median across countries in 2024?
100 (median of the 213 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("access-to-electricity-urban-percent-of-urban-population.csv"))
df[df.year == 2024]["value"].median()File: access-to-electricity-urban-percent-of-urban-population.csv
Which country rose the most between 2014 and 2024?
Liberia: from 14.8 to 55.5, a rise of 40.7 (out of 212 countries with both years).
Excel (on the long CSV: E = year, F = value)
Use the wide file (access-to-electricity-urban-percent-of-urban-population-wide.csv): add a column = [2024] - [2014], 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 = 2014 AND b.year = 2024 ORDER BY rise DESC LIMIT 1;pandas (df = pd.read_csv("access-to-electricity-urban-percent-of-urban-population.csv"))
w = df.pivot(index="country", columns="year", values="value")
(w[2024] - w[2014]).dropna().nlargest(1)File: access-to-electricity-urban-percent-of-urban-population.csv
Which year has the most countries reporting?
2024, with 213 countries.
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("access-to-electricity-urban-percent-of-urban-population.csv"))
df.groupby("year").size().sort_values(ascending=False).head(1)File: access-to-electricity-urban-percent-of-urban-population.csv