Sign in / up

back to article Panama Papers finally online

A searchable database of 320,000 offshore companies and trusts from the Panama Papers and the Offshore Leaks investigations is now online. That's the data leaked from Panamanian legal firm Mossack Fonseca and ultimately given to the International Consortium of Investigative Journalists to pore over. You can find out more on …

COMMENTS

Post your comment
House rules Send corrections
Add to 'My topics' unstar *
  1. Justin Clift

    Torrent file

    Although they make a torrent file available:

    https://cloudfront-files-1.publicintegrity.org/offshoreleaks/data-csv.zip.torrent

    It's just their processed database data in CSV format, 36MB in total:

    $ unzip ../offshoreleaks_data-csv.zip

    Archive: ../offshoreleaks_data-csv.zip

    creating: offshore_leaks_csvs/

    inflating: offshore_leaks_csvs/Addresses.csv

    inflating: offshore_leaks_csvs/Entities.csv

    inflating: offshore_leaks_csvs/Intermediaries.csv

    inflating: offshore_leaks_csvs/Officers.csv

    inflating: offshore_leaks_csvs/all_edges.csv

    $

    0 0 Reply
    1. Jonathan Richards 1
      Reply Icon

      Re: Torrent file

      Indeed, but a substantial quantity of data if you want to extract some relationships:

      /offshore_leaks_csvs-20160510$ wc -l *.csv

      151128 Addresses.csv

      1269797 all_edges.csv

      319422 Entities.csv

      23643 Intermediaries.csv

      345646 Officers.csv

      2109636 total

      So, approximately 1.27 million relationships between 840 thousand nodes.

      0 0 Reply
      1. Jonathan Richards 1
        Reply Icon

        Re: Torrent file

        ... and a rich set of relationships, too, with over 80 unique labels for those 1.27 million relationships, e.g.

        Auditor of; Beneficial owner of; Nominee Director of; Power of Attorney of; same address as; Tax Advisor of

        Now I shall embark on a script to convert the CSVs to Graphviz :)

        0 0 Reply

POST COMMENT House rules

Not a member of The Register? Create a new account here.

Forgotten password ?

  • Enter your comment

  • Add an icon

Anonymous cowards cannot choose their icon