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

Table List

2 tables(119.54 KB)

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

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

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

@eurostat.lfsi_ahw_q_h.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

93.48 KB
201 rows
66 columns

freq Freq	age Age	s_adj S Adj	sex Sex	unit Unit	geo Geo	n_2006_q1 2006-Q1	n_2006_q2 2006-Q2	n_2006_q3 2006-Q3	n_2006_q4 2006-Q4	n_2007_q1 2007-Q1	n_2007_q2 2007-Q2	n_2007_q3 2007-Q3	n_2007_q4 2007-Q4	n_2008_q1 2008-Q1	n_2008_q2 2008-Q2	n_2008_q3 2008-Q3	n_2008_q4 2008-Q4	n_2009_q1 2009-Q1	n_2009_q2 2009-Q2	n_2009_q3 2009-Q3	n_2009_q4 2009-Q4	n_2010_q1 2010-Q1	n_2010_q2 2010-Q2	n_2010_q3 2010-Q3	n_2010_q4 2010-Q4	n_2011_q1 2011-Q1	n_2011_q2 2011-Q2	n_2011_q3 2011-Q3	n_2011_q4 2011-Q4	n_2012_q1 2012-Q1	n_2012_q2 2012-Q2	n_2012_q3 2012-Q3	n_2012_q4 2012-Q4	n_2013_q1 2013-Q1	n_2013_q2 2013-Q2	n_2013_q3 2013-Q3	n_2013_q4 2013-Q4	n_2014_q1 2014-Q1	n_2014_q2 2014-Q2	n_2014_q3 2014-Q3	n_2014_q4 2014-Q4	n_2015_q1 2015-Q1	n_2015_q2 2015-Q2	n_2015_q3 2015-Q3	n_2015_q4 2015-Q4	n_2016_q1 2016-Q1	n_2016_q2 2016-Q2	n_2016_q3 2016-Q3	n_2016_q4 2016-Q4	n_2017_q1 2017-Q1	n_2017_q2 2017-Q2	n_2017_q3 2017-Q3	n_2017_q4 2017-Q4	n_2018_q1 2018-Q1	n_2018_q2 2018-Q2	n_2018_q3 2018-Q3	n_2018_q4 2018-Q4	n_2019_q1 2019-Q1	n_2019_q2 2019-Q2	n_2019_q3 2019-Q3	n_2019_q4 2019-Q4	n_2020_q1 2020-Q1	n_2020_q2 2020-Q2	n_2020_q3 2020-Q3	n_2020_q4 2020-Q4
Quarterly	From 20 to 64 years	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	Index, 2006=100	Austria	100.9	100.7	95.6	102.7	104.4	102.5	97.9	103.5	103.6	108.2	99.8	104.3	101.3	104.3	98.6	100.1	103.9	104.7	97.6	102.7	107.1	105.9	97.5	103.6	106.7	104.3	97.9	104	104.5	106.9	97.7	105.4	106.1	104.7	97.3	106.5	103.9	105.9	99.4	103.7	106	110.5	99.7	107.2	110.8	107.8	99.1	108.4	109.3	110.1	100.5	109.5	112.1	110.4	103.3	113.1	106.1	93.2	99.9	99.1
Quarterly	From 20 to 64 years	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	Index, 2006=100	Belgium	106.8	102	87.9	103.4	108.1	108.2	95.2	111.3	111.4	112	100.2	110.3	111.1	108	98.8	112.5	121.3	111.5	99.6	114.8	115	117.3	101.7	114	118.8	115.2	104.1	116.3	118	121.1	107.7	117.9	121	122.1	108.1	125.8	123	122.3	108	121.1	126.6	123.2	109	122	117.7	113.9	98.2	112.8	116.6	113.3	102.5	118	119.4	118.4	102.1	117.8	113.6	100.1	102	109.7
Quarterly	From 20 to 64 years	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	Index, 2006=100	Bulgaria	95.6	100.8	99.8	103.8	100.4	104.6	103.1	108.5	107.5	108.7	107.3	107.4	100.6	103	100.8	101.2	97.2	100	99.3	99.4	95.6	95.7	95.7	99	95	93.9	95.5	93.7	92.5	94.1	96.4	94.3	92.8	95	96.2	97	94.8	96.5	97.7	98.6	94.8	95	93.9	96.1	96.5	99.9	98.4	98.4	97.9	98.7	96.4	97.6	99.9	101.5	99	99.5	96.4	87.9	97.3	93.1
Quarterly	From 20 to 64 years	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	Index, 2006=100	Cyprus	101.2	100.1	92	106.6	107.6	109	100.9	113.6	111.5	110	101.4	112.3	109.8	114.2	105.7	117.5	118.6	123.6	107.8	125.6	123.8	127	110.2	126.9	125.6	120.6	111.7	125.2	115.8	112.3	104.6	114.1	112.1	113.5	106.6	115.8	108.7	112.3	103.5	115.9	109.4	114.6	107.2	116.4	113.5	116.2	109.9	120.7	120.2	122.5	115.1	126.2	121.2	125.2	117	126.2	116.3	96	113.1	121.7
Quarterly	From 20 to 64 years	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	Index, 2006=100	Czechia	104.9	102.9	91.1	101.1	104.6	104.6	91.7	102.1	104.6	106.5	96	101.9	101.2	102.9	90.5	98.7	103	103.9	88.2	97	103.8	102.2	86.2	97.1	103.7	100.6	84.5	99.1	99	101.2	87.4	97.7	101	100.8	90.4	98.7	102.3	105.5	92.4	95.5	106.9	111.4	90.4	102.8	109.8	104.5	89.7	104.7	107.6	108.6	93.6	107.5	109.5	106.3	94.7	104.5	102.4	93.3	94.7	90.7
Quarterly	From 20 to 64 years	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	Index, 2006=100	Germany	99.7	99.5	97.9	102.9	101.7	100.4	99.5	104.7	102.6	102.9	101.9	105.9	102.3	101.7	99	105.9	103.6	102.7	99.3	105	104.8	102.3	99.5	105	105.2	102.8	100.1	104.3	104.6	104.3	100.6	104.9	106.2	104.5	102.6	107	106	105.8	102.9	108.5	109.4	110.2	105.2	112.7	111.3	107.7	105.8	110.5	111	109.1	107.7	112	113	109.5	107.5	114.9
Quarterly	From 20 to 64 years	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	Index, 2006=100	Denmark	106.4	100	90.9	102.8	107.1	102.2	94.5	104.8	102.3	107.1	94.8	105.2	104.8	102.7	93.1	99.8	99.9	104.7	91.5	98.1	104.1	100.8	90.5	100	104.9	102.5	89.6	101.2	99.7	105.2	91.4	101.8	102.9	102.3	90.4	101.4	101.1	103.1	92.1	105.6	102.7	107.3	93.7	102.1	108.1	104.4	93.5	104.3	106.1	112	98	106.3	109.4	103.1	97.2	108.4	105.3	99.7	96.9	109.5
Quarterly	From 20 to 64 years	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	Index, 2006=100	Estonia	101.7	102.4	94.5	101.4	101.9	99.8	94.8	99.4	99.3	100.9	94.9	97.4	92.3	88.9	79.2	86.8	88.6	84.2	77.5	88	88	88.3	85.7	91.7	91.7	91.6	80.5	89.3	88.7	90.9	81.2	91.5	88.1	90.1	82.1	90.9	89.8	89.2	83	90.6	89	90.3	81.2	89.1	92.1	87.2	84.8	92.9	89	89.2	79.5	87.8	89.7	88.4	79.9	89.2	86.5	77.7	79.4	87.1
Quarterly	From 20 to 64 years	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	Index, 2006=100	Greece	98.1	101.4	100	100.5	97.3	101.2	98.3	101.6	99.3	105.2	99.4	103.6	100	103.9	100	101	98.1	103.7	98.1	98.9	96.1	98.2	93.7	91.8	88.5	88.8	85.3	85	81.1	84.6	81.5	81.4	80.8	85.1	82.6	84.8	81.7	87.9	86.2	86.9	84.3	88.9	86.3	85.5	84.7	90.8	87.4	86.5	83.7	90.7	89.5	88	86.7	94.7	91.7	91.9	82	67.7	89.3	81.9
Quarterly	From 20 to 64 years	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	Index, 2006=100	Spain	102.2	102.4	92.9	102.4	106.2	107.1	96.1	106.3	106.4	113.3	98.5	109.3	105.9	107.1	94.6	105.2	104.7	108.8	95	103	106.6	107.1	94.5	101.6	103.2	102.3	90.6	97.4	96.4	100.4	89.2	98.7	98.1	99.4	88.7	100.9	98.4	102.3	92.1	103.1	102.3	107.7	95	103.5	106	106.4	95.3	104.7	107.2	112.4	99.9	109.1	110.8	112.3	100.2	112.2	107.6	81.8	92.3	105.1


