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

Eurostat code: earn_ses22_adeci · (2022 - 2022)

@eurostat.earn_ses22_adeci

Table List

2 tables(14.16 KB)

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

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

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

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

7.36 KB
864 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	5345
Annual	Full-time	Median	Euro	Austria	2022	45466
Annual	Full-time	Median	Euro	Bosnia and Herzegovina	2022	9508
Annual	Full-time	Median	Euro	Belgium	2022	50994
Annual	Full-time	Median	Euro	Bulgaria	2022	9530
Annual	Full-time	Median	Euro	Switzerland	2022	84109
Annual	Full-time	Median	Euro	Cyprus	2022	22850
Annual	Full-time	Median	Euro	Czechia	2022	19121
Annual	Full-time	Median	Euro	Germany	2022	46721
Annual	Full-time	Median	Euro	Denmark	2022	63808


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.