Absence From Work By Main Reason, Sex And Age Group (2006-2020)- Quarterly Data

Eurostat code: lfsi_abs_q_h · (2006-Q1 - 2020-Q4)

@eurostat.lfsi_abs_q_h

Table List

2 tables(455.97 KB)

Absence From Work By Main Reason, Sex And Age Group (2006-2020)- Quarterly Data - Raw

Absence From Work By Main Reason, Sex And Age Group (2006-2020)- Quarterly Data - Unpivoted

Absence From Work By Main Reason, Sex And Age Group (2006-2020)- Quarterly Data - Unpivoted

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

155.99 KB
52400 rows
9 columns

freq Freq	age Age	s_adj S Adj	sex Sex	reason Reason	unit Unit	geo Geo	time_period Time Period	value Value
Quarterly	From 20 to 64 years	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	Holidays	Thousand	Austria	2006-Q1	71.3
Quarterly	From 20 to 64 years	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	Holidays	Thousand	Belgium	2006-Q1	54.5
Quarterly	From 20 to 64 years	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	Holidays	Thousand	Bulgaria	2006-Q1	8.1
Quarterly	From 20 to 64 years	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	Holidays	Thousand	Cyprus	2006-Q1	2.5
Quarterly	From 20 to 64 years	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	Holidays	Thousand	Czechia	2006-Q1	22.4
Quarterly	From 20 to 64 years	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	Holidays	Thousand	Germany	2006-Q1	247
Quarterly	From 20 to 64 years	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	Holidays	Thousand	Denmark	2006-Q1	57
Quarterly	From 20 to 64 years	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	Holidays	Thousand	Greece	2006-Q1	14.8
Quarterly	From 20 to 64 years	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	Holidays	Thousand	Spain	2006-Q1	156.4
Quarterly	From 20 to 64 years	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	Holidays	Thousand	European Union - 27 countries (from 2020)	2006-Q1	1847.7


CREATE TABLE tidy (
  "freq" VARCHAR,
  "age" VARCHAR,
  "s_adj" VARCHAR,
  "sex" VARCHAR,
  "reason" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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