Availability of Mortality rate, under-5 (per 1,000 live births) data meeting quality standards according to UN IGME (5 year moving average)
Real data: World Bank, Statistical Performance Indicators, indicator SPI.D1.5.CHLD.MORT, retrieved 19 November 2026. Values are as published; we only reshaped the file.
What it measures
Child Mortality Metadata from UN IGME
The numbers in 2023
In 2023, 217 countries have a value. At the top, 180 countries tie at 1 (e.g. Afghanistan, Albania, Algeria); at the bottom, 37 countries tie at 0 (e.g. American Samoa, Aruba, Bermuda). The median country value is 1.
Highest, 2023
Ties are listed A to Z.
| # | Country | Value |
|---|---|---|
| 1 | Afghanistan | 1 |
| 2 | Albania | 1 |
| 3 | Algeria | 1 |
| 4 | Andorra | 1 |
| 5 | Angola | 1 |
| 6 | Antigua and Barbuda | 1 |
| 7 | Argentina | 1 |
| 8 | Armenia | 1 |
| 9 | Australia | 1 |
| 10 | Austria | 1 |
Lowest, 2023
Ties are listed A to Z.
| # | Country | Value |
|---|---|---|
| 1 | Virgin Islands (U.S.) | 0 |
| 2 | Turks and Caicos Islands | 0 |
| 3 | Trinidad and Tobago | 0 |
| 4 | St. Martin (French part) | 0 |
| 5 | Solomon Islands | 0 |
| 6 | Sint Maarten (Dutch part) | 0 |
| 7 | Puerto Rico (US) | 0 |
| 8 | Panama | 0 |
| 9 | Northern Mariana Islands | 0 |
| 10 | New Caledonia | 0 |
How many countries report, by decade
| Decade | Most countries in one year |
|---|---|
| 2000s | 217 |
| 2010s | 217 |
| 2020s | 217 |
First rows
availability-of-mortality-rate-under-5-per-1-000-live-births-data-meeting-quality-standard.csv
| countrytext | iso3text | regiontext | income_grouptext | yearnumber | valuenumber |
|---|---|---|---|---|---|
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2004 | 1 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2005 | 1 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2006 | 1 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2007 | 1 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2008 | 1 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2009 | 1 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2010 | 1 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2011 | 1 |
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 | Availability of Mortality rate, under-5 (per 1,000 live births) data meeting quality standards according to UN IGME (5 year moving average), 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 2023?
There is a tie: 180 countries share the highest value, 1 (for example Afghanistan, Albania, Algeria).
Excel (on the long CSV: E = year, F = value)
=FILTER(A2:A100000,(E2:E100000=2023)*(F2:F100000=MAXIFS(F2:F100000,E2:E100000,2023)))SQL (table wb = the CSV)
SELECT country, value FROM wb WHERE year = 2023
AND value = (SELECT MAX(value) FROM wb WHERE year = 2023);pandas (df = pd.read_csv("availability-of-mortality-rate-under-5-per-1-000-live-births-data-meeting-quality-standard.csv"))
y = df[df.year == 2023]
y[y.value == y.value.max()][["country", "value"]]File: availability-of-mortality-rate-under-5-per-1-000-live-births-data-meeting-quality-standard.csv
How many countries report a value for 2023?
217 of the 217 economies in the file's country list.
Excel (on the long CSV: E = year, F = value)
=COUNTIF(E2:E100000,2023)SQL (table wb = the CSV)
SELECT COUNT(*) FROM wb WHERE year = 2023;pandas (df = pd.read_csv("availability-of-mortality-rate-under-5-per-1-000-live-births-data-meeting-quality-standard.csv"))
(df.year == 2023).sum()File: availability-of-mortality-rate-under-5-per-1-000-live-births-data-meeting-quality-standard.csv
What is the median across countries in 2023?
1 (median of the 217 country values; not a World Bank aggregate).
Excel (on the long CSV: E = year, F = value)
=MEDIAN(FILTER(F2:F100000,E2:E100000=2023))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 = 2023 ORDER BY value
LIMIT 2 - (SELECT COUNT(*) FROM wb WHERE year = 2023) % 2
OFFSET (SELECT (COUNT(*) - 1) / 2 FROM wb WHERE year = 2023));pandas (df = pd.read_csv("availability-of-mortality-rate-under-5-per-1-000-live-births-data-meeting-quality-standard.csv"))
df[df.year == 2023]["value"].median()File: availability-of-mortality-rate-under-5-per-1-000-live-births-data-meeting-quality-standard.csv
Which country rose the most between 2013 and 2023?
Antigua and Barbuda: from 0 to 1, a rise of 1 (out of 217 countries with both years).
Excel (on the long CSV: E = year, F = value)
Use the wide file (availability-of-mortality-rate-under-5-per-1-000-live-births-data-meeting-quality-standard-wide.csv): add a column = [2023] - [2013], 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 = 2013 AND b.year = 2023 ORDER BY rise DESC LIMIT 1;pandas (df = pd.read_csv("availability-of-mortality-rate-under-5-per-1-000-live-births-data-meeting-quality-standard.csv"))
w = df.pivot(index="country", columns="year", values="value")
(w[2023] - w[2013]).dropna().nlargest(1)File: availability-of-mortality-rate-under-5-per-1-000-live-births-data-meeting-quality-standard.csv
Which year has the most countries reporting?
2023, with 217 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("availability-of-mortality-rate-under-5-per-1-000-live-births-data-meeting-quality-standard.csv"))
df.groupby("year").size().sort_values(ascending=False).head(1)File: availability-of-mortality-rate-under-5-per-1-000-live-births-data-meeting-quality-standard.csv