TIPS

How to investigate companies found in the Offshore Leaks Database

The final in our three-part series: Now you can explore our database, it’s time to look at other publicly available data.

This is the final of a three-part series on ways to search our Offshore Leaks Database that now includes more than 680,000 entities from 55 secrecy jurisdictions. The first installment was How to search the Offshore Leaks Database by location. The second looked at the networks and metadata in the database.

The Offshore Leaks Database is a starting point for investigating activities offshore. ICIJ has published data on more than 680,000 entities as well as 600,000 directors and shareholders. More data will be added in the coming weeks. (Sign-up to make sure you’re the first to know!) Yet, in order to to investigate comprehensively you might need to do research outside the database.

ICIJ partners often run matches on the data in order to find interesting leads. For example, crossing a list of EU current and former commissioners with the Bahamas Leaks data led us to the undisclosed Bahamian company of the EU’s former commissioner for competition policy, Neelie Kroes.

Former EU commissioner Neelie Kroes
Former EU commissioner Neelie Kroes Image: Photo: AP Photo/Geert Vanden Wijngaert

1. Download and reference the data

One way to search further is to download the data from the database, then cross reference it with other lists such as the Forbes 500 list or a list of elected officials, using tools such Open Refine or Excel’s Fuzzy Lookup add-on (available only for the Microsoft version of Excel).

This will show you which names appear in both the list you selected and the Offshore Leaks Database. Those tools also compare series of characters to find names that are similar but not exactly the same. It would identify as similar “John Doe,” “John R. Doe” and “Doe, John” for example, a handy feature given names can sometimes be written differently or be misspelled.

2. Check for false positives

There could, of course, lead to false positives, meaning an individual or company with the same name but that is not, after verification, the same company or person. The more common the name – Maria Rivera for example – the more likely it is that the director or shareholder you have spotted is not the person you were looking for.

In order to check those results you can go back to the Offshore Leaks database and search for that name. That way, you will find other companies that person is connected to and also expand the nodes connected to those companies by double clicking on them.

The Duchy of Lancaster - Node from Offshore Leaks Database
By clicking on this orange “node” you are able to see all of the connections a person has in the data.

Are the other shareholders and directors family members? Can we link them to the person we are searching for using external sources such as news articles or corporate websites?

3. Get more information from company registries

You might also want to use company registries to buy information. The Aruba, Bahamas or Malta registries for example allow you to download basic documentation on companies such as incorporation forms or notices from the registries for a fee. Those documents might give you information that is not available in the Offshore Leaks database, which only makes structured data available.

Happy searching! As always, don’t forget to tell us what you find in the data.

And don’t forget, ICIJ believes this data should be publicly-available, and we need your support to keep it that way.

Make a donation and help us keep it free, online and accessible.

RUSSIA

New US sanctions target trust companies and corporate service providers for the first time

May 12, 2022
European Parliament
Accountability

Pandora Papers shed light on ‘gatekeepers’ of dirty money says European watchdog

May 09, 2022
MONEY LAUNDERING

As US pledges renewed fight against dirty money, head of financial crime agency says funding shortfalls have caused delays

Apr 29, 2022
Pandora Papers on screen
AWARDS

Pandora Papers investigation receives National Headliner Award, other honors

Apr 27, 2022
IMPACT

Lawmakers in US push to uncover riches shielded by state secrecy laws

Apr 21, 2022
IMPACT

Sweden’s anti-corruption agency launches investigation into suspicious Ericsson payments in Iraq

Apr 20, 2022
ICIJ is dedicated to ensuring all reports we publish are accurate. If you believe you have found an inaccuracy let us know.