Baselight

Early Leavers From Education And Training By Sex And Degree Of Urbanisation

Eurostat code: edat_lfse_30 ยท (2000 - 2024)

@eurostat.edat_lfse_30

Early Leavers From Education And Training By Sex And Degree Of Urbanisation - Unpivoted
@eurostat.edat_lfse_30.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.

  • 41.51 KB
  • 22213 rows
  • 9 columns
freq

Freq

unit

Unit

wstatus

Wstatus

sex

Sex

age

Age

deg_urb

Deg Urb

geo

Geo

time_period

Time Period

value

Value

AnnualPercentagePopulationFemalesFrom 18 to 24 yearsCitiesAustria200011
AnnualPercentagePopulationFemalesFrom 18 to 24 yearsCitiesBelgium200013.5
AnnualPercentagePopulationFemalesFrom 18 to 24 yearsCitiesCyprus200012.7
AnnualPercentagePopulationFemalesFrom 18 to 24 yearsCitiesGermany200016.7
AnnualPercentagePopulationFemalesFrom 18 to 24 yearsCitiesDenmark20007.7
AnnualPercentagePopulationFemalesFrom 18 to 24 yearsCitiesGreece20009.6
AnnualPercentagePopulationFemalesFrom 18 to 24 yearsCitiesSpain200018
AnnualPercentagePopulationFemalesFrom 18 to 24 yearsCitiesFinland20007
AnnualPercentagePopulationFemalesFrom 18 to 24 yearsCitiesFrance200011.1
AnnualPercentagePopulationFemalesFrom 18 to 24 yearsCitiesIceland200027.9

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

Share link

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