Government Effectiveness - Upper bound of the 90% confidence interval for the governance score
Real data: World Bank, Worldwide Governance Indicators, indicator GOV_WGI_GE.SC_UB, retrieved 19 November 2026. Values are as published; we only reshaped the file.
What it measures
Government Effectiveness (GE) captures perceptions of the quality of public services, the civil service, policy formulation and implementation, and the credibility of a government’s decisions. Upper bound of the 90% confidence interval for the governance score. Confidence intervals are a statistical range of values that likely contain the true value (of what is being estimated).
The numbers in 2025
In 2025, 205 countries have a value. At the top, 5 countries tie at 100 (e.g. Japan, Luxembourg, Monaco); the lowest is South Sudan (13.82). The median country value is 61.65.
Top 10 countries, 2025
value
Highest, 2025
Ties are listed A to Z.
| # | Country | Value |
|---|---|---|
| 1 | Japan | 100 |
| 2 | Luxembourg | 100 |
| 3 | Monaco | 100 |
| 4 | Singapore | 100 |
| 5 | Switzerland | 100 |
| 6 | Denmark | 99.81 |
| 7 | Finland | 99.45 |
| 8 | New Zealand | 98.62 |
| 9 | Norway | 97.8 |
| 10 | Sweden | 96.91 |
Lowest, 2025
| # | Country | Value |
|---|---|---|
| 1 | South Sudan | 13.82 |
| 2 | Haiti | 18.29 |
| 3 | Sudan | 18.78 |
| 4 | Somalia, Fed. Rep. | 19.8 |
| 5 | Afghanistan | 20.21 |
| 6 | Yemen, Rep. | 21.51 |
| 7 | Congo, Dem. Rep. | 24.27 |
| 8 | Central African Republic | 26.19 |
| 9 | Myanmar | 27.22 |
| 10 | Syrian Arab Republic | 27.41 |
How many countries report, by decade
| Decade | Most countries in one year |
|---|---|
| 1990s | 181 |
| 2000s | 202 |
| 2010s | 205 |
| 2020s | 205 |
First rows
government-effectiveness-upper-bound-of-the-90-percent-confidence-interval-for-the-governa.csv
| countrytext | iso3text | regiontext | income_grouptext | yearnumber | valuenumber |
|---|---|---|---|---|---|
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 1996 | 18.869993 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 1998 | 18.5973057 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2000 | 18.5800221 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2002 | 20.9644063 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2003 | 20.9127766 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2004 | 37.5332769 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2005 | 33.2795797 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2006 | 26.6352084 |
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 | Government Effectiveness - Upper bound of the 90% confidence interval for the governance score, 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?
There is a tie: 5 countries share the highest value, 100 (for example Japan, Luxembourg, Monaco).
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("government-effectiveness-upper-bound-of-the-90-percent-confidence-interval-for-the-governa.csv"))
y = df[df.year == 2025]
y[y.value == y.value.max()][["country", "value"]]File: government-effectiveness-upper-bound-of-the-90-percent-confidence-interval-for-the-governa.csv
How many countries report a value for 2025?
205 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("government-effectiveness-upper-bound-of-the-90-percent-confidence-interval-for-the-governa.csv"))
(df.year == 2025).sum()File: government-effectiveness-upper-bound-of-the-90-percent-confidence-interval-for-the-governa.csv
What is the median across countries in 2025?
61.65 (median of the 205 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("government-effectiveness-upper-bound-of-the-90-percent-confidence-interval-for-the-governa.csv"))
df[df.year == 2025]["value"].median()File: government-effectiveness-upper-bound-of-the-90-percent-confidence-interval-for-the-governa.csv
Which country rose the most between 2015 and 2025?
Greenland: from 74.91 to 92.46, a rise of 17.55 (out of 205 countries with both years).
Excel (on the long CSV: E = year, F = value)
Use the wide file (government-effectiveness-upper-bound-of-the-90-percent-confidence-interval-for-the-governa-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("government-effectiveness-upper-bound-of-the-90-percent-confidence-interval-for-the-governa.csv"))
w = df.pivot(index="country", columns="year", values="value")
(w[2025] - w[2015]).dropna().nlargest(1)File: government-effectiveness-upper-bound-of-the-90-percent-confidence-interval-for-the-governa.csv
Which year has the most countries reporting?
2025, with 205 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("government-effectiveness-upper-bound-of-the-90-percent-confidence-interval-for-the-governa.csv"))
df.groupby("year").size().sort_values(ascending=False).head(1)File: government-effectiveness-upper-bound-of-the-90-percent-confidence-interval-for-the-governa.csv