Number Of Statistical Units Selected For The Survey, By NACE Rev. 2 Activity

Eurostat code: lc_nstu_r2 · (2008 - 2020)

@eurostat.lc_nstu_r2

Table List

2 tables(1.15 MB)

Number Of Statistical Units Selected For The Survey, By NACE Rev. 2 Activity - Raw

Number Of Statistical Units Selected For The Survey, By NACE Rev. 2 Activity - Unpivoted

Number Of Statistical Units Selected For The Survey, By NACE Rev. 2 Activity - Unpivoted

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

584.67 KB
190148 rows
8 columns

freq Freq	statinfo Statinfo	sizeclas Sizeclas	nace_r2 Nace R2	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Sample	From 10 to 49 employees	Mining and quarrying	Number	Austria	2008	15
Annual	Sample	From 10 to 49 employees	Mining and quarrying	Number	Bulgaria	2008	103
Annual	Sample	From 10 to 49 employees	Mining and quarrying	Number	Cyprus	2008	25
Annual	Sample	From 10 to 49 employees	Mining and quarrying	Number	Czechia	2008	73
Annual	Sample	From 10 to 49 employees	Mining and quarrying	Number	Germany	2008	211
Annual	Sample	From 10 to 49 employees	Mining and quarrying	Number	Denmark	2008	77
Annual	Sample	From 10 to 49 employees	Mining and quarrying	Number	Euro area - 16 countries (2009-2010)	2008	732
Annual	Sample	From 10 to 49 employees	Mining and quarrying	Number	Euro area - 17 countries (2011-2013)	2008	732
Annual	Sample	From 10 to 49 employees	Mining and quarrying	Number	Euro area - 18 countries (2014)	2008	766
Annual	Sample	From 10 to 49 employees	Mining and quarrying	Number	Euro area - 19 countries (2015-2022)	2008	791


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