Pupils Enrolled In Lower-secondary Education By Programme Orientation, Sex, Type Of Institution And Intensity Of Participation

Eurostat code: educ_uoe_enrs01 · (2012 - 2023)

@eurostat.educ_uoe_enrs01

Table List

2 tables(368.01 KB)

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

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

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

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

181.64 KB
51511 rows
9 columns

freq Freq	unit Unit	worktime Worktime	sector Sector	isced11 Isced11	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Number	Full-time	Private institutions	Lower secondary education	Total	Germany	2012	447403
Annual	Number	Full-time	Public institutions	Lower secondary education	Total	Germany	2012	4321580
Annual	Number	Full-time	Total	Lower secondary education	Total	Germany	2012	4768983
Annual	Number	Total	Private institutions	Lower secondary education	Total	Germany	2012	447403
Annual	Number	Total	Public institutions	Lower secondary education	Total	Germany	2012	4321580
Annual	Number	Total	Total	Lower secondary education	Total	Germany	2012	4768983
Annual	Number	Total in full-time equivalents	Private institutions	Lower secondary education	Total	Germany	2012	447403
Annual	Number	Total in full-time equivalents	Public institutions	Lower secondary education	Total	Germany	2012	4321580
Annual	Number	Total in full-time equivalents	Total	Lower secondary education	Total	Germany	2012	4768983
Annual	Number	Full-time	Private institutions	Lower secondary education	Females	Austria	2013	16446


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