Name: Unemployment (1–000) - Monthly Data
Creator: Eurostat
License: https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Copyright/licence_policy

About this Dataset

Unemployment (1–000) - Monthly Data

This Eurostat dataset contains data on unemployment (1 000) - monthly data, 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-10-06T11:00:00+0200

Tables

Unemployment (1–000) - Monthly Data - Raw

@eurostat.ei_lmhu_m.raw

1.37 MB
660 rows
518 columns

CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "s_adj" VARCHAR,
  "indic" VARCHAR,
  "geo" VARCHAR,
  "n_1983_01" DOUBLE  -- 1983-01,
  "n_1983_02" DOUBLE  -- 1983-02,
  "n_1983_03" DOUBLE  -- 1983-03,
  "n_1983_04" DOUBLE  -- 1983-04,
  "n_1983_05" DOUBLE  -- 1983-05,
  "n_1983_06" DOUBLE  -- 1983-06,
  "n_1983_07" DOUBLE  -- 1983-07,
  "n_1983_08" DOUBLE  -- 1983-08,
  "n_1983_09" DOUBLE  -- 1983-09,
  "n_1983_10" DOUBLE  -- 1983-10,
  "n_1983_11" DOUBLE  -- 1983-11,
  "n_1983_12" DOUBLE  -- 1983-12,
  "n_1984_01" DOUBLE  -- 1984-01,
  "n_1984_02" DOUBLE  -- 1984-02,
  "n_1984_03" DOUBLE  -- 1984-03,
  "n_1984_04" DOUBLE  -- 1984-04,
  "n_1984_05" DOUBLE  -- 1984-05,
  "n_1984_06" DOUBLE  -- 1984-06,
  "n_1984_07" DOUBLE  -- 1984-07,
  "n_1984_08" DOUBLE  -- 1984-08,
  "n_1984_09" DOUBLE  -- 1984-09,
  "n_1984_10" DOUBLE  -- 1984-10,
  "n_1984_11" DOUBLE  -- 1984-11,
  "n_1984_12" DOUBLE  -- 1984-12,
  "n_1985_01" DOUBLE  -- 1985-01,
  "n_1985_02" DOUBLE  -- 1985-02,
  "n_1985_03" DOUBLE  -- 1985-03,
  "n_1985_04" DOUBLE  -- 1985-04,
  "n_1985_05" DOUBLE  -- 1985-05,
  "n_1985_06" DOUBLE  -- 1985-06,
  "n_1985_07" DOUBLE  -- 1985-07,
  "n_1985_08" DOUBLE  -- 1985-08,
  "n_1985_09" DOUBLE  -- 1985-09,
  "n_1985_10" DOUBLE  -- 1985-10,
  "n_1985_11" DOUBLE  -- 1985-11,
  "n_1985_12" DOUBLE  -- 1985-12,
  "n_1986_01" DOUBLE  -- 1986-01,
  "n_1986_02" DOUBLE  -- 1986-02,
  "n_1986_03" DOUBLE  -- 1986-03,
  "n_1986_04" DOUBLE  -- 1986-04,
  "n_1986_05" DOUBLE  -- 1986-05,
  "n_1986_06" DOUBLE  -- 1986-06,
  "n_1986_07" DOUBLE  -- 1986-07,
  "n_1986_08" DOUBLE  -- 1986-08,
  "n_1986_09" DOUBLE  -- 1986-09,
  "n_1986_10" DOUBLE  -- 1986-10,
  "n_1986_11" DOUBLE  -- 1986-11,
  "n_1986_12" DOUBLE  -- 1986-12,
  "n_1987_01" DOUBLE  -- 1987-01,
  "n_1987_02" DOUBLE  -- 1987-02,
  "n_1987_03" DOUBLE  -- 1987-03,
  "n_1987_04" DOUBLE  -- 1987-04,
  "n_1987_05" DOUBLE  -- 1987-05,
  "n_1987_06" DOUBLE  -- 1987-06,
  "n_1987_07" DOUBLE  -- 1987-07,
  "n_1987_08" DOUBLE  -- 1987-08,
  "n_1987_09" DOUBLE  -- 1987-09,
  "n_1987_10" DOUBLE  -- 1987-10,
  "n_1987_11" DOUBLE  -- 1987-11,
  "n_1987_12" DOUBLE  -- 1987-12,
  "n_1988_01" DOUBLE  -- 1988-01,
  "n_1988_02" DOUBLE  -- 1988-02,
  "n_1988_03" DOUBLE  -- 1988-03,
  "n_1988_04" DOUBLE  -- 1988-04,
  "n_1988_05" DOUBLE  -- 1988-05,
  "n_1988_06" DOUBLE  -- 1988-06,
  "n_1988_07" DOUBLE  -- 1988-07,
  "n_1988_08" DOUBLE  -- 1988-08,
  "n_1988_09" DOUBLE  -- 1988-09,
  "n_1988_10" DOUBLE  -- 1988-10,
  "n_1988_11" DOUBLE  -- 1988-11,
  "n_1988_12" DOUBLE  -- 1988-12,
  "n_1989_01" DOUBLE  -- 1989-01,
  "n_1989_02" DOUBLE  -- 1989-02,
  "n_1989_03" DOUBLE  -- 1989-03,
  "n_1989_04" DOUBLE  -- 1989-04,
  "n_1989_05" DOUBLE  -- 1989-05,
  "n_1989_06" DOUBLE  -- 1989-06,
  "n_1989_07" DOUBLE  -- 1989-07,
  "n_1989_08" DOUBLE  -- 1989-08,
  "n_1989_09" DOUBLE  -- 1989-09,
  "n_1989_10" DOUBLE  -- 1989-10,
  "n_1989_11" DOUBLE  -- 1989-11,
  "n_1989_12" DOUBLE  -- 1989-12,
  "n_1990_01" DOUBLE  -- 1990-01,
  "n_1990_02" DOUBLE  -- 1990-02,
  "n_1990_03" DOUBLE  -- 1990-03,
  "n_1990_04" DOUBLE  -- 1990-04,
  "n_1990_05" DOUBLE  -- 1990-05,
  "n_1990_06" DOUBLE  -- 1990-06,
  "n_1990_07" DOUBLE  -- 1990-07,
  "n_1990_08" DOUBLE  -- 1990-08,
  "n_1990_09" DOUBLE  -- 1990-09,
  "n_1990_10" DOUBLE  -- 1990-10,
  "n_1990_11" DOUBLE  -- 1990-11
);

Unemployment (1–000) - Monthly Data - Unpivoted

@eurostat.ei_lmhu_m.tidy

522.53 kB
249,827 rows
7 columns

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