Baselight

Employment By Sex, Age And Job Tenure

Eurostat code: lfsa_egad$dv_1742

@eurostat.lfsa_egad_dv_1742

Employment By Sex, Age And Job Tenure - Unpivoted
@eurostat.lfsa_egad_dv_1742.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.

  • 68.34 KB
  • 21410 rows
  • 8 columns
freq

Freq

duration

Duration

sex

Sex

age

Age

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualFrom 0 to 11 monthsFemalesFrom 15 to 24 yearsPercentageAustria201541.2
AnnualFrom 0 to 11 monthsFemalesFrom 15 to 24 yearsPercentageBelgium201549
AnnualFrom 0 to 11 monthsFemalesFrom 15 to 24 yearsPercentageBulgaria201536.6
AnnualFrom 0 to 11 monthsFemalesFrom 15 to 24 yearsPercentageSwitzerland201544.4
AnnualFrom 0 to 11 monthsFemalesFrom 15 to 24 yearsPercentageCyprus201557.4
AnnualFrom 0 to 11 monthsFemalesFrom 15 to 24 yearsPercentageCzechia201542.2
AnnualFrom 0 to 11 monthsFemalesFrom 15 to 24 yearsPercentageGermany201540.2
AnnualFrom 0 to 11 monthsFemalesFrom 15 to 24 yearsPercentageDenmark201549.8
AnnualFrom 0 to 11 monthsFemalesFrom 15 to 24 yearsPercentageEuro area – 20 countries (from 2023)201547.1
AnnualFrom 0 to 11 monthsFemalesFrom 15 to 24 yearsPercentageEstonia201555.4

CREATE TABLE tidy (
  "freq" VARCHAR,
  "duration" 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.