Visualisation of EU funds helps to fight corruption in the EU

Click on the map for the full size image (>4 MB); explanations in the text

What you see above is a visualisation to who (some of the) EU funds were awarded in 2009*. It is just a little experiment, a proof of concept, to see if open data available from the EU can contribute to the fight against corruption.

The map is a very practical way to demonstrate that the European public could do more to prevent corruption and the misuse of public (EU) funds (i.e. taxpayers money) if it had more  and better open data about EU funds and its beneficiaries.

The concrete idea for that map came to me thanks to a productive intersection of (a) two projects I stumbled across via Twitter these days, (b) my transparency in the EU institutions advocacy work with Transparency International here in Brussels, (c) my preparations for the Personal Democracy Forum (PDF) Europe in October, and (d) my own doctoral research.

The first of the two projects mentioned above is GovWild, which I found via the German Open Data Network. In this project from my home university in Potsdam, a group of scientists is linking data from different public sources, including EU funds, national party donations and US spending data, into one big data set available for search and analysis.

The second project (via @delineator), which gave the final impetus for my map, is Palentir and this must-see project video on how to use connections of public data and information to detect fraud and corruption risks. After I watched the video I retweeted it, and one of our followers, @ErikWesselius, wrote: “I doubt if similar #govt opendata is available in the EU…” which made me think.

And since I will speak for Transparency International at the Personal Democracy Forum Europe in Barcelona in October, giving an EU perspective on possibilities to use (online) technology to fight corruption, and since I also have been experimenting with network visualisation software for my academic research in the last weeks I thought I’ll give it a try.

You can see the result on the map above, a map with about 500 beneficiaries of EU funds (or groups of beneficiaries) created with open data provided by the EU Commission.

On the map, beneficiaries are linked to the responsible departments of the EU Commission (the green rectangles) and the amount of money they were awarded through one or several grants (in million Euro) can be found on each edge between departments and beneficiaries.

This visualisation is just a small and selected extract of the whole data set, yet it covers quite important amounts of money (see below). And more importantly, I feel it is much more interesting to start looking into EU funding in this kind of visualised presentation than it is in the standard text search available on the Commission website.

The networked presentation makes you think about the connections and concrete flows of money, it gives you a a quick visual glimpse at who receives what kind of money in what amounts. And by looking at the image you start asking questions, questions like:

How can it be that the Europe Aid Cooperation Office seems to pay several hundred million Euros to beneficiaries that are classified “confidential”? (Look it up on the map!)

In order to be able to ask these and many other questions we need good and freely available data in usable formats – and we also need to make use of it as soon as we have it.

The map is just an example of what one can do with open data, and the way it is build is also just one of many possibilities. I hope it serves as a trigger for you to try your own stuff with this and other data.

In the EU, compared to the US, we still have a long way to go when it comes to funding transparency – see for example my post on EU structural funds transparency – and open data projects, and so initiatives like FollowTheMoney.eu and are filling holes that governmental institutions have left open so far, holes that nevertheless need to be filled better sooner than later!

Ronny Patz, Advisor to the Transparency International EU Liaison Office


* For those interested, here is what I did to arrive at the final map:

I downloaded the publicly available data on EU funds handled by the Commission (about 20% of the EU budget) for 2009 as an Excel sheet. This data does not show the amounts paid but the amounts awarded!

In a next step I ordered the data by the amount of money awarded and then opened the changed Excel file with the yEd Graph Editor. I created a graph based on a link list (links between responsible department and beneficiary) taken from  the 1000 first data sets i.e. the 1000 largest amounts of money awarded. Then I played around with the graph with yEd and visone (both free network analysis and visualisation tools with different advantages and disadvantages).

Where the same beneficiary was awarded money from the same department several times, I merged multiple edges into one edge, adding up the amounts of money on the merged edge (the sums on the edges show the amount of money in million €).

In the end, there were about 800 different beneficiaries or groups of beneficiaries on my map together with the responsible Commission departments. For memory and visual reasons I erased all those who only received money from the General Directorate for Research (about 300 groups of beneficiaries that are worth looking into separately because the amounts of money spent there are considerable) when creating the image for this article, leaving the final map displayed here with about 500 (groups of) beneficiaries.

