← Home
Alive & Thrive · FHI Solutions

Uncovering who is furthest behind

Two decades of maternal and child nutrition data across Cambodia, Lao PDR, and Viet Nam — harmonised into one pipeline that shows whether progress is reaching the people national averages hide.

35pp
widest equity gap surfaced — between ethnic groups in Lao PDR
15+
MICS & DHS survey rounds harmonised
3
countries, across 20+ years of data
5
equity stratifiers, every indicator
Client
Alive & Thrive (FHI Solutions)
Role
Design & build
Stack
Python, configuration-driven
Data
15+ rounds · Cambodia, Lao PDR, Viet Nam
Timeline
Apr – Dec 2022
At a glance
The problem
National averages can hide who is being left behind. A&T needed to know whether 20 years of MCHN progress reached ethnic minorities, rural communities, and the poorest households — but the evidence sat in dozens of incompatible survey files.
What I built
A configuration-driven Python pipeline that harmonises 15+ MICS/DHS rounds, computes standard MCHN indicators, and disaggregates every one by five equity stratifiers across more than 20 years.
The outcome
Per-country equity profiles that surfaced gaps the averages hid — including a 35-percentage-point gap between ethnic groups in Lao PDR — delivered as a reusable asset that extends to new countries and rounds.
01 Challenge

National averages mask who progress reaches

Alive & Thrive needed to understand how maternal and child health and nutrition outcomes had changed over two decades across Cambodia, Lao PDR, and Viet Nam — and, critically, whether that progress was reaching the most vulnerable populations.

Improvements in antenatal care, breastfeeding, or dietary diversity at the country level may not reflect the reality for ethnic minorities, rural communities, or the poorest households. But the data sat in dozens of separate survey files, collected with different instruments and variable definitions over more than 20 years.

The real requirement

A reusable evidence base — not a one-off report — that A&T could extend to new countries and survey rounds without rebuilding the analysis from scratch.

02 Approach

One config per survey, five equity lenses on every indicator

A3DI built a reproducible, configuration-driven analysis pipeline in Python to harmonise 15+ rounds of MICS and DHS surveys across the three countries, then disaggregate every indicator across five stratifiers and across time.

Input
Raw SPSS
15+ MICS/DHS rounds
Configure
JSON per country-year
variable mapping
Harmonise
Merge & compute
weighted MCHN indicators
Disaggregate
5 stratifiers
+ weighted logistic trends
config/vnm_2021_children.json
{
  "country": "VNM",
  "survey_year": 2021,
  "survey_type": "MICS",
  "indicators": {
    "excl_bf": "BD2",
    "cont_bf": "BD3",
    "mdd_ch": ["food_grp_1", "food_grp_2", "food_grp_3"],
    "mmf_ch": "BD7",
    "mad_ch": ["mdd_ch", "mmf_ch"]
  },
  "equity_stratifiers": {
    "wealth_q": "windex5",
    "region": "HH7",
    "residence": "HH6",
    "eth_hoh": "ethnicity",
    "mother_edu": "welevel"
  }
}
Why it earns trust

Each country-year maps raw survey variables to standardised indicator definitions through a JSON config, not hardcoded logic — so Viet Nam’s 2000 MICS and Cambodia’s 2021 DHS run through the same codebase. Every statistic is weighted for the complex survey designs, and disaggregated by wealth quintile, region, residence, ethnicity of household head, and mother’s education.

03 Result

Progress was real — but deeply uneven

The gap national averages hid

Lao PDR · between ethnic groups

Schematic of the pattern; 35pp is the real finding — the breastfeeding/dietary-diversity gap between ethnic groups. The national average sits between the two.

The analysis produced a comprehensive equity profile for each country. Wealth-driven disparities persisted across most indicators; access to services like antenatal care and institutional delivery had expanded substantially, but the quality of care within them improved far less.

Regional and ethnic disparities remained substantial — particularly in Lao PDR, where gaps in breastfeeding and dietary diversity between ethnic groups exceeded 35 percentage points. A&T used the findings to inform country strategies, advocacy with government and donors, and regional knowledge products. Because the pipeline is configuration-driven, it extends to new countries or survey rounds without rebuilding — a reusable asset, not a one-off deliverable.

The takeaway

When national averages show progress, disaggregated analysis is the only way to know whether it reaches the people who need it most.

Need to know who your averages are hiding?

I build reproducible, configuration-driven pipelines that turn scattered survey rounds into equity evidence your team can extend.