Occupations of persons from Panama Papers

Posted on Updated on

Can we get an overview of the occupations of the persons associated with the Panama Papers? Well … that might be difficult, but we can get a biased plot by using the listing in Wikidata, where persons associated with the Panama Papers seems to be tagged and where their occupation(s) is listed. It produces the plot below.

PanamaPapersOccupations

It is fairly straightforward to construct such a bubble chart given the new plotting capabilities in the Wikidata Query Service. Dutch Wikipedian Gerard Meijssen seems to have been the one who has entered the information in Wikidata linking Panama Papers to persons via the ‘significant event‘ property. How complete he yet has managed to do this I do not know. Our Danish Wikipedian Ole Palnatoke Andersen set up a page on the Danish Wikipedia at Diskussion:Panama-papirerne/Wikidata tabulating with the nice Listeria tool of Magnus Manske. Modifying Ole’s SPARQL query we can get the count of occupations for the persons associated with the Panama Papers in Wikidata.

SELECT ?occupationLabel(count(distinct ?person) as ?count) WHERE {
  ?person wdt:P793 wd:Q23702848 ; wdt:P106 ?occupation .   
  service wikibase:label { bd:serviceParam wikibase:language "en" . }
} group by ?occupationLabel

Some people may see that politicians are the largest group, but that might simply be an artifact of the notability criterion of Wikidata: Only people who are somewhat notable or are linked to something notable are likely to be included in Wikidata, e.g., the common businessman/woman may not (yet?) be represented in Wikidata.

The bubble chart cuts letters of the words for the occupation. ‘murd’ is murderer. Joaquín Guzmán has his occupation set to murderer in Wikidata, – without source…

 

