Activity Rate By Sex

Eurostat code: tepsr_wc130 · (2005 - 2024)

@eurostat.tepsr_wc130

Table List

2 tables(36.42 KB)

Activity Rate By Sex - Unpivoted

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

10.36 KB
1725 rows
8 columns

freq Freq	indic_em Indic Em	sex Sex	age Age	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Persons in the labour force (former name: active persons)	Females	From 15 to 64 years	Percentage of total population	France	2005	65.9
Annual	Persons in the labour force (former name: active persons)	Females	From 15 to 64 years	Percentage of total population	Sweden	2005	75.9
Annual	Persons in the labour force (former name: active persons)	Males	From 15 to 64 years	Percentage of total population	France	2005	75.2
Annual	Persons in the labour force (former name: active persons)	Males	From 15 to 64 years	Percentage of total population	Sweden	2005	80.8
Annual	Persons in the labour force (former name: active persons)	Total	From 15 to 64 years	Percentage of total population	France	2005	70.4
Annual	Persons in the labour force (former name: active persons)	Total	From 15 to 64 years	Percentage of total population	Sweden	2005	78.4
Annual	Persons in the labour force (former name: active persons)	Females	From 15 to 64 years	Percentage of total population	France	2006	66
Annual	Persons in the labour force (former name: active persons)	Females	From 15 to 64 years	Percentage of total population	Sweden	2006	75.8
Annual	Persons in the labour force (former name: active persons)	Males	From 15 to 64 years	Percentage of total population	France	2006	74.9
Annual	Persons in the labour force (former name: active persons)	Males	From 15 to 64 years	Percentage of total population	Sweden	2006	81


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.