Foreign Control Of Enterprises By Economic Activity And A Selection Of Controlling Countries (2008-2020)

Eurostat code: fats_g1a_08 · (2008 - 2020)

@eurostat.fats_g1a_08

Table List

2 tables(83.14 MB)

Foreign Control Of Enterprises By Economic Activity And A Selection Of Controlling Countries (2008-2020) - Raw

Foreign Control Of Enterprises By Economic Activity And A Selection Of Controlling Countries (2008-2020) - Unpivoted

Foreign Control Of Enterprises By Economic Activity And A Selection Of Controlling Countries (2008-2020) - Unpivoted

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

42.41 MB
24409916 rows
7 columns

freq Freq	nace_r2 Nace R2	indic_sb Indic Sb	c_ctrl C Ctrl	geo Geo	time_period Time Period	value Value
Annual	Mining and quarrying	Enterprises - number	Austria	Cyprus	2008
Annual	Mining and quarrying	Enterprises - number	Austria	Czechia	2008	9
Annual	Mining and quarrying	Enterprises - number	Austria	Germany	2008	8
Annual	Mining and quarrying	Enterprises - number	Austria	Denmark	2008
Annual	Mining and quarrying	Enterprises - number	Austria	Estonia	2008
Annual	Mining and quarrying	Enterprises - number	Austria	Spain	2008
Annual	Mining and quarrying	Enterprises - number	Austria	Finland	2008
Annual	Mining and quarrying	Enterprises - number	Austria	Croatia	2008	13
Annual	Mining and quarrying	Enterprises - number	Austria	Hungary	2008	15
Annual	Mining and quarrying	Enterprises - number	Austria	Ireland	2008


CREATE TABLE tidy (
  "freq" VARCHAR,
  "nace_r2" VARCHAR,
  "indic_sb" VARCHAR,
  "c_ctrl" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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