ES

← 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.

Mauro José Ciappina · Astro · TypeScript · open data · code on GitHub · live site

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

The problem

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 .