Baselight

Distribution Of Academic Staff At Education Level By Age Groups

Eurostat code: educ_uoe_perd02 ยท (2013 - 2023)

@eurostat.educ_uoe_perd02

Distribution Of Academic Staff At Education Level By Age Groups - Unpivoted
@eurostat.educ_uoe_perd02.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.

  • 43.13 KB
  • 25800 rows
  • 8 columns
freq

Freq

unit

Unit

isced11

Isced11

age

Age

sex

Sex

geo

Geo

time_period

Time Period

value

Value

AnnualPercentageShort-cycle tertiary educationFrom 25 to 29 yearsFemalesAustria20133.2
AnnualPercentageShort-cycle tertiary educationFrom 25 to 29 yearsFemalesCyprus201312.6
AnnualPercentageShort-cycle tertiary educationFrom 25 to 29 yearsFemalesCzechia20135.1
AnnualPercentageShort-cycle tertiary educationFrom 25 to 29 yearsFemalesGermany20132.2
AnnualPercentageShort-cycle tertiary educationFrom 25 to 29 yearsFemalesSpain20131.4
AnnualPercentageShort-cycle tertiary educationFrom 25 to 29 yearsFemalesFrance20136.9
AnnualPercentageShort-cycle tertiary educationFrom 25 to 29 yearsFemalesHungary20134.7
AnnualPercentageShort-cycle tertiary educationFrom 25 to 29 yearsFemalesLatvia20134.8
AnnualPercentageShort-cycle tertiary educationFrom 25 to 29 yearsFemalesMalta201311.9
AnnualPercentageShort-cycle tertiary educationFrom 25 to 29 yearsFemalesPoland20134.1

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

Share link

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