Baselight

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

Eurostat code: edat_aes_l55 · (2007 - 2022)

@eurostat.edat_aes_l55

Level Of The Foreign Language Reported As Best-known In The Country (self-reported) By Occupation - Unpivoted
@eurostat.edat_aes_l55.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.

  • 14.96 KB
  • 3465 rows
  • 8 columns
freq

Freq

age

Age

unit

Unit

lev_know

Lev Know

isco08

Isco08

geo

Geo

time_period

Time Period

value

Value

AnnualFrom 25 to 64 yearsPercentageBasicManagers, professionals, technicians and associate professionalsAustria200724.6
AnnualFrom 25 to 64 yearsPercentageBasicManagers, professionals, technicians and associate professionalsBelgium200737.2
AnnualFrom 25 to 64 yearsPercentageBasicManagers, professionals, technicians and associate professionalsBulgaria200757.6
AnnualFrom 25 to 64 yearsPercentageBasicManagers, professionals, technicians and associate professionalsCyprus200710.7
AnnualFrom 25 to 64 yearsPercentageBasicManagers, professionals, technicians and associate professionalsCzechia200745.6
AnnualFrom 25 to 64 yearsPercentageBasicManagers, professionals, technicians and associate professionalsGermany200740.7
AnnualFrom 25 to 64 yearsPercentageBasicManagers, professionals, technicians and associate professionalsEuro area – 20 countries (from 2023)200737.8
AnnualFrom 25 to 64 yearsPercentageBasicManagers, professionals, technicians and associate professionalsEstonia200722.8
AnnualFrom 25 to 64 yearsPercentageBasicManagers, professionals, technicians and associate professionalsGreece200731.4
AnnualFrom 25 to 64 yearsPercentageBasicManagers, professionals, technicians and associate professionalsSpain200737.3

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

Share link

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