Labour Market Transitions - Annual Data

Eurostat code: lfsi_long_a · (2004 - 2024)

@eurostat.lfsi_long_a

Table List

2 tables(157.79 KB)

Labour Market Transitions - Annual Data - Raw

Labour Market Transitions - Annual Data - Unpivoted

Labour Market Transitions - Annual Data - Unpivoted

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

58.73 KB
21812 rows
7 columns

freq Freq	unit Unit	indic_em Indic Em	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Percentage of total employment	Transition employment - employment	Females	Netherlands	2004	92.1
Annual	Percentage of total employment	Transition employment - employment	Males	Netherlands	2004	93.8
Annual	Percentage of total employment	Transition employment - employment	Total	Netherlands	2004	93
Annual	Percentage of total employment	Transition employment - outside the labour force	Females	Netherlands	2004	5.4
Annual	Percentage of total employment	Transition employment - outside the labour force	Males	Netherlands	2004	3.9
Annual	Percentage of total employment	Transition employment - outside the labour force	Total	Netherlands	2004	4.6
Annual	Percentage of total employment	Transition employment - unemployment	Females	Netherlands	2004	2.6
Annual	Percentage of total employment	Transition employment - unemployment	Males	Netherlands	2004	2.3
Annual	Percentage of total employment	Transition employment - unemployment	Total	Netherlands	2004	2.4
Annual	Percentage of population outside the labour force	Transition outside the labour force - employment	Females	Netherlands	2004	8.6


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

Share link

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