CREATE TABLE raw (
  "freq" VARCHAR,
  "age" VARCHAR,
  "s_adj" VARCHAR,
  "sex" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_2006_q1" DOUBLE,
  "n_2006_q2" DOUBLE,
  "n_2006_q3" DOUBLE,
  "n_2006_q4" DOUBLE,
  "n_2007_q1" DOUBLE,
  "n_2007_q2" DOUBLE,
  "n_2007_q3" DOUBLE,
  "n_2007_q4" DOUBLE,
  "n_2008_q1" DOUBLE,
  "n_2008_q2" DOUBLE,
  "n_2008_q3" DOUBLE,
  "n_2008_q4" DOUBLE,
  "n_2009_q1" DOUBLE,
  "n_2009_q2" DOUBLE,
  "n_2009_q3" DOUBLE,
  "n_2009_q4" DOUBLE,
  "n_2010_q1" DOUBLE,
  "n_2010_q2" DOUBLE,
  "n_2010_q3" DOUBLE,
  "n_2010_q4" DOUBLE,
  "n_2011_q1" DOUBLE,
  "n_2011_q2" DOUBLE,
  "n_2011_q3" DOUBLE,
  "n_2011_q4" DOUBLE,
  "n_2012_q1" DOUBLE,
  "n_2012_q2" DOUBLE,
  "n_2012_q3" DOUBLE,
  "n_2012_q4" DOUBLE,
  "n_2013_q1" DOUBLE,
  "n_2013_q2" DOUBLE,
  "n_2013_q3" DOUBLE,
  "n_2013_q4" DOUBLE,
  "n_2014_q1" DOUBLE,
  "n_2014_q2" DOUBLE,
  "n_2014_q3" DOUBLE,
  "n_2014_q4" DOUBLE,
  "n_2015_q1" DOUBLE,
  "n_2015_q2" DOUBLE,
  "n_2015_q3" DOUBLE,
  "n_2015_q4" DOUBLE,
  "n_2016_q1" DOUBLE,
  "n_2016_q2" DOUBLE,
  "n_2016_q3" DOUBLE,
  "n_2016_q4" DOUBLE,
  "n_2017_q1" DOUBLE,
  "n_2017_q2" DOUBLE,
  "n_2017_q3" DOUBLE,
  "n_2017_q4" DOUBLE,
  "n_2018_q1" DOUBLE,
  "n_2018_q2" DOUBLE,
  "n_2018_q3" DOUBLE,
  "n_2018_q4" DOUBLE,
  "n_2019_q1" DOUBLE,
  "n_2019_q2" DOUBLE,
  "n_2019_q3" DOUBLE,
  "n_2019_q4" DOUBLE,
  "n_2020_q1" DOUBLE,
  "n_2020_q2" DOUBLE,
  "n_2020_q3" DOUBLE,
  "n_2020_q4" DOUBLE
);