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

Eurostat code: lc_n04stu · (2004 - 2004)

@eurostat.lc_n04stu

Table List

2 tables(115.12 KB)

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

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

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

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

57.12 KB
17263 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	From 10 to 49 employees	Agriculture, hunting and forestry	Number	European Union - 27 countries (2007-2013)	2004	1192
Annual	Sample	From 10 to 49 employees	Agriculture, hunting and forestry	Number	Hungary	2004	811
Annual	Sample	From 10 to 49 employees	Agriculture, hunting and forestry	Number	Romania	2004	331
Annual	Sample	From 10 to 49 employees	Fishing	Number	European Union - 27 countries (2007-2013)	2004	68
Annual	Sample	From 10 to 49 employees	Fishing	Number	Hungary	2004	17
Annual	Sample	From 10 to 49 employees	Fishing	Number	Romania	2004	47
Annual	Sample	From 10 to 49 employees	Mining and quarrying	Number	Austria	2004	24
Annual	Sample	From 10 to 49 employees	Mining and quarrying	Number	Bulgaria	2004	26
Annual	Sample	From 10 to 49 employees	Mining and quarrying	Number	Cyprus	2004	5
Annual	Sample	From 10 to 49 employees	Mining and quarrying	Number	Czechia	2004	28


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.