New Entrants By Education Level, Programme Orientation, Sex And Age

Eurostat code: educ_uoe_ent01 · (2012 - 2022)

@eurostat.educ_uoe_ent01

Table List

2 tables(2.33 MB)

New Entrants By Education Level, Programme Orientation, Sex And Age - Raw

New Entrants By Education Level, Programme Orientation, Sex And Age - Unpivoted

New Entrants By Education Level, Programme Orientation, Sex And Age - Unpivoted

@eurostat.educ_uoe_ent01.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.12 MB
575932 rows
8 columns

freq Freq	unit Unit	age Age	sex Sex	isced11 Isced11	geo Geo	time_period Time Period	value Value
Annual	Number	Total	Females	Upper secondary education	Germany	2012	425791
Annual	Number	Total	Females	Post-secondary non-tertiary education	Germany	2012	96283
Annual	Number	Total	Females	Doctoral or equivalent level	Germany	2012	22500
Annual	Number	Total	Males	Upper secondary education	Germany	2012	477426
Annual	Number	Total	Males	Post-secondary non-tertiary education	Germany	2012	105719
Annual	Number	Total	Males	Doctoral or equivalent level	Germany	2012	31300
Annual	Number	Total	Total	Upper secondary education	Germany	2012	903216
Annual	Number	Total	Total	Post-secondary non-tertiary education	Germany	2012	202002
Annual	Number	Total	Total	Doctoral or equivalent level	Germany	2012	53800
Annual	Number	Unknown	Females	Upper secondary education	Germany	2012	180781


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

Share link

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