The Jobbridge database


The Jobbridge database [Version One] courtesy  of a Freedom of Information request.

Jobbridge database

[Since the Excel XLSX file is rather large at over 14Mb, there may be problems in formatting etc. Any suggestions for improving usability gratefully received.]

Version Two: Jobbridge database in Socrata (from a suggestion by Steve White)

Jobbridge and Freedom of Information

Jobbridge: Does exactly what it says on the tin

Victory of a sort…but mostly not

In March 2012, I sent a Freedom of Information request to the Department of Social Protection (DSP), looking for the Jobbridge database.

By July of the same year, DSP had replied with some of what I sought, but I had some problems, and so an appeals process began.

My first problem was the DSP refusal to provide details of companies which had asked for anonymity during the advertising process. Internally, these are referred to as “Closed Vacancy” companies. About one in five advertisements for Jobbridge internships are closed vacancy, that is, the applicant does not know what company is advertising the post.

The second problem was the refusal to hand over a field called “COMPANY_ID”. This field is the only way to link the company placing an advertisement with the job it is advertising. DSP said this was confidential information and releasing it would constitute a security breach which could unleash evil hackers in some unspecificed manner.

Finally, there’s a field in the Database which indicates whether or not a company requested anonymity. It’s basically a “Yes/No” button, called “ANONYMOUS”. We’ll come back to that later.

As it turns out, when DSP sent me a database in July 2012, they accidentally sent me the names of the Closed Vacancy companies. I didn’t know this at the time, and I appealed the Department’s refusal to provide me with the names of Closed Vacancy companies. The internal appeal was upheld in the Department’s favour, and so I then began an external appeal, to the Office of the Information Commissioner (OIC).

In December 2014, OIC got back to me to let me know they’d issue a decision shortly, and to bring me up to date on their thinking. It was at this point that I first learned that I already had the Closed Vacancy companies. OIC explained that, since DSP had given me the Closed Vacancy names, the question was moot, and it would not decide the issue of whether DSP was required to hand over Closed Vacancy names. In return, I pointed out the database they had sent me was almost three years old, and I intended once a decision was made to ask for a fresh database with up-to-date names, and if they didn’t make a decision, then I’d have to go through the entire appeals process again, which would take another three years.

They said they’d think about it.

Well, they’ve thought about it.[See end of post].

The OIC decided not to decide about Closed Vacancy names, as they first indicated. On the up side, the OIC did make some “General Observations” at the end of the decision. Reading them optimistically, they appear to say in effect that, if the issue arose again, OIC would be inclined to find in my favour.

However, observations are not binding, and DSP could easily delay for another few years until an appeals process plays itself out.

Happily, OIC did decide I had a right to COMPANY_ID numbers, so I will now receive a database with meaning, and not a list of internships orphaned from the companies advertising them.

I had emailed a request for a fresh database (including Closed Vacancy companies) to DSP today. They can decide to release those names, or I can enter the appeals process again. So ar, it’s been two years and eleven months…

I’ll keep you updated.

Update 1: For those of you wondering, the database I received in 2012 is at this link: Scribd doesn’t like very large excel files, and the Jobbridge data dump clocks in at around 6Mb, so the Jobbridge database is available through a Dropbox link
The “ANONYMOUS” field appears with a zero in every case, which I assume is some sort of processing error by DSP which led to the unwitting release of all.companies.

Update 2: There’s some fine tuning to take care of before the information is released, since the database is quite large (I have no interest in fax numbers, for instance) but the Department of Social Protection has indicated to me today (24 February 2015) that it will release the names of Closed Vacancy companies.

FOI jobbridge external appeal decision

Jobbridge: Does exactly what it says on the tin
Jobbridge: Does exactly what it says on the tin

RTE, BAI, and the marriage referendum

Balance. Image via Morguefile

In response to a letter from the Broadcasting Authority of Ireland about coverage of same sex marriage, RTE politely responded that it knew how balance worked. I previously published a copy of the BAI’s letter to RTE, which I obtained from the BAI itself.

Below are the letter and the official RTE response, obtained through an FOI request to RTE.

Same Sex Marriage BAI to RTE 060814

MoJo Kit

Image © Faduda

Kit used in the course of mobile journalism #mojo (mostly radio/audio at present)

1- Hama Traveller Compact Pro tripod

2- Canon 450D DSLR Camera + Canon EF-S 18-200mm f/3.5-5.6 IS Standard Zoom Lens

3- SD Cards

4- Audac CMX230 microphone

5- Samsung Galaxy S5

6- Panasonix RP-HC200 headphones

7- 1m XLR microphone cable

8- JTS NX-8 microphone

9- Zoom H4n recorder

10- Foam windscreen

11/12- Sony dictaphone + stereo microphone

13- Olympus TP-8 Digital Headset Ear Microphone

