ICIJ: OFFSHORE LEAKS DATABASE LAUNCHED – TIPS ON HOW TO USE IT

Today, we’re thrilled to share that you can now explore structured data from the Pandora Papers on the Offshore Leaks Database, which has been updated with information related to two of the 14 offshore service providers at the heart of the investigation.

“It’s the secrecy that enables wrongdoing,” says director Gerard Ryle on why ICIJ believes that this data should be freely available to all. “The Offshore Leaks Database helps put the power of information back where it belongs — in the hands of the public.”

With this latest addition, the database strips away the secrecy of hundreds of thousands of offshore entities stemming from five different ICIJ investigations, linking to people and companies in more than 200 countries and territories. It uncovers an unprecedented amount of information on beneficial owners, or true owners, of entities registered in secrecy jurisdictions all over the world. (Here’s some tips on how to get started with using the database.)

 

How to use the Offshore Leaks Database

Tips to make the most of the data

The ICIJ Offshore Leaks database allows you to search through more than 800,000 offshore companies and trusts. It comes from five different leaks, and links to people and companies in more than 200 countries and territories.

More than 200,000 entities were registered by the Panamanian law firm Mossack Fonseca, whose inner workings were exposed in the Panama Papers, and 100,000 entities incorporated through Portcullis Trustnet and Commonwealth Trust Limited, two offshore service providers exposed as part of the 2013 ICIJ Offshore Leaks investigation.

The largest collection of entities comes from the Paradise Papers investigation. Between November 2017 and February 2018 ICIJ added more than 290,000 records from offshore law firm Appleby and seven corporate registries: Aruba, Bahamas, Barbados, Cook Islands, Malta, Nevis and Samoa. While entities registered in those jurisdictions didn’t necessarily use offshore services providers, and some are local businesses, ICIJ believes that the publication of the registries helps provide more transparency to the general public.

Beneficial ownership data on more than 15,000 entities from the Pandora Papers investigation were added on December 6th, 2021.

The Offshore Leaks database offers multiple ways to explore the data, including searching by names or keywords, looking for country-specific connections or browsing offshore entities by jurisdiction.

Find a specific person or company

Let’s say you are researching property ownership in a city like London and come across an offshore company listed as an owner of a £750,000 commercial building in the British Land Registry. The registry does not tell you who is actually behind the company “Moonlight Estates Limited.”

But the Offshore Leaks database might be able to help. Start by typing the “Moonlight Estates” into the search box and hit “Search.” Typing only the first part of the company name will show partial matches, so it won’t matter if “Limited” is spelled “Ltd” or “Ltd.” in the data. As a general rule, we encourage you to try different spellings when looking for a person of a company.

How to 1

The results page returns one company named “Moonlight Estates Limited,” connected to Ecuador and registered in the British Virgin Islands. Had the results page returned several companies with the name “Moonlight Estates Limited,” you could have filtered by jurisdiction, for example by clicking on “British Virgin Islands” in the right menu.

How to 2

Clicking on the company’s name will lead you to a page with more information about that company and who’s behind it. In addition to basic information about the company, you’ll also see an interactive visualization that allows you to explore the connections between this company and related addresses, shareholders, beneficiaries and more. There’s also a text list of these connections and links out to OpenCorporates (for additional corporate data).

Take a look at the visualization, and you’ll see that the shareholder and beneficiary of “Moonlight Estates Limited” is actually Ayad H. Allawi, the former prime minister of Iraq.

How to 3

Clicking on the beneficiary node shows the address connected to Allawi, which enables you to check if it is indeed the former prime minister. Clicking on the shareholder node shows you another company for which Allawi is a listed shareholder, “Foxwood Estates Limited.”

If you check the British Land Registry, you can see that Foxwood Estates Limited owns a townhouse worth £2.75m in Kensington. Clicking on Foxwood Estates Limited in the visualization will reveal that another director for this company is “Ayad Allawi” (without an H), also connected to another company.

