European Cohesion Policy has always paid special attention to transparency. Today all European Regions publish lists of beneficiaries of Structural Funds as required by the Council regulations.  But only a part of this data is in a machine-readable and reusable format.  Italian region of Calabria represents a good exception.

Source: Calabria Region project database

Total 2007-13 ERDF funds allocated to the projects whose
beneficiaries are located in a single municipality, March 2010

The Calabria project database

A good example of how this data should be published is the project database of Italian Region of Calabria, accessible online through the web site Calabria Europa.

To date, the database includes more than 32,000 projects; for each project the following information is reported:

  1. the name of the project

  2. the name of the final beneficiary

  3. the owner of the process

  4. the territory where the beneficiary is located

  5. the type of funds (ERDF, ESF, etc) and the Operational Programme

  6. the amounts allocated

  7. the amounts paid out

Through an interactive interface and an advanced search, users can look for specific projects, territories where the project impacts, Operational Programmes, measures, or expenditure categories and then to export the results in CSV format.  It is also possible to visualize the data in terms of statistics, graphs and figures, and then export to a PDF.  This tool is also used to report on the state of play and implementation levels of the policies funded, not only by the Structural Funds, but also by national funds such as the FAS (Under-utilized Area Funds). The tool includes data about the programming periods 2000-2006 and 2007-2013.

The most interesting feature is the search for a single municipal territory, which gives the opportunity, once exported to a CSV file, of geo-referencing the data with the greatest possible detail.  As an example, the map below shows the total amounts allocated in the 2007-13 programming period, displaying the funds only for projects impacting on a single municipality.

Download as a PDF on Scribd2_Open_data_and_structural_funds_files/Executive%20summary%20SOL%202008%20EN.pdf2_Open_data_and_structural_funds_files/Executive%20summary%20SOL%202008%20EN.pdfhttp://www.scribd.com/doc/33597904/The-Open-Data-Paradigm-and-the-European-Structural-Fundsshapeimage_4_link_0shapeimage_4_link_1