DATA USED FOR DELIVERABLE 2.5 – sections 3, 4 and 5.

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”

Data subset Author: Enrique López Bazo (Universitat de Barcelona) ; http://orcid.org/0000-0002-4654-8237 

Data subset 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 used to develop sections 3, 4 and 5 of deliverable 2.5. In particular, section 3 computes several regional indicators of the citizens’ perception of the EU, distinguishing between support for the EU project and citizens’ attitudes towards the EU. It describes disparities between countries and regions in these indicators, and discusses its evolution from 2000 to 2016. Section 4 reports and discusses the results of the impact of the Cohesion Policy in the region on the citizens’ perception of the EU. It takes into consideration both the intensity of the policy and the effectiveness in its implementation. To do so, it uses the measures computed in sections 2 and 3. Section 5 focuses on the impact of Cohesion Policy on regional growth, and whether growth and convergence eventually influence the degree of support for Europe and attitudes towards the EU. It uses the indicators of perception computed in section 3 and the methodological framework designed in section 4.
Content of the file: 
PERCEIVE_WP2_D2_5_sect3_disparities_country.csv
PERCEIVE_WP2_D2_5_sect3_disparities_region.csv
PERCEIVE_WP2_D2_5_sect4_PerceptionEU&CPinregion_region.csv
PERCEIVE_WP2_D2_5_sect4_PerceptionEU&absorption_region.csv
PERCEIVE_WP2_D2_5_sect5_RegGrowthConv_CP_region.csv
PERCEIVE_WP2_D2_5_sect5_RegGrowthConv_PerceptionEU_region.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 analysis of territorial disparities in the identification with the EU project in section 3 of Deliverable 2.5

This data was used to produce the results for the analysis of disparities across the 28 EU member states in the degree of identification with the EU project.
The Eurobarometer surveys used to compute the indicators of interest for the sets of EU countries in the three periods analysed are: 
•	Period 2000–2002: ZA3296–Eurobarometer 53 (spring 2000), ZA3627– Eurobarometer 56.2 (autumn 2001), ZA3693–Eurobarometer 58.1 (autumn 2002) 
•	Period 2007–2009: ZA4530–Eurobarometer 67.2 (spring 2007), ZA4819– Eurobarometer 70.1 (autumn 2008), ZA4994–Eurobarometer 72.4 (autumn 2009) 
•	Period 2014–2016: ZA5932–Eurobarometer 82.3 (autumn 2014), ZA5998– Eurobarometer 83.3 (spring 2015), ZA6788–Eurobarometer 86.2 (autumn 2016) 

Datafile: PERCEIVE_WP2_D2_5_sect3_disparities_country.csv

Variables:
•	country_code: code of the corresponding EU member state
•	period: indicator of the period (string)
•	period_num: identifier of the period (numerical)
•	cntry_num: identifier of the country (numerical)
•	EUmember_Good: percentage of individuals that think that EU membership is a good thing
•	EUbenefit_YES: percentage of individuals that think that their country has benefited from being a member of the EU
•	EUtrust_YES: percentage of people that tend to trust in the EU
•	EU_image_Posit: percentage of people with a positive image of the EU

Data used for the analysis of territorial disparities in the identification with the EU project in section 3 of Deliverable 2.5

This data was used to produce the results for the analysis of disparities across regions in the degree of identification with the EU project.
The Eurobarometer surveys used to compute the indicators of interest for the group of EU regions in the three periods analysed are: 
•	Period 2000–2002: ZA3296–Eurobarometer 53 (spring 2000), ZA3627– Eurobarometer 56.2 (autumn 2001), ZA3693–Eurobarometer 58.1 (autumn 2002) 
•	Period 2007–2009: ZA4530–Eurobarometer 67.2 (spring 2007), ZA4819– Eurobarometer 70.1 (autumn 2008), ZA4994–Eurobarometer 72.4 (autumn 2009) 
•	Period 2014–2016: ZA5932–Eurobarometer 82.3 (autumn 2014), ZA5998– Eurobarometer 83.3 (spring 2015), ZA6788–Eurobarometer 86.2 (autumn 2016) 

Datafile: PERCEIVE_WP2_D2_5_sect3_disparities_region.csv

Variables:
•	region_code_n: code of the region as in the PERCEIVE survey database 
•	country_code: code of the corresponding EU member state
•	period: identifier of the period (string)
•	period_num: identifier of the period (numerical)
•	EUmember_Good: percentage of individuals that think that EU membership is a good thing
•	EUbenefit_YES: percentage of individuals that think that their country has benefited from being a member of the EU
•	EUtrust_YES: percentage of people that tend to trust in the EU
•	EU_image_Posit: percentage of people with a positive image of the EU

