Enterprises By Year Of Registration And By Type Of Enterprise, NACE Rev.2 Activity And Size Class (2020)

Eurostat code: inn_cis12_yreg · (2020 - 2020)

@eurostat.inn_cis12_yreg

Table List

2 tables(214.88 KB)

Enterprises By Year Of Registration And By Type Of Enterprise, NACE Rev.2 Activity And Size Class (2020) - Raw

Enterprises By Year Of Registration And By Type Of Enterprise, NACE Rev.2 Activity And Size Class (2020) - Unpivoted

Enterprises By Year Of Registration And By Type Of Enterprise, NACE Rev.2 Activity And Size Class (2020) - Unpivoted

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

107 KB
48252 rows
9 columns

freq Freq	y_regis Y Regis	enterpr Enterpr	sizeclas Sizeclas	nace_r2 Nace R2	unit Unit	geo Geo	time_period Time Period	value Value
Annual	From 2012 to 2015	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Bulgaria	2020
Annual	From 2012 to 2015	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Czechia	2020	1
Annual	From 2012 to 2015	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Germany	2020	13
Annual	From 2012 to 2015	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Estonia	2020	1
Annual	From 2012 to 2015	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Greece	2020	6
Annual	From 2012 to 2015	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Hungary	2020	1
Annual	From 2012 to 2015	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Italy	2020	5
Annual	From 2012 to 2015	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Lithuania	2020	4
Annual	From 2012 to 2015	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Latvia	2020
Annual	From 2012 to 2015	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Malta	2020


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

Share link

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