Pupils And Students Enrolled By Education Level, Sex And Field Of Education

Eurostat code: educ_uoe_enra03 · (2012 - 2023)

@eurostat.educ_uoe_enra03

Table List

2 tables(3.52 MB)

Pupils And Students Enrolled By Education Level, Sex And Field Of Education - Raw

Pupils And Students Enrolled By Education Level, Sex And Field Of Education - Unpivoted

Pupils And Students Enrolled By Education Level, Sex And Field Of Education - Unpivoted

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

1.69 MB
980634 rows
8 columns

freq Freq	unit Unit	iscedf13 Iscedf13	isced11 Isced11	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Number	Total	Doctoral or equivalent level	Females	Germany	2012	84500
Annual	Number	Total	Doctoral or equivalent level	Males	Germany	2012	124000
Annual	Number	Total	Doctoral or equivalent level	Total	Germany	2012	208500
Annual	Number	Generic programmes and qualifications	Upper secondary education - vocational	Females	Switzerland	2013
Annual	Number	Generic programmes and qualifications	Upper secondary education - vocational	Females	Germany	2013
Annual	Number	Generic programmes and qualifications	Upper secondary education - vocational	Females	Greece	2013
Annual	Number	Generic programmes and qualifications	Upper secondary education - vocational	Females	Finland	2013
Annual	Number	Generic programmes and qualifications	Upper secondary education - vocational	Females	Netherlands	2013
Annual	Number	Generic programmes and qualifications	Upper secondary education - vocational	Females	Norway	2013
Annual	Number	Generic programmes and qualifications	Upper secondary education - vocational	Males	Switzerland	2013


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