Enterprises By Type Of Business Strategy Applied, Importance Of The Strategy, NACE Rev. 2 Activity And Size Class (2020)

Eurostat code: inn_cis12_strat · (2020 - 2020)

@eurostat.inn_cis12_strat

Table List

2 tables(2.44 MB)

Enterprises By Type Of Business Strategy Applied, Importance Of The Strategy, NACE Rev. 2 Activity And Size Class (2020) - Raw

Enterprises By Type Of Business Strategy Applied, Importance Of The Strategy, NACE Rev. 2 Activity And Size Class (2020) - Unpivoted

Enterprises By Type Of Business Strategy Applied, Importance Of The Strategy, NACE Rev. 2 Activity And Size Class (2020) - Unpivoted

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

1.22 MB
574074 rows
10 columns

freq Freq	bsn_strat Bsn Strat	lev_impt Lev Impt	enterpr Enterpr	sizeclas Sizeclas	nace_r2 Nace R2	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Focus on a broad range of goods and services	High	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Czechia	2020	5
Annual	Focus on a broad range of goods and services	High	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Germany	2020	40
Annual	Focus on a broad range of goods and services	High	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Denmark	2020	1
Annual	Focus on a broad range of goods and services	High	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Estonia	2020	4
Annual	Focus on a broad range of goods and services	High	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Greece	2020	12
Annual	Focus on a broad range of goods and services	High	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Croatia	2020	2
Annual	Focus on a broad range of goods and services	High	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Hungary	2020	3
Annual	Focus on a broad range of goods and services	High	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Italy	2020	19
Annual	Focus on a broad range of goods and services	High	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Lithuania	2020	2
Annual	Focus on a broad range of goods and services	High	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Luxembourg	2020


CREATE TABLE tidy (
  "freq" VARCHAR,
  "bsn_strat" VARCHAR,
  "lev_impt" 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.