Share and enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • TwitThis
  • Twitter
  • Facebook
  • Digg
  • del.icio.us
  • StumbleUpon
  • Reddit
  • MisterWong
  • Google Bookmarks
  • Technorati
  • LinkedIn
  • NewsVine
  • YahooBuzz
  • Print
  • email

, ,

12 Responses to Visualisation of EU funds helps to fight corruption in the EU

  1. Hans Zomer 19 August 2010 at 12:34 pm #

    Great! Can you do one for the EU’s humanitarian aid (ECHO) and/or its development cooperation programme (DG Dev)? That would be great!

  2. TI EU 19 August 2010 at 2:55 pm #

    @ Hans

    Sure it can be done:
    http://blog.transparency.org/wp-content/uploads/2010/08/Dev_blog2.png

    These are all recipients listed in the 2009 file with the responsible units “Development” and “Humanitarian Aid”. The figures on the edges are 1000 € (1,000 thus means one million €).

    PS.: Both for the map linked here and in the main article, P
    please always cross-check them with the search on the Commission website before using the figures (taking into account that they both reflect selective extracts).

  3. Cheryl 25 August 2010 at 1:03 pm #

    Great work! What an enormous undertaking.

    Would be revealing to make graphic sizes related to funding amounts. Maybe a good source of inspiration (my buddy, David McCandless): http://www.informationisbeautiful.net

    Good luck and thank you for all the tireless effort!!!

  4. TI EU 25 August 2010 at 2:17 pm #

    @ Cheryl

    Thanks for the positive comment!

    In fact, it wouldn’t be a huge problem to deal with the node sizes according to the amounts paid, I just didn’t have enough time to play around. I actually did it with the European Space Agency (the big red rectangle) which is this big because of the amounts it receives and also with the colouring of the nodes, but it doesn’t really get through.

    So I agree, there would be room for visual improvement. :)

    Ronny

  5. SAVE VISIONS AFRICA (SVA) 19 August 2011 at 12:12 pm #

    Dear Sir/Madam,

    Please we seek funds to fight the massive corruption on Nigeria Highways/Roads.

    Details Proposal or Letter of Intent is available on request.

    Peter Okereke, PhD,
    Lead Person.

Trackbacks/Pingbacks

  1. Tweets that mention Visualisation of EU funds helps to fight corruption in the EU : space for transparency -- Topsy.com - 19 August 2010

    [...] This post was mentioned on Twitter by Transparency Int'l, kattebel, Conor Slowey, georg_neu, Servs and others. Servs said: RT @kattebel: Interesting visualisation-map of #EU spending by @TI_EU http://bit.ly/d0GAMq (via @paolabrussels) [...]

  2. Euroblog Round-up: Number Crunching the EU | Eurogoblin.eu - 22 August 2010

    [...] to the EU budget and Transparency International has put together a mash-up proof-of-concept investigating how data-visualisation tools can help fight EU [...]

  3. bloggingportal.eu Blog & Support » Blog Archive » The Week in Bloggingportal: Number Crunching the EU - 22 August 2010

    [...] to the EU budget and Transparency International has put together a mash-up proof-of-concept investigating how data-visualisation tools could help fight EU [...]

  4. Nobody lobbies the EU Council! : space for transparency - 7 October 2010

    [...] to Commissioner Sefcovic, which will ease it for us to link the data with other data sets such as EU funds data to check whether groups that influence the institutions also receive money from them. Sefcovic [...]

  5. Polscieu » Blog Archive » Spilled water, wasted funds? – A special look at a special EU Court of Auditors report - 21 December 2010

    [...] transparency of EU funds spending (see e.g. this blog post on Structural Funds or this one on network visualisation of EU funds). I should mention that Transparency International also deals with “Corruption in the water [...]

  6. EU budget transparency: Advocating better rules and practices : space for transparency - 16 March 2011

    [...] rules and practices in this regard, as you can for instance see in previous blog posts here or here or in this joint European civil society position on Transparency of End Beneficiaries of EU [...]

  7. EU budget transparency: Advocating better rules and practices | space for transparency - 17 January 2012

    [...] rules and practices in this regard, as you can for instance see in previous blog posts here or here or in this joint European civil society position on Transparency of End Beneficiaries of EU [...]