Severe Material And Social Deprivation By Age, Sex And Educational Attainment Level

Eurostat code: ilc_mdsd14 · (2015 - 2024)

@eurostat.ilc_mdsd14

Table List

2 tables(336.35 KB)

Severe Material And Social Deprivation By Age, Sex And Educational Attainment Level - Raw

Severe Material And Social Deprivation By Age, Sex And Educational Attainment Level - Unpivoted

Severe Material And Social Deprivation By Age, Sex And Educational Attainment Level - Unpivoted

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

154.37 KB
107463 rows
8 columns

freq Freq	isced11 Isced11	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Less than primary, primary and lower secondary education (levels 0-2)	From 16 to 19 years	Females	Percentage	Austria	2015
Annual	Less than primary, primary and lower secondary education (levels 0-2)	From 16 to 19 years	Females	Percentage	Belgium	2015	17
Annual	Less than primary, primary and lower secondary education (levels 0-2)	From 16 to 19 years	Females	Percentage	Bulgaria	2015	41
Annual	Less than primary, primary and lower secondary education (levels 0-2)	From 16 to 19 years	Females	Percentage	Switzerland	2015	0.4
Annual	Less than primary, primary and lower secondary education (levels 0-2)	From 16 to 19 years	Females	Percentage	Cyprus	2015	28.2
Annual	Less than primary, primary and lower secondary education (levels 0-2)	From 16 to 19 years	Females	Percentage	Czechia	2015	2.4
Annual	Less than primary, primary and lower secondary education (levels 0-2)	From 16 to 19 years	Females	Percentage	Germany	2015	4.7
Annual	Less than primary, primary and lower secondary education (levels 0-2)	From 16 to 19 years	Females	Percentage	Denmark	2015	3.4
Annual	Less than primary, primary and lower secondary education (levels 0-2)	From 16 to 19 years	Females	Percentage	Euro area – 20 countries (from 2023)	2015	9.9
Annual	Less than primary, primary and lower secondary education (levels 0-2)	From 16 to 19 years	Females	Percentage	Estonia	2015	0.2


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