Pupils And Students Enrolled By Education Level, Sex, Type Of Institution And Intensity Of Participation

Eurostat code: educ_uoe_enra01 · (2012 - 2023)

@eurostat.educ_uoe_enra01

Table List

2 tables(1.7 MB)

Pupils And Students Enrolled By Education Level, Sex, Type Of Institution And Intensity Of Participation - Raw

Pupils And Students Enrolled By Education Level, Sex, Type Of Institution And Intensity Of Participation - Unpivoted

Pupils And Students Enrolled By Education Level, Sex, Type Of Institution And Intensity Of Participation - Unpivoted

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

849.28 KB
209971 rows
9 columns

freq Freq	unit Unit	worktime Worktime	isced11 Isced11	sector Sector	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Number	Full-time	Pre-primary to tertiary education	Private institutions	Total	Germany	2012	2347746
Annual	Number	Full-time	Pre-primary to tertiary education	Public institutions	Total	Germany	2012	10867177
Annual	Number	Full-time	Pre-primary to tertiary education	Total	Total	Germany	2012	13214923
Annual	Number	Full-time	Primary education	Private institutions	Total	Germany	2012	131942
Annual	Number	Full-time	Primary education	Public institutions	Total	Germany	2012	2804809
Annual	Number	Full-time	Primary education	Total	Total	Germany	2012	2936751
Annual	Number	Full-time	Lower secondary education	Private institutions	Total	Germany	2012	447403
Annual	Number	Full-time	Lower secondary education	Public institutions	Total	Germany	2012	4321580
Annual	Number	Full-time	Lower secondary education	Total	Total	Germany	2012	4768983
Annual	Number	Full-time	Upper secondary education	Private institutions	Total	Germany	2012	202702


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

Share link

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