Pupils And Students Enrolled By Sex, Age And NUTS 2 Region

Eurostat code: educ_uoe_enra12 · (2013 - 2023)

@eurostat.educ_uoe_enra12

Table List

2 tables(3.78 MB)

Pupils And Students Enrolled By Sex, Age And NUTS 2 Region - Raw

Pupils And Students Enrolled By Sex, Age And NUTS 2 Region - Unpivoted

Pupils And Students Enrolled By Sex, Age And NUTS 2 Region - Unpivoted

@eurostat.educ_uoe_enra12.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.8 MB
479734 rows
7 columns

freq Freq	unit Unit	age Age	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Number	Unknown	Females	Austria	2013	8
Annual	Number	Unknown	Females	Ostösterreich	2013	8
Annual	Number	Unknown	Females	Burgenland	2013
Annual	Number	Unknown	Females	Niederösterreich	2013
Annual	Number	Unknown	Females	Wien	2013	8
Annual	Number	Unknown	Females	Südösterreich	2013
Annual	Number	Unknown	Females	Kärnten	2013
Annual	Number	Unknown	Females	Steiermark	2013
Annual	Number	Unknown	Females	Westösterreich	2013
Annual	Number	Unknown	Females	Oberösterreich	2013


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.