Baselight

Employment By Sex, Age, Time Since Job Started And Economic Activity (from 2008 Onwards, NACE Rev. 2) - 1–000

Eurostat code: lfsa_egdn2 · (2008 - 2024)

@eurostat.lfsa_egdn2

Employment By Sex, Age, Time Since Job Started And Economic Activity (from 2008 Onwards, NACE Rev. 2) - 1–000 - Unpivoted
@eurostat.lfsa_egdn2.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.

  • 1.44 MB
  • 550372 rows
  • 9 columns
freq

Freq

unit

Unit

sex

Sex

age

Age

duration

Duration

nace_r2

Nace R2

geo

Geo

time_period

Time Period

value

Value

AnnualThousand personsFemalesFrom 15 to 24 years3 months or overAgriculture, forestry and fishingAustria20084.3
AnnualThousand personsFemalesFrom 15 to 24 years3 months or overAgriculture, forestry and fishingSwitzerland20082.3
AnnualThousand personsFemalesFrom 15 to 24 years3 months or overAgriculture, forestry and fishingCzechia20081
AnnualThousand personsFemalesFrom 15 to 24 years3 months or overAgriculture, forestry and fishingGermany200812.9
AnnualThousand personsFemalesFrom 15 to 24 years3 months or overAgriculture, forestry and fishingDenmark20082.3
AnnualThousand personsFemalesFrom 15 to 24 years3 months or overAgriculture, forestry and fishingEuro area – 20 countries (from 2023)200860.7
AnnualThousand personsFemalesFrom 15 to 24 years3 months or overAgriculture, forestry and fishingGreece20086.2
AnnualThousand personsFemalesFrom 15 to 24 years3 months or overAgriculture, forestry and fishingSpain200810.1
AnnualThousand personsFemalesFrom 15 to 24 years3 months or overAgriculture, forestry and fishingEuropean Union - 27 countries (from 2020)2008204.4
AnnualThousand personsFemalesFrom 15 to 24 years3 months or overAgriculture, forestry and fishingCroatia20082.3

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

Share link

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