Baselight

Pupils Enrolled In Upper Secondary Education By Programme Orientation, Sex, Type Of Institution And Intensity Of Participation

Eurostat code: educ_uoe_enrs04 ยท (2005 - 2023)

@eurostat.educ_uoe_enrs04

Pupils Enrolled In Upper Secondary Education By Programme Orientation, Sex, Type Of Institution And Intensity Of Participation - Unpivoted
@eurostat.educ_uoe_enrs04.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.

  • 312.28 KB
  • 75622 rows
  • 9 columns
freq

Freq

unit

Unit

worktime

Worktime

sector

Sector

sex

Sex

isced11

Isced11

geo

Geo

time_period

Time Period

value

Value

AnnualNumberTotalTotalFemalesUpper secondary educationAustria2005179369
AnnualNumberTotalTotalFemalesUpper secondary educationBelgium2005402614
AnnualNumberTotalTotalFemalesUpper secondary educationBulgaria2005181294
AnnualNumberTotalTotalFemalesUpper secondary educationCyprus200516076
AnnualNumberTotalTotalFemalesUpper secondary educationEstonia200531074
AnnualNumberTotalTotalFemalesUpper secondary educationSpain2005537874
AnnualNumberTotalTotalFemalesUpper secondary educationFinland2005174854
AnnualNumberTotalTotalFemalesUpper secondary educationFrance20051351542
AnnualNumberTotalTotalFemalesUpper secondary educationHungary2005267812
AnnualNumberTotalTotalFemalesUpper secondary educationIreland200577936

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

Share link

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