Level Of The Foreign Language Reported As Best-known In The Country (self-reported) By Educational Attainment Level

Eurostat code: edat_aes_l53 · (2007 - 2022)

@eurostat.edat_aes_l53

Table List

2 tables(36.44 KB)

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

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

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

@eurostat.edat_aes_l53.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.07 KB
4016 rows
8 columns

freq Freq	age Age	unit Unit	lev_know Lev Know	isced11 Isced11	geo Geo	time_period Time Period	value Value
Annual	From 25 to 64 years	Percentage	Basic	Less than primary, primary and lower secondary education (levels 0-2)	Austria	2007	72
Annual	From 25 to 64 years	Percentage	Basic	Less than primary, primary and lower secondary education (levels 0-2)	Belgium	2007	60.8
Annual	From 25 to 64 years	Percentage	Basic	Less than primary, primary and lower secondary education (levels 0-2)	Bulgaria	2007	94.4
Annual	From 25 to 64 years	Percentage	Basic	Less than primary, primary and lower secondary education (levels 0-2)	Cyprus	2007	77.3
Annual	From 25 to 64 years	Percentage	Basic	Less than primary, primary and lower secondary education (levels 0-2)	Czechia	2007	82.6
Annual	From 25 to 64 years	Percentage	Basic	Less than primary, primary and lower secondary education (levels 0-2)	Germany	2007	67.9
Annual	From 25 to 64 years	Percentage	Basic	Less than primary, primary and lower secondary education (levels 0-2)	Euro area – 20 countries (from 2023)	2007	70.3
Annual	From 25 to 64 years	Percentage	Basic	Less than primary, primary and lower secondary education (levels 0-2)	Estonia	2007	49.4
Annual	From 25 to 64 years	Percentage	Basic	Less than primary, primary and lower secondary education (levels 0-2)	Greece	2007	81.4
Annual	From 25 to 64 years	Percentage	Basic	Less than primary, primary and lower secondary education (levels 0-2)	Spain	2007	79.5


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

Share link

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