Employed Persons By Actual Hours Worked In Main And Second Job During The Reference Week - Quarterly Data
Eurostat code: lfsi_hwa_q ยท (2021-Q1 - 2025-Q2)
@eurostat.lfsi_hwa_q
Eurostat code: lfsi_hwa_q ยท (2021-Q1 - 2025-Q2)
@eurostat.lfsi_hwa_q
This Eurostat dataset contains data on employed persons by actual hours worked in main and second job during the reference week - quarterly data, as collected and published by the Statistical Office of the European Union.
raw
: Original table as downloaded from Eurostat.tidy
: A cleaned and transformed version of the raw
table, where time period values appear as rows instead of columns (unpivoted format).Last updated: 2025-10-06T23:00:00+0200
CREATE TABLE raw (
"freq" VARCHAR,
"s_adj" VARCHAR,
"duration" VARCHAR,
"sex" VARCHAR,
"age" VARCHAR,
"unit" VARCHAR,
"geo" VARCHAR,
"n_2021_q1" DOUBLE -- 2021-Q1,
"n_2021_q2" DOUBLE -- 2021-Q2,
"n_2021_q3" DOUBLE -- 2021-Q3,
"n_2021_q4" DOUBLE -- 2021-Q4,
"n_2022_q1" DOUBLE -- 2022-Q1,
"n_2022_q2" DOUBLE -- 2022-Q2,
"n_2022_q3" DOUBLE -- 2022-Q3,
"n_2022_q4" DOUBLE -- 2022-Q4,
"n_2023_q1" DOUBLE -- 2023-Q1,
"n_2023_q2" DOUBLE -- 2023-Q2,
"n_2023_q3" DOUBLE -- 2023-Q3,
"n_2023_q4" DOUBLE -- 2023-Q4,
"n_2024_q1" DOUBLE -- 2024-Q1,
"n_2024_q2" DOUBLE -- 2024-Q2,
"n_2024_q3" DOUBLE -- 2024-Q3,
"n_2024_q4" DOUBLE -- 2024-Q4,
"n_2025_q1" DOUBLE -- 2025-Q1,
"n_2025_q2" DOUBLE -- 2025-Q2
);
CREATE TABLE tidy (
"freq" VARCHAR,
"s_adj" VARCHAR,
"duration" VARCHAR,
"sex" VARCHAR,
"age" VARCHAR,
"unit" VARCHAR,
"geo" VARCHAR,
"time_period" VARCHAR,
"value" DOUBLE
);
Anyone who has the link will be able to view this.