Baselight
Sign In

Education - Functional Urban Areas

Eurostat code: urb_leduc · (1990 - 2024)

@eurostat.urb_leduc

Education - Functional Urban Areas - Unpivoted
@eurostat.urb_leduc.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.

  • 126.08 KB
  • 20871 rows
  • 5 columns
freq

Freq

indic_ur

Indic Ur

cities

Cities

time_period

Time Period

value

Value

AnnualPersons (aged 25-64) with ISCED level 0, 1or 2 as the highest level of educationSwitzerland19901544452
AnnualPersons (aged 25-64) with ISCED level 0, 1or 2 as the highest level of educationBern199059321
AnnualPersons (aged 25-64) with ISCED level 0, 1or 2 as the highest level of educationZürich1990196130
AnnualPersons (aged 25-64) with ISCED level 0, 1or 2 as the highest level of educationGenève1990105684
AnnualPersons (aged 25-64) with ISCED level 0, 1or 2 as the highest level of educationBasel1990102907
AnnualPersons (aged 25-64) with ISCED level 0, 1or 2 as the highest level of educationLausanne199071493
AnnualPersons (aged 25-64) with ISCED level 0, 1or 2 as the highest level of educationLuzern199038469
AnnualPersons (aged 25-64) with ISCED level 0, 1or 2 as the highest level of educationLugano199027932
AnnualPersons (aged 25-64) with ISCED level 0, 1or 2 as the highest level of educationSt. Gallen199030854
AnnualPersons (aged 25-64) with ISCED level 0, 1or 2 as the highest level of educationBiel/Bienne199020326

CREATE TABLE tidy (
  "freq" VARCHAR,
  "indic_ur" VARCHAR,
  "cities" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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