Compensation Per Employee And Hours Worked Per Employed Person By NUTS 2 Regions And By Industry

Eurostat code: nama_10r_2lp10 · (1995 - 2023)

@eurostat.nama_10r_2lp10

Table List

2 tables(1.73 MB)

Compensation Per Employee And Hours Worked Per Employed Person By NUTS 2 Regions And By Industry - Raw

Compensation Per Employee And Hours Worked Per Employed Person By NUTS 2 Regions And By Industry - Unpivoted

Compensation Per Employee And Hours Worked Per Employed Person By NUTS 2 Regions And By Industry - Unpivoted

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

918.6 KB
432832 rows
7 columns

freq Freq	nace_r2 Nace R2	na_item Na Item	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Agriculture, forestry and fishing	Compensation of employees per hour worked	Euro	Cyprus	1995	3.1
Annual	Agriculture, forestry and fishing	Compensation of employees per hour worked	Euro	Kýpros	1995	3.1
Annual	Agriculture, forestry and fishing	Compensation of employees per hour worked	Euro	Kýpros	1995	3.1
Annual	Agriculture, forestry and fishing	Compensation of employees per hour worked	Euro	Czechia	1995	1.9
Annual	Agriculture, forestry and fishing	Compensation of employees per hour worked	Euro	Česko	1995	1.9
Annual	Agriculture, forestry and fishing	Compensation of employees per hour worked	Euro	Praha	1995	0.9
Annual	Agriculture, forestry and fishing	Compensation of employees per hour worked	Euro	Střední Čechy	1995	1.9
Annual	Agriculture, forestry and fishing	Compensation of employees per hour worked	Euro	Jihozápad	1995	2.2
Annual	Agriculture, forestry and fishing	Compensation of employees per hour worked	Euro	Severozápad	1995	1.3
Annual	Agriculture, forestry and fishing	Compensation of employees per hour worked	Euro	Severovýchod	1995	1.8


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

Share link

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