65 thoughts on “Occupations of persons from Panama Papers

    addshore said:
    May 11, 2016 at 10:14 am

    Reblogged this on Addshore.

    Sophie said:
    May 11, 2016 at 5:58 pm

    One of those bubbles seems to indicate “muderer” as an occupation. Trying to figure out what else that could be (but too lazy to look it up).

    GerardM said:
    May 11, 2016 at 6:10 pm

    I am amused that I am a Wikipedian. More a Wikimedian :)

    […] For hvem hvilket erhverv de nævnte i Panama Papers har, se her. […]

    Count Ludwig said:
    May 11, 2016 at 9:23 pm

    Area of the bubbles, or radius? If radius then misleading. If area then why not easily comparable bar chart?

      Finn Årup Nielsen responded:
      May 11, 2016 at 9:28 pm

      The count is 86 for politician and 25 for businessperson. The lowest has a count of 1. I guess the count is proportional to area then. I am just using the standard Wikidata Query Service plotting facility at https://query.wikidata.org

      Si Rees said:
      May 12, 2016 at 3:14 pm

      Possibly because a bar chart would have to be extremely wide, still have tiny fonts for the headers and this fits quite well onto a smaller space?

    Ignacio Oyarzún said:
    May 11, 2016 at 9:51 pm

    0% librarian, heck yeah.

    Subfl said:
    May 11, 2016 at 11:05 pm

    People in medical professions seem to be separated by specialization, which might be misleading. Could someone do a similar graph putting ophthalmologists, surgeons, , physicians, dentist etc all together? Otherwise one of the best paid professions would seem underrepresented…

      Finn Årup Nielsen responded:
      May 12, 2016 at 8:29 am

      Note that the number of occupations making up the plot is limited. The plot is made from what is in Wikidata only, – and that is not much compared to the full Panamapapers dataset. One should urge caution in the interpretation. “Ophthalmologists” are only two people: Mehriban Aliyeva and Bashar al-Assad.

    space said:
    May 12, 2016 at 4:46 am

    What the heck is the occupation labeled “pain”? Painter? Also, what’s the difference between “drug t” and just “drug”?

    E said:
    May 12, 2016 at 8:53 am

    I assume “murd” (light orange to the right) doesn’t mean “Murderer” as in professional assassin but what does it mean?

      Finn Årup Nielsen responded:
      May 12, 2016 at 9:26 am

      It does! A mexican drug lord had his occupation set to ‘Murderer’, but yesterday that was deleted.

    Kaz Lokuciewski said:
    May 12, 2016 at 10:09 am

    The globalists have creates a fantastic system where a % of the gains of labour are collected offshore and used to hold a slave like bond over citizens of the functioning economies.

    The solution remains simple. Tax the assets at a rate that repairs the market. 100% for assets owned by unknown entities of known entities with unregistered creditors.

    Provide no legal protection for entities that lack a living beneficiary trail.

      Jacqueline Casey said:
      May 14, 2016 at 9:32 pm

      Yep

    […] Qual é a principal profissão dos envolvidos nos Panamá Papers? Destaco os oftalmologistas, com direito a categoria própria. De resto só me apraz dizer que isto da circulação de capitais é uma vergonha, precisamos de mais Estado e de mais políticos para zelarem por nós e garantirem que os maus, zás!, cadeia. […]

    Bhoom S. (@hypotheses) said:
    May 12, 2016 at 11:53 am

    just my two cents. It would be nice to have a frequency table to look at as a supplement as well.

      Finn Årup Nielsen responded:
      May 12, 2016 at 12:06 pm

      That is indeed readily available in the Wikidata Query Service where the data comes from: Go to https://query.wikidata.org/?query= and copy and paste the “select” statement above into the edit field and press Run. They you get the frequency table. (But note that there is something wrong with the https://query.wikidata.org at the moment. Sometimes it returns a blank page. The Wikidata operators are aware of this and I believe they are trying to fix it).

        sando2000 said:
        May 12, 2016 at 12:23 pm

        There are two “cric”s there. I’m guessing Cricket player and Cricket umpire. Who are the umpires?

        Finn Årup Nielsen responded:
        May 12, 2016 at 1:12 pm

        You can see the underlying data here: https://en.wikipedia.org/wiki/User:Fnielsen/Autolists/Panama_Papers I do not know what an umpire is and have to trust the English Wikipedia on that point: “an umpire (from the Old French nompere meaning not a peer, i.e. not a member of one of the teams, impartial) is a person who has the authority to make judgements on the cricket field”

    Gabor Lisztes said:
    May 12, 2016 at 12:17 pm

    No architetcts? Or they are part of the Eng bubble?

    Douglas said:
    May 12, 2016 at 12:33 pm

    It is interesting that among them all there looks like there is only 1 musician.

    […] Occupations of persons from Panama Papers […]

    Occupations of persons from Panama Papers said:
    May 12, 2016 at 3:42 pm

    […] Finn Årup Nielsen’s blog // […]

    IMak said:
    May 12, 2016 at 4:41 pm

    All that this shows is that people analysing the panama papers have chosen to search for politicians. Why are so few people in legal or financial occupations cited here? Simply because most of these names are not famous, and also because too few researchers are looking for them.

    The data has been generated using an obvious confirmation bias and does not represent a true sample of the data, therefore this analysis says something about those who are analysing the papers, not those who are named in them.

    As a result, it is pretty meaningless research, and it would be contemptible for anyone to suggest that this represents the true state of identities in the papers.

      Finn Årup Nielsen responded:
      May 12, 2016 at 5:08 pm

      I agree that there is indeed a serious bias. Note that the plot is based on Wikidata and I believe that is what is causing the primary bias: If you are not notable to be in Wikipedia you are very much less likely to appear in Wikidata. I think the people analysing the Panama papers may be less to blame for the bias.

        Oğuzhan said:
        May 13, 2016 at 7:40 am

        Would it not help if we could see the number of names mentioned in the documents and how many of them were matched to wikidata per categories here?

    Oğuzhan said:
    May 13, 2016 at 7:45 am

    In the previous comment I’ve written ‘per group’, of course it’s not meant to be there :)

    […] to plot occupations associated with those featured in the leaked documents, Finn Årup Nielsen’s bubble chart appears to show that politicians are mentioned most often, followed by lawyers, business people, […]

    Panama – Sausage Rolls with Sauce said:
    May 13, 2016 at 11:55 pm

    […] Panama papers continue to cause a stir and the infographic on Finn Årup Nielsens page gives us reason to be worried about our elected officials with […]

      Finn Årup Nielsen responded:
      May 23, 2016 at 6:57 pm

      As I have noted to several other bloggers and commentors: Please note that the data is based on Wikidata. That means one should not (necessarily) “be worried about our elected officials”. The plot is biased.

    Jak said:
    May 14, 2016 at 11:29 am

    Nice! Idm really curious to see a diagram where all athletes are combined into one group!

      Finn Årup Nielsen responded:
      May 23, 2016 at 6:50 pm

      I have used the default SPARQL query service of Wikidata. In is a interesting problem whether SPARQL lets you formulate a query were all the athletes are combined. I will need to think about it.

    Drew said:
    May 14, 2016 at 12:06 pm

    I’d be interested in seeing a visualization with the largest group ‘politicians’ omitted from the dataset.

    A6er said:
    May 14, 2016 at 4:42 pm

    Reblogged this on Britain Isn't Eating and commented:
    Very revealing.
    Thanks for posting this.

      Finn Årup Nielsen responded:
      May 23, 2016 at 6:54 pm

      Well… The plot has some quite important limitations as it is based on what we have in Wikidata. I do not think it is “very revealing”. It is too difficult at the moment to get a full overview of the occupations of people mentioned in the Panama Papers.

    […] this data is probably unreliable – “Some people may see that politicians are the largest group, but that might simply be […]

      Finn Årup Nielsen responded:
      May 16, 2016 at 9:40 am

      This is probably one of first comments with a correct scepticism. Thanks!

    5.16 This Week in Numbers – Michael Zhao said:
    May 16, 2016 at 3:33 am

    […] Occupations of persons from the Panama Papers, via this awesome blog: […]

    Joe Gichuki said:
    May 16, 2016 at 8:36 am

    No accountants? Wonder what they know that others don’t.

      Finn Årup Nielsen responded:
      May 16, 2016 at 9:23 am

      I urge you to consider that the data in Wikidata is only a small part of the full Panama papers dataset. Persons in Wikidata are usually only “notable” people, such as politicians, authors, actors, businesspeople of a certain standing, sportspersons and artists. Less known people (people which have not appeared in the media) will unlikely be found in the Wikidata dataset. A less known accountant utilizing services from the Panama company is very likely not in the bubble chart!

    wilson said:
    May 17, 2016 at 7:20 pm

    So, those tax evasion guys are the successful ones; we, the rest, are mere mortals earning the bread by the sweat of our brow. Economically, who is essential? who is superfluous? show less

      Finn Årup Nielsen responded:
      May 23, 2016 at 4:45 pm

      There are two problems with your comment: Firstly, the people mentioned in the Panama papers are not necessarily doing tax evasion. Secondly, the data comes from Wikidata, the sister site of Wikipedia. Persons in Wikidata are typically those that are found in Wikipedia. To get included in Wikipedia you need to be “notable”. Successful people are usually notable. The plot shows mostly successful people by the very limitation of Wikidata! It does not reflect a good statistics of the number of occupations people in the Panama Papers have.

    […] The people who make the loopholes, use the loopholes: […]

      Finn Årup Nielsen responded:
      May 23, 2016 at 3:36 pm

      Remember the plot gives a distorted view of the involvement of politicians as Wikidata has a disproportional large number of these, and the plot is based on Wikidata, rather than the released Panama Papers!

        Finn Årup Nielsen responded:
        May 23, 2016 at 4:37 pm

        Thanks for the cautionary note about the interpretation of plot.

    Panama paper infographic - Piratenpartij said:
    May 18, 2016 at 8:27 pm

    […] Note: originele graphic is gemaakt met data van wikipedia door Finn Årup Nielsen […]

      Finn Årup Nielsen responded:
      May 20, 2016 at 4:07 pm

      But please note that the plot shows only a very limited part of the full Panama Papers. Politicians are likely to make up a very small part in the full dataset.

    Åke Sandberg (@AkeSandberg) said:
    May 20, 2016 at 8:03 am

    Wondering, would be nice to know the political affiliation etc of the politicians – suppose that is not possible

      Finn Årup Nielsen responded:
      May 20, 2016 at 8:57 am

      I have just let Listeria generate a new column with the information about political membership as listed in Wikidata: table with Panama Papers persons in Wikidata. I have also made a SPARQL query that allows you to see the result as a bubble chart (Press Run and switch to bubble chart in the Display menu). The chart is made up of 52 party memberships where “Kinas kommunistiska parti” has 5 listings. British “Konservativa partiet” also had five listings, but I removed Margaret Thatcher as she – AFAIK – was only listed through her son.

    […] more names were linked to the scandal, on blogger Finn Arup Nielsen decided to monitor patterns that arose. Nielsen recently released a data visualization highlighting […]

      Finn Årup Nielsen responded:
      June 6, 2016 at 10:04 am

      An important limitation of the plot, that needs to be stressed, is that it only displays data from Wikidata. The is a very limited part of the full released set of the Panama Papers, – and certainly makes the plot biased towards notable people, such as politicians.

    […] The panama papers buble […]

      Finn Årup Nielsen responded:
      June 21, 2016 at 1:36 pm

      One should note that the chart only displays data that is available in the Wikidata database. The data there is very biased towards “notable” people such as politicians. This is very likely the reason why politician shows up at the most frequent occupation. I doubt that politicians are frequent in the full dataset.

    syafiee halim said:
    July 19, 2016 at 2:38 am

    Like Finn has well-clarified, there is a huge bias due to limitations of wikidata and there are probably more from other occupations involved as well. I also think that it is important to not point fingers just because they are linked to the panama papers because bear in mind, Tax avoidance is very well legal in most countries. However i do think it is a pity some of these names are unfairly implicated. Thats why i’ll never understand why Mossack didn’t bother encrypting their client’s data. Softwares like cloakapps and viivo exist for a reason so i guess they were just too security complacent after all.

    […] more names were linked to the scandal, on blogger Finn Arup Nielsen decided to monitor patterns that arose. Nielsen recently released a data visualization highlighting […]

      Finn Årup Nielsen responded:
      August 5, 2016 at 1:21 pm

      I like to note (yet again) that the interpretation should recall that the data is only from Wikidata which has a very limited part of the full Panama Papers. Politicians are not likely the most common (occupation) in the full dataset. It is simply due to the bias in Wikidata due to Wikipedia’s notability issue.

    […] in the Panama Papers. This may come as a surprise to those who had studied a bubble chart put in a post on my blog. A sizeable portion of blog readers, tweeters and probably also Facebook users seem to have […]

    […] workshoppen lavede @fnielsen et boblediagram over personerne i panama-lækkets professioner baseret på oplysninger i Wikipedia. Diagrammet skal tages med forbehold, fordi det langt fra er alle personer fra lækket, der […]

Leave a comment