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

About this Dataset

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

This Eurostat dataset contains data on pupils enrolled in upper secondary education by programme orientation, sex, type of institution and intensity of participation, as collected and published by the Statistical Office of the European Union.

Tables included:

raw: Original table as downloaded from Eurostat.
tidy: A cleaned and transformed version of the raw table, where time period values appear as rows instead of columns (unpivoted format).

Last updated: 2025-06-06T23:00:00+0200

Tables

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

@eurostat.educ_uoe_enrs04.raw

327.99 KB
9351 rows
21 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "worktime" VARCHAR,
  "sector" VARCHAR,
  "sex" VARCHAR,
  "isced11" VARCHAR,
  "geo" VARCHAR,
  "n_2005" DOUBLE,
  "n_2010" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE
);

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

@eurostat.educ_uoe_enrs04.tidy

312.62 KB
75730 rows
9 columns


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