Baselight
Sign In

Over-qualification Rates By Country Of Birth

Eurostat code: lfsa_eoqgac ยท (1995 - 2024)

@eurostat.lfsa_eoqgac

Over-qualification Rates By Country Of Birth - Unpivoted
@eurostat.lfsa_eoqgac.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.

  • 125.11 KB
  • 77111 rows
  • 8 columns
freq

Freq

c_birth

C Birth

age

Age

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualEU27 countries (from 2020) except reporting countryFrom 15 to 64 yearsFemalesPercentageBelgium199530.1
AnnualEU27 countries (from 2020) except reporting countryFrom 15 to 64 yearsFemalesPercentageGreece199524.4
AnnualEU27 countries (from 2020) except reporting countryFrom 15 to 64 yearsFemalesPercentageSpain199529
AnnualEU27 countries (from 2020) except reporting countryFrom 15 to 64 yearsFemalesPercentageUnited Kingdom199513.9
AnnualEU27 countries (from 2020) except reporting countryFrom 15 to 64 yearsMalesPercentageBelgium199518.2
AnnualEU27 countries (from 2020) except reporting countryFrom 15 to 64 yearsMalesPercentageSpain199541
AnnualEU27 countries (from 2020) except reporting countryFrom 15 to 64 yearsTotalPercentageBelgium199523.4
AnnualEU27 countries (from 2020) except reporting countryFrom 15 to 64 yearsTotalPercentageGreece199523.1
AnnualEU27 countries (from 2020) except reporting countryFrom 15 to 64 yearsTotalPercentageSpain199534.4
AnnualEU27 countries (from 2020) except reporting countryFrom 15 to 64 yearsTotalPercentageFrance199514

CREATE TABLE tidy (
  "freq" VARCHAR,
  "c_birth" 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.