Over-qualification Rates By Citizenship

Eurostat code: lfsa_eoqgan · (1995 - 2024)

@eurostat.lfsa_eoqgan

Table List

2 tables(311.49 KB)

Over-qualification Rates By Citizenship - Raw

Over-qualification Rates By Citizenship - Unpivoted

Over-qualification Rates By Citizenship - Unpivoted

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

118.39 KB
72397 rows
8 columns

freq Freq	citizen Citizen	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	EU27 countries (from 2020) except reporting country	From 15 to 64 years	Females	Percentage	Belgium	1995	30.9
Annual	EU27 countries (from 2020) except reporting country	From 15 to 64 years	Females	Percentage	Germany	1995	32.3
Annual	EU27 countries (from 2020) except reporting country	From 15 to 64 years	Males	Percentage	Belgium	1995	19.6
Annual	EU27 countries (from 2020) except reporting country	From 15 to 64 years	Males	Percentage	Germany	1995	26.7
Annual	EU27 countries (from 2020) except reporting country	From 15 to 64 years	Males	Percentage	Spain	1995	29.2
Annual	EU27 countries (from 2020) except reporting country	From 15 to 64 years	Total	Percentage	Belgium	1995	23.5
Annual	EU27 countries (from 2020) except reporting country	From 15 to 64 years	Total	Percentage	Germany	1995	28.5
Annual	EU27 countries (from 2020) except reporting country	From 15 to 64 years	Total	Percentage	Spain	1995	25.3
Annual	EU27 countries (from 2020) except reporting country	From 15 to 64 years	Total	Percentage	Luxembourg	1995	7.1
Annual	EU27 countries (from 2020) except reporting country	From 20 to 34 years	Females	Percentage	Belgium	1995	34.4


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

Share link

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