Weekly Absences From Work, By Sex And Age - Weekly Data, Experimental Statistics
Eurostat code: lfsi_abs_w ยท (2015-W01 - 2022-W52)
@eurostat.lfsi_abs_w
Eurostat code: lfsi_abs_w ยท (2015-W01 - 2022-W52)
@eurostat.lfsi_abs_w
This Eurostat dataset contains data on weekly absences from work, by sex and age - weekly data, experimental statistics, 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: 2023-03-16T23:00:00+0100
CREATE TABLE raw (
"freq" VARCHAR,
"age" VARCHAR,
"sex" VARCHAR,
"unit" VARCHAR,
"geo" VARCHAR,
"n_2015_w01" DOUBLE -- 2015-W01,
"n_2015_w02" DOUBLE -- 2015-W02,
"n_2015_w03" DOUBLE -- 2015-W03,
"n_2015_w04" DOUBLE -- 2015-W04,
"n_2015_w05" DOUBLE -- 2015-W05,
"n_2015_w06" DOUBLE -- 2015-W06,
"n_2015_w07" DOUBLE -- 2015-W07,
"n_2015_w08" DOUBLE -- 2015-W08,
"n_2015_w09" DOUBLE -- 2015-W09,
"n_2015_w10" DOUBLE -- 2015-W10,
"n_2015_w11" DOUBLE -- 2015-W11,
"n_2015_w12" DOUBLE -- 2015-W12,
"n_2015_w13" DOUBLE -- 2015-W13,
"n_2015_w14" DOUBLE -- 2015-W14,
"n_2015_w15" DOUBLE -- 2015-W15,
"n_2015_w16" DOUBLE -- 2015-W16,
"n_2015_w17" DOUBLE -- 2015-W17,
"n_2015_w18" DOUBLE -- 2015-W18,
"n_2015_w19" DOUBLE -- 2015-W19,
"n_2015_w20" DOUBLE -- 2015-W20,
"n_2015_w21" DOUBLE -- 2015-W21,
"n_2015_w22" DOUBLE -- 2015-W22,
"n_2015_w23" DOUBLE -- 2015-W23,
"n_2015_w24" DOUBLE -- 2015-W24,
"n_2015_w25" DOUBLE -- 2015-W25,
"n_2015_w26" DOUBLE -- 2015-W26,
"n_2015_w27" DOUBLE -- 2015-W27,
"n_2015_w28" DOUBLE -- 2015-W28,
"n_2015_w29" DOUBLE -- 2015-W29,
"n_2015_w30" DOUBLE -- 2015-W30,
"n_2015_w31" DOUBLE -- 2015-W31,
"n_2015_w32" DOUBLE -- 2015-W32,
"n_2015_w33" DOUBLE -- 2015-W33,
"n_2015_w34" DOUBLE -- 2015-W34,
"n_2015_w35" DOUBLE -- 2015-W35,
"n_2015_w36" DOUBLE -- 2015-W36,
"n_2015_w37" DOUBLE -- 2015-W37,
"n_2015_w38" DOUBLE -- 2015-W38,
"n_2015_w39" DOUBLE -- 2015-W39,
"n_2015_w40" DOUBLE -- 2015-W40,
"n_2015_w41" DOUBLE -- 2015-W41,
"n_2015_w42" DOUBLE -- 2015-W42,
"n_2015_w43" DOUBLE -- 2015-W43,
"n_2015_w44" DOUBLE -- 2015-W44,
"n_2015_w45" DOUBLE -- 2015-W45,
"n_2015_w46" DOUBLE -- 2015-W46,
"n_2015_w47" DOUBLE -- 2015-W47,
"n_2015_w48" DOUBLE -- 2015-W48,
"n_2015_w49" DOUBLE -- 2015-W49,
"n_2015_w50" DOUBLE -- 2015-W50,
"n_2015_w51" DOUBLE -- 2015-W51,
"n_2015_w52" DOUBLE -- 2015-W52,
"n_2015_w53" DOUBLE -- 2015-W53,
"n_2016_w01" DOUBLE -- 2016-W01,
"n_2016_w02" DOUBLE -- 2016-W02,
"n_2016_w03" DOUBLE -- 2016-W03,
"n_2016_w04" DOUBLE -- 2016-W04,
"n_2016_w05" DOUBLE -- 2016-W05,
"n_2016_w06" DOUBLE -- 2016-W06,
"n_2016_w07" DOUBLE -- 2016-W07,
"n_2016_w08" DOUBLE -- 2016-W08,
"n_2016_w09" DOUBLE -- 2016-W09,
"n_2016_w10" DOUBLE -- 2016-W10,
"n_2016_w11" DOUBLE -- 2016-W11,
"n_2016_w12" DOUBLE -- 2016-W12,
"n_2016_w13" DOUBLE -- 2016-W13,
"n_2016_w14" DOUBLE -- 2016-W14,
"n_2016_w15" DOUBLE -- 2016-W15,
"n_2016_w16" DOUBLE -- 2016-W16,
"n_2016_w17" DOUBLE -- 2016-W17,
"n_2016_w18" DOUBLE -- 2016-W18,
"n_2016_w19" DOUBLE -- 2016-W19,
"n_2016_w20" DOUBLE -- 2016-W20,
"n_2016_w21" DOUBLE -- 2016-W21,
"n_2016_w22" DOUBLE -- 2016-W22,
"n_2016_w23" DOUBLE -- 2016-W23,
"n_2016_w24" DOUBLE -- 2016-W24,
"n_2016_w25" DOUBLE -- 2016-W25,
"n_2016_w26" DOUBLE -- 2016-W26,
"n_2016_w27" DOUBLE -- 2016-W27,
"n_2016_w28" DOUBLE -- 2016-W28,
"n_2016_w29" DOUBLE -- 2016-W29,
"n_2016_w30" DOUBLE -- 2016-W30,
"n_2016_w31" DOUBLE -- 2016-W31,
"n_2016_w32" DOUBLE -- 2016-W32,
"n_2016_w33" DOUBLE -- 2016-W33,
"n_2016_w34" DOUBLE -- 2016-W34,
"n_2016_w35" DOUBLE -- 2016-W35,
"n_2016_w36" DOUBLE -- 2016-W36,
"n_2016_w37" DOUBLE -- 2016-W37,
"n_2016_w38" DOUBLE -- 2016-W38,
"n_2016_w39" DOUBLE -- 2016-W39,
"n_2016_w40" DOUBLE -- 2016-W40,
"n_2016_w41" DOUBLE -- 2016-W41,
"n_2016_w42" DOUBLE -- 2016-W42
);CREATE TABLE tidy (
"freq" VARCHAR,
"age" VARCHAR,
"sex" VARCHAR,
"unit" VARCHAR,
"geo" VARCHAR,
"time_period" VARCHAR,
"value" DOUBLE
);Anyone who has the link will be able to view this.