Level Of The Best-known Foreign Language (self-reported) By Educational Attainment Level

Eurostat code: edat_aes_l33 · (2007 - 2022)

@eurostat.edat_aes_l33

Table List

2 tables(36.65 KB)

Level Of The Best-known Foreign Language (self-reported) By Educational Attainment Level - Raw

Level Of The Best-known Foreign Language (self-reported) By Educational Attainment Level - Unpivoted

Level Of The Best-known Foreign Language (self-reported) By Educational Attainment Level - Unpivoted

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

16 KB
4174 rows
8 columns

freq Freq	age Age	unit Unit	isced11 Isced11	lev_know Lev Know	geo Geo	time_period Time Period	value Value
Annual	From 25 to 64 years	Percentage	Less than primary, primary and lower secondary education (levels 0-2)	Basic	Austria	2007	54.3
Annual	From 25 to 64 years	Percentage	Less than primary, primary and lower secondary education (levels 0-2)	Basic	Belgium	2007	55.3
Annual	From 25 to 64 years	Percentage	Less than primary, primary and lower secondary education (levels 0-2)	Basic	Bulgaria	2007	88
Annual	From 25 to 64 years	Percentage	Less than primary, primary and lower secondary education (levels 0-2)	Basic	Cyprus	2007	75.1
Annual	From 25 to 64 years	Percentage	Less than primary, primary and lower secondary education (levels 0-2)	Basic	Czechia	2007	80.9
Annual	From 25 to 64 years	Percentage	Less than primary, primary and lower secondary education (levels 0-2)	Basic	Germany	2007	42.8
Annual	From 25 to 64 years	Percentage	Less than primary, primary and lower secondary education (levels 0-2)	Basic	Euro area – 20 countries (from 2023)	2007	53.3
Annual	From 25 to 64 years	Percentage	Less than primary, primary and lower secondary education (levels 0-2)	Basic	Estonia	2007	45.9
Annual	From 25 to 64 years	Percentage	Less than primary, primary and lower secondary education (levels 0-2)	Basic	Greece	2007	67.6
Annual	From 25 to 64 years	Percentage	Less than primary, primary and lower secondary education (levels 0-2)	Basic	Spain	2007	55


CREATE TABLE tidy (
  "freq" VARCHAR,
  "age" VARCHAR,
  "unit" VARCHAR,
  "isced11" VARCHAR,
  "lev_know" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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