Department of Arts, Sport and Tourism expenses database

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).

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

BIM decommissioning grants

Bord Iascaigh Mhara paid out €5.2m in decommissioning grants to fisherman in 2008, while the EU paid out €15.7m. The total numbers of grants paid was €20,999,998.96, to the owners of 44 vessels. The highest paid out was to Keating Fish Ltd, for the Molly B – a total of €1.7m. The next highest was for the decommissioning of the Joseph S, owned by Alan Scanlan – €1.3m. The full list is here:



The paycuts that never happened

Ken Foxe has blogged some interesting correspondence concerning the proposed paycuts for senior civil servants. He has also published the original documents. Ken writes:

THE Department of Finance climbed down on major pay cuts for 650 senior civil servants and other highly-paid public workers, primarily because they feared a costly legal action.

Legal advice had been sought by the Association of Assistant Secretaries and Higher Grades, which found that performance-related
awards were in fact part of a “core remuneration package”.

The Minister for Finance Brian Lenihan eventually decided to scale back the pay cuts for senior civil servants to take into account these bonus payments, which had already been stripped from their salaries.

A series of documents released under the Freedom of Information Act detail the to-ing and fro-ing that went on between the Department and the civil servants, as early as last May.

A letter sent by Bryan Andrews of the Association of Assistant Secretaries and Higher Grades said: “Our membership is also strongly
of the view that for the purpose of any exercise being contemplated as part of a reform of public service pay, Performance Related Awards must be seen as part of our core remuneration package.

“Such a position is strongly borne out by the legal advice now available to the Association. As you will appreciate from the foregoing, the Association has considerable concerns about this review exercise.”

“Legal concerns” seem to be quite common these days. Rody Molloy told us much about it.

Enterprise Ireland – two more data sets

Following on from my earlier post on the raw data related to company totals and the raw combined spreadsheet, I am publishing two further data sets.

Last month I attended the ScraperWiki Hacks and Hackers event. During the day, and with the sterling efforts of two Python developers, a scraper was written. This scraper does something relatively simple (though was a little complex to write). It inputs each company into the EI website here and then outputs the Development Advisor (if any) for that company. It then puts that data into a .csv file. This data is raw and incomplete (many returned with no DA). If people want the code for the scraper do leave a comment.

Enterprise Ireland Development Advisors

The second scraper ran was Joe Drumgoole’s CRO scraper. A reader ran the scraper for us, and sent us the result. I am now publishing this also. I did run the result into a geocode batch analyser for Google Maps, and it was largely successful. But I am sure there are people reading this that can do cool mapping with this data and do so better than I can.

Enterprise Ireland company addresses

I again emphasise: we are publishing the raw data. Because the process was automated we cannot guarantee the results are 100% accurate. It does not purport to be a full representation, and if you want to use it you might have to spend a bit of time cleaning it up.

I can think of some nice research or visualisations that could result from it though.

Delay and Pray

“Delay and Pray”, also known as “Extend and Pretend”, probably best sums up exactly where Irish banks and indeed NAMA are right now.

No, I’m not joking. There are oft used phrases across the Atlantic – specifically in relation to the type of loans that have made our banking system insolvent – commercial real estate (CRE).

The US itself is facing a commercial real estate crisis, particularly over the next four years, as this excellent FT analysis outlined last week. $1.4 trillion worth of CRE loans will reach the end of their terms over the next four years. The problem is that nearly half of these loans are already in negative equity. As the FT says:

More shocking is that banks and their auditors are typically well aware of the problem, but have not written down the value of property as prices have fallen. Instead they are “extending and pretending” – or “delaying and praying”: holding property values steady and assisting the borrowers where possible. They need to. If banks were accurately to record property values, they would write down assets on their own balance sheets and jeopardise their business.

This actually sums up how the Irish banks, especially Anglo, have been dealing with our property developers. Rolling over interest, not writing down the loans, not crystalising the losses, doing repayment deals with developers – to drag it out – extending and pretending.

The US government has examined this situation throughout a Congressional Oversight Panel. Their report was issued two weeks ago. You can read it here. The panel concluded that it expects many banks to go under, and the pretence to come to an end, as the FT quotes:

“There is a commercial real estate crisis on the horizon, and there are no easy solutions to the risks commercial real estate may pose to the financial system and the public.”

Equally so for Ireland. Brian Lucey, writing in today’s Irish Times, makes a point along similar lines. He is worth quoting here at length:

