Labour Input In Wholesale And Retail Trade - Quarterly Data

Eurostat code: sts_trlb_q · (1989-Q4 - 2024-Q4)

@eurostat.sts_trlb_q

Table List

2 tables(1.92 MB)

Labour Input In Wholesale And Retail Trade - Quarterly Data - Raw

Labour Input In Wholesale And Retail Trade - Quarterly Data - Unpivoted

Labour Input In Wholesale And Retail Trade - Quarterly Data - Raw

@eurostat.sts_trlb_q.raw

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

1.13 MB
5819 rows
147 columns
Only the first 100 columns are shown

freq Freq	indic_bt Indic Bt	nace_r2 Nace R2	s_adj S Adj	unit Unit	geo Geo	n_1994_q1 1994-Q1	n_1994_q2 1994-Q2	n_1994_q3 1994-Q3	n_1994_q4 1994-Q4	n_1995_q1 1995-Q1	n_1995_q2 1995-Q2	n_1995_q3 1995-Q3	n_1995_q4 1995-Q4	n_1996_q1 1996-Q1	n_1996_q2 1996-Q2	n_1996_q3 1996-Q3	n_1996_q4 1996-Q4	n_1997_q1 1997-Q1	n_1997_q2 1997-Q2	n_1997_q3 1997-Q3	n_1997_q4 1997-Q4	n_1998_q1 1998-Q1	n_1998_q2 1998-Q2	n_1998_q3 1998-Q3	n_1998_q4 1998-Q4	n_1999_q1 1999-Q1	n_1999_q2 1999-Q2	n_1999_q3 1999-Q3	n_1999_q4 1999-Q4	n_2000_q1 2000-Q1	n_2000_q2 2000-Q2	n_2000_q3 2000-Q3	n_2000_q4 2000-Q4	n_2001_q1 2001-Q1	n_2001_q2 2001-Q2	n_2001_q3 2001-Q3	n_2001_q4 2001-Q4	n_2002_q1 2002-Q1	n_2002_q2 2002-Q2	n_2002_q3 2002-Q3	n_2002_q4 2002-Q4	n_2003_q1 2003-Q1	n_2003_q2 2003-Q2	n_2003_q3 2003-Q3	n_2003_q4 2003-Q4	n_2004_q1 2004-Q1	n_2004_q2 2004-Q2	n_2004_q3 2004-Q3	n_2004_q4 2004-Q4	n_2005_q1 2005-Q1	n_2005_q2 2005-Q2	n_2005_q3 2005-Q3	n_2005_q4 2005-Q4	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
Quarterly	Persons employed	Wholesale and retail trade; repair of motor vehicles and motorcycles	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Index, 2010=100	Austria																									91.8	92.5	94.3	94.5	93.8	94.2	95.6	95.6	94.5	94.6	95.7	95.5	94.5	94.9	96.2	96.2	95.3	95.6	97.1	97.2	96	96.2	97.4	97.8	96.9	97.3	98.9	99	98.6	99	100.5	100.5	99.8	100.2	101.3	101.4	99.6	98.8	99.7	99.7	99	99.1	100.7	101.2	100.1	100.6	101.9	102.4	101.8	101.9	102.9	102.8	101.5
Quarterly	Persons employed	Wholesale and retail trade; repair of motor vehicles and motorcycles	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Index, 2010=100	Belgium																									56.6	56.7	57.4	90.3	89.9	90.6	90.3	91.2	91.5	91.8	91.8	92.9	101.2	97.5	96.5	96.9	96.8	97.2	96.9	98.3	98.3	97.9	97.6	98.2	98.1	98.4	98.4	99.5	100	100.5	100.2	100.7	101.4	101.2	101.3	101.6	100.8	100.5	100.1	100.5	99.8	100	99.7	100.5	99.9	100.1	100.1	100.8	100.2	100.2	99.8	100	99
Quarterly	Persons employed	Wholesale and retail trade; repair of motor vehicles and motorcycles	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Index, 2010=100	Bulgaria																									43.7	45.5	51.4	50.4	49.6	51.8	53.7	52.7	53.2	55.6	58.5	59.1	60	59.3	68.9	69.6	69.6	71.8	74.1	75.8	75.1	78.4	81.5	81.6	79.7	83.8	84.3	86.1	88.3	89.6	90	92.7	94.1	94.2	99.7	98.1	97.3	104.1	102.9	100.3	100.1	100.1	99.5	100.3	98.9	98.9	97.1	95	93.6	95.1	94	92	92.4
Quarterly	Persons employed	Wholesale and retail trade; repair of motor vehicles and motorcycles	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Index, 2010=100	Switzerland																	97.5	97.8	97.9	97.6	98.3	97.6	97.2	97.8	97.4	97.2	97.2	97.3	96.9	97.3	97.3	97	97.3	96.2	97.4	97.9	96.3	96.7	96.6	96.9	97.6	97	96.3	96.5	95.9	95.9	95.7	95.5	95.1	95.1	95.8	97.2	96.9	97.8	99	100.2	99.7	99.3	100.6	100.4	99.5	98.4	98.9	99.8	99.6	99.5	100.2	100.7	99.6	99.5	99.9	100.8	99.7	99.7	101.2	102.1	101.6
Quarterly	Persons employed	Wholesale and retail trade; repair of motor vehicles and motorcycles	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Index, 2010=100	Cyprus																									81.7	81.9	81.5	84.3	84.3	84.5	84.1	87	84.5	84.7	84.3	87.2	87.9	88.2	87.8	90.8	93.3	92.2	91.8	94.9	95.1	95.1	94.5	96.1	95.6	98.4	96.9	100.5	100.3	101	100.2	102.7	104.7	106	106.6	105.8	104.1	102.8	102.1	101.6	99.8	99.8	100.2	100.2	99.8	99.3	98.6	96.7	94.7	94.9	94	91.7	90.3
Quarterly	Persons employed	Wholesale and retail trade; repair of motor vehicles and motorcycles	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Index, 2010=100	Czechia																									93.8	94.7	95.5	97.2	94.3	97.2	97.2	98.9	93.2	94	94.5	95.1	92.6	93.5	94.5	94.7	93.2	94.3	95	95.9	95.5	95.9	96.4	96.8	94.8	95.4	96.1	97.1	96.3	97.4	98.3	99.3	98.7	99.2	99.6	100.4	99.9	98.5	97.6	97.7	98.6	99.8	100.1	101.5	100.2	101.4	102	103	101.6	102.1	102.6	103	101.4
Quarterly	Persons employed	Wholesale and retail trade; repair of motor vehicles and motorcycles	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Index, 2010=100	Germany	116.6	116.9	117.6	118.5	117	117	117.7	118	115.6	115.2	115.5	116	114.2	114.3	114.7	115	113.2	113.3	114.4	115.2	112.6	110.4	110.7	111.2	109.8	110.2	110.7	110.9	108.3	108.3	108.7	109.1	106.6	106.2	105.9	105.9	103	103.1	104	104.7	103.3	103.2	104.1	104.6	104.1	104	104.4	105	103.2	103.2	103.9	104.5	102.8	103.6	104.4	105.3	103.5	103.4	104	104.6	100.9	100.6	100.6	100.7	99	99.5	100.3	101.3	100.3	101	102	103	102.1	102.4	102.9	103.7	102.7
Quarterly	Persons employed	Wholesale and retail trade; repair of motor vehicles and motorcycles	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Index, 2010=100	Denmark																																																									107.5	108.3	108.6	107.4	104.4	102.6	101.9	100.3	99.1	99.8	100.7	100.4	99.9	100.6	101.4	100.6	99.2	99.7	100.6	100.3	98.9
Quarterly	Persons employed	Wholesale and retail trade; repair of motor vehicles and motorcycles	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Index, 2010=100	Euro area - 19 countries (2015-2022)	94.4	94.8	95.5	96	94.9	95.4	96	96.2	94.7	95	95.3	95.7	94.7	95.2	95.6	96	94.9	95.7	96.6	97.1	96.1	95.6	96	96.5	95.3	96.3	97.4	98.5	97.2	98	98.8	99	98	98.5	98.8	99.4	98.2	98.9	99.3	99.8	99.4	100.1	100.8	101.3	100.3	100.9	101.5	102	100.8	101.8	102.7	103.2	102	103.4	104.2	104.8	103.4	104	104.3	104.2	101.3	101	100.6	100.6	99.3	100	100.2	100.5	99.6	100.4	100.7	100.8	99.5	100.1	100.2	100.1	98.6
Quarterly	Persons employed	Wholesale and retail trade; repair of motor vehicles and motorcycles	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Index, 2010=100	Estonia																	109.2	108.9	107.1	104.2	104.1	102.8	100.7	99.2	101.2	101.6	100.6	100.2	100.4	100.3	101	99.4	103.8	105.7	105.2	104.9	103.2	104.9	104	102.1	101.5	102.6	103.6	101.8	109.5	112.5	114	112.2	111.3	113.7	116	114.7	116.7	119.1	119.4	122.7	118.8	120.7	120.3	115.3	114.7	110.7	105.7	102.8	100.1	100.9	100.2	98.8	94.8	97.1	97.4	98.1	99.4	100.1	100	99.1	102.3


