Number Of Statistical Units, By NACE Rev. 2 Activity And NUTS 1 Region

Eurostat code: lc_rstu_r2 · (2008 - 2020)

@eurostat.lc_rstu_r2

Table List

2 tables(345.5 KB)

Number Of Statistical Units, By NACE Rev. 2 Activity And NUTS 1 Region - Raw

Number Of Statistical Units, By NACE Rev. 2 Activity And NUTS 1 Region - Unpivoted

Number Of Statistical Units, By NACE Rev. 2 Activity And NUTS 1 Region - Unpivoted

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

163.48 KB
64430 rows
8 columns

freq Freq	statinfo Statinfo	sizeclas Sizeclas	nace_r2 Nace R2	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Sample	10 employees or more	Mining and quarrying	Number	Ostösterreich	2008	23
Annual	Sample	10 employees or more	Mining and quarrying	Number	Südösterreich	2008	20
Annual	Sample	10 employees or more	Mining and quarrying	Number	Westösterreich	2008	36
Annual	Sample	10 employees or more	Mining and quarrying	Number	Severna i Yugoiztochna Bulgaria	2008	83
Annual	Sample	10 employees or more	Mining and quarrying	Number	Yugozapadna i Yuzhna tsentralna Bulgaria	2008	93
Annual	Sample	10 employees or more	Mining and quarrying	Number	Baden-Württemberg	2008	56
Annual	Sample	10 employees or more	Mining and quarrying	Number	Bayern	2008	80
Annual	Sample	10 employees or more	Mining and quarrying	Number	Brandenburg	2008	33
Annual	Sample	10 employees or more	Mining and quarrying	Number	Hessen	2008	50
Annual	Sample	10 employees or more	Mining and quarrying	Number	Mecklenburg-Vorpommern	2008	17


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

Share link

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