How to 4

Of course, if you already knew that Allawi was in the Panama Papers data, you could also have found his name by typing it into the search box. On the database’s landing page select the “Search by country” tab (the “Search by jurisdiction” tab is for company searches only, not for individuals), type in “Ayad Allawi” and click “Search.”

How to 5

The results page lists all the officers with that name. From the results page you can already see which countries those officers are connected to.

When you click on the name, you get information and a visualization showing the connections between Ayad Allawi and different addresses and offshore entities. Clicking on the different nodes will enable you to find all the information you previously found by starting with the company search.

How to 6

How to 7

One final tip when searching for a specific name: ICIJ is publishing the names as they were typed in the leaked records. This means that there could be multiple spellings or even misspellings in how names are listed. We encourage you to try different spellings. If you’re not sure about the spelling of a name, you can also use a wild card – adding an asterisk (*) at the end of a name, or searching for multiple possible spellings. For example, you could try searching for Allaw* or Allawi~2.

Find all the names connected to a country

ICIJ connected the names of individuals and offshore entities in the database to more than 200 countries and territories through their listed addresses. This way, if a person is the beneficial owner of a company and is connected to an address in France, the person will appear if you search for all the names associated with France.

To do that, make sure you check the filter entitled “Linked countries.” Open the drop-down menu by clicking on the arrow and “All countries.” Select the country you are looking for, in this case France.

How to 8

The search results are displayed in sections: you can see the offshore entities (these are the companies, trusts, foundations and more), the officers (which includes directors, shareholders and/or beneficiaries), intermediaries (the lawyers and service providers who help set up or act as the registered agents for the offshore companies), and the addresses connected to that country.

How to 9

In the case of offshore entities, you can also add a second filter to focus on companies from a specific jurisdiction. Select the jurisdiction from the list in the right menu. For example, if you search for “France” and then filter by the jurisdiction “Bahamas,” you will see all the companies connected to France that are registered in the Bahamas.

If you select the filter “Officers,” you’ll be able to see all the people connected to France. For example former minister Jérôme Cahuzac.

How to 10

Clicking on his name will reveal that he is connected to the company “Cerman Group Limited” in the Panama Papers data.

How to 11

Browse by jurisdiction

Is there a particular tax haven or secrecy jurisdiction you’re curious about? You can browse all the companies registered in one of the jurisdictions included in our data using the “Search by jurisdictions” filter. Click on the tab, then select the jurisdiction from the drop-down menu. Leave the search box blank and hit “Search.”

You can browse the list of offshore entities and can click through to find out more information about their offshore connections.

You can also switch between the jurisdictions using the “Filter by jurisdiction” menu on the right menu. Read more about how secretive some of these jurisdictions are here.

We encourage you to be careful when describing the information contained in this database. There are legitimate uses for offshore companies and trusts, and we do not intend to suggest or imply that any people, companies or other entities have broken the law or otherwise acted improperly. In addition, many people and entities have the same or similar names. We suggest you confirm the identities of any individuals or entities located in the database based on addresses or other identifiable information. In the case of the data leaked from company registries as part of the Paradise Papers investigation, entities registered in those jurisdictions didn’t necessarily use offshore services providers. Some are local businesses. ICIJ believes that the publication of the registries helps provide more transparency to the general public.

In addition to using the online Offshore Leaks database, you can also download the full dataset and explore all the data on your computer. We are making the raw data available for download here.

ICIJ has been investigating the offshore economy for more than eight years, and will keep digging into these leaked files. We welcome any tips you may find searching this database. Please send them to us here. If you wish to use a more secure method to contact us or want to share sensitive information, please consider using an alternative method, such as encrypted email or messaging. More details are available here.

Source:    https://offshoreleaks.icij.org/pages/howtouse?utm_source=ICIJ&utm_campaign=10332625a1-2021206_WeeklyEmail&utm_medium=email&utm_term=0_992ecfdbb2-10332625a1-83412166