Eighteen months into the crisis in the Irish banking sector, and astonishing as it may seem, no real effective repair action has yet taken place. Not a single impaired loan has been taken off the books of the banks. Instead, Government handling of the banking system has been marked by an unwillingness to face up to this fundamental problem – the banks are effectively bankrupted by the losses that they face on speculative lending.

The National Asset Management Agency (Nama), as structured, is designed to buy time for the market, somehow, to sort it out, as there is an ideological obsession at the heart of Government against the notion of the State as the majority shareholder in the banks, even if required and even if temporary. But events may force their hand.

Recall that Nama will in essence take off the banks the loans secured on now deflated bubble assets. The idea is that, in extremis, Nama can sell the assets for their “long-term economic” value and recoup some of its outlay. Nama is proposing to take over some €33 billion of land and development loans in Ireland alone.

Here it is in a nutshell: NAMA is one massive “Delay and Pray”.

Given that our banks are insolvent, that they are facing massive liquidity issues with the imminent closure of the ECB discount window, they cannot keep the pretence of extending and pretending up forever – and NAMA is, or was supposed to be, the answer to their prayers. You could also argue that Bank of Ireland recently changing its fiscal year was part of this tactic.

The Government would take the crappy loans from the banks (rather a lot), and through some financial voodoo, the losses would still not be crystalised, and rather ingeniously – the debt would not appear as sovereign debt for Ireland, or as debt for the banks, but would instead be dumped into this NAMA bad bank.

And NAMA has one sole purpose – keep the pretence going that someday, somehow, the value of the underlying assets will return to peak prices. Delay and pray. Do not write down the loans. Do not accept the reality of the losses. Do not pass go.

Not only is it unlikely that this will happen, it is almost impossible. Morgan Kelly wrote in December that it could take 50 years for the underlying assets to return to 2006 prices. Last week, in the High Court, we saw development lands being written down by 60% to 98% (in terms of valuation, not borrowing). These figures are the reality of the lands that NAMA is taking charge of. And we are overpaying already. How long do you think it will take rezoned agricultural land bought for €13m at peak, revalued at €600,000 in 2010, to return to €13m? The answer is: it won’t. So much land was rezoned that there is no necessity for rezoning for a further 70 years in many counties. Add to that the 300,000 vacant properties. Add to that little demand. Add to that zombie banks unable or unwilling to lend.

This is the reality of NAMA. Delay and pray.

And as if to add salt to the wound, Lucey further explains:

“…in many cases of development land the title was not actually transferred to the developer; rather, they took out a licence to develop. This was, it seems, a scheme to minimise tax, but it leaves open the incredible scenario that rather than being secured on an asset, these loans were secured on what is technically a derivative whose value has now collapsed to zero. If the underlying assets are worth zero, the hole in the banking system is that much larger.”

Lucey is referring sideways to the famous Section 110 of the 2007 Finance Act. This was a part of the Act that was never activated through a commencement order, which would have effectively closed the loophole that allowed developers to avoid paying stamp duty when buying landbanks. Brian Cowen, as Finance Minister, and Brian Lenihan after him, failed to commence the section due to concerns that it would further undermine the property market.

At the time, the Government commissioned AIB/Goodbody to write this report on the Section. It was published in November 2007, and is available here. The report concluded that if the Section were to be commenced:

It is recommended that Section 110 provisions should not be commenced at this time. To do so, would run the risk of exacerbating the down turn in the property
market.

Of course, the market was already beginning its freefall by this time, as the market had peaked some 11 months previous. The Goodbody report hedges its bets, in some places saying things could get bad, and in others saying they might not – as any good report does. But was is critical here is who owns the land.

A developer wishes to buy rezoned land from a farmer. Instead of paying money directly to the farmer (and incur stamp duty), the two instead enter a deal in order to avoid it. They enter a resting on contract or a type of lease. The developer essentially takes out a 100% mortgage to buy the right to build on the land, with no collateral to back the loan since he essentially does not own the land in question. Stamp duty is payable by the buyers of the houses that are to be built on the land, but the developer has avoided paying it.

As Lucey says it is essentially derived, and with little or nothing backing the loan, the losses are far steeper for the lender in a situation where few or no houses were built or sold. Those ghost estates are ‘worth’ far less than many might have assumed. Joan Burton pointed again to this last week. As late as April 2008, the Government was still considering commencing the section, but never did so.

It logically follows that where the banks lent money with no obvious collateral to back the loan, and where the supposed value of derivative is now zero, the bank sustains a massive capital loss.

However the banks are simply delaying and praying until NAMA takes over the loans, and then NAMA continues the praying.

We are in for one hell of a fiscal mess.