← Portfolio · Case · Open data
Congreso Abierto: open data for the Argentine Congress
The Argentine Congress publishes its data across several official sources, in different formats, with names that never match. This site joins them: deputies, senators, official trips, bills, committees and votes in one place.
01The problem
The information exists — the HCDN open-data portal and the Senate API publish it — but it is split: a deputy's trips don't connect to their committees, or their bills to their votes. And each source spells names differently: «Chiconi, Abel» against «CHICONI RICARDO ABEL». Unjoined, the Congress is a folder of CSVs.
02From raw sources to 443 pages
A static Astro site: the 443 pages are generated at build time from the official Deputies data and the Senate API, with global search and related profiles by bloc, province and committee. There is no production database: there is a versioned data snapshot and a weekly automatic refresh with GitHub Actions (cron on Mondays), so the site records what data it showed and when.
03Matching names across sources
Linking trips, committees, bills and votes to each legislator requires deciding that «Herrera Ahuad, Oscar A.» and «HERRERA AHUAD OSCAR ALBERTO» are the same person — without assigning blindly.
I solved it with Jaro-Winkler compared word by word, with a confidence score and doubtful cases that are shown, never hidden. The full explanation, with thresholds and real code, is in the article: Matching names with Jaro-Winkler →.
Matching result
Committees 99.6% (1,612 of 1,618), Deputies bills 99.1% (14,523 of 14,651), Senate votes 100% (24,912 of 24,912). The hard cases were pinned as tests.
04Honest statistics
To compare trips so that three extreme cases don't move the bar: median and MAD with the Iglewicz-Hoaglin modified z-score, and peers by estimated distance — not by province. The site says "travels far more than their peers", never "abuses": statistics describe, they do not accuse. Details: robust statistics →.
05Result
Result
Public site running with deputies, senators, trips, bills, committees and votes; versioned snapshot and weekly automatic refresh. The code and its ODD specs are public: github.com/mauroociappinaph/congreso-abierto .
More of the work: zk-secrets (next) → · ← UNNA · Algorithms I used and why →