Number Of Statistical Units Selected For The Survey, By NACE Rev. 1.1 Activity - LCS Survey 2008

Eurostat code: lc_n08stu_r1 · (2008 - 2008)

@eurostat.lc_n08stu_r1

Table List

2 tables(40.62 KB)

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

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

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

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

20.49 KB
2786 rows
8 columns

freq Freq	statinfo Statinfo	sizeclas Sizeclas	nace_r1 Nace R1	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Sample	10 employees or more	Mining and quarrying	Number	Austria	2008	79
Annual	Sample	10 employees or more	Mining and quarrying	Number	Bulgaria	2008	179
Annual	Sample	10 employees or more	Mining and quarrying	Number	Cyprus	2008	29
Annual	Sample	10 employees or more	Mining and quarrying	Number	Czechia	2008	127
Annual	Sample	10 employees or more	Mining and quarrying	Number	Germany	2008	692
Annual	Sample	10 employees or more	Mining and quarrying	Number	Denmark	2008	188
Annual	Sample	10 employees or more	Mining and quarrying	Number	Euro area - 16 countries (2009-2010)	2008	1764
Annual	Sample	10 employees or more	Mining and quarrying	Number	Euro area - 17 countries (2011-2013)	2008	1764
Annual	Sample	10 employees or more	Mining and quarrying	Number	Euro area - 18 countries (2014)	2008	1809
Annual	Sample	10 employees or more	Mining and quarrying	Number	Euro area - 19 countries (2015-2022)	2008	1807


CREATE TABLE tidy (
  "freq" VARCHAR,
  "statinfo" VARCHAR,
  "sizeclas" VARCHAR,
  "nace_r1" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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