Home » Research » Library » Research Guides » Economics » Statistics » Statistical Data » ERD

European Regional (Sub-state) Database

 


Data description

RegionsThe European Regional Database provides disaggregated data for European sub-state regions. Multiple indicators of growth, convergence, competitiveness and demography are included. Coverage is from 1980 to 2015 (data release, December 2017). The data is presented in eight large Excel files on the Library's restricted server (access instructions further below).

The European Regional Database is created by Cambridge Econometrics, based on data from Eurostat, the European Commission's AMECO database (DG ECFIN) and other international sources.

The Eurostat Regional Yearbook is at this link.

 


ERD variables

Employment

  • The following descriptions are provided by ERD publisher, Cambridge Econometrics
  • Definition: Employment covers all persons engaged in some productive activity (within the production boundary of the national accounts). Employed persons are either employees (working by agreement for another resident unit and receiving remuneration) or self-employed (owners of unincorporated enterprises). Employment is a workplace based measure and therefore attributes people to the region in which they work rather than where they live.
  • Units: Thousands of people
  • Source(s): Eurostat, AMECO
  • Disaggregation: 6 Sectors, NUTS 3
  • Methodology: Missing data is filled by scaling up data from sub-regions, extrapolation and interpolation. Manual fixes are implemented and the data is scaled to AMECO totals.

Gross Value Added

  • Definition: GVA is the net result of output valued at basic prices less intermediate consumption valued at purchasers' prices deflated to 2005 constant price euros. Output consists of the products created during the accounting period. Intermediate consumption consists of the value of the goods and services consumed as inputs by a process of production, excluding fixed assets whose consumption is recorded as consumption of fixed capital. The goods and services may be either transformed or used up by the production process. GVA is calculated before consumption of fixed capital.
  • Units: Millions of Euro in 2005 prices
  • Source(s): Eurostat, AMECO
  • Disaggregation: 6 Sectors, NUTS 3
  • Methodology: GVA is divided by employment to produce productivity. Missing productivity data is filled by scaling up data from sub-regions, extrapolation and interpolation. Productivity is then multiplied by employment to generate GVA. Manual fixes are implemented and the data is scaled to AMECO totals.

Gross Domestic Product

  • Definition: GDP is defined as Total Gross Value Added plus taxes less subsidies on products. Taxes and subsidies are taxes or subsidies payable (resp. receivable) per unit of some good or service produced or transacted. They include in particular value added taxes, taxes and duties on imports, and taxes such as stamp taxes on the sale of alcohol and tobacco. When calculating value added, output is valued at basic prices whereas intermediate consumption is valued at purchaser's prices, and thus the difference between taxes and subsidies on products has to be put on top of value added. The resulting GDP is then valued at market prices before being deflated to 2005 constant price euros.
  • Units: Billions of Euro in 2005 prices
  • Source(s): Eurostat, AMECO
  • Disaggregation: No sector disaggregation, NUTS 3
  • Methodology: Missing data is filled by applying GVA growth rates. Manual fixes are implemented and the data is scaled to AMECO totals.

Compensation of Employees

  • Definition: Compensation of Employees is defined as the total remuneration, in cash or in kind, payable by an employer to an employee in return for work done by the latter during the accounting period. Compensation of employees consists of wages and salaries, and of employers' social contributions. Current price compensation of employees is deflated to 2005 constant price euros
  • Units: Millions of Euro in 2005 prices
  • Source(s): Eurostat, AMECO
  • Disaggregation: 6 sectors, NUTS 2
  • Methodology: Compensation of Employees is filled by interpolating and extrapolating the ratio between GVA and Compensation of Employees. Manual fixes are implemented and the data is scaled to AMECO totals.

