chris-asianzu/community-fever-surveillance

A digital health surveillance system for tracking malaria and fever clusters in Uganda. This platform automates data collection from field volunteers via mobile apps, replaces slow paper records with a real-time SQL database, and provides actionable insights through a Streamlit dashboard with spatial mapping and trend analysis. # Community Fever & Malaria Surveillance Initiative ### End-to-end digital disease surveillance system for rural Uganda --- ## What This Project Does Rural clinics and schools in Uganda rely on paper-based health reporting. This causes delays in detecting fever and malaria clusters — meaning outbreaks grow before anyone notices. This project builds a complete digital surveillance system: - Field workers report cases via **KoboCollect mobile app** - Data flows automatically through a **Python ETL pipeline** - Records are stored in a **SQLite relational database** - A live **Streamlit dashboard** shows trends, maps, and actionable insights in real time **Result:** Health coordinators can see where fever and malaria are spreading — by district, by week, by rainfall — and act before cases surge. --- ## Live Dashboard 👉 **Launch Dashboard →** --- ## Project Scope | Item | Detail | |---|---| | Geography | 4 districts — Arua, Gulu, Lira, Kampala | | Data Volume | 1,000 records across districts | | Collection Method | KoboCollect mobile app + KoboToolbox API | | Database | SQLite (upgradeable to PostgreSQL) | | Dashboard | Streamlit + folium maps | --- ## System Architecture ``` KoboCollect App ↓ KoboToolbox Server (API) ↓ Python ETL Pipeline (extract → clean → validate → load) ↓ SQLite Database (surveillance.db) ↓ Analytics + Visualizations ↓ Streamlit Dashboard (live) ``` --- ## Key Findings - 🌧️ Fever cases spike **4–6 weeks after high rainfall** periods - 🦟 Districts with low mosquito net usage show **significantly higher malaria positivity** - 📍 Certain districts are consistent **hotspots** — identifiable on the heatmap - 📊 Dashboard enables coordinators to filter by district and week in real time --- ## Dashboard Features - **Top metrics** — total reports, fever cases, malaria positives - **Weekly fever trend** — line chart per district - **Malaria positivity rate** — bar chart by district - **Mosquito net effect table** — positivity rate vs n …