Hourly Earnings By Economic Activity And Contractual Working Time (2022)

Eurostat code: earn_ses22_hftpt · (2022 - 2022)

@eurostat.earn_ses22_hftpt

Table List

2 tables(27.18 KB)

Hourly Earnings By Economic Activity And Contractual Working Time (2022) - Raw

Hourly Earnings By Economic Activity And Contractual Working Time (2022) - Unpivoted

Hourly Earnings By Economic Activity And Contractual Working Time (2022) - Unpivoted

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

13.87 KB
1605 rows
7 columns

freq Freq	worktime Worktime	nace_r2 Nace R2	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Full-time	Industry and construction	Euro	Albania	2022	2.77
Annual	Full-time	Industry and construction	Euro	Austria	2022	21.63
Annual	Full-time	Industry and construction	Euro	Bosnia and Herzegovina	2022	5.13
Annual	Full-time	Industry and construction	Euro	Belgium	2022	25.13
Annual	Full-time	Industry and construction	Euro	Bulgaria	2022	4.83
Annual	Full-time	Industry and construction	Euro	Switzerland	2022	43.93
Annual	Full-time	Industry and construction	Euro	Cyprus	2022	10.42
Annual	Full-time	Industry and construction	Euro	Czechia	2022	9.3
Annual	Full-time	Industry and construction	Euro	Germany	2022	25.07
Annual	Full-time	Industry and construction	Euro	Denmark	2022	38.28


CREATE TABLE tidy (
  "freq" VARCHAR,
  "worktime" 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.