Labour Transitions By Employment Status

Eurostat code: ilc_lvhl30$dv_1323

@eurostat.ilc_lvhl30_dv_1323

Table List

2 tables(19.86 KB)

Labour Transitions By Employment Status - Raw

Labour Transitions By Employment Status - Unpivoted

Labour Transitions By Employment Status - Unpivoted

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

7.18 KB
349 rows
8 columns

freq Freq	trans1y Trans1y	wstatus Wstatus	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Transition to unemployment	Employed persons	Total	Percentage	Austria	2015	3.5
Annual	Transition to unemployment	Employed persons	Total	Percentage	Belgium	2015	2.4
Annual	Transition to unemployment	Employed persons	Total	Percentage	Bulgaria	2015	3.1
Annual	Transition to unemployment	Employed persons	Total	Percentage	Switzerland	2015	2
Annual	Transition to unemployment	Employed persons	Total	Percentage	Cyprus	2015	6.6
Annual	Transition to unemployment	Employed persons	Total	Percentage	Czechia	2015	1.7
Annual	Transition to unemployment	Employed persons	Total	Percentage	Germany	2015	1.7
Annual	Transition to unemployment	Employed persons	Total	Percentage	Denmark	2015	2.2
Annual	Transition to unemployment	Employed persons	Total	Percentage	Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)	2015	3.4
Annual	Transition to unemployment	Employed persons	Total	Percentage	Euro area - 18 countries (2014)	2015	3.4


CREATE TABLE tidy (
  "freq" VARCHAR,
  "trans1y" VARCHAR,
  "wstatus" VARCHAR,
  "sex" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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