Name: Unemployment - Monthly Data - Vintages From 2001 To 2020
Creator: Eurostat
License: https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Copyright/licence_policy

About this Dataset

Unemployment - Monthly Data - Vintages From 2001 To 2020

This Eurostat dataset contains data on unemployment - monthly data - vintages from 2001 to 2020, 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: 2024-03-26T23:00:00+0100

Tables

Unemployment - Monthly Data - Vintages From 2001 To 2020 - Raw

@eurostat.ei_lm_m_vtgfix.raw

2.18 MB
12684 rows
498 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "s_adj" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "geo" VARCHAR,
  "revdate" VARCHAR,
  "n_1980_01" DOUBLE,
  "n_1980_02" DOUBLE,
  "n_1980_03" DOUBLE,
  "n_1980_04" DOUBLE,
  "n_1980_05" DOUBLE,
  "n_1980_06" DOUBLE,
  "n_1980_07" DOUBLE,
  "n_1980_08" DOUBLE,
  "n_1980_09" DOUBLE,
  "n_1980_10" DOUBLE,
  "n_1980_11" DOUBLE,
  "n_1980_12" DOUBLE,
  "n_1981_01" DOUBLE,
  "n_1981_02" DOUBLE,
  "n_1981_03" DOUBLE,
  "n_1981_04" DOUBLE,
  "n_1981_05" DOUBLE,
  "n_1981_06" DOUBLE,
  "n_1981_07" DOUBLE,
  "n_1981_08" DOUBLE,
  "n_1981_09" DOUBLE,
  "n_1981_10" DOUBLE,
  "n_1981_11" DOUBLE,
  "n_1981_12" DOUBLE,
  "n_1982_01" DOUBLE,
  "n_1982_02" DOUBLE,
  "n_1982_03" DOUBLE,
  "n_1982_04" DOUBLE,
  "n_1982_05" DOUBLE,
  "n_1982_06" DOUBLE,
  "n_1982_07" DOUBLE,
  "n_1982_08" DOUBLE,
  "n_1982_09" DOUBLE,
  "n_1982_10" DOUBLE,
  "n_1982_11" DOUBLE,
  "n_1982_12" DOUBLE,
  "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
);

Unemployment - Monthly Data - Vintages From 2001 To 2020 - Unpivoted

@eurostat.ei_lm_m_vtgfix.tidy

3.22 MB
3093318 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
);