Baselight

Employment By Sex, Age And Detailed Economic Activity (from 2008 Onwards, NACE Rev. 2 Two Digit Level) - 1–000

Eurostat code: lfsa_egan22d · (2008 - 2024)

@eurostat.lfsa_egan22d

Employment By Sex, Age And Detailed Economic Activity (from 2008 Onwards, NACE Rev. 2 Two Digit Level) - 1–000 - Unpivoted
@eurostat.lfsa_egan22d.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.

  • 5.39 MB
  • 2198813 rows
  • 8 columns
freq

Freq

unit

Unit

age

Age

sex

Sex

nace_r2

Nace R2

geo

Geo

time_period

Time Period

value

Value

AnnualThousand personsFrom 15 to 24 yearsFemalesCrop and animal production, hunting and related service activitiesAustria20084.5
AnnualThousand personsFrom 15 to 24 yearsFemalesCrop and animal production, hunting and related service activitiesSwitzerland20082.9
AnnualThousand personsFrom 15 to 24 yearsFemalesCrop and animal production, hunting and related service activitiesCzechia20081.3
AnnualThousand personsFrom 15 to 24 yearsFemalesCrop and animal production, hunting and related service activitiesGermany200815.1
AnnualThousand personsFrom 15 to 24 yearsFemalesCrop and animal production, hunting and related service activitiesDenmark20082.7
AnnualThousand personsFrom 15 to 24 yearsFemalesCrop and animal production, hunting and related service activitiesEuro area – 20 countries (from 2023)200884.6
AnnualThousand personsFrom 15 to 24 yearsFemalesCrop and animal production, hunting and related service activitiesGreece20086.3
AnnualThousand personsFrom 15 to 24 yearsFemalesCrop and animal production, hunting and related service activitiesSpain200814.6
AnnualThousand personsFrom 15 to 24 yearsFemalesCrop and animal production, hunting and related service activitiesEuropean Union - 27 countries (from 2020)2008240.5
AnnualThousand personsFrom 15 to 24 yearsFemalesCrop and animal production, hunting and related service activitiesFinland20082.4

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

Share link

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