CREATE TABLE raw (
  "freq" VARCHAR,
  "indic_bt" VARCHAR,
  "nace_r2" VARCHAR,
  "s_adj" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_1989_q4" DOUBLE,
  "n_1990_q1" DOUBLE,
  "n_1990_q2" DOUBLE,
  "n_1990_q3" DOUBLE,
  "n_1990_q4" DOUBLE,
  "n_1991_q1" DOUBLE,
  "n_1991_q2" DOUBLE,
  "n_1991_q3" DOUBLE,
  "n_1991_q4" DOUBLE,
  "n_1992_q1" DOUBLE,
  "n_1992_q2" DOUBLE,
  "n_1992_q3" DOUBLE,
  "n_1992_q4" DOUBLE,
  "n_1993_q1" DOUBLE,
  "n_1993_q2" DOUBLE,
  "n_1993_q3" DOUBLE,
  "n_1993_q4" DOUBLE,
  "n_1994_q1" DOUBLE,
  "n_1994_q2" DOUBLE,
  "n_1994_q3" DOUBLE,
  "n_1994_q4" DOUBLE,
  "n_1995_q1" DOUBLE,
  "n_1995_q2" DOUBLE,
  "n_1995_q3" DOUBLE,
  "n_1995_q4" DOUBLE,
  "n_1996_q1" DOUBLE,
  "n_1996_q2" DOUBLE,
  "n_1996_q3" DOUBLE,
  "n_1996_q4" DOUBLE,
  "n_1997_q1" DOUBLE,
  "n_1997_q2" DOUBLE,
  "n_1997_q3" DOUBLE,
  "n_1997_q4" DOUBLE,
  "n_1998_q1" DOUBLE,
  "n_1998_q2" DOUBLE,
  "n_1998_q3" DOUBLE,
  "n_1998_q4" DOUBLE,
  "n_1999_q1" DOUBLE,
  "n_1999_q2" DOUBLE,
  "n_1999_q3" DOUBLE,
  "n_1999_q4" DOUBLE,
  "n_2000_q1" DOUBLE,
  "n_2000_q2" DOUBLE,
  "n_2000_q3" DOUBLE,
  "n_2000_q4" DOUBLE,
  "n_2001_q1" DOUBLE,
  "n_2001_q2" DOUBLE,
  "n_2001_q3" DOUBLE,
  "n_2001_q4" DOUBLE,
  "n_2002_q1" DOUBLE,
  "n_2002_q2" DOUBLE,
  "n_2002_q3" DOUBLE,
  "n_2002_q4" DOUBLE,
  "n_2003_q1" DOUBLE,
  "n_2003_q2" DOUBLE,
  "n_2003_q3" DOUBLE,
  "n_2003_q4" DOUBLE,
  "n_2004_q1" DOUBLE,
  "n_2004_q2" DOUBLE,
  "n_2004_q3" DOUBLE,
  "n_2004_q4" DOUBLE,
  "n_2005_q1" DOUBLE,
  "n_2005_q2" DOUBLE,
  "n_2005_q3" DOUBLE,
  "n_2005_q4" DOUBLE,
  "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
);