Data used for the analysis of the effect of the Cohesion Policy in the region on the perception of the EU in section 4 of Deliverable 2.5

This data was used to produce the results of the analysis of the impact of the intensity of the Cohesion Policy on the perception of the European project in the region.

To reproduce results in section 4.4.1 of Deliverable 2.5
Datafile: PERCEIVE_WP2_D2_5_sect4_PerceptionEU&CPinregion_region.csv

Variables:
•	region_code: code of the region
•	region_code_n: code of the region as in PERCEIVE survey database 
•	country_code: code of the corresponding EU member state
•	period: identifier of the period (string)
•	period_num: identifier of the period (numerical)
•	EUmember_Good: percentage of individuals that think that EU membership is a good thing
•	EUbenefit_YES: percentage of individuals that think that their country has benefited from being a member of the EU
•	EUtrust_YES: percentage of people that tend to trust in the EU
•	EU_image_Posit: percentage of people with a positive image of the EU
•	l_gdppc: GDP per capita in PPS (log) (*)
•	l_SF_totalpc: total Structural Funds expenditures per capita in the year previous to the period in which the indicators of perception of the EU are measured (*)
•	emplrate: employment rate defined as the ratio between the employed and the working age population (15 to 64 years old) (*)
•	l_popdens: population density defined as the annual average population per square kilometre (*)
•	educ_ed25645_8_t: percentage of the regional population between 25 and 64 years old with tertiary education –ISCED levels 5 to 8 (*)
•	eqi_eqi: 2013 European Quality of Government Index, computed by The Quality of Government Institute (*)
•	pov_pop_povr_excl: rate of social exclusion (*)
•	pov_risk_pov_r: risk-of-poverty rate (*)
•	sctech_a_b_t: percentage of total employment in agriculture (*)

(*)	from the PERCEIVE-QOG EU Regional Dataset 
DOI: 10.5281/zenodo.845349
PERCEIVE regional panel datasets.zip      codebook for regional panel dataset.pdf

Data used for the analysis of the effect of the Cohesion Policy in the region on the perception of the EU in section 4 of Deliverable 2.5

This data was used to produce the results of the analysis of the impact of the absorption of the Cohesion Policy funds on the perception of the European project in the region.

To reproduce results in section 4.4.2 of Deliverable 2.5
Datafile: PERCEIVE_WP2_D2_5_sect4_PerceptionEU&absorption_region.csv

Variables:
•	region_code: code of the region
•	region_code_n: code of the region as in PERCEIVE survey database 
•	country_code: code of the corresponding EU member state
•	period: identifier of the period (string)
•	period_num: identifier of the period (numerical)
•	EUmember_Good: percentage of individuals that think that EU membership is a good thing
•	EUbenefit_YES: percentage of individuals that think that their country has benefited from being a member of the EU
•	EUtrust_YES: percentage of people that tend to trust in the EU
•	EU_image_Posit: percentage of people with a positive image of the EU
•	l_gdppc: GDP per capita in PPS (log) (*)
•	l_SF_totalpc: total Structural Funds expenditures per capita in the year previous to the period in which the indicators of perception of the EU are measured (log) (*)
•	emplrate: employment rate defined as the ratio between the employed and the working age population (15 to 64 years old) (*)
•	l_popdens: population density defined as the annual average population per square kilometre (log) (*)
•	educ_ed25645_8_t: percentage of the regional population between 25 and 64 years old with tertiary education –ISCED levels 5 to 8 (*)
•	absrate16: absorption rate defined as the ratio between the 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) and the amount allocated to the region 
•	pct5thyearmodelled: percentage of expenditures accumulated after five years of implementation of the programme in the region, i.e. from 2007 to 2011 
•	dur_yearmedianmodelled: number of years needed to accumulate the 50% of the amount of funds allocated to the region 

(*)	from the PERCEIVE-QOG EU Regional Dataset 
DOI: 10.5281/zenodo.845349
PERCEIVE regional panel datasets.zip      codebook for regional panel dataset.pdf

Data used for the analysis of the effect of regional growth and convergence, and Cohesion Policy in the region on the perception of the EU in section 5 of Deliverable 2.5

This data was used to produce the results of the analysis of the effect of the Cohesion Policy in the region on regional growth and convergence.
To reproduce results in sections 5.4.1 and 5.4.2 of Deliverable 2.5

