Case study / Elections / Web app
A vote tally web app for a DPR RI candidate in North Sumatra III during the 2024 election. It held more than 100,000 records from polling stations and kept every C1 result form on file in case a count was disputed.
01 / The problem
Where it started
On 14 February 2024 Indonesia elected its president, DPR, DPD and regional councils on the same day. North Sumatra III spans ten regencies and cities, from Langkat and Binjai to Asahan and Tanjungbalai, with ten DPR seats at stake.
Each polling station writes its count on a C1 form. The official recap then moves up through district, regency and province. A campaign that wants to check those numbers needs its own count from the same forms, and photos of the forms themselves if a result ends up in a dispute.
What success had to look like
Every polling station result in one database, from regency down to village and TPS.
A photo of the C1 form attached to each TPS record.
Totals that update as results arrive, filtered to any area.
Evidence ready to pull and download if a result is contested.
02 / The process
Four steps, from mapping the dapil to running the count.
Phase 01
Ten regencies and cities, broken down into districts, villages and polling stations.
Phase 02
One dashboard that drills from the whole dapil down to a single TPS.
Phase 03
A TPS form that checks its own totals, and a C1 archive filed by location.
Phase 04
Results entered TPS by TPS as the forms came in after polling day.
03 / What we built
From the recap dashboard to the C1 archive.
01 / Recap
Pick a regency, district, village or polling station, and the chart redraws for that area. The header shows how many TPS have reported and how many C1 photos are still missing.
02 / TPS entry
Operators enter each candidate's votes for a polling station with the photo of its C1 form open beside them, so every number can be read straight off the paper.
03 / C1 archive
C1 photos sit under the regency, district and village they came from, and any TPS without a photo shows up as missing.
04 / Mobile
The recap and the archive fit a phone screen, so a coordinator in the field can check an area's totals or pull up a TPS form without a laptop.
05 / Scale
The database held more than 100,000 records at polling-station level across the ten regencies and cities of North Sumatra III, each linked to its regency, district and village.
Confidentiality
The system served a single candidate's team. Screens on this page use sample numbers, and candidate and party names are anonymised.
04 / Results
The coverage of the count, and the evidence behind it.
100k+
Polling-station records held10
Regencies and cities coveredC1
Form photo stored with each TPS record4
Levels: regency, district, village, TPSNowThe team filters to any regency, district or village and sees the count as it stands.
NowEach form is filed under its TPS, so the one that matters can be found and downloaded when a result is challenged.
Next project / Palm oil mill system
A palm oil mill system for fruit intake, CPO lab results, quality norms and the daily report, all in one place.
Open project
Reply within one business day
