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

Eurostat code: lc_r00stu · (2000 - 2000)

@eurostat.lc_r00stu

Table List

2 tables(47.84 KB)

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

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

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

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

24.11 KB
5331 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	2000	37
Annual	Sample	10 employees or more	Mining and quarrying	Number	Ostösterreich	2000	14
Annual	Sample	10 employees or more	Mining and quarrying	Number	Südösterreich	2000	14
Annual	Sample	10 employees or more	Mining and quarrying	Number	Westösterreich	2000	9
Annual	Sample	10 employees or more	Mining and quarrying	Number	Belgium	2000	68
Annual	Sample	10 employees or more	Mining and quarrying	Number	Vlaams Gewest	2000	21
Annual	Sample	10 employees or more	Mining and quarrying	Number	Région wallonne	2000	47
Annual	Sample	10 employees or more	Mining and quarrying	Number	Germany	2000	702
Annual	Sample	10 employees or more	Mining and quarrying	Number	Baden-Württemberg	2000	72
Annual	Sample	10 employees or more	Mining and quarrying	Number	Bayern	2000	76


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.