Department expense database

[Crossposted to]

Readers may recall a blog post I wrote back in December detailing my dealings with the Department of Arts, Sport and Tourism (DAST). After gleaning information from the footers of Ken Foxe’s FOIs concerning John O’Donoghue, I established that the Department was using Oracle iExpense software to store expenses information.

I wrote an FOI request in October asking for a ‘datadump’, of the entire database since inception (in other words, a copy of the database). The Department refused both the original request and the appeal for internal review (conducted by a more senior official in the Department).

In January I appealed the decision to the Office of the Information Commissioner. The request, internal review and appeal have cost a combined €240 (kindly made available by you, the public).

The Appeal letter to the Information Commissioner

Today I am pleased to say that I have reached a settlement with the Department, brokered by the Office of the Information Commissioner. The Department have agreed to release almost the entire database, with some elements removed. This is not a formal decision of the Commissioner, but is instead a settling of the issue. This just means that a formal OIC Decision was not required as the two parties reached an agreement.

The settlement is this: the entire expenses database of the Department, to include the follow expenses data headings:

Description, Grade, Full Name, Claim, Date, Purpose, Status, Total Claimed, Distribution Line Number, Start Date, Expense Type, Euro Line Amount, Currency Code, Currency Rate, Amount Quantity Unit, Rate Net Total, (EUR) Payment Date, Withholding Amount Invoice, Amount, Amount Paid.

Cost Centre numbers, employee cost centre numbers, named approvers and justification fields have been removed. There are also some removals from other fields which is either considered personal information or information obtained in confidence. These removals do not mean the information is redacted per se, it just means that in order to get the data, I agreed to remove certain columns in order to expedite the process. It does not preclude me from seeking the justification field, for example, in the future.

The data contains €774,882.29 of expense claims by named civil servants over a five year period (2005 to 2009 inclusive). The amount involved might appear relatively small, but it is the quality of the data that is more significant.

I cannot overstate the importance of the release of this data, and there are a number of reasons why this is the case.

Firstly, it sets an important precedent in terms of what information can be obtained from public bodies. In their refusals to release this data, the Department cited three sections of the Act which they felt exempted them from releasing it. The OIC felt differently. While not a formal decision of the OIC, a settlement was justified in this case as the Department were amenable to releasing the majority of the data sought. Decisions can take far longer to get (up to two years), so I felt that on balance the offered information in the settlement was acceptable.

Second, are the broader implications.

Following this settlement with DAST, I have started the process of requesting similar expenses data from the Department of Agriculture and Food, the Department of Communications, Energy and Natural Resources, the Department of Community Rural & Gaeltacht Affairs, the Department of Defence, the Department of Education and Science, the Department of the Taoiseach, the Houses of the Oireachtas Commission, the Department of Justice Equality and Law Reform, the Courts Service, the Industrial Development Authority, the Department of Enterprise, Trade and Employment, the Department of the Environment Heritage and Local Government, the Department of Finance, the Department of Foreign Affairs, the Department of Health and Children, the Department of Social and Family Affairs, the Department of Transport, the Health Service Executive, the Revenue Commissioners, FÁS and Enterprise Ireland.

I believe the combined expenses data for these (and other) bodies will run to tens, if not hundreds of millions of euro.

But perhaps most critical is this: I sought the data not as a journalist looking for a scoop, not as a member of the public with an axe to grind, but as a transparency advocate only interested in the public interest. By publishing this, and coming data, I believe the public is served by a more open and accountable State – where data related to how some public monies are spent is no longer hidden, but is in full view. Transparency keeps the system honest.

I should also make clear that publishing this data is not an attempt to embarrass any one person, nor does it form the basis of any claim that somehow there was something unjustified about any expense claimed by civil servants. It is simply an exercise in transparency, and no more.

And I will leave readers with one question.

If I am getting this data and intend publishing it in its entirety online for the public to see, what is stopping the Government from doing the same, proactively, without question, and as a matter of course?

In the end, sunlight benefits us all.

The dataset, presented as is (and containing some macros):

Department of Arts, Sport & Tourism expenses database

Baker Tilly report

For those interested on what goes on at some State bodies that do not fall under FOI legislation, Mark has distilled the details of the Baker Tilly report in CIE (the Irish operator of railways), and posted the report itself. It details widespread fraud at the body, and is the first time the report has been made publicly available. As is policy now, I OCRd the document making it searchable and indexable.

I am back from Barcelona… and so many projects will hopefully come to fruition as a result of attending PDF Europe.

Anger and John O'Donoghue

The Sunday Tribune reported over the weekend that current speaker of the Dail, and former tourism minister John O’Donoghue spent upwards of €125,000 (excluding government jet costs) over two years. Among the details:

Among the expenditure were a series of €900-a-night hotels, €7,591 on “airport pick-ups” during a two-day trip to London, €120 for hat rental, €250 for water taxis and €80 to “Indians for moving the luggage”.

On one luxurious trip to Venice, the former arts minister, his wife and the civil servant ran up hotel bills of €5,834 at the Albergo San Marco, the Hotel Cipriani and the San Clemente Palace. The ministerial entourage travelled to Italy by government jet, where they were collected by a private airport boat and taken to their luxury accommodation.

VIP facilities, limousine hire and hat rental were all paid for at the taxpayer’s expense. A limousine in Berlin to transport O’Donoghue to a World Cup soccer game cost €2,436, while Therese O’Connor’s hat hire for an official engagement cost €120.

Curious how the Tribune, I believe, only managed to get access to the information just as the Dail was going into recess. But what is perhaps more important is the attitude of the FOI officer. At first they looked for €600 to get the information requested, which was later reduced to €200. This is clearly unacceptable.

Let me be very clear. As a citizen, I have a right to know about how every cent is spent by every Minister, TD and Senator. I have a right to know how taxpayers’ money is spent. It really is that simple. I want details of every single expenditure. For the moment only ministerial expenses can be accessed in this almost detailed way. TD expenses simply fall under broad categories. This has to change, and I will be pursuing this through every means necessary.

And one thing for the Tribune. Publish all the documents you received in the FOI to the web. This isn’t just your data, it’s our data.

Giving something back?

Given the day that’s in it, after seven years of blogging, I feel like I should try and give something back to the blogosphere.

Over the years I have offered hosting to a number of people who I felt deserved better tools than Blogspot offers, or would be better served by having their own domain, and the use of the WordPress platform.

So my offer is this, for what it’s worth:

To the first five people who leave a comment to this post (or drop me an email alternatively), and who’s blog is hosted on a third party platform such as, or, I will offer one year of free hosting using the WordPress platform. Included are advice and support on how best to implement the installation, full FTP access, a default selection of themes, and an array of plugins. I will install and host WordPress for you, free of charge. I will also help with any import of entries from a prior blog.

Of course there might not be five people out there who want this, so if you know of anyone, do leave a comment and point me in their direction.

And another thought, if at the end of the year you wish to move, I will of course export your database to a file, and you can go out on your own into the brave world of self-hosting. 🙂