Baselight
Sign In

Regional Disparities In Long-term Unemployment Rates (NUTS Level 2)

Eurostat code: lfst_r_lmdltu ยท (1999 - 2023)

@eurostat.lfst_r_lmdltu

Regional Disparities In Long-term Unemployment Rates (NUTS Level 2) - Unpivoted
@eurostat.lfst_r_lmdltu.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.

  • 7.56 KB
  • 415 rows
  • 7 columns
freq

Freq

unit

Unit

statinfo

Statinfo

age

Age

geo

Geo

time_period

Time Period

value

Value

AnnualPercentageDispersion at NUTS level 2From 15 to 74 yearsAustria199956.3
AnnualPercentageDispersion at NUTS level 2From 15 to 74 yearsBelgium199969.1
AnnualPercentageDispersion at NUTS level 2From 15 to 74 yearsCzechia199950.3
AnnualPercentageDispersion at NUTS level 2From 15 to 74 yearsGermany199957.9
AnnualPercentageDispersion at NUTS level 2From 15 to 74 yearsGreece199927
AnnualPercentageDispersion at NUTS level 2From 15 to 74 yearsSpain199932.6
AnnualPercentageDispersion at NUTS level 2From 15 to 74 yearsFinland199915.9
AnnualPercentageDispersion at NUTS level 2From 15 to 74 yearsFrance199935.2
AnnualPercentageDispersion at NUTS level 2From 15 to 74 yearsHungary199939.5
AnnualPercentageDispersion at NUTS level 2From 15 to 74 yearsItaly199983.6

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