declerke/Kenya-Health-Coverage

47-County Spatial Health Facility Access Intelligence Pipeline - MOH data, KEPH levels, composite access index, dbt, Streamlit # 🏥 Kenya Health Facility Coverage: 47-County Spatial Access Intelligence Pipeline **Kenya Health Facility Coverage** is a production-grade geospatial health analytics pipeline that ingests 9,992 Kenya Ministry of Health-registered health facilities from the energydata.info open dataset, downloads GADM 4.1 county boundary polygons for all 47 Kenyan counties, fetches 4 national health indicators from the World Bank Open Data API spanning decades of reporting, performs Shapely-based spatial analysis computing 10km catchment buffers around every Level 4+ facility, calculates per-county health access indices combining facility density, catchment coverage, and nearest-hospital proximity, identifies the 10 most underserved counties by a composite gap severity score, runs a 6-model dbt-DuckDB transformation layer across staging and mart boundaries, and surfaces all of this across a 4-page Streamlit dashboard with a Folium choropleth county map, Plotly ranking charts, and World Bank indicator time-series — the complete analytical stack Kenya's Ministry of Health, county health departments, and development finance institutions use to monitor healthcare access equity across the country's 47-county devolution structure. | Metric | Value | |--------|-------| | Health facilities | 9,992 (Kenya MOH via energydata.info) | | Counties | 47 (all Kenya counties) | | 10km buffer zones | 534 (Level 4+ facilities) | | World Bank indicators | 4 (hospital beds, physicians, under-5 mortality, maternal mortality) | | dbt models | 6 (3 staging · 3 marts) | | dbt tests | 24 (all passing) | | Pytest tests | 42 (all passing) | | Dashboard pages | 4 | | Cost to run | $0 — open government data + World Bank API + local stack | --- ## 🎯 Project Goal Kenya's devolution structure places healthcare delivery responsibility at the county level, yet counties vary dramatically in their facility density, geographic accessibility, and service quality. Kenya's national average of ~2 physicians per 10,000 …