Distribution Of Population Aged 18 And Over By Educational Attainment Level And Age Group

Eurostat code: ilc_lvps04 · (2003 - 2024)

@eurostat.ilc_lvps04

Table List

2 tables(126.63 KB)

Distribution Of Population Aged 18 And Over By Educational Attainment Level And Age Group - Raw

Distribution Of Population Aged 18 And Over By Educational Attainment Level And Age Group - Unpivoted

Distribution Of Population Aged 18 And Over By Educational Attainment Level And Age Group - Unpivoted

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

38.04 KB
20844 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 18 to 64 years	Females	Percentage	Austria	2003	25.8
Annual	Less than primary, primary and lower secondary education (levels 0-2)	From 18 to 64 years	Females	Percentage	Belgium	2003	31.7
Annual	Less than primary, primary and lower secondary education (levels 0-2)	From 18 to 64 years	Females	Percentage	Denmark	2003	30.2
Annual	Less than primary, primary and lower secondary education (levels 0-2)	From 18 to 64 years	Females	Percentage	Greece	2003	41.2
Annual	Less than primary, primary and lower secondary education (levels 0-2)	From 18 to 64 years	Females	Percentage	Ireland	2003	32
Annual	Less than primary, primary and lower secondary education (levels 0-2)	From 18 to 64 years	Females	Percentage	Luxembourg	2003	43.7
Annual	Less than primary, primary and lower secondary education (levels 0-2)	From 18 to 64 years	Females	Percentage	Norway	2003	10.8
Annual	Less than primary, primary and lower secondary education (levels 0-2)	From 18 to 64 years	Males	Percentage	Austria	2003	14.9
Annual	Less than primary, primary and lower secondary education (levels 0-2)	From 18 to 64 years	Males	Percentage	Belgium	2003	29.7
Annual	Less than primary, primary and lower secondary education (levels 0-2)	From 18 to 64 years	Males	Percentage	Denmark	2003	28.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.