Employment And Activity By Sex And Age - Quarterly Data

Eurostat code: lfsi_emp_q · (2003-Q1 - 2024-Q4)

@eurostat.lfsi_emp_q

Table List

2 tables(3.31 MB)

Employment And Activity By Sex And Age - Quarterly Data - Raw

Employment And Activity By Sex And Age - Quarterly Data - Unpivoted

Employment And Activity By Sex And Age - Quarterly Data - Raw

@eurostat.lfsi_emp_q.raw

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

1.94 MB
9324 rows
95 columns

freq Freq	indic_em Indic Em	s_adj S Adj	sex Sex	age Age	unit Unit	geo Geo	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	n_2021_q1 2021-Q1	n_2021_q2 2021-Q2	n_2021_q3 2021-Q3	n_2021_q4 2021-Q4	n_2022_q1 2022-Q1	n_2022_q2 2022-Q2	n_2022_q3 2022-Q3	n_2022_q4 2022-Q4	n_2023_q1 2023-Q1	n_2023_q2 2023-Q2	n_2023_q3 2023-Q3	n_2023_q4 2023-Q4	n_2024_q1 2024-Q1	n_2024_q2 2024-Q2	n_2024_q3 2024-Q3	n_2024_q4 2024-Q4
Quarterly	Persons in the labour force (former name: active persons)	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	From 15 to 24 years	Percentage of total population	Austria	55.8	55.1	60.3	54.7	53.1	52	57.6	54.3	55.2	52.6	57.7	54.7	54.4	52.1	59.5	56.4	53.8	53.7	59.3	55.5	54.9	54.4	57.2	56	53	52.6	58.1	53.9	53.8	52.3	59.1	54.3	53.2	53.3	56.1	53	52	52	57.5	54.6	53	50.6	54.6	52.7	52.4	50.4	56.2	52	50.6	49.7	56.1	49.5	49.9	51.5	56.4	55	54.1	55.1	60	53.8	51.7	50.9	57.7	54.7
Quarterly	Persons in the labour force (former name: active persons)	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	From 15 to 24 years	Percentage of total population	Bosnia and Herzegovina																																																	24.9	24.5	24.6	25.1	23.1	22.9	20.1	18.8	17.3	15.8	17.1	18.6	16.4	14.4	16.3
Quarterly	Persons in the labour force (former name: active persons)	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	From 15 to 24 years	Percentage of total population	Belgium	27.9	29.1	32.1	30.7	30.1	27	31.7	30.3	29.7	28	31.2	30.4	27.2	24.7	29.8	30.2	27	27.2	30.4	28.5	26.9	27.2	30	28.5	27.4	25.8	28.1	27.8	27.1	24.8	27	25.9	24	22.6	28	27.5	27.2	24.7	30.8	28.4	27.3	28.8	32.3	29.5	28.1	24.4	29.7	23.4	24.2	26.6	34.4	27.9	26.6	28.7	33.9	29.4	27.7	29	33.7	30.6	27.9	27.6	33	30
Quarterly	Persons in the labour force (former name: active persons)	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	From 15 to 24 years	Percentage of total population	Bulgaria	22.8	22.9	22.7	20.1	22.4	23.7	26.1	23.5	21.7	21.6	23.5	23	22.6	21.8	24.2	23.2	21.9	22.4	24.2	21	19.3	20.2	22.2	20.3	19.1	18.2	20.6	18.5	17.2	17.4	18.2	17.3	17.1	19.9	21.8	19	15.8	17	19.4	16.4	15.2	17.1	20.8	17.8	14	15.9	17.7	17.5	15.6	14.3	16.3	15.1	15.8	17.1	17.4	20.5	19.4	17.8	19.5	16.1	17	15.3	16	13.8
Quarterly	Persons in the labour force (former name: active persons)	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	From 15 to 24 years	Percentage of total population	Switzerland		68.5			68.4	64.8	69.9	66.4	67.7	66.7	69.6	67.5	67.5	64.3	68.3	64.9	66.5	65	68	68.7	66.6	65.7	67.2	70.4	67.8	65.9	68.8	70.8	68.7	67.5	70.1	69.6	68.6	65.5	69	67.9	66.9	64.2	70.7	68.7	65.5	65.1	67.5	67.1	63.9	60.5	67.1	66.9	63.7	61.9	66.2	67.8	64.4	63.6	64.1	66.3	66	62.7	64.9	65.9	63	64.2	66	65.2
Quarterly	Persons in the labour force (former name: active persons)	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	From 15 to 24 years	Percentage of total population	Cyprus	41.5	37.9	36.6	39.1	41.5	41.9	37.7	39.9	39.7	37.9	34.2	34.7	34.8	34.3	36	37.1	35.1	34.8	36.7	38.5	39.9	37.6	39.3	41.4	42.3	39.5	36.6	37.2	36.7	38.6	39.3	39.2	38	40.1	41	40.2	42.3	42.2	41.9	40.8	40.1	37.9	35.2	37.3	36.4	34	34	34.5	35.8	37.7	40	39.6	40	39.1	41.4	41.7	41	40.9	40.2	40	40.2	38.9	40.8	36.5
Quarterly	Persons in the labour force (former name: active persons)	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	From 15 to 24 years	Percentage of total population	Czechia	25.6	25.2	27	26.6	24	24	27	26.1	23.9	23.7	25.3	23.5	25	25.1	26.8	26.9	25.7	25.7	26.7	26.2	24.4	24.7	27.1	28.1	27.3	26.9	28.3	26.9	25.2	25.1	27.3	27.3	26.8	25.5	27.6	26.4	25.1	25.7	27.3	26.9	26.3	25.9	26.8	24.3	22.3	20.2	21	22.2	21.5	19.8	23.1	23	23	22.1	24.6	23.5	23.8	23.4	24.7	23.9	22.9	23.5	24.9	23.6
Quarterly	Persons in the labour force (former name: active persons)	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	From 15 to 24 years	Percentage of total population	Germany	48.8	48.7	48.8	49.4	48.1	47.3	49.2	49.3	48.8	49.3	50.7	49.6	46.8	47.3	48.5	48.1	48.4	47.5	48.4	49	47.4	46.5	47.8	47.6	47.7	45.5	46.3	47.2	46.3	45.6	48.2	47.8	47.2	46.5	48.3	49.5	47.2	45.7	48.5	48.2	47.7	47.3	48.8	48.1	49.6	48.7	49.3	48.5	47.2	48.1	50.1	51	50.7	49.6	50.6	51.8	51.5	50.9	50.9	52.5	52.6	51.5	52.3	53
Quarterly	Persons in the labour force (former name: active persons)	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	From 15 to 24 years	Percentage of total population	Denmark	65.7	68.6	69.6	64.9	63.2	65.9	66.2	60.5	63.1	64.6	65.9	59.8	59.2	63.1	62.8	58.7	58.4	58.6	62.2	56.7	55.3	57.7	62.4	59.9	58.2	60.4	60.4	56.4	60.6	63.1	62.8	58.4	60.4	60.9	64.5	59.2	60	61.5	62	59.8	61.6	60.8	63	61.8	59.5	59.4	62.2	60.3	57.5	60.4	61.2	60.6	60.5	61	64.3	65.7	64.9	63.1	65.3	68.9	70	68.6	70.4	69.2
Quarterly	Persons in the labour force (former name: active persons)	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	From 15 to 24 years	Percentage of total population	Euro area – 20 countries (from 2023)	40.6	40.9	41.9	40.2	39.4	39.5	41	39.7	39	39.4	40.9	39.5	38.4	38.8	40.3	39.3	38.6	38.5	39.9	39	37.8	37.9	39.4	38.3	37.8	37.5	39	37.9	37.1	37.9	39.6	38	37.4	37.9	39.1	38.5	37.3	37.4	39.3	38.2	37.7	37.8	39.2	38	37.4	34.8	38.4	36.3	35.7	37.8	40.5	38.6	38.4	39.7	41.1	39.9	39.2	40.2	41.7	40.6	39.3	39.6	41.4	39.5


CREATE TABLE raw (
  "freq" VARCHAR,
  "indic_em" VARCHAR,
  "s_adj" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "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,
  "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,
  "n_2021_q1" DOUBLE,
  "n_2021_q2" DOUBLE,
  "n_2021_q3" DOUBLE,
  "n_2021_q4" DOUBLE,
  "n_2022_q1" DOUBLE,
  "n_2022_q2" DOUBLE,
  "n_2022_q3" DOUBLE,
  "n_2022_q4" DOUBLE,
  "n_2023_q1" DOUBLE,
  "n_2023_q2" DOUBLE,
  "n_2023_q3" DOUBLE,
  "n_2023_q4" DOUBLE,
  "n_2024_q1" DOUBLE,
  "n_2024_q2" DOUBLE,
  "n_2024_q3" DOUBLE,
  "n_2024_q4" DOUBLE
);