Baselight
Sign In

Number Of Foreign Languages Known (self-reported) By Degree Of Urbanisation

Eurostat code: edat_aes_l26 · (2007 - 2022)

@eurostat.edat_aes_l26

Number Of Foreign Languages Known (self-reported) By Degree Of Urbanisation - Unpivoted
@eurostat.edat_aes_l26.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.84 KB
  • 3887 rows
  • 8 columns
freq

Freq

age

Age

n_lang

N Lang

unit

Unit

deg_urb

Deg Urb

geo

Geo

time_period

Time Period

value

Value

AnnualFrom 25 to 64 yearsNo languagesPercentageCitiesAustria200711.9
AnnualFrom 25 to 64 yearsNo languagesPercentageCitiesBelgium200728.1
AnnualFrom 25 to 64 yearsNo languagesPercentageCitiesBulgaria200743.4
AnnualFrom 25 to 64 yearsNo languagesPercentageCitiesCyprus200711.1
AnnualFrom 25 to 64 yearsNo languagesPercentageCitiesCzechia200725
AnnualFrom 25 to 64 yearsNo languagesPercentageCitiesGermany200724.2
AnnualFrom 25 to 64 yearsNo languagesPercentageCitiesDenmark20077.2
AnnualFrom 25 to 64 yearsNo languagesPercentageCitiesEuro area – 20 countries (from 2023)200730.3
AnnualFrom 25 to 64 yearsNo languagesPercentageCitiesEstonia200717.1
AnnualFrom 25 to 64 yearsNo languagesPercentageCitiesGreece200734

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