Datafile: PERCEIVE_WP2_D2_5_sect5_RegGrowthConv_CP_region.csv

Variables:
•	region_code: code of the region
•	region_code_n: code of the region as in PERCEIVE survey database
•	year: indicator of the year from 2000 to 2014
•	one_reg: indicator for single-region member states (LU, CY, EE, LT, LV, MT)
•	econ_2gdp_pps_hab_eu: GDP per inhabitant in PPS as percentage of EU average (*)
•	gdppc_rel_CNTRY: GDP per inhabitant in PPS as percentage of country average (*)
•	gdppc_rel_Q4: GDP per inhabitant in PPS as percentage of the average in the group of regions that received similar amounts of Structural Funds per capita in the programming period 2007-2013 (*)
•	g_gdppc: annual (logarithmic) growth rate of GDP per inhabitant in PPS (*)
•	l_gdppc0: one-year lag of GDP per inhabitant in PPS (log) (*)
•	l_SF_totalpc: total Structural Funds expenditures per capita (log) (*)
•	Q4_SF_totalpc: indicator of the quartile in the regional distribution of SF_totalpc (*)
•	Q_SF_totalpc: indicator of below/above the median of the regional distribution of SF_totalpc (*)
•	l_primeduc: percentage of the region’s population 25-64 years old whose highest level of education successfully completed is ‘Less than primary, primary and low secondary education’ (ISCED levels 0–2) (log) (*)
•	l_terteduc: percentage of the region’s population 25-64 years old whose highest level of education successfully completed is ‘Tertiary education’ (ISCED levels 5–8) (log) (*)
•	l_motorhab: kilometres of the regional motorways network per inhabitant (log) (*)
•	emplrate: ratio between the employed and the working age population (15 to 64 years old) in the region (*)
•	l_empl_dens: number of employees per square kilometre (log) (*)
•	l_popdens: population per square kilometer (log) (*)
•	g_gdppc_CNTRY: annual per capita GDP growth rate of the country to which the region belongs (*)

(*)	from/based on the PERCEIVE-QOG EU Regional Dataset 
DOI: 10.5281/zenodo.845349
PERCEIVE regional panel datasets.zip      codebook for regional panel dataset.pdf

Data used for the analysis of the effect of regional growth and convergence, and Cohesion Policy in the region on the perception of the EU in section 5 of Deliverable 2.5

This data was used to produce the results of the analysis of the effect of regional growth and convergence, and the Cohesion Policy in the region on the perception of the European project.

To reproduce results in section 5.4.3 of Deliverable 2.5

Datafile:   PERCEIVE_WP2_D2_5_sect5_RegGrowthConv_PerceptionEU_region.csv 

Variables:
•	region_code: code of the region
•	region_code_n: code of the region as in PERCEIVE survey database
•	year: indicator of the year from 2000 to 2014
•	period: identifier of the period (string)
•	period_n: identifier of the period (numerical)
•	EUmember_Good: percentage of individuals that think that EU membership is a good thing
•	EUbenefit_YES: percentage of individuals that think that their country has benefited from being a member of the EU
•	EUtrust_YES: percentage of people that tend to trust in the EU
•	EU_image_Posit: percentage of people with a positive image of the EU
•	g5_gdppc: growth in the previous five years of GDP per inhabitant in PPS (*) 
•	dEU5_gdppc: change in the last five years in the deviation of GDP per inhabitant in PPS with respect to the EU (*)
•	g_rel_EU: indicator defined based on the growth in the region over the five-year period relative to growth in the entire EU, and its initial gap in GDP per capita relative to the EU average. Four categories: 1) Convergence from above; 2) Convergence from below; 3) Divergence from below; 4) Divergence from above (*)
•	l_SF_totalpc: total Structural Funds expenditures per capita (log) (*)
•	l_gdppc: initial level of GDP per inhabitant in PPS (log) (*)
•	educ_ed25645_8_t: percentage of the regional population between 25 and 64 years old with tertiary education –ISCED levels 5 to 8 (*)
•	emplrate: ratio between the employed and the working age population (15 to 64 years old) in the region (*)
•	l_popdens: population per square kilometer (log) (*)
•	below_EU_GDPpc: indicator for below/above the EU average GDP per inhabitant in PPS (*)

(*)	from/based on the PERCEIVE-QOG EU Regional Dataset 
DOI: 10.5281/zenodo.845349
PERCEIVE regional panel datasets.zip      codebook for regional panel dataset.pdf