Baselight

Regional Disparities In Unemployment Rates (NUTS Level 2, NUTS Level 3)

Eurostat code: lfst_r_lmdur ยท (1999 - 2023)

@eurostat.lfst_r_lmdur

Regional Disparities In Unemployment Rates (NUTS Level 2, NUTS Level 3) - Unpivoted
@eurostat.lfst_r_lmdur.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.

  • 17.15 KB
  • 5342 rows
  • 8 columns
freq

Freq

statinfo

Statinfo

sex

Sex

age

Age

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualDispersion at NUTS level 2FemalesFrom 15 to 74 yearsPercentageAustria199920
AnnualDispersion at NUTS level 2FemalesFrom 15 to 74 yearsPercentageBelgium199957.6
AnnualDispersion at NUTS level 2FemalesFrom 15 to 74 yearsPercentageCzechia199933.9
AnnualDispersion at NUTS level 2FemalesFrom 15 to 74 yearsPercentageGermany199957.4
AnnualDispersion at NUTS level 2FemalesFrom 15 to 74 yearsPercentageGreece199919.9
AnnualDispersion at NUTS level 2FemalesFrom 15 to 74 yearsPercentageSpain199932.5
AnnualDispersion at NUTS level 2FemalesFrom 15 to 74 yearsPercentageEuropean Union - 27 countries (from 2020)199961.8
AnnualDispersion at NUTS level 2FemalesFrom 15 to 74 yearsPercentageFrance199923.2
AnnualDispersion at NUTS level 2FemalesFrom 15 to 74 yearsPercentageHungary199935.5
AnnualDispersion at NUTS level 2FemalesFrom 15 to 74 yearsPercentageItaly199961.2

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

Share link

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