Gross Fixed Capital Formation 

  • Definition: GFCF consists of resident producers' acquisitions, less disposals, of fixed assets during a given period plus certain additions to the value of non-produced assets realised by the productive activity of producer or institutional units. Fixed assets are tangible or intangible assets produced as outputs from processes of production that are themselves used repeatedly, or continuously, in processes of production for more than one year. Disposals of fixed assets are treated as negative acquisitions. Current price GFCF is deflated to 2005 constant price euros.
  • Units: Millions of Euro in 2005 prices
  • Source(s): Eurostat, AMECO
  • Disaggregation: 6 Sectors, NUTS 2
  • Methodology: Missing data is filled by interpolating and extrapolating the ratio between GVA and GFCF. Manual fixes are implemented and the data is scaled to AMECO totals.

Hours Worked

  • Definition: Hours worked is the number of hours actually worked, defined as the sum of all periods spent on direct and ancillary activities to produce goods and services.
  • Units: Total annual hours worked (Millions of hours worked)
  • Source(s): Eurostat, AMECO, OECD
  • Disaggregation: 6 Sectors, NUTS 2
  • Methodology: Average weekly hours worked data is converted into total hours worked per worker. Missing data is filled by scaling up data from sub-regions, extrapolation and interpolation. Manual fixes are implemented and the data is scaled to AMECO totals. Total hours worked per worker is multiplied by employment to produce total hours worked.

Population 

  • Definition: Population consists of all persons, nationals or foreigners, who are permanently settled in the economic territory of the country, even if they are temporarily absent from it, on a given date. A person staying or intending to stay at least one year is considered to be settled on the territory. By convention, the total population includes neither foreign students nor members of foreign armed forces stationed in a country. Population and active population are household based measures, meaning people are allocated to the region in which they live, rather than where they work. Using these measures to calculate employment rates can therefore give misleading results which do not take account of commuting effects.
  • Units: Thousands of people
  • Source(s): Eurostat, AMECO
  • Disaggregation: No sector disaggregation, NUTS 3
  • Methodology: Missing data is filled using basic interpolation and extrapolation. Manual fixes are implemented and the data is scaled to AMECO totals.

Active Population

  • Definition: The active population includes both employed and unemployed people, but not economically inactive, such as students and pensioners. Population and active population are household based measures, meaning people are allocated to the region in which they live, rather than where they work. Using these measures to calculate employment rates can therefore give misleading results which do not take account of commuting effects.
  • Units: Thousands of people
  • Source(s): Eurostat, AMECO
  • Disaggregation: No sector disaggregation, NUTS 2
  • Methodology: Missing data is filled by scaling up data from sub-regions and applying Population growth rates. The data is then scaled to AMECO totals.

 


Time period

Version: December, 2017
Data is from 1980 to 2015
Coverage of newer EU member states is from 1990 to 2012.

 


Support links

 


How to access data
  • Access to the European Regional Database (in eight data folders) is available via the EUI Library restricted data server. EUI members can register as follows:
  • Complete the Library's Micro Data Registration Form (selecting 'European Regional Data' from the menu)
  • Following confirmation of status, registered current EUI members are given clearance to access the data via secured server. There is no off-site access.

There are two dossiers: 'Data' and 'Docs.'

The Data dossier contains seven Excel spreadsheets. Each sheet contains one variable or - in the case of variables with a sectoral dimension - one sector per sheet.

The Docs dossier contains the table of indicators, units and geo-code information.

 


Related resources

The Eurostat Regional Yearbook is at this link.

The EU Regional Competitiveness Index, prepared by the EC Directorate General REGIO and DG Joint Research, ranks European Union NUTS-2 regions by economic strength, using eleven variables: (1) Quality of Institutions (2) Macro-economic Stability (3) Infrastructure (4) Health (5) Quality of Primary and Secondary Education (6) Higher Education and Lifelong Learning (7) Labour Market Efficiency (8) Market Size (9) Technological Readiness, (10) Business Sophistication and (11) Innovation. RCI-2016 tables are available in Excel format.

 


Data homepage

Contact: Thomas Bourke at [email protected]

 

Data_Portal

 


 

Page last updated on 19 July 2019