Early Leavers From Education And Training By Sex And Citizenship

Eurostat code: edat_lfse_01$dv_1866

@eurostat.edat_lfse_01_dv_1866

Table List

2 tables(91.56 KB)

Early Leavers From Education And Training By Sex And Citizenship - Raw

Early Leavers From Education And Training By Sex And Citizenship - Unpivoted

Early Leavers From Education And Training By Sex And Citizenship - Unpivoted

@eurostat.edat_lfse_01_dv_1866.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.

32.51 KB
16413 rows
9 columns

freq Freq	sex Sex	wstatus Wstatus	citizen Citizen	age Age	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Females	Population	Reporting country	From 18 to 24 years	Percentage	Austria	2004	6.8
Annual	Females	Population	Reporting country	From 18 to 24 years	Percentage	Belgium	2004	9.3
Annual	Females	Population	Reporting country	From 18 to 24 years	Percentage	Bulgaria	2004	20.6
Annual	Females	Population	Reporting country	From 18 to 24 years	Percentage	Switzerland	2004	5
Annual	Females	Population	Reporting country	From 18 to 24 years	Percentage	Cyprus	2004	9.2
Annual	Females	Population	Reporting country	From 18 to 24 years	Percentage	Czechia	2004	6.3
Annual	Females	Population	Reporting country	From 18 to 24 years	Percentage	Germany	2004	9.4
Annual	Females	Population	Reporting country	From 18 to 24 years	Percentage	Denmark	2004	6.8
Annual	Females	Population	Reporting country	From 18 to 24 years	Percentage	Euro area – 20 countries (from 2023)	2004	12.5
Annual	Females	Population	Reporting country	From 18 to 24 years	Percentage	Estonia	2004	7.2


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

Share link

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