Pupils And Students Enrolled By Education Level, Programme Orientation, Completion And Sex

Eurostat code: educ_uoe_enra16 · (2012 - 2023)

@eurostat.educ_uoe_enra16

Table List

2 tables(335.67 KB)

Pupils And Students Enrolled By Education Level, Programme Orientation, Completion And Sex - Raw

Pupils And Students Enrolled By Education Level, Programme Orientation, Completion And Sex - Unpivoted

Pupils And Students Enrolled By Education Level, Programme Orientation, Completion And Sex - Unpivoted

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

165.06 KB
31096 rows
7 columns

freq Freq	unit Unit	isced11 Isced11	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Number	Upper secondary education	Total	Germany	2012	2645504
Annual	Number	Post-secondary non-tertiary education	Total	Germany	2012	548099
Annual	Number	Upper secondary education	Females	Austria	2013	174237
Annual	Number	Upper secondary education	Females	Belgium	2013	412018
Annual	Number	Upper secondary education	Females	Bulgaria	2013	135276
Annual	Number	Upper secondary education	Females	Switzerland	2013	165791
Annual	Number	Upper secondary education	Females	Cyprus	2013	15687
Annual	Number	Upper secondary education	Females	Czechia	2013	213960
Annual	Number	Upper secondary education	Females	Germany	2013	1181121
Annual	Number	Upper secondary education	Females	Denmark	2013	154451


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