Baselight

Employment By Sex, Age, Professional Status And Job Tenure

Eurostat code: lfsa_egasjt ยท (1995 - 2024)

@eurostat.lfsa_egasjt

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

  • 262.54 KB
  • 198793 rows
  • 8 columns
freq

Freq

wstatus

Wstatus

unit

Unit

sex

Sex

age

Age

geo

Geo

time_period

Time Period

value

Value

AnnualContributing family workersYearFemalesFrom 15 to 24 yearsBelgium19951.5
AnnualContributing family workersYearFemalesFrom 15 to 24 yearsGermany19953
AnnualContributing family workersYearFemalesFrom 15 to 24 yearsGreece19953.3
AnnualContributing family workersYearFemalesFrom 15 to 24 yearsSpain19952.6
AnnualContributing family workersYearFemalesFrom 15 to 24 yearsItaly19953
AnnualContributing family workersYearFemalesFrom 15 to 24 yearsNetherlands19952
AnnualContributing family workersYearFemalesFrom 15 to 24 yearsPortugal19955.1
AnnualContributing family workersYearFemalesFrom 15 to 64 yearsAustria199516.2
AnnualContributing family workersYearFemalesFrom 15 to 64 yearsBelgium199515.8
AnnualContributing family workersYearFemalesFrom 15 to 64 yearsGermany199517.4

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

Share link

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