Geospatial analysis of healthcare facility density and functionality across all 36 Nigerian states + FCT — built on 34,139 real NMIS facility records using GeoPandas, Folium, and Python.
# Nigeria National Healthcare Facility Access Analysis
A national-scale geospatial portfolio project analyzing healthcare infrastructure density and functionality across all 36 Nigerian states + FCT, built on real government survey data.
## Scale
- **34,139 geocoded health facilities**
- **772 of Nigeria's 774 Local Government Areas** represented
- **37 states (36 + FCT)** compared by facility density and service quality
## What this project demonstrates
- **Large real-world dataset handling** — cleaning, validating, and spatially joining 34k+ records
- **Geospatial analysis** — CRS-correct area calculations, spatial joins, density metrics
- **Data storytelling** — raw count vs. true density as a deliberate "don't be misled by the obvious chart" narrative
- **Policy-relevant insight** — facility density AND functionality (electricity, water, skilled staffing) combined into a coherent regional story
## Data source
NMIS Health Facility Database (2014) — collected by Nigeria's Office of the Senior Special Assistant to the President on the MDGs (OSSAP-MDGs), in partnership with Columbia University's Sustainable Engineering Lab. Published under **CC-BY 4.0** via energydata.info (World Bank ESMAP).
## Key findings
1. **Facility density varies 50x across states** — from 6.6 facilities per 1,000 km² in Borno to 345.8 in Lagos.
2. **The northeast (Borno, Yobe) is the most underserved region** by both density and functionality — likely compounded by the regional insurgency's impact on infrastructure over the past decade.
3. **Raw facility counts mislead.** States like Katsina and Niger look infrastructure-rich on a simple count map, but their actual density (accounting for land area) tells the opposite story.
4. **Facility presence ≠ facility function.** On Average only 40.2% of facilities nationally have grid electricity, and 40.5% have a skilled birth attendant on staff. The lowest-density states often double as the lowest-functionality states.
## Files in this pr …