DATA USED FOR DELIVERABLE 2.5 – section 2 

This readme file belongs to Data Set 5, title: “PERCEIVE: WP2: Evaluation of EU citizens’ perception of the EU project: Key variables for citizens' identification with EU”

Contributor of this file: Rosina Moreno Serrano (Universitat de Barcelona) ; http://orcid.org/0000-0002-3500-8622  

Data Set Contact Person/s:  Vicente Royuela Mora, (Universitat de Barcelona) ; http://orcid.org/0000-0002-7647-0063; vroyuela@ub.edu  

License: this data subset is distributed under a Creative Commons Attribution 4.0 International (CC BY 4.0) license, https://creativecommons.org/licenses/by/4.0/. 

Publication Year: 2019

Project Info: PERCEIVE (Perception and Evaluation of Regional and Cohesion Policies by Europeans and Identification with the Values of Europe), funded by European Union, Horizon 2020 Programme. Grant Agreement num. 693529; https://www.perceiveproject.eu/.  
Data subset Documentation
Abstract
This data subset is the one used in section 2 of deliverable 2.5. It is devoted to review the analyses produced so far regarding the absorption of the funds of the EU Cohesion Policy. It discusses the characteristics of the measures used so far and proposes alternative indicators. They are computed and analysed using the most recent data available to conclude on regional disparities in the effectiveness of the management of EU funds.
Content of the file: 
PERCEIVE_WP2_D2_5_sect2-4-1&sect2-4-2.csv
PERCEIVE_WP2_D2_5_sect2-4-3.csv
PERCEIVE_WP2_D2_5_sect2-4-4.csv
PERCEIVE_WP2_D2_5_sect2-5.csv
PERCEIVE_WP2_D2-5_Table2_4.csv

File specifics
The file is available in a csv format, being the Field delimiter « , » (comma)

Notes 
The deliverable D25 can be downloaded at 
http://doi.org/10.6092/unibo/amsacta/6114 (AMS Acta)

Data used for the descriptive analysis of regional disparities in the measures of the CP effectiveness in section 2.4.1 and 2.4.2 of Deliverable 2.5

This data subset was used to produce the results for the analysis of disparities across the 272 EU NUTS2 regions in the different measures generally used to proxy for CP effectiveness.
To reproduce results in sections 2.4.1 and 2.4.2 of Deliverable 2.5.
The EU data subset used to compute the indicators of interest for the set of EU regions are: 
•	Data on structural funds payments: In the dataset of the DG REGIO, under the level of Historic EU payments-regionalised and modelled, you can find historic long-term regionalised (NUTS2) annual EU expenditure data for different EU funds - ERDF, Cohesion Fund, EAFRD/EAGGF and ESF. We use this dataset to get the information on the most updated payments (until 2016). https://cohesiondata.ec.europa.eu/Other/Historic-EU-payments-regionalised-and-modelled/tc55-7ysv
•	Data on SF allocations: In the dataset of DG REGIO, under the level of Historic data on SF by member state and in the section of ‘Geography of expenditure study, August 2015 (Ex post 2007-2013)’ you find the cumulative allocations to selected projects and expenditure at NUTS2 level. 
•	Section 2.3 in Deliverable 2.5 gives detailed description on how the variables are constructed. 
Datafile: PERCEIVE_WP2_D2-5_sect2-4-1&sect2-4-2.csv
Variables:
•	regcode: code of the corresponding EU NUTS2 region
•	allocated2014: monetary amount of funds allocated to the region over the lifetime of the programming period 2007-2013
•	payment2014: monetary amount of funds effectively spent in the region over the lifetime of the programming period 2007-2013 (payments made by the European Commission until 2014) 
•	payment 2016: monetary amount of funds effectively spent in the region over the lifetime of the programming period 2007-2013 (payments made by the European Commission until 2016) 
•	alloc2014pc: monetary amount of funds allocated to the region over the lifetime of the programming period 2007-2013 in per capita terms (divided by population)
•	payment2014pc: monetary amount of funds effectively spent in the region over the lifetime of the programming period 2007-2013 (payments made by the European Commission until 2014) in per capita terms (divided by population)
•	payment2016pc: monetary amount of funds effectively spent in the region over the lifetime of the programming period 2007-2013 (payments made by the European Commission until 2016) in per capita terms (divided by population)
•	AR2014: absorption rate defined as the ratio between the payments and the allocations in the region over the lifetime of the programming period 2007-2013 (payments made by the European Commission until 2014)
•	AR2016: absorption rate defined as the ratio between the payments and the allocations in the region over the lifetime of the programming period 2007-2013 (payments made by the European Commission until 2016)

