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

Eurostat code: lc_n00stu · (2000 - 2000)

@eurostat.lc_n00stu

Table List

2 tables(95.29 KB)

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

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

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

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

47.44 KB
13483 rows
8 columns

freq Freq	statinfo Statinfo	nace_r1 Nace R1	sizeclas Sizeclas	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Sample	Agriculture, hunting and forestry	From 10 to 49 employees	Number	Estonia	2000
Annual	Sample	Agriculture, hunting and forestry	From 10 to 49 employees	Number	Hungary	2000	925
Annual	Sample	Agriculture, hunting and forestry	From 10 to 49 employees	Number	Romania	2000	451
Annual	Sample	Agriculture, hunting and forestry	From 10 to 49 employees	Number	Slovakia	2000	14
Annual	Sample	Agriculture, hunting and forestry	From 250 to 499 employees	Number	Estonia	2000
Annual	Sample	Agriculture, hunting and forestry	From 250 to 499 employees	Number	Hungary	2000	46
Annual	Sample	Agriculture, hunting and forestry	From 250 to 499 employees	Number	Romania	2000	79
Annual	Sample	Agriculture, hunting and forestry	From 250 to 499 employees	Number	Slovakia	2000	9
Annual	Sample	Agriculture, hunting and forestry	From 50 to 249 employees	Number	Estonia	2000
Annual	Sample	Agriculture, hunting and forestry	From 50 to 249 employees	Number	Hungary	2000	763


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

Share link

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