Baselight

Early Leavers From Education And Training, By Citizenship

Eurostat code: sdg_04_10a · (2004 - 2024)

@eurostat.sdg_04_10a

Early Leavers From Education And Training, By Citizenship - Unpivoted
@eurostat.sdg_04_10a.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.

  • 10.6 KB
  • 1365 rows
  • 9 columns
freq

Freq

sex

Sex

wstatus

Wstatus

unit

Unit

age

Age

citizen

Citizen

geo

Geo

time_period

Time Period

value

Value

AnnualTotalPopulationPercentageFrom 18 to 24 yearsReporting countryAustria20047.8
AnnualTotalPopulationPercentageFrom 18 to 24 yearsReporting countryBelgium200412.1
AnnualTotalPopulationPercentageFrom 18 to 24 yearsReporting countryBulgaria200421.5
AnnualTotalPopulationPercentageFrom 18 to 24 yearsReporting countrySwitzerland20045.4
AnnualTotalPopulationPercentageFrom 18 to 24 yearsReporting countryCyprus200417
AnnualTotalPopulationPercentageFrom 18 to 24 yearsReporting countryCzechia20046.1
AnnualTotalPopulationPercentageFrom 18 to 24 yearsReporting countryGermany20049.8
AnnualTotalPopulationPercentageFrom 18 to 24 yearsReporting countryDenmark20048.4
AnnualTotalPopulationPercentageFrom 18 to 24 yearsReporting countryEuro area – 20 countries (from 2023)200415.5
AnnualTotalPopulationPercentageFrom 18 to 24 yearsReporting countryEstonia200411.7

CREATE TABLE tidy (
  "freq" VARCHAR,
  "sex" VARCHAR,
  "wstatus" VARCHAR,
  "unit" 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.