Data used for the descriptive analysis of regional disparities in the measures of the CP effectiveness in section 2.4.3 of Deliverable 2.5

This data subset was used to produce the results for the analysis of disparities across the 272 EU NUTS2 regions in the different measures of the speed of the payments along the programming period.
To reproduce results in section 2.4.3 of Deliverable 2.5.
The EU data subset used to compute the indicators of interest for the set of EU regions are: 
•	The different indicators of speed in the absorption of the funds have been computed both with the historic data regionalised and modelled as provided in the webpage http://ec.europa.eu/regional_policy/EN/policy/evaluations/data-for-research/. As commented in subsection 2.3.1, although these two measures (real payment and annual expenditure modelled) coincide when you consider the information at the end of the period, they are different in each year, and given that this is the information we are using here, we have computed them in both cases. For a detailed description of the variables and dataset, see sections 2.2.2 and 2.4.3.

Datafile: PERCEIVE_WP2_D2-5_sect2-4-3.csv
Variables:
•	NUTS_ID: code of the corresponding EU NUTS2 region
•	pct5thyearpayment: percentage of expenditures (real payment) accumulated after five years of implementation of the programme in the region, i.e. from 2007 to 2011.
•	pct5thyearmodelled: percentage of expenditures (modelled) accumulated after five years of implementation of the programme in the region, i.e. from 2007 to 2011.
•	pct3thyearpayment: percentage of expenditures (real payment) accumulated after three years of implementation of the programme in the region, i.e. from 2007 to 2009.
•	pct3thyearmodelled: percentage of expenditures (modelled) accumulated after three years of implementation of the programme in the region, i.e. from 2007 to 2009.
•	last3payment: percentage of expenditures (real payment) accumulated in the last three years of implementation of the programme in the region, i.e. from 2014 to 2016.
•	last3modelled: percentage of expenditures (modelled) accumulated in the last three years of implementation of the programme in the region, i.e. from 2014 to 2016.
•	dur_yearmedianpayment: number of years needed to accumulate the 50% of the amount of funds allocated to the region (real payment)
•	dur_yearmedianmodelled: number of years needed to accumulate the 50% of the amount of funds allocated to the region (modelled)
•	dur_year25payment: number of years needed to accumulate the 25% of the amount of funds allocated to the region (real payment)
•	dur_year25modelled: number of years needed to accumulate the 25% of the amount of funds allocated to the region (modelled)
•	dur_year75payment: number of years needed to accumulate the 75% of the amount of funds allocated to the region (real payment)
•	dur_year75modelled: number of years needed to accumulate the 75% of the amount of funds allocated to the region (modelled)
Data used for the correlation analysis between CP effectiveness and key economic magnitudes at the regional level in section 2.4.4 of Deliverable 2.5

This data subset was used to produce the coefficients of pairwise correlation between different measures of CP effectiveness and key economic magnitudes of the 272 EU NUTS2 regions (Table 2.3) of Deliverable 2.5.
To reproduce results in section 2.4.4 of Deliverable 2.5.
The EU data subset used to compute the correlation coefficients are: 
•	The measures of CP effectiveness obtained in previous sections of D2.5 (sections 2.4.1, 2.4.2 and 2.4.3).
•	The measures of key economic magnitudes at the regional level are obtained from PERCEIVE-QOG EU Regional Dataset. PERCEIVE regional panel datasets.zip

Datafile: PERCEIVE_WP2_D2_5_sect2-4-4.csv
Variables:
•	NUTS_ID: code of the corresponding EU NUTS2 region
•	alloc2014pc: monetary amount of funds allocated to the region over the lifetime of the programming period 2007-2013 in per capita terms (divided by population)
•	payment2016pc: monetary amount of funds effectively spent in the region over the lifetime of the programming period 2007-2013 (payments made by the European Commission until 2016) in per capita terms (divided by population)
•	AR2016: absorption rate defined as the ratio between the payments and the allocations in the region over the lifetime of the programming period 2007-2013 (payments made by the European Commission until 2016)
•	pct5thyearmodelled: percentage of expenditures (modelled) accumulated after five years of implementation of the programme in the region, i.e. from 2007 to 2011.
•	last3modelled: percentage of expenditures (modelled) accumulated in the last three year of implementation of the programme in the region, i.e. from 2014 to 2016.
•	dur_yearmedianmodelled: number of years needed to accumulate the 50% of the amount of funds allocated to the region (modelled)
•	econ_2gdp_pps_hab: Gross Domestic Product per capita in PPS
•	educ_ed25645_8_t: percentage of the regional population between 25 and 65 yearsold with tertiary education- ISCED levels 5 to 8
•	sctech_htc_t Employment in High-technology sectors
•	unemp_y2064_t: Unemployment rates: 20-64 Years, Total. 

