Sneak Peek of Panama Papers (Offshore Companies) Data Leak

Posted on May 20, 2016

Contributed by Ruonan Ding. She is currently in the NYC Data Science Academy 12 week full time Data Science Bootcamp program taking place between April 11th to July 1st, 2016. This post is based on her second class project - Shiny (due on the 4th week of the program)

The Shiny App can be found by clicking:

On May 9th, 2016, the International Consortium of Investigative Journalists released a searchable database with information on more than 200,000 offshore entities that are part of the Panama Papers investigation.  The data comes from the Panamanian law firm, Mossack Fonseca, one of the top players in the offshore world, and includes information about companies, trusts, foundations and funds incorporated in 21 tax havens, from Hong Kong to Nevada in the United States. It links to people in more than 200 countries and territories.

The purpose of this App is to give the users the access to look at the geographic development of this secretive offshore world from 1975 to 2015.  By definition, an offshore entity is that is incorporated in a low-tax jurisdiction.  The company is not liable to taxation in its country of incorporation, it will be taxed in the country where it carries on its business.  The two main purpose of having the offshore companies are first to have tax benefit and the other is to hide the final beneficial owners from this structure.  Again, the purpose of this App is to unveil this offshore world.  There are many complicated structures within itself and governed by different jurisdiction laws. 


Where does the U.S. Money Go?

Let's start with an example.  U.S. has been a significant player in the world of all the offshore companies.  That means these companies actually operate in the U.S. while having the jurisdiction somewhere off the shore.  First let's see where the money is from: the intermediaries, (law firms, banks, and accounting firms) facilitating the set up of the entities.  The map below shows the participating middleman's country.  You can see most of the world countries actively participating. They move the money in or out of U.S. in this case.

And where the money goes in the end?  the final jurisdiction is where the company is incorporated and need to fulfill the tax duties. As you can see on the graph, it's very much concentrated in Central America and Europe, and some countries in SouthEast Asia.

Entities Distribution By Location

The next tab is show the geographic distribution of the offshore entities.  It covers all the top countries with the most offshore entities.  The table below gives you the exact statistics by country.  As we can see, Hong Kong and Switzerland are the traditional offshore-onshore countries that offer not only low corporate tax but safety and good reputation for the entities.

Number of Entities Over Time

The number of offshore entities peaked at year 2005 till 2008 before the financial crisis.  The graph below gives you the option of exploring the time wide development by different jurisdiction.  The drop down selected the popular Central America jurisdictions.

Entities Status As of 2015

The entities status shows the purpose of having these entities.  The majority of the entities are no longer active.  26% of the all entities are still available.  That means most of them are not set up for the operational purpose.  This could explain why people have the presumption that offshore entities are not a typical corporation.  There are multiple purpose of establishing offshore entities.


There are legitimate uses for offshore companies and trusts.  The purpose of this App is to give you an overview of the database in hope to unveil some of this secretive world.  It does not suggest or imply that any persons, companies or other entities included in the ICIJ Offshore Leaks Database have broken the law or otherwise acted improperly.




About Author

Ruonan Ding

Ruonan Ding has more than five years of experience in the actuarial science and financial field across asset management and insurance sectors. She was a pricing actuary for a property and casualty company, a lead analyst in capital...
View all posts by Ruonan Ding >

Related Articles

Leave a Comment

Rigoberto September 16, 2017
For hottest news you have to pay a visit the web and on world-wide-web I found this web site as a best site for latest updates.
Georgetta August 16, 2016
This is the appropriate website for anyone who wants to learn about this topic. You comprehend so much its almost difficult to argue with you (not that I really would desire… HaHa). You definitely set a brand new spin on a topic thats been written about for years. Great stuff, simply fantastic!
Sneak Peek of Panama Papers Data Leak | Open Data Science July 22, 2016
[…] Originally posted at […]

View Posts by Categories

Our Recent Popular Posts

View Posts by Tags

#python #trainwithnycdsa 2019 2020 Revenue 3-points agriculture air quality airbnb airline alcohol Alex Baransky algorithm alumni Alumni Interview Alumni Reviews Alumni Spotlight alumni story Alumnus ames dataset ames housing dataset apartment rent API Application artist aws bank loans beautiful soup Best Bootcamp Best Data Science 2019 Best Data Science Bootcamp Best Data Science Bootcamp 2020 Best Ranked Big Data Book Launch Book-Signing bootcamp Bootcamp Alumni Bootcamp Prep boston safety Bundles cake recipe California Cancer Research capstone car price Career Career Day citibike classic cars classpass clustering Coding Course Demo Course Report covid 19 credit credit card crime frequency crops D3.js data data analysis Data Analyst data analytics data for tripadvisor reviews data science Data Science Academy Data Science Bootcamp Data science jobs Data Science Reviews Data Scientist Data Scientist Jobs data visualization database Deep Learning Demo Day Discount disney dplyr drug data e-commerce economy employee employee burnout employer networking environment feature engineering Finance Financial Data Science fitness studio Flask flight delay gbm Get Hired ggplot2 googleVis H20 Hadoop hallmark holiday movie happiness healthcare frauds higgs boson Hiring hiring partner events Hiring Partners hotels housing housing data housing predictions housing price hy-vee Income Industry Experts Injuries Instructor Blog Instructor Interview insurance italki Job Job Placement Jobs Jon Krohn JP Morgan Chase Kaggle Kickstarter las vegas airport lasso regression Lead Data Scienctist Lead Data Scientist leaflet league linear regression Logistic Regression machine learning Maps market matplotlib Medical Research Meet the team meetup methal health miami beach movie music Napoli NBA netflix Networking neural network Neural networks New Courses NHL nlp NYC NYC Data Science nyc data science academy NYC Open Data nyc property NYCDSA NYCDSA Alumni Online Online Bootcamp Online Training Open Data painter pandas Part-time performance phoenix pollutants Portfolio Development precision measurement prediction Prework Programming public safety PwC python Python Data Analysis python machine learning python scrapy python web scraping python webscraping Python Workshop R R Data Analysis R language R Programming R Shiny r studio R Visualization R Workshop R-bloggers random forest Ranking recommendation recommendation system regression Remote remote data science bootcamp Scrapy scrapy visualization seaborn seafood type Selenium sentiment analysis sentiment classification Shiny Shiny Dashboard Spark Special Special Summer Sports statistics streaming Student Interview Student Showcase SVM Switchup Tableau teachers team team performance TensorFlow Testimonial tf-idf Top Data Science Bootcamp Top manufacturing companies Transfers tweets twitter videos visualization wallstreet wallstreetbets web scraping Weekend Course What to expect whiskey whiskeyadvocate wildfire word cloud word2vec XGBoost yelp youtube trending ZORI