This database contains information on more than 520,000 offshore entities that are part of the Panama Papers, the Offshore Leaks, the Bahamas Leaks and Appleby’s structured data from the Paradise Papers investigation. The data links to people and companies in more than 200 countries and territories.
The real value of the database is that it strips away the secrecy that cloaks companies and trusts incorporated in tax havens and exposes the people behind them. This includes, when available, the names of the real owners of those opaque structures. In all, the interactive application reveals more than 370,000 names of people and companies behind secret offshore structures. They come from leaked records and not a standardized corporate registry, so there may be duplicates. In some cases, companies are listed as shareholders for another company or a trust, arrangement that often helps obscure the flesh-and-blood people behind offshore entities.
ICIJ obtained the data through four massive leaks. One comes from the firm Appleby and data from some politicians featured in the Paradise Papers investigation. In November 2017 ICIJ added the structured data from the Paradise Papers connected to Appleby. Another one comes from Panamanian law firm Mossack Fonseca, whose inner workings were exposed in the Panama Papers investigation published in April 2016 in conjunction with Süddeutsche Zeitung and more than 100 other media partners. Another portion of the offshore entities were incorporated through Portcullis Trustnet (now Portcullis) and Commonwealth Trust Limited, two offshore service providers exposed as part of ICIJ’s 2013 Offshore Leaks exposé. This was the first information added to this database when it was released in June 2013, which was then produced in conjunction with Costa Rican newspaper La Nación. ICIJ added a third installment of information on September 21, 2016 as part of the Bahamas Leaks investigation based on a trove of data from the official corporate registry of the Bahamas. The full Paradise Papers structured data will be released in the coming weeks.
The database does not disclose the totality of the leaked records. It doesn’t divulge raw documents or personal information en masse. It contains a great deal of information about company owners, proxies and intermediaries in secrecy jurisdictions, but it doesn’t disclose bank accounts, email exchanges and financial transactions contained in the documents.
ICIJ is publishing the information in the public interest. While many of the activities carried out through offshore entities are perfectly legal, extensive reporting by ICIJ and its media partners for more than five years has shown that the anonymity granted by the offshore economy facilitates money laundering, tax evasion, fraud and other crimes. Even when it’s legal, transparency advocates argue that the use of an alternative, parallel economy undermines democracy because it benefits a few at the expense of the majority.
Read more about why ICIJ is making this information public here. The questions and answers below address the most frequent questions about this data. If you still have questions after reading them, please get in touch with us.
The Offshore Leaks data is current through 2010. The Panama Papers data is current through 2015. The Bahamas Leaks data is current through early 2016. The Paradise Papers Appleby data is current through 2014 and the Paradise Papers Bahamas, Lebanon, Malta and Barbados data is current through 2016.
No, there are legitimate uses for offshore companies and trusts. We do not intend to suggest or imply that any people, companies or other entities included in the ICIJ Offshore Leaks Database have broken the law or otherwise acted improperly.
The Offshore Leaks Database was first published on June 14, 2013 with the names of more than 100,000 offshore entities incorporated through agents Portcullis Trustnet and Commonwealth Trust Limited. On October 11, 2013 ICIJ provided the possibility to search these names by country.
On May 9, 2016 at 8pm EDT, ICIJ added more than 200,000 offshore entities from the Panama Papers investigation, incorporated through agent Mossack Fonseca. We also launched a new site design, with more functionalities. That version of the database included address connections that were incorrect. This error was fixed on May 10 11pm EDT.
On May 24 we updated some records with a better country identification, including connections to South and North Korea, and fixed a website glitch that did not display North Korea, French Polynesia and Tonga in the dropdown box of the homepage. We also included jurisdiction information for some entities that were previously labeled as "undetermined".
On September 21, ICIJ added more than 175,000 companies, trusts and foundations incorporated in the Bahamas.
On November 5, 2017, ICIJ added data from some politicians featured in the Paradise Papers investigation and on November 17 ICIJ added records connected to around 25,000 entities that were connected to Appleby. ICIJ will be releasing the full structured data linked to this investigation in the coming weeks.
We will continue to provide information about any updates to the database in this section as they occur.
Why can’t I find some names in the database that appeared in the Paradise Papers, the Panama Papers and the Bahamas Leaks stories?
While the ICIJ Offshore Leaks Database opens up a world that has never been shown in this much detail, not every officer of a company that appears in the Paradise Papers, the Panama Papers and the Bahamas Leaks shows up in the public database. This is because that information about ownership is often buried in emails, power-of-attorney letters and internal notes and cannot easily be extracted in a systematic manner. In addition, Mossack Fonseca often failed to collect the necessary information about the real owners of companies, relying instead on banks and other intermediaries to keep track of that essential data. In the case of the Bahamas Leaks, this is because many directors of offshore entities are found in unscanned registers that cannot be easily extracted in a systematic manner. While we faced a similar situation with the original Offshore Leaks data, those original databases from Portcullis Trustnet and Commonwealth Trust Limited contained more ownership information.
On November 5, 2017 and on April 3, 2016 ICIJ published interactive applications with detailed information on dozens of politicians in the leaked files. In order to better tell those specific stories, ICIJ manually added information from the Paradise Papers and the Panama Papers documents about the politicians to this database. You will identify these records easily because they include a note that says “record manually added from leaked documents.” In those cases ICIJ only registered the information connected to the public figure and not that of the rest of the people that may be associated to an offshore entity, whose information could have been inside the documents. On September 21, 2016, ICIJ performed a similar manual addition from documents within the Bahamas Leaks in the case of some former public officials and others.
The names of people and entities in this website come from leaked files. ICIJ used reverse engineering techniques to extract the information from them and build this database. In most occasions, the original records connected names with codes, which are used as unique identifiers. However, this was not always the case. For example, shareholder and beneficiary records in the Panama Paper lacked a code. In the case of agent Commonwealth Trust Limited, there were cases where the name was the same but it was associated with different codes. This means that sometimes what seems to be the same name could appear as two or more different nodes in this database.
ICIJ did not merge records with similar names, so there may be duplicates. However, we did merge shareholder and beneficiary records in the Panama Papers data if the name and the address were the same. We did this because those records had no unique identifiers in the leaked databases.
Names could have typos or be misspelled, but this is how they appear in the original databases ICIJ obtained. We did not perform any cleaning or standardization on the names, except for some slight cleaning on the entity names in the Panama Papers data to split the current from the former name of the company (both were sometimes together in Mossack Fonseca’s database).
In order to facilitate the exploration of the data, ICIJ created links between nodes with similar names and addresses. Those links also connect the Paradise Papers, the Bahamas Leaks, the Panama Papers and the Offshore Leaks data, the different sources of information that make up the database. ICIJ incorporated one additional node type with the Paradise Papers release in November 2017 that is connected to the Appleby data. This node “other” connects all the entities that are part of a holding group. These connections were not created by ICIJ, but are a direct reflection of Appleby’s data. Because this is a database that connects people and companies, isolated entities or people with no apparent connections have been removed. Isolated addresses have also been removed.
Because this is a database that connects people and companies, isolated entities or people with no apparent connections have been removed. Isolated addresses have also been removed.
ICIJ performed automatic identification of country names within all the addresses contained in the database. We used geocoding tools to complement the process. Some of the addresses ended up being manually reviewed by our team. ICIJ also shared these identifications with the reporting team of more than 370 journalists and improved the results based on their feedback.
Once a country was determined, the connected record --an entity, an officer or an intermediary-- was linked to that country. The record was tagged as a having a “not identified” country, if no match could be made. The limitations to this whole identification process include potential data entry and country matching errors. If you find a name that is identified to the wrong country please contact us.
The original addresses from the leaked records were not standardized, containing multiple spellings or ways of describing the same address. ICIJ did not perform any cleaning on the addresses. This may mean that what a human eye appears to be same address, in our database appears as several records.
The information contained in the ICIJ Offshore Leaks Database is just a fraction of the leaked files of the Paradise Papers, the Panama Papers, the Offshore Leaks and the Bahamas Leaks investigations. We recommend caution before drawing any conclusions, as many people and entities have the same or similar names. We suggest you confirm the identities of any individuals or entities found in the database using addresses or other identifiable information.
ICIJ will release the structured data connected to the Paradise Papers investigation in the coming weeks. Until then, some search results might not show all the connections related to entities and officers.
This database contains information about offshore entities, officers, intermediaries and addresses:
- Offshore Entity:
- A company, trust or fund created in a low-tax, offshore jurisdiction by an agent.
- Agent (registered agent or offshore service provider):
- Firm that provides services in an offshore jurisdiction to incorporate, register and manage an offshore entity at the request of a client.
- A person or company who plays a role in an offshore entity.
- A go-between for someone seeking an offshore corporation and an offshore service provider -- usually a law-firm or a middleman that asks an offshore service provider to create an offshore firm for a client.
- Contact postal address as it appears in the original databases obtained by ICIJ.
These are some useful definitions of other terms used in this application, which originate from the terminology that appeared in the leaked records:
- Beneficial owner (ultimate beneficial owner or beneficiary):
- The person who is the true owner of a company. In the offshore world, the identity of beneficial owners is often kept secret.
- Bearer shares:
- Whoever physically holds a certificate of shares is considered the owner of the shares. Bearer shares provide one of the deepest levels of secrecy. Many countries have banned bearer shares because they are considered a facilitator of tax evasion and money laundering. In the database, bearer shares are sometimes referred to in Spanish as “Portador.”
- A person or company that acts on behalf of the beneficial owner of an entity to provide an extra level of secrecy.
- Nominee director:
- Stand-in who controls a company on paper but exercise no real authority over its activities.
- Nominee shareholder:
- A person who is listed as a shareholder on a company’s documents but has no real power over the company or claim to its assets. This is common practice in offshore financial structures to hide the identity of the real owner.
- Power of attorney:
- Authorization given to a person to represent the offshore company. It can confer rights that include managing the company without any limitation, carrying out contracts, purchasing products and borrowing or lending money. Each authorization notes which powers are granted to the person who will act on behalf of the company and whether they are general or specific.
- Incorporation Date:
- The date when an offshore entity was created.
- Dormancy Date:
- The date when an offshore entity stopped being active.
- Inactivation Date:
- The date when a client told the agent to deactivate the offshore entity, which could be reactivated at a later date.
- Struck off Date:
- A company becomes struck off when it fails to be in good standing, which happens when it fails to pay license fees. In the offshore world this is the equivalent to closing an entity, although it can be reactivated at a later date if the fees start being paid again.
- Sundry Account:
- An internal account created by the offshore services firm to record miscellaneous charges of an officer or master client.
- Tax status:
- In this database, it is information that relates to the jurisdiction where an entity may have fiscal duties.
And here’s some terminology connected to trusts:
- A legal arrangement in which an individual transfers assets owned by him/her to a trustee.
- A person who holds title to the assets in a trust and is responsible for administering the assets on behalf of the beneficiaries of the trust.
- A person who is entitled to certain financial benefits under a trust arrangement. Sometimes beneficiaries are not aware of their role in a trust because the settlor or the trustee have not notified them.
- An advisor to a trust settlor who oversees the work of the trustee.
- Trust settlor:
- A person who creates a trust or transfers assets to an already existing trust.
- It may indicate that the company chose not to renew a payment or otherwise missed a payment necessary to remain active on the country's corporate registry. It does not necessarily mean the company defaulted.
OpenCorporates is a website with information on more than 99 million companies (as of May 9, 2016). It claims to be “the largest open database of companies in the world”. The website was very useful for the reporting of ICIJ’s offshore investigations. As the offshore economy is directly connected to our regular economy and its regular companies, we believe there is an added value for connecting the opaque structures exposed in the ICIJ Offshore Leaks Database with OpenCorporates.
ICIJ also linked to Google Maps in the pages showing addresses to provide additional information on its geolocation.
The connection to both sites was done automatically and it may not yield any results. We also recommend you to double check the result obtained refers to the same record in this database.
The Panama Papers and Offshore Leaks datasets reveal the names of the people behind opaque offshore structures and expose these networks of secrecy. Graph databases are the best way to explore the relationships between these people and entities — it’s much more intuitive to use for this purpose than a SQL database or other types of NoSQL databases. In addition, graphs allow to understand these networks in a very intuitive way and easily discover connections.
Yes, of course! Follow the instructions in this link. Remember that the ICIJ Offshore Leaks Database is licensed under the Open Database License and contents under Creative Commons Attribution-ShareAlike license. Always cite the International Consortium of Investigative Journalists when using this data.
The easiest way to contact us about any issues related to this database is to fill this form. From there, we’ll answer any emails that have to do with tips, questions or errors you may find in the database. If you have any general queries to ICIJ, please email email@example.com.
If you wish to contact us in a secure manner, follow the instructions in this page, which includes a link to our Secure Drop server.
If you’re a journalist wanting access to the totality of the leaked files or interested in collaborating with ICIJ, please send an email to firstname.lastname@example.org. We welcome these new offers of collaboration, but also ask for your patience as we are vetting the requests carefully and may only add a few new partners to the investigation.
This is not easy data to understand. It took great commitment from all of our current media partners to find stories of important public interest. ICIJ’s data unit provided training to our partners to make sure that everyone understood the intricacies of the information they were reporting on.
ICIJ is a non-profit organization. We rely heavily on charitable foundations and on financial support from the public. We do not take funding from governments. Without our readers’ support, we cannot exist. Recent ICIJ funders include: Adessium Foundation, Open Society Foundations, The Sigrid Rausing Trust, The Ford Foundation, Fritt Ord Foundation and the Pulitzer Center on Crisis Reporting. We also receive support from Australian philanthropist Graeme Wood.