Ratio Of Pupils And Students To Teachers And Academic Staff By Education Level And Programme Orientation
Eurostat code: educ_uoe_perp04 ยท (2013 - 2023)
@eurostat.educ_uoe_perp04
Eurostat code: educ_uoe_perp04 ยท (2013 - 2023)
@eurostat.educ_uoe_perp04
This Eurostat dataset contains data on ratio of pupils and students to teachers and academic staff by education level and programme orientation, as collected and published by the Statistical Office of the European Union.
raw: Original table as downloaded from Eurostat.tidy: A cleaned and transformed version of the raw table, where time period values appear as rows instead of columns (unpivoted format).Last updated: 2025-10-29T23:00:00+0100
CREATE TABLE raw (
"freq" VARCHAR,
"unit" VARCHAR,
"isced11" VARCHAR,
"geo" VARCHAR,
"n_2013" DOUBLE -- 2013,
"n_2014" DOUBLE -- 2014,
"n_2015" DOUBLE -- 2015,
"n_2016" DOUBLE -- 2016,
"n_2017" DOUBLE -- 2017,
"n_2018" DOUBLE -- 2018,
"n_2019" DOUBLE -- 2019,
"n_2020" DOUBLE -- 2020,
"n_2021" DOUBLE -- 2021,
"n_2022" DOUBLE -- 2022,
"n_2023" DOUBLE -- 2023
);CREATE TABLE tidy (
"freq" VARCHAR,
"unit" VARCHAR,
"isced11" VARCHAR,
"geo" VARCHAR,
"time_period" VARCHAR,
"value" DOUBLE
);Anyone who has the link will be able to view this.