Data used for the comparison of the rates of implementation of the funds with the PERCEIVE and the public datasets for the 9 case-study regions in sections 2.5.1 and 2.5.2 of Deliverable 2.5

This data subset was used to analyse the evolution of the rates of implementation of the funds on the 9 case study regions in the PERCEIVE project. 
To reproduce plots in section 2.5.1 and 2.5.2 of Deliverable 2.5.
The data subset used to make the plots of the 9 case study regions are: 
•	The measures of CP effectiveness obtained in previous sections of D2.5 (sections 2.4.1, 2.4.2 and 2.4.3).
•	The dataset obtained by UNIBO for the elaboration of Task 6.1 in the PERCEIVE project. With the aim of generating a model to be processed through simulation in order to develop a scenario analysis, the absorption rates for the 9 regions under analysis in the PERCEIVE project were obtained from the annual PDF reports by each fund and period, so that all the data were collected and gathered in time series for each of the 9 regions under study. The aforementioned data refer to the ROP (Regional Organisation Plan) commitments and the payments that the EU gives to the regions, without taking into considerations the national/regional co-finance. See section 2.5 in Deliverable 2.5 for a more detailed explanation.
Datafile: PERCEIVE_WP2_D2-5_sect2-5.csv
Variables:
•	year: year of reference
•	AT11publicdataset: absorption rate in the corresponding year according to the data obtained online (section 2.4.2) for the region of Burgenland
•	ITF6publicdataset: absorption rate in the corresponding year according to the data obtained online (section 2.4.2) for the region of Calabria
•	ITH5publicdataset: absorption rate in the corresponding year according to the data obtained online (section 2.4.2) for the region of Emilia-Romagna
•	PL51publicdataset: absorption rate in the corresponding year according to the data obtained online (section 2.4.2) for the region of Dolnośląskie
•	PL62publicdataset: absorption rate in the corresponding year according to the data obtained online (section 2.4.2) for the region of  Warmińsko--Mazurskie
•	ES43publicdataset: absorption rate in the corresponding year according to the data obtained online (section 2.4.2) for the region of Extremadura
•	SE31publicdataset: absorption rate in the corresponding year according to the data obtained online (section 2.4.2) for the region of Norra Mellansverige
•	AT11PERCEIVEdataERDF: absorption rate in the corresponding year according to the data obtained from section 6.1 in PERCEIVE project for the region of Burgenland. ERDF 
•	ITF6 PERCEIVEdataERDF: absorption rate in the corresponding year according to the data obtained from section 6.1 in PERCEIVE project for the region of Calabria. ERDF
•	ITH5 PERCEIVEdataERDF : absorption rate in the corresponding year according to the data obtained from section 6.1 in PERCEIVE project for the region of Emilia-Romagna. ERDF
•	PL51 PERCEIVEdataERDF: absorption rate in the corresponding year according to the data obtained from section 6.1 in PERCEIVE project for the region of Dolnośląskie. ERDF
•	PL62 PERCEIVEdataERDF: absorption rate in the corresponding year according to the data obtained from section 6.1 in PERCEIVE project for the region of  Warmińsko--Mazurskie. ERDF
•	ES43 PERCEIVEdataERDF: absorption rate in the corresponding year according to the data obtained from section 6.1 in PERCEIVE project for the region of Extremadura. ERDF
•	SE31 PERCEIVEdataERDF: absorption rate in the corresponding year according to the data obtained from section 6.1 in PERCEIVE project for the region of Norra Mellansverige. ERDF
•	AT11PERCEIVEdataESF: absorption rate in the corresponding year according to the data obtained from section 6.1 in PERCEIVE project for the region of Burgenland. ESF 
•	ITF6 PERCEIVEdataESF: absorption rate in the corresponding year according to the data obtained from section 6.1 in PERCEIVE project for the region of Calabria. ESF
•	ITH5 PERCEIVEdataESF : absorption rate in the corresponding year according to the data obtained from section 6.1 in PERCEIVE project for the region of Emilia-Romagna. ESF
•	PL51 PERCEIVEdataESF: absorption rate in the corresponding year according to the data obtained from section 6.1 in PERCEIVE project for the region of Dolnośląskie. ESF
•	PL62 PERCEIVEdataESF: absorption rate in the corresponding year according to the data obtained from section 6.1 in PERCEIVE project for the region of  Warmińsko--Mazurskie. ESF
•	RO22 PERCEIVEdataESF: absorption rate in the corresponding year according to the data obtained from section 6.1 in PERCEIVE project for the region of  Sud-Est. ESF
•	ES43 PERCEIVEdataESF: absorption rate in the corresponding year according to the data obtained from section 6.1 in PERCEIVE project for the region of Extremadura. ESF
•	SE31 PERCEIVEdataESF: absorption rate in the corresponding year according to the data obtained from section 6.1 in PERCEIVE project for the region of Norra Mellansverige. ESF

	

