Labour Transitions By Employment Status

Eurostat code: ilc_lvhl30 · (2006 - 2024)

@eurostat.ilc_lvhl30

Table List

2 tables(217.01 KB)

Labour Transitions By Employment Status - Raw

Labour Transitions By Employment Status - Unpivoted

Labour Transitions By Employment Status - Unpivoted

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

76.57 KB
49776 rows
8 columns

freq Freq	trans1y Trans1y	wstatus Wstatus	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Transition to employed person	Employed persons	Females	Percentage	Euro area - 18 countries (2014)	2006	92.1
Annual	Transition to employed person	Employed persons	Females	Percentage	Estonia	2006	92.1
Annual	Transition to employed person	Employed persons	Females	Percentage	Greece	2006	89.4
Annual	Transition to employed person	Employed persons	Females	Percentage	Spain	2006	88.1
Annual	Transition to employed person	Employed persons	Females	Percentage	Italy	2006	91
Annual	Transition to employed person	Employed persons	Females	Percentage	United Kingdom	2006	92.4
Annual	Transition to employed person	Employed persons	Males	Percentage	Euro area - 18 countries (2014)	2006	94.5
Annual	Transition to employed person	Employed persons	Males	Percentage	Estonia	2006	93.9
Annual	Transition to employed person	Employed persons	Males	Percentage	Greece	2006	94.5
Annual	Transition to employed person	Employed persons	Males	Percentage	Spain	2006	92.7


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.