The database of "Panama document" is finally released, and the method of easy search by anyone is

Data detailing the actual state of "offshore transaction" using tax · haven (tax avoidance area)"Panama document" leaked from law firm "Mosac Fonseca"What is done is a big news on a global scale, but the International Searching Journalists Association (ICIJ), which exposed this Panama document under the white sun, went to 21 world tax havens including Panama and the British Virgin Islands We opened a database of the names and addresses of more than 210,000 corporations established and about 360,000 enterprises and individuals concerned on our website. This database is in a state that anyone can access it as long as it has the Internet, and ICIJ widely announces it to the world, and asks "to provide information if you find something worthy of investigation".

ICIJ releases database revealing thousands of secret offshore companies · ICIJ
https://panamapapers.icij.org/blog/20160509-offshore-database-release.html


When searching the database, click on the character string "searchable database" at the scroll page a little


When accessing for the first time, the following confirmation screen may appear. "There are also legitimate uses of offshore companies etc. ICIJ does not suggest or imply that companies and individuals included in the database are violating laws and there are also people with the same name of the same family It is necessary to investigate, so if you read the message saying "Please click the check box in the lower left corner and click" SUBMIT ".


The search page was displayed. Here, it is possible to narrow down by searching by country (Search by jurisdiction) such as search (Serch by country) and "Panama" and "British Virgin Islands" for tax avoidance areas.


First of all, I decide to narrow down by "Japan" which I have no choice but to mind. Select "Japan" from the pull-down menu and click "Search".


Then, a list of offshore companies related to Japan was displayed. In the initial state, "Offshore Entities" item is selected.


If you click on the link that was on the top of the trial, you will see the company name and foundation date (Incorporated), cancellation date (Inactivation), current status (Status), registered place in Has been displayed. In the lower part, a related diagram showing connection with offshore companies is displayed.


When you click on the company name in the related diagram, the location of the company and the source of the data ("Panama document" or "offshore leaks") etc. are displayed.


Returning to the search result screen, click on "Officers", and the personal names registered at the time of establishment are displayed.


When you click on "Itochu Corporation", the company name and related charts are displayed just as before.


In the search, it is also possible to narrow down by more concrete name etc. AlreadyIt is widely reportedTry putting the name of Rakuten chairman · Miki Valley ... ...


Information indicating that it is registered as an officer of a company called "TRADENET INVESTMENTS LTD." In the British Virgin Islands has been displayed.


The above search is narrowed down on the browser, but you can download the data converted from multiple original CSV files directly from the following page from the original database.

How to download this database | ICIJ Offshore Leaks Database
https://offshoreleaks.icij.org/pages/database

"(You may download an archive of all these files)HereClicking on it will download the compressed file. Note that as file downloads concentrate, the access to ICIJ increases and costs increase, so if possibleTorrent fileI recommend downloading and getting files with BitTorrent etc.


When you decompress the file, it contains 5 csv files as follows ... ...


You can see that hundreds of thousands of rows of huge databases are in it.