Data used for the correlation analysis between CP effectiveness and the identification with the EU for the 9 case study regions in section 2.5.2 of Deliverable 2.5

This data subset was used to produce the coefficients of pairwise correlation between different measures of CP effectiveness and key variables proxying for the identification with the EU for the 9 case study regions in the PERCEIVE survey (Table 2.4).
To reproduce results in section 2.5.2 (Table 2.4) of Deliverable 2.5.
The EU dataset used to compute the correlation coefficients are: 
•	The measures of CP effectiveness obtained in previous sections of D2.5 (sections 2.4.1, 2.4.2 and 2.4.3).
•	The measures of the identification with the EU at the regional level obtained from the PERCEIVE survey (individual-level data).

Datafile: PERCEIVE_WP2_D2-5_Table2_4.csv
Variables:
•	region_name: name of the region
•	regcode16: code of the region
•	absrate2016: absorption rate defined as the ratio between the payments and the allocations in the region over the lifetime of the programming period 2007-2013 (payments made by the European Commission until 2016)
•	payment2016pc: monetary amount of funds effectively spent in the region over the lifetime of the programming period 2007-2013 (payments made by the European Commission until 2016) in per capita terms (divided by population)
•	alloc2014pc: monetary amount of funds allocated to the region over the lifetime of the programming period 2007-2013 in per capita terms (divided by population)
•	payment2014pc: monetary amount of funds effectively spent in the region over the lifetime of the programming period 2007-2013 (payments made by the European Commission until 2014) in per capita terms (divided by population)
•	pct5thyearpayment: percentage of expenditures (real payment) accumulated after five years of implementation of the programme in the region, i.e. from 2007 to 2011.
•	pct5thyearmodelled: percentage of expenditures (modelled) accumulated after five years of implementation of the programme in the region, i.e. from 2007 to 2011.
•	pct3thyearpayment: percentage of expenditures (real payment) accumulated after three years of implementation of the programme in the region, i.e. from 2007 to 2009.
•	pct3thyearmodelled: percentage of expenditures (modelled) accumulated after three years of implementation of the programme in the region, i.e. from 2007 to 2009.
•	last3payment: percentage of expenditures (real payment) accumulated in the last three years of implementation of the programme in the region, i.e. from 2014 to 2016.
•	last3modelled: percentage of expenditures (modelled) accumulated in the last three years of implementation of the programme in the region, i.e. from 2014 to 2016.
•	dur_yearmedianpayment: number of years needed to accumulate the 50% of the amount of funds allocated to the region (real payment)
•	dur_yearmedianmodelled: number of years needed to accumulate the 50% of the amount of funds allocated to the region (modelled)
•	EUmembership: percentage of individuals that think that EU membership is a good thing
•	Ident_EU: degree of identification with Europe (0 don’t identify at all to 10 identify very strongly)
•	Support_CP: percentage of individuals that support the Cohesion Policy
•	Heard_CP: percentage of individuals that heard about Cohesion Policy
•	Heard_RP: percentage of individuals that heard about Regional Policy
•	Heard_SF: percentage of individuals that heard about Structural Funds
•	Heard_AnyEUfund: percentage of individuals that heard about any EU funded project in the region or area