We have already started the process of tabulating all historical expense claims for TDs and Senators. For reference these are the salary and expense claims for Members of the Seanad for 2008:
There has been a significant event in my ongoing quest to understand the full cost of the Oireachtas to the public. Another part of the request I mention below was refused, partly on the basis of Section 10 (1) (e), vexatious, frivolous or manifestly unreasonable (specifically the vexatious part), Section 27 (1) (a) and (b) Commercially Sensitive and even if Section 27 did not apply, the request would be considered voluminous in nature under Section 10 (1) (c).
I entirely disagree with this decision. My request sought:
A datadump of the entire Integra database insofar as such data relates to claimed expenses, from any Member or any member of staff.
A datadump of the entire Integra database insofar as such data relates to costs incurred by the Commission in the administration of Members’ activities.
A datadump of the entire Integra database since inception.
I have gone to great lengths over a period of some eight months to try and gain as full a picture as possible as to the expenses and costs incurred by Members of the Oireachtas. I have been entirely reasonable in my dealings with the Oireachtas. I have at all times acted in good faith, and sought to the maximum degree possible to facilitate the release of detailed information on how public money is spent by the Oireachtas.
I have spread out my requests over a number of months, and at greater expense per request, in order to assist the Oireachtas in the release of records. I have been refused two years of expense claims and had to appeal for internal review, costing another 75 euro, which while successful, does not lead to a refund under the Act. I have also sought to negotiate with the Oireachtas on the tabulation of costs incurred by Members (as distinct from just expenses claimed), and the calculation of the total cost per Member. My sincere efforts have proved fruitless, which has brought about a situation where my requests are considered vexatious.
I have at all times sought for the release of the records in question in digital form. In some cases this was agreed to, however not in the form which was requested. Since 2005, the Oireachtas has used a financial management system called Integra. Integra is built on Oracle software.
In order to demonstrate the nature of release, I will give one primary example.
Last year I sought all expense claims of members for the period 1997 to 2008. I was told this would be a voluminous request, but that I could vary it since 2005 to 2008 was held digitally. I sought this information in digital format, since logically, thinking perhaps naively that I would get spreadsheets. But instead of releasing spreadsheets, the Oireachtas released to me PDFs containing tables for each year. But the PDFs were not digital PDFs, they were scans of printouts of spreadsheets. But worse than that, given the degraded nature of the text, they actually appeared to be scans of photocopies of printouts of spreadsheets. There is a significant difference between emailing someone an XLS or CSV document and emailing them a PDF of scans of photocopies of printouts of spreadsheets. This requires much greater manual work on my part to convert degraded scanned images into functioning and correct spreadsheets.
2003 and 2004 (which became part of the 2005-2008 request) were released as scans but not in a table or spreadsheet format, as it predated the Integra system.
In the next request costing another 15 euro, 2002 and 2001 were refused on the grounds of a voluminous request, which I then appealed (readers should remember that between FOI submission, refusal, and appeal, it takes up to eight weeks). My appeal was successful, but no money is returned even where appeals are successful. 2002 and 2001 were released, but in paper format, not in tables (it predates tabulation too), and several inches thick.
In the next request, 2000 and 1999 were then sought, again costing 15 euro, and were also released, this time in digital format on PDFs, albeit degraded as might be expected for older documents.
Other factors are worth noting. 2005 to 2008 contains salary figures for members, but salary figures are not contained in 1999 to 2004 – these will be sought in another separate request. Also, in January it became clear that Members expenses do not fully cover the scope of the actual cost per Member. In many cases no expense claim will be involved, but the Oireachtas will directly pay for the activities of a Member (such as flights for Committee Travel). In order to arrive at a figure that accurately represents what a Member has incurred, we believe that expenses claims and costs incurred need to be combined, so a full picture can be drawn as to the totality of cost.
During communications with the Oireachtas however, a number of questions arose as to the accuracy of how our parliament was calculating this. In early January I was informed:
Costs incurred for foreign travel are paid directly by the Houses of the Oireachtas in some cases. Cost incurred and paid by the Member and refunded to the Member will be recorded as an expense paid to that Member. The costs paid by the Houses of the Oireachtas can include hotel bills, flights etc paid directly to the service providers for the entire delegation and are recorded on the system as a payment to that service provider. It is not always possible to allocate a cost per Member for foreign travel as members of delegations can attend for different durations etc. Records are maintained on each trip and payments are made through a number of systems eg Inter Parliamentary Union and British Irish Parliamentary Association from funding allocated for their programmes. It is a manual process to draw this information together when requested.
Fair enough, I said. This might involve me having to manually add costs incurred into expenses claimed, broken down by Member, but with a proviso that the Oireachtas itself had not tabulated in all cases the cost per Member. I then received a breakdown of costs incurred by Members for foreign travel, in PDFs. I wish to stress that all email exchanges were cordial and professional. I sought further clarification, using random examples from the information I had been given:
I just wanted to make sure my figures are correct, so if I may for example point to 2008 figures (open to correction!):
Expenses: Jim O’Keeffe
€2345.72 for Committee Travel (home and foreign)
€1147.81 for BIPA travel.
No expenses were claimed for IPA travel
€2,125.78 was incurred in relation to Committee Travel
€154.58, €274.54, €556.77, €354.60, €625.01, €735.55, €68.06 and €263.79 (Just over €3k in total) was incurred for BIPA travel
No costs were incurred for IPA travel
If added, totals are:
€4471.50 for Committee
€4180.71 for BIPA
My question is do these figures overlap? When I add expense figures to cost figures do I get an accurate figure as to the cost to the taxpayer?
I wish to clarify that the data you use of costs for foreign travel per Member where quantifiable includes the expenses paid to members and therefore you would be double counting the costs if you add both figures. Please note that the example you use for Jim O’ Keeffe does not include one of the figures included in the committee travel expenses paid to the member in respect of the journey to Lithuania of €1063.27.
Again, fair enough. But I needed to understand properly where any overlap occurred, was expenses including in costs, or vice versa. They reply stated, my emphasis:
Just to clarify as stated that the cost of foreign travel includes expenses claimed by the member for each particular trip. The costs per member are paid on behalf of the Member to enable them to attend the relevant meeting as a representative of the Oireachtas and would cover the costs of attending that meeting. Just to note that salary and specified position allowances is the remuneration of the members and subject to tax. Other allowances and expenses are for expenses incurred under the categories provided in their role as public representatives.
And again, I was trying to get to the bottom of understanding how the system worked, in order to accurately reflect the position. I therefore created a spreadsheet, where I could compare costs to expenses. I replied:
The difficulty I am having is in reconciling the costs figures and the expenses figures. If expenses are a part of overall costs then I would logically assume that cost figures must be greater than or equal to expenses figures – but this is not the case.
For example in 2008 (Committee Travel, Home & Foreign):
Cuffe Ciaran, Expenses claimed: € 1758.27 Costs incurred: € 652.39
Fahey Frank, Expenses claimed: € 8720.22 Costs incurred: € 1804.93
Costello Joe, Expenses claimed: € 4110.53 Costs incurred: € 3621.9
Breen Pat, Expenses claimed: € 13664.44 Costs incurred: € 1503.89
If expenses are included in costs, how can Ciaran Cuffe’s expenses be greater than his costs?
There are examples where cost figures are equal to expenses figures such as:
Fleming Sean, Expenses claimed € 247.12 Costs incurred € 247.12
Am I missing something? Perhaps I am missing “Home” Travel costs?
I have studied the explanatory document but it does not seem to account for these variances.
In fairness to the FOI officer in question, she did seek to answer my questions but was unable to take the issue any further. She did however pass me on to the Press Office, with whom I entered I dialogue in order to try and reach clarity on the overall picture, so that I could be as fair as possible to the Houses and to the Members, when publishing combined expenses and costs data. And I did wait, another two months, in the hope that some arrangement could be reached to correct any discrepancy, to reach an agreement on release or calculation of total costs and expenses. And again, in fairness, the Press Office acted in good faith, and two months later they told me:
the system of accounts operated here is a financial accounting system rather than a financial information retrieval system and thus doesn’t provide the information in a way in which is easily accessible. I understand fully your difficulties however there is little more that we can do to assist.
And I must again emphasise, the tone was always professional and I felt that the office was acting in very good faith, and at no stage was I treated in anything other than a friendly and professional manner. But it sill left me in a position where I had an inordinate amount of poor quality data, either on PDFs or on paper, where the sheer scale of scanning, OCRing, tabulating, correcting, calculating and combining hundreds of pages of data would take several months to complete.
All this, while knowing that for the period 2005 to 2009, all of this data is held on an Oracle database, that can export to spreadsheets in seconds. To that end, I sought a copy of the database, and since the database included not just the claims and costs of Members, but of the entire staff of the Oireachtas, I sought that also. The database would also contain the expenditure of the Oireachtas, in almost any capacity, which I also felt would help the public to understand and inspect how money is spent by the Oireachtas (in 2009 the Oireachtas cost about 125m to run, yet we have little idea as to the detail of this expenditure). I believe how the Oireachtas spends money should be open to public scrutiny.
If there is one body in the State that must be transparent, it is our houses of parliament. And instead of spending tens of thousands of euros of public money on High Definition videos of Members telling us why the Oireachtas is important, the Oireachtas might be better served by opening up its data to public scrutiny. It is, afterall, our data.
And in the strange world of FOI – due to my asking, in different ways, for what the Oireachtas considers to be the same information, I am now told that my request is vexatious. It is frankly mind boggling in its supposed logic.
I will be appealing this decision (another 75 euro), and will publish the appeal letter here. If that decision is refused, I will be appealing to the Information Commissioner (another 150 euro).
This will take at least another two months – pushing a year since I started this process.
These datasets are too large for Google Spreadsheets so I am using Socrata. They contain the expense claims of all FAS staff, broken down by name and amount for the years 2005 to 2009. The total amount claimed via expenses was €24.7 million. I am presenting the data ‘as is’, and draw no conclusion on the validity, or otherwise, of any claim – this is a copy of what FAS has, and I believe this type of information should be online as a matter of course.
Please note: you can download the datasets themselves by clicking on ‘menu’ and ‘download dataset’ and choose which format you would like. I recommend CSV or XLS.
The expense allowances available to cathaoirleachs and leas cathaoirleachs (chair/mayor and deputy chair/mayor) of local councils are interesting to examine. Or at least would be if we could see them all in the one dataset.
Under the provisions of Section 143 the Local Government Act 2001 a local authority may pay an allowance to its chair and deputy chair for “reasonable” expenses. This means councillors vote on how much the council chair (also a councillor) gets for expenses, which are unvouched in the vast majority of cases and often untaxed. Of course that also means the allowances vary from one council to another.
Last week one New Ross Labour councillor, Bobby Dunphy, made a good case for changing this system. He proposed that mayoral expenses be reimbursed instead of awarded as a fixed amount. He told the News Ross Standard [paywalled link]…
All I was proposing was a system that would give greater openness and transparency. The only reason for opposing that would be that you did not want openness and transparency. For example, while the €8,000 is intended to cover anticipated expenses, in reality any expenses incurred can be and are claimed separately. The €8,000 is, in effect pocketed as a tax free salary. There is no scrutiny, no value for money analysis… Because it is public money we Councillors have a duty to oversee the proper disbursement of this money
It’s perhaps insightful to note that Dunbar couldn’t get another elected member to second his proposal. This meant he couldn’t speak from the floor to argue why such a change would be beneficial to the people of New Ross. According to the council website there is another Labour member on the council. Continue reading “Allowances for local council chairs' expenses”
Update: I have totaled the staff claims here.
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).
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):