Monthly Earnings By Quantiles And Contractual Working Time - NACE Rev. 2, B-S Excluding O (2022)

Eurostat code: earn_ses22_mdeci · (2022 - 2022)

@eurostat.earn_ses22_mdeci

Table List

2 tables(19.39 KB)

Monthly Earnings By Quantiles And Contractual Working Time - NACE Rev. 2, B-S Excluding O (2022) - Raw

Monthly Earnings By Quantiles And Contractual Working Time - NACE Rev. 2, B-S Excluding O (2022) - Unpivoted

Monthly Earnings By Quantiles And Contractual Working Time - NACE Rev. 2, B-S Excluding O (2022) - Unpivoted

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

9.98 KB
1284 rows
7 columns

freq Freq	worktime Worktime	quant_inc Quant Inc	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Full-time	Median	Euro	Albania	2022	441
Annual	Full-time	Median	Euro	Austria	2022	3111
Annual	Full-time	Median	Euro	Bosnia and Herzegovina	2022	788
Annual	Full-time	Median	Euro	Belgium	2022	3843
Annual	Full-time	Median	Euro	Bulgaria	2022	705
Annual	Full-time	Median	Euro	Switzerland	2022	7009
Annual	Full-time	Median	Euro	Cyprus	2022	1686
Annual	Full-time	Median	Euro	Czechia	2022	1424
Annual	Full-time	Median	Euro	Germany	2022	3469
Annual	Full-time	Median	Euro	Denmark	2022	4998


CREATE TABLE tidy (
  "freq" VARCHAR,
  "worktime" VARCHAR,
  "quant_inc" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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