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

Eurostat code: lc_r04stu · (2004 - 2004)

@eurostat.lc_r04stu

Table List

2 tables(56.74 KB)

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

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

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

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

28.62 KB
7278 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	Agriculture, hunting and forestry	Number	Région de Bruxelles-Capitale/Brussels Hoofdstedelijk Gewest	2004
Annual	Sample	10 employees or more	Agriculture, hunting and forestry	Number	Vlaams Gewest	2004
Annual	Sample	10 employees or more	Agriculture, hunting and forestry	Number	Région wallonne	2004
Annual	Sample	10 employees or more	Agriculture, hunting and forestry	Number	Közép-Magyarország	2004	153
Annual	Sample	10 employees or more	Agriculture, hunting and forestry	Number	Dunántúl	2004	549
Annual	Sample	10 employees or more	Agriculture, hunting and forestry	Number	Alföld és Észak	2004	642
Annual	Sample	10 employees or more	Fishing	Number	Région de Bruxelles-Capitale/Brussels Hoofdstedelijk Gewest	2004
Annual	Sample	10 employees or more	Fishing	Number	Vlaams Gewest	2004
Annual	Sample	10 employees or more	Fishing	Number	Région wallonne	2004
Annual	Sample	10 employees or more	Fishing	Number	Közép-Magyarország	2004	4


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.