unravel the panama papers - cleraun media · icij officer leaks database emma charlotte duerre...

How ICIJ used Technology to Unravel the Panama Papers

Cécile Schilis-Gallego

Data JournalistThe International Consortium of Investigative Journalists (ICIJ)

@csgallego | @ICIJorg

16th Cleraun Media Conference • Nov. 12, 2016

Almost 200 journalistsBased in 65 countries

“Our aim is to bring journalists from different countries together in teams - eliminating rivalry and promoting collaboration.

Together, we aim to be theworld’s best cross-border investigative team.”

icij.org/about

The International Consortium ofInvestigative Journalists

You may remember us from...

What are the Panama Papers?

Nearly one in 10 of the 31,000 tax haven companies that own British property are linked to Mossack Fonseca

#panamapapers

Iceland, April 4th 2016

How did we do it?

INSIDE THE 2.6 TB

INSIDE THE 2.6 TB

From Offshore Leaks to the

Panama Papers

HOW IT USED TO WORK...

Jaime Rotondo RussoMonte Esquirnza 26, 4°28010 Madrid Spain

BACK IN JUNE 2013...

BACK TO THE FUTURE...

MAGIC!!

➢ I click on “dots” and I find stories!

➢ I discover stories thanks to fuzzy searching

➢ Find shortest path

What is available now?

100,000+ companiesPortcullis Trustnet and Commonwealth Trust Limited

200,000+ companiesMossack Fonseca

NODES

entity

intermediary

address

There may be duplicates

Suuuuper dirty data

You can check it at offshoreleaks.icij.org

Cécile Schilis-Gallegocschilisgallego@icij.org | @csgallego