PROJECT FILE / 04
Child Mortality Patterns
An R-based analysis of under-five, infant and neonatal mortality across Sub-Saharan Africa, connecting UNICEF trends with World Bank fertility and economic indicators.
G/04UNICEF and World Bank datasets were cleaned, harmonised and joined in R, then turned into interactive trends, maps, rankings and comparisons.
OVERVIEW
Overview
This project explores historical and recent trends in under-five child mortality across Sub-Saharan African countries, using data from UNICEF's Data Warehouse and World Bank indicators.
It applies data wrangling and visualisation techniques in R to reveal disparities between countries, assess progress toward Sustainable Development Goal target 3.2 (ending preventable deaths of newborns and children under five), and point to where interventions matter most.
Mortality indicators are analysed alongside fertility and GDP per capita so that the patterns can be read in their demographic and economic context rather than as isolated numbers.
Objectives
- Import and clean UNICEF child mortality datasets using readr, tidyr and dplyr.
- Harmonise under-five (U5MR), infant (IMR) and neonatal mortality indicators.
- Segment the analysis by region, country and income group.
- Track trends from 2000 onward.
- Visualise disparities with ggplot2 and interactive charts.
- Generate insights for development strategy.
Data sources
| Source | Description |
|---|---|
| UNICEF Data Warehouse | Official child mortality data: U5MR, IMR and neonatal mortality |
| World Bank | GDP per capita, health access and fertility overlays |
| UN region codes | Country mapping to Sub-Saharan Africa |
Methods and tools
- Key variables
- Country, Year, U5MR, IMR, Neonatal_Mortality, Births, Deaths and Region.
- Data cleaning
- Imported with read_csv(), standardised with clean_names(), filtered to Sub-Saharan African countries and cleared of missing values.
- Wrangling
- Grouped by country and year, calculated rate reductions and merged GDP and fertility overlays.
- Visualisation
- Time series, rankings and heatmaps plotted with ggplot2, with interactive versions for maps, scatter plots and tables. Rates follow UNICEF/UN definitions and are expressed per 1,000 live births.
Key findings
- Under-five mortality in Sub-Saharan Africa declined from 145 per 1,000 live births in 2000 to 72 per 1,000 in 2022.
- Nigeria carries the highest burden, with only a modest decline.
- Ethiopia achieved a drop of more than 60%, linked to immunisation and improved access to care.
- Progress stagnated in conflict-affected countries such as South Sudan.
- High fertility and low GDP per capita correlate with poorer child survival.
Applications
- Public health planning in Sub-Saharan Africa.
- Monitoring progress toward SDG 3.2.
- Prioritising maternal and child health investment.
- Academic research and teaching.
Explore the original work
- Under-five mortality trend, 2000-2025 Progress toward SDG 3.2 targets
- Under-five mortality map Geographic distribution per 1,000 live births
- Mortality heatmap Under-five, infant and neonatal rates by country and year
- Under-five mortality vs GDP per capita (2023)
- Neonatal mortality vs fertility rate
- Top 10 fertility rates (2021)
- Top 10 GDP per capita (2021)
- Full data table 41,832 entries
- Download the CSV files (ZIP)
BUILD OUTPUT
What the project delivered.
Long-term neonatal, infant and under-five mortality trends
Country and regional comparisons across Sub-Saharan Africa
Interactive maps, heatmaps and a 41,832-row data table
GDP and fertility relationship exploration