This is a presentation I gave in RTÃ‰ late last year to the Hacks/Hackers group about building databases of political expenses and the challenges of trying to put all of that material together in one place for the first time.
These were the key challenges faced with such a project, the types of issues anybody interested inÂ data journalism would beÂ familiar with:
- Information published month to month in PDFs and inconsistently formatted.
- Many categories of expenses wereÂ not available publicly: mobile phone purchases, constituency office grants etc.
- Salaries and allowances for certain positions wereÂ not routinely published.
- MaterialÂ provided across a dozen or moreÂ different spreadsheets and broken down year by year.
- Some of original material had errors and updated versions were later sent.
- Wide variation in data provided, its formatting, even spelling of names (particularly Irish variants & Oâ€™/Mc names)
- Apparent errors in the data. These would have to be checked by phone for clarification.
- Known unknowns in the data. For some allowances, not all TDs and Senators took them. Under FoI legislation, this â€˜giftingâ€™ is considered exempt. However, the money is listed as if it had been paid.
It raises an interesting question about materialÂ that is provided under Freedom of Information legislation, which then turns out to be wrong.
Is there the possibility of defamation if media organisations – in good faith – republish official information that turns out to be incorrect?
Not aware of it having happened yet … butÂ it is probablyÂ just a matter of time.