Employment And Activity By Sex And Age - Annual Data

Eurostat code: lfsi_emp_a$dv_1906

@eurostat.lfsi_emp_a_dv_1906

Table List

2 tables(54.29 KB)

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

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

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

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

18.09 KB
6390 rows
8 columns

freq Freq	indic_em Indic Em	sex Sex	age Age	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Total employment (resident population concept - LFS)	Females	From 15 to 24 years	Percentage of total population	Austria	2015	48.7
Annual	Total employment (resident population concept - LFS)	Females	From 15 to 24 years	Percentage of total population	Belgium	2015	21.7
Annual	Total employment (resident population concept - LFS)	Females	From 15 to 24 years	Percentage of total population	Bulgaria	2015	14
Annual	Total employment (resident population concept - LFS)	Females	From 15 to 24 years	Percentage of total population	Switzerland	2015	62.6
Annual	Total employment (resident population concept - LFS)	Females	From 15 to 24 years	Percentage of total population	Cyprus	2015	26.8
Annual	Total employment (resident population concept - LFS)	Females	From 15 to 24 years	Percentage of total population	Czechia	2015	23.4
Annual	Total employment (resident population concept - LFS)	Females	From 15 to 24 years	Percentage of total population	Germany	2015	43.4
Annual	Total employment (resident population concept - LFS)	Females	From 15 to 24 years	Percentage of total population	Denmark	2015	52.3
Annual	Total employment (resident population concept - LFS)	Females	From 15 to 24 years	Percentage of total population	Euro area – 20 countries (from 2023)	2015	29.4
Annual	Total employment (resident population concept - LFS)	Females	From 15 to 24 years	Percentage of total population	Estonia	2015	33.3


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

Share link

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