Pupils Enrolled In Upper-secondary Education By Programme Orientation, Sex And Age

Eurostat code: educ_uoe_enrs05 · (2012 - 2023)

@eurostat.educ_uoe_enrs05

Table List

2 tables(901.04 KB)

Pupils Enrolled In Upper-secondary Education By Programme Orientation, Sex And Age - Raw

Pupils Enrolled In Upper-secondary Education By Programme Orientation, Sex And Age - Unpivoted

Pupils Enrolled In Upper-secondary Education By Programme Orientation, Sex And Age - Unpivoted

@eurostat.educ_uoe_enrs05.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.

409.66 KB
122980 rows
8 columns

freq Freq	unit Unit	age Age	sex Sex	isced11 Isced11	geo Geo	time_period Time Period	value Value
Annual	Number	Total	Females	Upper secondary education	Germany	2012	1207048
Annual	Number	Total	Males	Upper secondary education	Germany	2012	1438456
Annual	Number	Total	Total	Upper secondary education	Germany	2012	2645504
Annual	Number	Unknown	Females	Upper secondary education	Germany	2012	109
Annual	Number	Unknown	Males	Upper secondary education	Germany	2012	187
Annual	Number	Unknown	Total	Upper secondary education	Germany	2012	296
Annual	Number	15 years	Females	Upper secondary education	Germany	2012	72311
Annual	Number	15 years	Males	Upper secondary education	Germany	2012	63295
Annual	Number	15 years	Total	Upper secondary education	Germany	2012	135606
Annual	Number	16 years	Females	Upper secondary education	Germany	2012	191058


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