Baselight
Sign In

Transition Of Educational Attainment Level From Parents To Current Adults (population Aged 25 - 59)

Eurostat code: ilc_igtp01 ยท (2019 - 2023)

@eurostat.ilc_igtp01

Transition Of Educational Attainment Level From Parents To Current Adults (population Aged 25 - 59) - Unpivoted
@eurostat.ilc_igtp01.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.

  • 13.46 KB
  • 2286 rows
  • 8 columns
freq

Freq

unit

Unit

trans1g

Trans1g

isced11

Isced11

sex

Sex

geo

Geo

time_period

Time Period

value

Value

AnnualPercentageFrom pre-primary, primary and lower secondary education (levels 0-2) of the parentsLess than primary, primary and lower secondary education (levels 0-2)FemalesAlbania201990.2
AnnualPercentageFrom pre-primary, primary and lower secondary education (levels 0-2) of the parentsLess than primary, primary and lower secondary education (levels 0-2)FemalesAustria201958.9
AnnualPercentageFrom pre-primary, primary and lower secondary education (levels 0-2) of the parentsLess than primary, primary and lower secondary education (levels 0-2)FemalesBelgium201979.6
AnnualPercentageFrom pre-primary, primary and lower secondary education (levels 0-2) of the parentsLess than primary, primary and lower secondary education (levels 0-2)FemalesBulgaria201988.9
AnnualPercentageFrom pre-primary, primary and lower secondary education (levels 0-2) of the parentsLess than primary, primary and lower secondary education (levels 0-2)FemalesSwitzerland201963.6
AnnualPercentageFrom pre-primary, primary and lower secondary education (levels 0-2) of the parentsLess than primary, primary and lower secondary education (levels 0-2)FemalesCyprus201984.6
AnnualPercentageFrom pre-primary, primary and lower secondary education (levels 0-2) of the parentsLess than primary, primary and lower secondary education (levels 0-2)FemalesCzechia201978.8
AnnualPercentageFrom pre-primary, primary and lower secondary education (levels 0-2) of the parentsLess than primary, primary and lower secondary education (levels 0-2)FemalesGermany201933.6
AnnualPercentageFrom pre-primary, primary and lower secondary education (levels 0-2) of the parentsLess than primary, primary and lower secondary education (levels 0-2)FemalesDenmark201942.3
AnnualPercentageFrom pre-primary, primary and lower secondary education (levels 0-2) of the parentsLess than primary, primary and lower secondary education (levels 0-2)FemalesEuro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)201986.5

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

Share link

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