Dylan Beesemer
@dylan_beesemer
Lauder School of Government. Building readable charts out of election data that is published as PDFs on purpose.
Posts
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.
Read the article →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 e…