Compensation Of Employees By NUTS 2 Region

Eurostat code: nama_10r_2coe · (1995 - 2023)

@eurostat.nama_10r_2coe

Table List

2 tables(2.6 MB)

Compensation Of Employees By NUTS 2 Region - Raw

Compensation Of Employees By NUTS 2 Region - Unpivoted

Compensation Of Employees By NUTS 2 Region - Unpivoted

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

1.33 MB
281024 rows
6 columns

freq Freq	currency Currency	nace_r2 Nace R2	geo Geo	time_period Time Period	value Value
Annual	Million euro	Agriculture, forestry and fishing	Cyprus	1995	43.43
Annual	Million euro	Agriculture, forestry and fishing	Kýpros	1995	43.43
Annual	Million euro	Agriculture, forestry and fishing	Kýpros	1995	43.43
Annual	Million euro	Agriculture, forestry and fishing	Czechia	1995	821.85
Annual	Million euro	Agriculture, forestry and fishing	Česko	1995	821.85
Annual	Million euro	Agriculture, forestry and fishing	Praha	1995	3.72
Annual	Million euro	Agriculture, forestry and fishing	Střední Čechy	1995	106.5
Annual	Million euro	Agriculture, forestry and fishing	Jihozápad	1995	168.69
Annual	Million euro	Agriculture, forestry and fishing	Severozápad	1995	52.14
Annual	Million euro	Agriculture, forestry and fishing	Severovýchod	1995	136.73


CREATE TABLE tidy (
  "freq" VARCHAR,
  "currency" VARCHAR,
  "nace_r2" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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