Baselight

Employed Persons By Level Of Standardization Of Tasks, Migration Status And Citizenship

Eurostat code: lfso_22wrkm13 ยท (2022 - 2022)

@eurostat.lfso_22wrkm13

Employed Persons By Level Of Standardization Of Tasks, Migration Status And Citizenship - Unpivoted
@eurostat.lfso_22wrkm13.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.

  • 556.68 KB
  • 191636 rows
  • 10 columns
freq

Freq

citizen

Citizen

mgstatus

Mgstatus

levels

Levels

age

Age

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualEU27 countries (from 2020) except reporting countryForeign-born (first generation)HighFrom 15 to 24 yearsFemalesThousand personsSwitzerland20223.7
AnnualEU27 countries (from 2020) except reporting countryForeign-born (first generation)HighFrom 15 to 24 yearsFemalesThousand personsLuxembourg20220.8
AnnualEU27 countries (from 2020) except reporting countryForeign-born (first generation)HighFrom 15 to 24 yearsFemalesThousand personsNetherlands20226.4
AnnualEU27 countries (from 2020) except reporting countryForeign-born (first generation)HighFrom 15 to 24 yearsMalesThousand personsAustria20225
AnnualEU27 countries (from 2020) except reporting countryForeign-born (first generation)HighFrom 15 to 24 yearsMalesThousand personsSwitzerland20223.4
AnnualEU27 countries (from 2020) except reporting countryForeign-born (first generation)HighFrom 15 to 24 yearsMalesThousand personsGermany202215.4
AnnualEU27 countries (from 2020) except reporting countryForeign-born (first generation)HighFrom 15 to 24 yearsMalesThousand personsSpain20228.2
AnnualEU27 countries (from 2020) except reporting countryForeign-born (first generation)HighFrom 15 to 24 yearsMalesThousand personsNetherlands20223.7
AnnualEU27 countries (from 2020) except reporting countryForeign-born (first generation)HighFrom 15 to 24 yearsTotalThousand personsAustria20228.9
AnnualEU27 countries (from 2020) except reporting countryForeign-born (first generation)HighFrom 15 to 24 yearsTotalThousand personsSwitzerland20227.2

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

Share link

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