Baselight

Pupils Enrolled In Post-secondary Non-tertiary Education By Programme Orientation, Sex And Age

Eurostat code: educ_uoe_enrs08 ยท (2012 - 2023)

@eurostat.educ_uoe_enrs08

Pupils Enrolled In Post-secondary Non-tertiary Education By Programme Orientation, Sex And Age - Unpivoted
@eurostat.educ_uoe_enrs08.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.

  • 161.2 KB
  • 71113 rows
  • 8 columns
freq

Freq

unit

Unit

age

Age

sex

Sex

isced11

Isced11

geo

Geo

time_period

Time Period

value

Value

AnnualNumberTotalFemalesPost-secondary non-tertiary educationGermany2012261728
AnnualNumberTotalMalesPost-secondary non-tertiary educationGermany2012286371
AnnualNumberTotalTotalPost-secondary non-tertiary educationGermany2012548099
AnnualNumberUnknownFemalesPost-secondary non-tertiary educationGermany201296
AnnualNumberUnknownMalesPost-secondary non-tertiary educationGermany2012171
AnnualNumberUnknownTotalPost-secondary non-tertiary educationGermany2012267
AnnualNumber15 yearsFemalesPost-secondary non-tertiary educationGermany201210
AnnualNumber15 yearsMalesPost-secondary non-tertiary educationGermany201220
AnnualNumber15 yearsTotalPost-secondary non-tertiary educationGermany201230
AnnualNumber16 yearsFemalesPost-secondary non-tertiary educationGermany20122085

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.