Employment And Activity By Sex And Age (1992-2020) - Annual Data

Eurostat code: lfsi_emp_a_h · (1992 - 2020)

@eurostat.lfsi_emp_a_h

Table List

2 tables(438.63 KB)

Employment And Activity By Sex And Age (1992-2020) - Annual Data - Raw

Employment And Activity By Sex And Age (1992-2020) - Annual Data - Unpivoted

Employment And Activity By Sex And Age (1992-2020) - Annual Data - Unpivoted

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

162.41 KB
56928 rows
8 columns

freq Freq	age Age	unit Unit	sex Sex	indic_em Indic Em	geo Geo	time_period Time Period	value Value
Annual	From 15 to 24 years	Percentage of total population	Females	Persons in the labour force (former name: active persons)	Metropolitan France	1992	37.8
Annual	From 15 to 24 years	Percentage of total population	Females	Total employment (resident population concept - LFS)	Metropolitan France	1992	28.2
Annual	From 15 to 24 years	Percentage of total population	Males	Persons in the labour force (former name: active persons)	Metropolitan France	1992	42.1
Annual	From 15 to 24 years	Percentage of total population	Males	Total employment (resident population concept - LFS)	Metropolitan France	1992	33.7
Annual	From 15 to 24 years	Percentage of total population	Total	Persons in the labour force (former name: active persons)	Metropolitan France	1992	39.9
Annual	From 15 to 24 years	Percentage of total population	Total	Total employment (resident population concept - LFS)	Metropolitan France	1992	30.9
Annual	From 15 to 24 years	Thousand persons	Females	Persons in the labour force (former name: active persons)	Metropolitan France	1992	1454
Annual	From 15 to 24 years	Thousand persons	Females	Total employment (resident population concept - LFS)	Metropolitan France	1992	1082
Annual	From 15 to 24 years	Thousand persons	Males	Persons in the labour force (former name: active persons)	Metropolitan France	1992	1542
Annual	From 15 to 24 years	Thousand persons	Males	Total employment (resident population concept - LFS)	Metropolitan France	1992	1236


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

Share link

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