Dataset: Unemployment - Monthly Data - Vintages From 2021 Onwards

About this Dataset

Unemployment - Monthly Data - Vintages From 2021 Onwards

This Eurostat dataset contains data on unemployment - monthly data - vintages from 2021 onwards, as collected and published by the Statistical Office of the European Union.

Tables included:

raw: Original table as downloaded from Eurostat.
tidy: A cleaned and transformed version of the raw table, where time period values appear as rows instead of columns (unpivoted format).

Last updated: 2025-06-10T23:00:00+0200

Tables

Unemployment - Monthly Data - Vintages From 2021 Onwards - Raw

@eurostat.ei_lm_m_vtg.raw

1.11 MB
3372 rows
515 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "s_adj" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "geo" VARCHAR,
  "revdate" VARCHAR,
  "n_1983_01" DOUBLE,
  "n_1983_02" DOUBLE,
  "n_1983_03" DOUBLE,
  "n_1983_04" DOUBLE,
  "n_1983_05" DOUBLE,
  "n_1983_06" DOUBLE,
  "n_1983_07" DOUBLE,
  "n_1983_08" DOUBLE,
  "n_1983_09" DOUBLE,
  "n_1983_10" DOUBLE,
  "n_1983_11" DOUBLE,
  "n_1983_12" DOUBLE,
  "n_1984_01" DOUBLE,
  "n_1984_02" DOUBLE,
  "n_1984_03" DOUBLE,
  "n_1984_04" DOUBLE,
  "n_1984_05" DOUBLE,
  "n_1984_06" DOUBLE,
  "n_1984_07" DOUBLE,
  "n_1984_08" DOUBLE,
  "n_1984_09" DOUBLE,
  "n_1984_10" DOUBLE,
  "n_1984_11" DOUBLE,
  "n_1984_12" DOUBLE,
  "n_1985_01" DOUBLE,
  "n_1985_02" DOUBLE,
  "n_1985_03" DOUBLE,
  "n_1985_04" DOUBLE,
  "n_1985_05" DOUBLE,
  "n_1985_06" DOUBLE,
  "n_1985_07" DOUBLE,
  "n_1985_08" DOUBLE,
  "n_1985_09" DOUBLE,
  "n_1985_10" DOUBLE,
  "n_1985_11" DOUBLE,
  "n_1985_12" DOUBLE,
  "n_1986_01" DOUBLE,
  "n_1986_02" DOUBLE,
  "n_1986_03" DOUBLE,
  "n_1986_04" DOUBLE,
  "n_1986_05" DOUBLE,
  "n_1986_06" DOUBLE,
  "n_1986_07" DOUBLE,
  "n_1986_08" DOUBLE,
  "n_1986_09" DOUBLE,
  "n_1986_10" DOUBLE,
  "n_1986_11" DOUBLE,
  "n_1986_12" DOUBLE,
  "n_1987_01" DOUBLE,
  "n_1987_02" DOUBLE,
  "n_1987_03" DOUBLE,
  "n_1987_04" DOUBLE,
  "n_1987_05" DOUBLE,
  "n_1987_06" DOUBLE,
  "n_1987_07" DOUBLE,
  "n_1987_08" DOUBLE,
  "n_1987_09" DOUBLE,
  "n_1987_10" DOUBLE,
  "n_1987_11" DOUBLE,
  "n_1987_12" DOUBLE,
  "n_1988_01" DOUBLE,
  "n_1988_02" DOUBLE,
  "n_1988_03" DOUBLE,
  "n_1988_04" DOUBLE,
  "n_1988_05" DOUBLE,
  "n_1988_06" DOUBLE,
  "n_1988_07" DOUBLE,
  "n_1988_08" DOUBLE,
  "n_1988_09" DOUBLE,
  "n_1988_10" DOUBLE,
  "n_1988_11" DOUBLE,
  "n_1988_12" DOUBLE,
  "n_1989_01" DOUBLE,
  "n_1989_02" DOUBLE,
  "n_1989_03" DOUBLE,
  "n_1989_04" DOUBLE,
  "n_1989_05" DOUBLE,
  "n_1989_06" DOUBLE,
  "n_1989_07" DOUBLE,
  "n_1989_08" DOUBLE,
  "n_1989_09" DOUBLE,
  "n_1989_10" DOUBLE,
  "n_1989_11" DOUBLE,
  "n_1989_12" DOUBLE,
  "n_1990_01" DOUBLE,
  "n_1990_02" DOUBLE,
  "n_1990_03" DOUBLE,
  "n_1990_04" DOUBLE,
  "n_1990_05" DOUBLE,
  "n_1990_06" DOUBLE,
  "n_1990_07" DOUBLE,
  "n_1990_08" DOUBLE,
  "n_1990_09" DOUBLE
);

Unemployment - Monthly Data - Vintages From 2021 Onwards - Unpivoted

@eurostat.ei_lm_m_vtg.tidy

778.69 KB
1249912 rows
9 columns


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