د . إAEDSRر . س

“I Ran a Search on Malta’s MPs and Their Spouses, and Bingo…”

Article Featured Image

Matthew Caruana Galizia, one of three data miners from ICIJ exposing Panama Papers, spoke to Lovin Malta about his experience working on the huge international leak, and what’s to be expected from the data drop coming tonight.

How long have
you known about Panama Papers?

I’ve known about
the leak for about a year and it was a long, cloistered one. For that entire
time I couldn’t talk
about any aspect of it — not to my friends, family or girlfriend. Work makes
up a large part of everyday conversation but most of the time I spoke about it
in only general terms. When I lived in Costa Rica I said I made websites and
when I lived in Greece I said I was working on an investigation into the
migrant crisis.

The first few
months were probably the hardest. We had to figure out how to receive the files
securely and once that was sorted I had to come up with a way of making all of
them accessible to journalists. I’ll never forget the moment I got the platform up and running with the
first terabyte of files. I was alone in my apartment on a sunny day in San José. I ran some searches to test everything and I couldn’t believe what I was seeing. Up
until then I had been working blind, focusing on the engineering problems and trying not to spend too much time looking into the files.

How did your
colleagues view the Maltese case?

It was another
case of dodgy behaviour in one of many we were seeing at senior levels of
government all over the world. In Swiss Leaks we had (former PN minister) Ninu Zammit in what was a
clear cut case of evasion on over three million euros. Imagine the
disillusionment and sense of betrayal when I found out he had been given a tax
amnesty by the current government – in complete secrecy – and gotten away scot-free.

With this leak
things were different. The files were live, not something from 2007. I was
looking at emails that were sent weeks ago. I thought, “OK, this is it. Surely there’s no escape for them this time.” I think that for everyone else it was clear,
too, that there was no way they could explain their way out of this.

What was it
like when you first got to know Konrad Mizzi and Keith Schembri were involved?

My jaw dropped.
I was working on a feature that would allow journalists to run automated
searches on the files using spreadsheets containing thousands of names — all
the world’s elected
officials or all the names on Interpol’s lists, for example. It had to be capable of
what’s called proximity
searching, where small differences in a name, like a middle initial or putting
the surname before the name, would be ignored. While I was testing this, I ran
an automated search on Malta’s MPs and their spouses, and bingo.

We have a
platform which we use to share and discuss findings and leads, called I-Hub.
The first thing I did was write a post there to report what I had found. After
that it was up to our partner journalists to follow through on the lead.

How did you
think it would play out? How differently did it?

There’s a difference between what I
expected to happen and what I expect should happen. They should all
resign — there’s no
doubt about that — but I was prepared for that not to happen. I knew they would
all go on the defensive immediately.

The most
important thing right now is that we’re empowering people with knowledge that has been kept hidden from them.
Now it’s up to them to
act and to demand resignations.

“I’ll never forget the moment I got the platform up and running with the first terabyte of files. I was alone in my apartment on a sunny day in San José. I ran some searches to test everything and I couldn’t believe what I was seeing.”

Panama Papers

Was there
ever a time you felt scared while working on the story?

There were lots
of tense moments, certainly, but I don’t think that at any point anyone on the team
was scared. I’ve worked
with people who’ve been
shot at and others who’ve
been imprisoned but none of them ever told me that they were scared. To me the
two things are so far removed that the thought that anyone at ICIJ might become
a victim of some kind of retributive attack would never cross my mind. How can
you ever be a good journalist if you’re scared of something like that? It would be like being truck driver
who’s scared of
crashing all the time. I don’t even consider myself to be a real journalist — I do no reporting and
have little time to do investigative work — so I have no right to be scared.
Nevermind that my existence in a post-democratic European state is pretty cosy,
while investigative journalists like ICIJ member Khadija Ismayilova are
harassed by the government and imprisoned by kangaroo courts in Azerbaijan.

What do you
consider to be the worst story the team uncovered? The one with biggest
implications?

There is no
worst story. The whole thing is symptomatic of a system that’s rotten to the core. Have fun
filing your tax returns this year while knowing that the very people who oblige
you to do so are busy working out how best to avoid it for themselves and their
friends.

Is there more to come?

Yes, tonight we’ll be releasing raw data on around 200,000 offshore entities from the Panama Papers investigation, in a searchable database.

The leak was entirely unstructured. We had files in around 50 different formats: emails, PDFs, spreadsheets and images. Among them were HTML files containing information on the offshore entities set up by Mossack Fonseca. We took these HTML files and used them to reverse engineer their operational database into what’s called a graph database. You’ll be able to explore the relationships between companies, directors and shareholders.

“Tonight we’ll be releasing raw data on around 200,000 offshore entities from the Panama Papers investigation, in a searchable database.”

How big is tonight’s leak going to be?

We’ll be releasing much of the structured data that we could build out of the files. It’s a lot and will be a boon to investigative reporters and others fighting for transparency all over the world. There are a lot more cases to dig up.

Will there be more info about the Maltese people listed in Panama Papers? Can you give any indication of what to expect?

I don’t know. I’ll be moving on to a new project that aims to automate much of the tedious work that investigative journalists do. A magic sieve, if you will. Hopefully something good will come out of that.

What’s your message to people interested in data journalism? What skills do you look for?

To journalists, learn to code — but don’t waste your time learning presentation-layer code like HTML or CSS, unless you’re particularly interested in making Web pages. If you want to do investigative work, learn things like SQL and Python. Learn to do advanced stuff in Excel to connect different data sets. Learn how to use the command line on your Mac to extract the text from ten thousand government gazettes. It’s fun, and you’ll break more stories.

I come from an engineering background and went into journalism because I thought we could change the way it’s done. And we did. So if there are other engineers out there reading this, I encourage you to come over to our side. What we look for are good ethics, imagination and that you’re nice people.

Christian is an award-winning journalist and entrepreneur who founded Lovin Malta, a new media company dedicated to creating positive impact in society. He is passionate about justice, public finances and finding ways to build a better future.

You may also love

View All