Baselight
Login
Login

Population On 1 January By Age, Sex And Educational Attainment Level

Eurostat code: demo_pjanedu ยท (2007 - 2024)

@eurostat.demo_pjanedu

Population On 1 January By Age, Sex And Educational Attainment Level - Unpivoted
@eurostat.demo_pjanedu.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.

  • 1002.22 KB
  • 254041 rows
  • 8 columns
freq

Freq

unit

Unit

sex

Sex

age

Age

isced11

Isced11

geo

Geo

time_period

Time Period

value

Value

AnnualNumberFemalesTotalLess than primary, primary and lower secondary education (levels 0-2)Denmark2007825500
AnnualNumberFemalesTotalLess than primary, primary and lower secondary education (levels 0-2)Finland20071245919
AnnualNumberFemalesTotalLess than primary, primary and lower secondary education (levels 0-2)Norway2007588801
AnnualNumberFemalesTotalLess than primary, primary and lower secondary education (levels 0-2)Sweden2007720542
AnnualNumberFemalesTotalUpper secondary and post-secondary non-tertiary education (levels 3 and 4)Denmark2007809571
AnnualNumberFemalesTotalUpper secondary and post-secondary non-tertiary education (levels 3 and 4)Finland2007814107
AnnualNumberFemalesTotalUpper secondary and post-secondary non-tertiary education (levels 3 and 4)Norway2007742904
AnnualNumberFemalesTotalUpper secondary and post-secondary non-tertiary education (levels 3 and 4)Sweden20071583736
AnnualNumberFemalesTotalTertiary education (levels 5-8)Denmark2007529015
AnnualNumberFemalesTotalTertiary education (levels 5-8)Finland2007633187

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

Share link

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