Multinational Enterprise Groups In EU-EFTA Countries By Controlling Country - Experimental Statistics

Eurostat code: egr_mne · (2018 - 2022)

@eurostat.egr_mne

Table List

2 tables(10.94 KB)

Multinational Enterprise Groups In EU-EFTA Countries By Controlling Country - Experimental Statistics - Raw

Multinational Enterprise Groups In EU-EFTA Countries By Controlling Country - Experimental Statistics - Unpivoted

Multinational Enterprise Groups In EU-EFTA Countries By Controlling Country - Experimental Statistics - Unpivoted

@eurostat.egr_mne.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.

4.51 KB
50 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Number	European Union - 27 countries (from 2020)	2018	88435
Annual	Number	European Union - 27 countries (from 2020) and European Free Trade Association (EFTA) countries	2018	101898
Annual	Number	Non-EU27 countries (from 2020)	2018	44564
Annual	Number	Non-EU27 countries (from 2020) nor EFTA countries	2018	31101
Annual	Number	All countries of the world	2018	132999
Annual	Percentage	European Union - 27 countries (from 2020)	2018	66.5
Annual	Percentage	European Union - 27 countries (from 2020) and European Free Trade Association (EFTA) countries	2018	76.6
Annual	Percentage	Non-EU27 countries (from 2020)	2018	33.5
Annual	Percentage	Non-EU27 countries (from 2020) nor EFTA countries	2018	23.4
Annual	Percentage	All countries of the world	2018	100


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

Share link

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