Baselight

Employment Rate By Sex

Eurostat code: tesem010 ยท (2005 - 2024)

@eurostat.tesem010

Employment Rate By Sex - Unpivoted
@eurostat.tesem010.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.53 KB
  • 1725 rows
  • 8 columns
freq

Freq

indic_em

Indic Em

unit

Unit

age

Age

sex

Sex

geo

Geo

time_period

Time Period

value

Value

AnnualTotal employment (resident population concept - LFS)Percentage of total populationFrom 20 to 64 yearsFemalesFrance200564.8
AnnualTotal employment (resident population concept - LFS)Percentage of total populationFrom 20 to 64 yearsFemalesSweden200574.8
AnnualTotal employment (resident population concept - LFS)Percentage of total populationFrom 20 to 64 yearsMalesFrance200575
AnnualTotal employment (resident population concept - LFS)Percentage of total populationFrom 20 to 64 yearsMalesSweden200580.6
AnnualTotal employment (resident population concept - LFS)Percentage of total populationFrom 20 to 64 yearsTotalFrance200569.8
AnnualTotal employment (resident population concept - LFS)Percentage of total populationFrom 20 to 64 yearsTotalSweden200577.7
AnnualTotal employment (resident population concept - LFS)Percentage of total populationFrom 20 to 64 yearsFemalesFrance200665
AnnualTotal employment (resident population concept - LFS)Percentage of total populationFrom 20 to 64 yearsFemalesSweden200675.2
AnnualTotal employment (resident population concept - LFS)Percentage of total populationFrom 20 to 64 yearsMalesFrance200674.7
AnnualTotal employment (resident population concept - LFS)Percentage of total populationFrom 20 to 64 yearsMalesSweden200681.5

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

Share link

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