14- Earphones

Not shown: Lenovo Thinkpad


Image © Faduda
Image © Faduda

Proper Charlie


Maybe the problem is Charlie Haughey wasn’t that interesting.
In a way, he wasn’t. I grew up with CJH as Taoiseach, yet no matter how many times I was assured he was a charismatic, powerful and dominant presence, I never saw it.
I saw another dull grey politician, and Ireland being Ireland, it wasn’t that hard to read between the lines of the regular newspaper profiles. Unexplained wealth? You mean the explanation is defamatory? Gotcha.
It wasn’t until later I found out how venal he was. I had in mind dodgy land deals, maybe a payoff here and there. Stealing Brian Lenihan’s liver transplant money? That I didn’t see coming.
There were half a dozen plots crammed into the first episode of Charlie. Any one of them could make a good drama. Instead, they were like signposts on a coach tour, places to look out the window at as we sped by.
The liver fund is a film in its own. It encapsulates the small minded thuggery and corruption of Haughey’s Ireland. But it won’t be the story we get. Instead we’ll have dull exposition about Dessie and the PDs, Sean Doherty and the phones, SPUC and the rosary clutchers.


Information wants to be free

Or at least, I want information to be freed. And thanks to the new Freedom of Information Act 2014, signed into law today, it just got a little more free in Ireland.

Now there are a lot of caveats. Not all officialdom falls under its terms, there are exceptions for things like commercial sensitivity (which can be very broadly defined), not to mention the cost of appeals.

But still, the 2014 Act is an improvement on the regime it replaces.

So suddenly there’s a wealth of information at my fingertips, if only I knew what to ask for.

Over the years, in piecemeal fashion, journalists have successfully sought information on a great number of topics, but not in a structured manner. A local reporter in Donegal might have asked a question of the local council, but no one has ever gone through every council in Ireland seeking the same information. Or a journalist sought particular databases from one government department, or one quango, but not all of them.

So here’s my question: What old FOI requests could be applied more broadly? Feel free to leave your answers below, or if you prefer, drop me a line at


Freelance Forum: All you need to know

There are only only six days to go until Freelance Forum Autumn 2014. Have you reserved your place yet?nujFF

Freelance Forum is a regular one day event designed to keep freelance journalists up to date with the latest developments in their industry. Aimed at writers and photographers, and hoping to cover print, broadcast and online, it is organised by Dublin Freelance NUJ Branch.

Speakers at the Autumn 2014 Forum include Lyra McKee, a young Belfast based journalist who used crowdfunding to finance an investigation into the death of Rev Robert Bradford MP, RTE correspondent Richard Dowling and Ray Mitchell, assistant national director of the HSE on the new Freedom of Information Act, as well as commissioning editors Frank Murtagh and Emmet Ryan on pitching skills, and representatives of the Mary Raftery Fund and Simon Cumers Fund giving details of how to use philanthropic funding for journalism projects.

Full details of the event, which takes place on 20 October in Buswells Hotel, Dublin, are available at the Dublin Freelance website.

Bookings can be made using Paypal or credit/debit cards.

What’s wrong with this graph?


indy-ref-by-ageIt’s been niggling me since the result was announced, but there were other things to do, so it took me a few days to sit down and scratch this itch.

The headline is simple. Older voters defeated the Scottish independence referendum, as illustrated by this graph breaking down voter intentions.

But data journalism can be a tricky thing, and graphs can easily misleading unless designed with a bit of thought. Take a look at the first bar. It illustrates the voting intentions of 16 and 17 year old voters. A two-year gap. Then there’s 18-24, a seven year group. Then ten-year steps until we reach 64, then “65+”.

Now look again. There’s no information about varying turnout rates, and even with 84% overall voting, I’m willing to bet turnout increased with voter age. Yet there’s a graph that gives the visual impression that over 65s (a cohort that covers a 30-40 year age range) is the same size as one for 16 and 17 year olds.

The graph, whether intentionally or otherwise, gives the impression of a small minority overruling the wishes of a majority.

And that annoys me.

God and the census

Census Form UK

How questions are phrased in a survey is important, as any market researcher or social scientist will tell you. And appearing early on a list matters too. One Irish TD even went to court a few years ago to argue that when arranging names in alphabetical order, the returning officer should ignore the Ó at the start of his name.

So consider the following: the number of people who answers “No religion” in reply to a census question in the UK is 14.1 million, one in four of the population (25% in England, 37% in Scotland, 32% in Wales, 7% in Northern Ireland).

Meanwhile in the Republic of Ireland, the number answering “No Religion” to the census question is 4%. (And that figure is also a matter of debate).

Now take a look at the two forms below.

Notice anything?

Cenus Form IrelandAbove: Religious question in the Irish census. Below, the religion question on the UK census form.

Census Form UK