Baselight

Labour Market - Functional Urban Areas

Eurostat code: urb_llma · (1990 - 2023)

@eurostat.urb_llma

Labour Market - Functional Urban Areas - Unpivoted
@eurostat.urb_llma.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.

  • 838.03 KB
  • 187665 rows
  • 5 columns
freq

Freq

indic_ur

Indic Ur

cities

Cities

time_period

Time Period

value

Value

AnnualEconomically active population, totalSwitzerland19903656489
AnnualEconomically active population, totalBern1990190762
AnnualEconomically active population, totalZürich1990587576
AnnualEconomically active population, totalGenève1990234729
AnnualEconomically active population, totalBasel1990253635
AnnualEconomically active population, totalLausanne1990162345
AnnualEconomically active population, totalLuzern1990101676
AnnualEconomically active population, totalLugano199056166
AnnualEconomically active population, totalSt. Gallen199076536
AnnualEconomically active population, totalBiel/Bienne199050224

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.