EU Structural Funds: get the data

May 29th, 2012 | by | Published in EU structural Funds, Open Society

Please support our work - share this article

Euro parliament- Flickr/John & Mel Kots

The EU Parliament – they wouldn’t give this data centrally.

In November 2010 the Bureau, with the Financial Times, reported on EU’s hidden billions.

Our work created the only comprehensive database tracking every penny distributed through the EU’s Structural Funds up to that date.

It provides evidence on a structural fund programme that distributes €347bn of European taxpayers’ money across 271 regions in 27 countries.

For over eight months the Bureau and the FT collected the data that was never centrally published.  It relates to billions of euros and reveals 646,000 recipients that have received the funds.

Our research exposed how:

  • Italy’s most dangerous mafia, the ndrangheta, has become an expert at getting its hands on these funds
  • A decentralised, cumbersome and weak system allows, and rarely punishes, fraud and misuse
  • Millions of euros are going to multinational companies to help them move factories within the union despite guidelines discouraging this practice
  • Funds have been used to finance a hotel building boom on protected nature reserves in Spain
  • The lack of thorough checks means money is being wasted
  • Some of the world’s largest companies are receiving funding despite the programme being aimed at small and medium-sized companies

Up to now the database was maintained by the Financial Times.  Now we release all the data to data journalists and programmers for their own use.

It isn’t in an easy format but we hope that it works for those that know how.

Please share this information and keep us informed of any stories that come from it.

Any credit to the Bureau of Investigative Journalism would be gratefully received.

MySQL file (approx 600Mb):

http://dl.dropbox.com/u/39827429/EU_Structural_Funds/sql/euFunds.sql

CSV file (approx 200Mb):
http://dl.dropbox.com/u/39827429/EU_Structural_Funds/csv/euFunds.csv

Related links:

  • No related links

Comments are closed.

Latest from the Bureau

Home Secretary wins latest round of citizenship-stripping case
May 24, 2013 | by | No Comments
Must include shutterstock.com in caption

Vietnamese-born man accused of militant training loses Court of Appeal case.

Obama frames covert drone war as necessary evil
May 23, 2013 | by | No Comments
Obama de Souza April 2013

Obama admits civilians have been killed in drone strikes.

Case study: Beleaguered in Brent
May 23, 2013 | by | No Comments
shutterstock_92189215-1

Hanane Toumi and her family work and study in Westminster but now commute from Brent.

Sharp rise in B&B spending as homelessness crisis intensifies
May 21, 2013 | by | No Comments
Copyright Hangtime/Shutterstock

A £90m bed and breakfast bill for UK's 12 largest cities.

Voices from the frontline of the housing crisis
May 20, 2013 | by | No Comments
shutterstock_89531086

Those who experience the housing maelstrom first-hand speak out.

Case study: Stranded in Southwark
May 20, 2013 | by | No Comments
Zara

With three children and a baby on the way Zara Mahamat just wants a stable home.

Infographic: Price of UK’s escalating housing crisis
May 20, 2013 | by | No Comments
Housing4

The scale of Britain's housing crisis visualised.

Get the data: Britain’s housing turmoil in numbers
May 19, 2013 | by | No Comments
shutterstock_5653459

Dataset: The Bureau's research into the extent and cost of housing upheaval.

How we did it: Tracking the housing crisis
May 19, 2013 | by | No Comments
House building via Shutterstock.com

Methodology: How the Bureau compiled its data on homelessness.

Britain’s housing crisis: The impact on children
shutterstock_105554129

A-star students fail to make the grade when they are moved away, say teachers.