Mini-project
Healthcare & Hospitals
Public health indicators across Indian states
Compare anaemia, vaccination and nutrition across states and districts with SQL.
The brief
A public health researcher wants to see which districts are falling behind on anaemia, child vaccination and nutrition. Load National Family Health Survey district data into a database and compare states and districts, and how they changed between survey rounds. Good looks like: a clean database, reconciled SQL queries, and maps or charts of the worst and most improved districts.
What you will build
- Download NFHS state and district fact sheets
- Clean indicator names and load them into a database
- Compare indicators across states and survey rounds in SQL
- Rank the districts most in need
- Present the findings with charts or a map
Free, open data to build it with
- National Family Health Survey (NFHS) ↗ International Institute for Population Sciences
- Open Government Data Platform India ↗ Government of India
Check each dataset's licence before you publish your work. Your mentor gives your team its own version of the brief (data, scope or region), so every team's project is its own.