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) - Raw

@eurostat.fats_g1a_08.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

40.72 MB
3942642 rows
18 columns

freq Freq	nace_r2 Nace R2	indic_sb Indic Sb	c_ctrl C Ctrl	geo Geo	n_2008 2008	n_2009 2009	n_2010 2010	n_2011 2011	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020
Annual	Mining and quarrying	Enterprises - number	Austria	Bosnia and Herzegovina							3
Annual	Mining and quarrying	Enterprises - number	Austria	Belgium
Annual	Mining and quarrying	Enterprises - number	Austria	Bulgaria		5	4	5	4	4	4		5		4	3
Annual	Mining and quarrying	Enterprises - number	Austria	Cyprus
Annual	Mining and quarrying	Enterprises - number	Austria	Czechia	9	7	6	4	4	4	4	3	5	5	3	3	3
Annual	Mining and quarrying	Enterprises - number	Austria	Germany	8	7	8	11		18	23	17	12	13		2	2
Annual	Mining and quarrying	Enterprises - number	Austria	Denmark
Annual	Mining and quarrying	Enterprises - number	Austria	Estonia
Annual	Mining and quarrying	Enterprises - number	Austria	Greece
Annual	Mining and quarrying	Enterprises - number	Austria	Spain


CREATE TABLE raw (
  "freq" VARCHAR,
  "nace_r2" VARCHAR,
  "indic_sb" VARCHAR,
  "c_ctrl" VARCHAR,
  "geo" VARCHAR,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE
);

Share link

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