Enterprises By Market Place, NACE Rev. 2 Activity And Size Class (2020)

Eurostat code: inn_cis12_mrk · (2020 - 2020)

@eurostat.inn_cis12_mrk

Table List

2 tables(323.08 KB)

Enterprises By Market Place, NACE Rev. 2 Activity And Size Class (2020) - Raw

Enterprises By Market Place, NACE Rev. 2 Activity And Size Class (2020) - Unpivoted

Enterprises By Market Place, NACE Rev. 2 Activity And Size Class (2020) - Unpivoted

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

161.73 KB
66501 rows
9 columns

freq Freq	mktplace Mktplace	enterpr Enterpr	sizeclas Sizeclas	nace_r2 Nace R2	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Other EU or EFTA countries	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Czechia	2020	12
Annual	Other EU or EFTA countries	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Germany	2020	74
Annual	Other EU or EFTA countries	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Estonia	2020	12
Annual	Other EU or EFTA countries	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Greece	2020	10
Annual	Other EU or EFTA countries	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	France	2020	18
Annual	Other EU or EFTA countries	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Croatia	2020	5
Annual	Other EU or EFTA countries	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Hungary	2020	5
Annual	Other EU or EFTA countries	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Italy	2020	28
Annual	Other EU or EFTA countries	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Lithuania	2020	9
Annual	Other EU or EFTA countries	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Number	Luxembourg	2020	2


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