Baselight
Sign In

Unemployment - Monthly Data - Vintages From 2021 Onwards

Eurostat code: ei_lm_m_vtg ยท (1983-01 - 2025-02)

@eurostat.ei_lm_m_vtg

Unemployment - Monthly Data - Vintages From 2021 Onwards - Unpivoted
@eurostat.ei_lm_m_vtg.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.

  • 759.93 KB
  • 1170643 rows
  • 9 columns
freq

Freq

unit

Unit

s_adj

S Adj

sex

Sex

age

Age

geo

Geo

revdate

Revdate

time_period

Time Period

value

Value

MonthlyPercentage of population in the labour forceSeasonally adjusted data, not calendar adjusted dataTotalTotalDenmark2021-01-081983-018.1
MonthlyPercentage of population in the labour forceSeasonally adjusted data, not calendar adjusted dataTotalTotalDenmark2021-02-011983-018.1
MonthlyPercentage of population in the labour forceSeasonally adjusted data, not calendar adjusted dataTotalTotalDenmark2021-03-041983-018.1
MonthlyPercentage of population in the labour forceSeasonally adjusted data, not calendar adjusted dataTotalTotalDenmark2021-04-061983-018.1
MonthlyPercentage of population in the labour forceSeasonally adjusted data, not calendar adjusted dataTotalTotalDenmark2021-04-301983-018.1
MonthlyPercentage of population in the labour forceSeasonally adjusted data, not calendar adjusted dataTotalTotalDenmark2021-06-011983-018.1
MonthlyPercentage of population in the labour forceSeasonally adjusted data, not calendar adjusted dataTotalTotalDenmark2021-07-011983-018.1
MonthlyPercentage of population in the labour forceSeasonally adjusted data, not calendar adjusted dataTotalTotalDenmark2021-07-301983-018.1
MonthlyPercentage of population in the labour forceSeasonally adjusted data, not calendar adjusted dataTotalTotalDenmark2021-09-011983-018.1
MonthlyPercentage of population in the labour forceSeasonally adjusted data, not calendar adjusted dataTotalTotalDenmark2021-09-301983-018.1

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

Share link

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