Baselight

Employment By Sex, Age And Job Tenure

Eurostat code: lfsa_egad ยท (1995 - 2024)

@eurostat.lfsa_egad

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

  • 869.03 KB
  • 318160 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 yearsPercentageAustria199525.3
AnnualFrom 0 to 11 monthsFemalesFrom 15 to 24 yearsPercentageBelgium199541.8
AnnualFrom 0 to 11 monthsFemalesFrom 15 to 24 yearsPercentageGermany199527.1
AnnualFrom 0 to 11 monthsFemalesFrom 15 to 24 yearsPercentageDenmark199558.3
AnnualFrom 0 to 11 monthsFemalesFrom 15 to 24 yearsPercentageGreece199532.1
AnnualFrom 0 to 11 monthsFemalesFrom 15 to 24 yearsPercentageSpain199572
AnnualFrom 0 to 11 monthsFemalesFrom 15 to 24 yearsPercentageFinland199552.4
AnnualFrom 0 to 11 monthsFemalesFrom 15 to 24 yearsPercentageFrance199549.5
AnnualFrom 0 to 11 monthsFemalesFrom 15 to 24 yearsPercentageIreland199539.5
AnnualFrom 0 to 11 monthsFemalesFrom 15 to 24 yearsPercentageIceland199556.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.