Starship

Dylan Beesemer

@dylan_beesemer

Lauder School of Government. Building readable charts out of election data that is published as PDFs on purpose.

1 post15 followers10 following

  1. 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 e…

    Read the article →