Number Of Foreign Languages Known (self-reported) By Educational Attainment Level

Eurostat code: edat_aes_l23 · (2007 - 2022)

@eurostat.edat_aes_l23

Table List

2 tables(39.49 KB)

Number Of Foreign Languages Known (self-reported) By Educational Attainment Level - Raw

Number Of Foreign Languages Known (self-reported) By Educational Attainment Level - Unpivoted

Number Of Foreign Languages Known (self-reported) By Educational Attainment Level - Unpivoted

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

17.37 KB
5103 rows
8 columns

freq Freq	age Age	n_lang N Lang	unit Unit	isced11 Isced11	geo Geo	time_period Time Period	value Value
Annual	From 25 to 64 years	No languages	Percentage	Less than primary, primary and lower secondary education (levels 0-2)	Austria	2007	38.4
Annual	From 25 to 64 years	No languages	Percentage	Less than primary, primary and lower secondary education (levels 0-2)	Belgium	2007	55.9
Annual	From 25 to 64 years	No languages	Percentage	Less than primary, primary and lower secondary education (levels 0-2)	Bulgaria	2007	79.2
Annual	From 25 to 64 years	No languages	Percentage	Less than primary, primary and lower secondary education (levels 0-2)	Cyprus	2007	41.2
Annual	From 25 to 64 years	No languages	Percentage	Less than primary, primary and lower secondary education (levels 0-2)	Czechia	2007	64.6
Annual	From 25 to 64 years	No languages	Percentage	Less than primary, primary and lower secondary education (levels 0-2)	Germany	2007	41.4
Annual	From 25 to 64 years	No languages	Percentage	Less than primary, primary and lower secondary education (levels 0-2)	Denmark	2007	27
Annual	From 25 to 64 years	No languages	Percentage	Less than primary, primary and lower secondary education (levels 0-2)	Euro area – 20 countries (from 2023)	2007	59.7
Annual	From 25 to 64 years	No languages	Percentage	Less than primary, primary and lower secondary education (levels 0-2)	Estonia	2007	24
Annual	From 25 to 64 years	No languages	Percentage	Less than primary, primary and lower secondary education (levels 0-2)	Greece	2007	76.1


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

Share link

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