LGU Health Spending Lens in two minutes
Philippine LGUs spend about PHP 850 per person on health, less than half of the PHP 1,828 that basic primary care costs, according to PIDS. The numbers that show it sit on separate platforms. I am joining them into one page per LGU that a local health board can bring to a budget hearing.
See it
- All 9 Central Luzon briefs
- Two briefs side by side
- Open data (JSON, Data Package)
- Read-only API, documented in OpenAPI
Done, and what comes next
Done
- All 117 LGUs in PIDS's 2024 health spending table matched to their PSGC codes, with no manual fixes.
- 9 one-page briefs for Central Luzon, readable on a phone and printable on one A4 page.
- FY 2024 NTA from DBM COMPASS's public export, joined to PIDS's 2024 health spending.
- Every figure on the briefs checked against its source: PIDS DP 2026-07 and DBM's NTA workbook.
- Open data (CSV, JSON, Data Package) and a read-only API, each figure with its source and date.
Next
- PIDS's source files, since the explorer has no download.
- A pipeline that rebuilds every figure from the sources, with tests.
- All 82 provinces and 33 highly urbanized cities.
- Testing the brief with a local health board or health office, a mayor's office, and a CSO or journalist.
Three months
- Month 1. Agree the comparison method and the pilot region with PIDS, DOH and mentors; secure PIDS's source files; test the briefs with the people they are for.
- Month 2. Run the pilot region on the pipeline and API. This is the floor: it ships even if data arrives late.
- Month 3. Cover all provinces and HUCs, return unmatched records to PIDS and DBM as data-quality flags, write a short guide, and present at Demo Day.
Who is building it
I am Angelo Julius Nuque, an Associate Solutions Developer at Indra Philippines. I helped build the frontend of Naga City's People's Budget Portal (opens in a new tab), an open-source participatory budgeting platform led by WeSolve Foundation, and I built and run EAF Schedulr on my own. The full method, sources and evidence are in the write-up.
~/angelo · nuque.dev