Skip to content

Latest commit

 

History

History
 
 

multinational-enterprise-groups_sql

experimental

Experimental statistics on structure of the multinational enterprise groups

In an effort to better respond to users' needs, Eurostat publishes Experimental statistics on the related Eurostat website based on the EuroGroups Register (EGR) data. The EGR is part of the EU statistical infrastructure and has been built up to better capture globalisation effects as well as for improving the consistency of national data on enterprise groups.

Data source

To produce the experimental statistics, the data source is the EGR, the central statistical business register of Eurostat and the EU and European Free Trade Association (EFTA) countries' statistical authorities.

Background data table

The SQL source code in the file egr_groups.sql retrieves microdata source populations from the data base and builds table with generated information on breakdowns required to produce experimental statistics for the publication.

The SQL code

The SQL code shared here was used to produce the tables and graphics for the Statistics Explained publication on the Structure of multinational enterprise groups in the EU. This article gives an overview of the structure of multinational enterprise groups in the EU in 2016.

Every single table/figure presented in the article can be generated by running the corresponding source file and using microdata from the EGR, e.g. the SQL source code in the file egr_figure4.sql will enable you to reproduce the figure #4 of the statistics explained article.

Contacts

estat-egr@ec.europa.eu