Pupils Enrolled In Primary Education By Sex And Age

Eurostat code: educ_uoe_enrp05 · (2012 - 2023)

@eurostat.educ_uoe_enrp05

Table List

2 tables(242.6 KB)

Pupils Enrolled In Primary Education By Sex And Age - Raw

Pupils Enrolled In Primary Education By Sex And Age - Unpivoted

Pupils Enrolled In Primary Education By Sex And Age - Unpivoted

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

111.72 KB
34608 rows
7 columns

freq Freq	unit Unit	age Age	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Number	Total	Females	Germany	2012	1428630
Annual	Number	Total	Males	Germany	2012	1508121
Annual	Number	Total	Total	Germany	2012	2936751
Annual	Number	Unknown	Females	Germany	2012
Annual	Number	Unknown	Males	Germany	2012
Annual	Number	Unknown	Total	Germany	2012
Annual	Number	10 years	Females	Germany	2012	155929
Annual	Number	10 years	Males	Germany	2012	186795
Annual	Number	10 years	Total	Germany	2012	342725
Annual	Number	11 years	Females	Germany	2012	18005


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

Share link

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