Multinational Enterprise Groups In EU-EFTA Countries By Controlling Country, Size Class And NACE Rev.2 Activity - Experimental Statistics

Eurostat code: egr_mne_n2sc · (2018 - 2022)

@eurostat.egr_mne_n2sc

Table List

2 tables(17.2 KB)

Multinational Enterprise Groups In EU-EFTA Countries By Controlling Country, Size Class And NACE Rev.2 Activity - Experimental Statistics - Raw

Multinational Enterprise Groups In EU-EFTA Countries By Controlling Country, Size Class And NACE Rev.2 Activity - Experimental Statistics - Unpivoted

Multinational Enterprise Groups In EU-EFTA Countries By Controlling Country, Size Class And NACE Rev.2 Activity - Experimental Statistics - Unpivoted

@eurostat.egr_mne_n2sc.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

7.41 KB
345 rows
7 columns

freq Freq	nace_r2 Nace R2	size_emp Size Emp	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Mining and quarrying	Total	Percentage of total	European Union - 27 countries (from 2020)	2018	0.3
Annual	Mining and quarrying	Total	Percentage of total	European Union - 27 countries (from 2020) and European Free Trade Association (EFTA) countries	2018	0.4
Annual	Mining and quarrying	Total	Percentage of total	All countries of the world	2018	0.4
Annual	Manufacturing	Total	Percentage of total	European Union - 27 countries (from 2020)	2018	19.5
Annual	Manufacturing	Total	Percentage of total	European Union - 27 countries (from 2020) and European Free Trade Association (EFTA) countries	2018	19.1
Annual	Manufacturing	Total	Percentage of total	All countries of the world	2018	18.1
Annual	Electricity, gas, steam and air conditioning supply	Total	Percentage of total	European Union - 27 countries (from 2020)	2018	1.2
Annual	Electricity, gas, steam and air conditioning supply	Total	Percentage of total	European Union - 27 countries (from 2020) and European Free Trade Association (EFTA) countries	2018	1.2
Annual	Electricity, gas, steam and air conditioning supply	Total	Percentage of total	All countries of the world	2018	1
Annual	Water supply; sewerage, waste management and remediation activities	Total	Percentage of total	European Union - 27 countries (from 2020)	2018	0.5


CREATE TABLE tidy (
  "freq" VARCHAR,
  "nace_r2" VARCHAR,
  "size_emp" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.