Starship
Mandat

The data is public. That is not the same as available.

Six weeks of turning election PDFs into something you can actually ask a question of.

Results are published per polling station. That sounds like a dataset. It is 1,400 pages of PDF tables, with the column headers repeated on every page, and three different spellings of the same municipality.

What the work actually was

Not analysis. Nine-tenths of it was reconciliation.

  • Municipality names normalised by hand: 214 of them
  • Pages where the table spilled and lost its header: 87
  • Numbers that did not sum to the stated total: 11, all of which turned out to be my parser, not the source

The eleven that did not add up cost me four days. I was sure I had found an error in the official figures. I had found an error in how I handled a two-line cell.

Assume it is you. It is almost always you.

What came out

A page where you can pick a municipality and see turnout against the previous three cycles. That is all it does. It took six weeks because the input was shaped for printing, not for reading by a machine.

What I will not claim

That any of this means anything about why people voted as they did. The chart shows what happened. Everything beyond that is me talking.

4 reactions

One project a week, in your inbox

What was built, the numbers it produced, and what did not work. No other email, and one click to leave.