Baselight

Index Of Total Actual Hours Worked In The Main Job By Sex And Age Group (2006 = 100) (2006-2020) - Quarterly Data

Eurostat code: lfsi_ahw_q_h ยท (2006-Q1 - 2020-Q4)

@eurostat.lfsi_ahw_q_h

Index Of Total Actual Hours Worked In The Main Job By Sex And Age Group (2006 = 100) (2006-2020) - Quarterly Data - Unpivoted
@eurostat.lfsi_ahw_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.

  • 26.06 KB
  • 12030 rows
  • 8 columns
freq

Freq

age

Age

s_adj

S Adj

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

QuarterlyFrom 20 to 64 yearsUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)FemalesIndex, 2006=100Austria2006-Q1100.9
QuarterlyFrom 20 to 64 yearsUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)FemalesIndex, 2006=100Belgium2006-Q1106.8
QuarterlyFrom 20 to 64 yearsUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)FemalesIndex, 2006=100Bulgaria2006-Q195.6
QuarterlyFrom 20 to 64 yearsUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)FemalesIndex, 2006=100Cyprus2006-Q1101.2
QuarterlyFrom 20 to 64 yearsUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)FemalesIndex, 2006=100Czechia2006-Q1104.9
QuarterlyFrom 20 to 64 yearsUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)FemalesIndex, 2006=100Germany2006-Q199.7
QuarterlyFrom 20 to 64 yearsUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)FemalesIndex, 2006=100Denmark2006-Q1106.4
QuarterlyFrom 20 to 64 yearsUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)FemalesIndex, 2006=100Estonia2006-Q1101.7
QuarterlyFrom 20 to 64 yearsUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)FemalesIndex, 2006=100Greece2006-Q198.1
QuarterlyFrom 20 to 64 yearsUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)FemalesIndex, 2006=100Spain2006-Q1102.2

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

Share link

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