Unemployment - Monthly Data - Vintages From 2001 To 2020

Eurostat code: ei_lm_m_vtgfix · (1980-01 - 2020-11)

@eurostat.ei_lm_m_vtgfix

Table List

2 tables(5.41 MB)

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

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

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

@eurostat.ei_lm_m_vtgfix.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.

3.22 MB
3093318 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
Monthly	Percentage of population in the labour force	Seasonally adjusted data, not calendar adjusted data	Total	Total	Sweden	2002-06-04	1980-01	2
Monthly	Percentage of population in the labour force	Seasonally adjusted data, not calendar adjusted data	Total	Total	Sweden	2002-06-20	1980-01	2
Monthly	Percentage of population in the labour force	Seasonally adjusted data, not calendar adjusted data	Total	Total	Sweden	2002-07-25	1980-01	2
Monthly	Percentage of population in the labour force	Seasonally adjusted data, not calendar adjusted data	Total	Total	Sweden	2002-08-06	1980-01	2
Monthly	Percentage of population in the labour force	Seasonally adjusted data, not calendar adjusted data	Total	Total	Sweden	2002-08-26	1980-01	2
Monthly	Percentage of population in the labour force	Seasonally adjusted data, not calendar adjusted data	Total	Total	Sweden	2002-09-17	1980-01	2
Monthly	Percentage of population in the labour force	Seasonally adjusted data, not calendar adjusted data	Total	Total	Sweden	2002-10-23	1980-01	2
Monthly	Percentage of population in the labour force	Seasonally adjusted data, not calendar adjusted data	Total	Total	Sweden	2002-11-20	1980-01	2
Monthly	Percentage of population in the labour force	Seasonally adjusted data, not calendar adjusted data	Total	Total	Sweden	2002-12-23	1980-01	2
Monthly	Percentage of population in the labour force	Seasonally adjusted data, not calendar adjusted data	Total	Total	Sweden	2003-01-07	1980-01	2


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.