Baselight

Employment By Sex, Age And Citizenship (1–000)

Eurostat code: lfsa_egan · (1995 - 2024)

@eurostat.lfsa_egan

Employment By Sex, Age And Citizenship (1–000) - Unpivoted
@eurostat.lfsa_egan.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.32 MB
  • 401129 rows
  • 8 columns
freq

Freq

unit

Unit

sex

Sex

age

Age

citizen

Citizen

geo

Geo

time_period

Time Period

value

Value

AnnualThousand personsFemalesFrom 15 to 19 yearsEU27 countries (from 2020) except reporting countryGermany199514.6
AnnualThousand personsFemalesFrom 15 to 19 yearsEU27 countries (from 2020) except reporting countryLuxembourg19950.7
AnnualThousand personsFemalesFrom 15 to 19 yearsForeign countryAustria19958.7
AnnualThousand personsFemalesFrom 15 to 19 yearsForeign countryGermany199567.3
AnnualThousand personsFemalesFrom 15 to 19 yearsForeign countryLuxembourg19950.7
AnnualThousand personsFemalesFrom 15 to 19 yearsReporting countryAustria199568.6
AnnualThousand personsFemalesFrom 15 to 19 yearsReporting countryBelgium19958.8
AnnualThousand personsFemalesFrom 15 to 19 yearsReporting countryGermany1995462.7
AnnualThousand personsFemalesFrom 15 to 19 yearsReporting countryDenmark199588.3
AnnualThousand personsFemalesFrom 15 to 19 yearsReporting countryGreece199528.4

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

Share link

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