chris-asianzu/community-fever-surveillance
Domain:
healthcareRecord type:
softwareproject
Creator:
chr
Host:
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 …