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

Eurostat code: inn_cis12_mrkt · (2020 - 2020)

@eurostat.inn_cis12_mrkt

Table List

2 tables(603.11 KB)

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

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

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

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

302.08 KB
59776 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	Percentage	Belgium	2020	10.3
Annual	Other EU or EFTA countries	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Percentage	Czechia	2020	27.2
Annual	Other EU or EFTA countries	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Percentage	Germany	2020	2
Annual	Other EU or EFTA countries	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Percentage	Greece	2020	10.2
Annual	Other EU or EFTA countries	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Percentage	Croatia	2020	2.9
Annual	Other EU or EFTA countries	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Percentage	Hungary	2020	4.9
Annual	Other EU or EFTA countries	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Percentage	Italy	2020	1.9
Annual	Other EU or EFTA countries	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Percentage	Lithuania	2020	43.5
Annual	Other EU or EFTA countries	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Percentage	Malta	2020
Annual	Other EU or EFTA countries	Innovation active enterprises	From 10 to 49 employees	Mining and quarrying	Percentage	Portugal	2020	11


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.