Labour Transitions By Pay Level

Eurostat code: ilc_lvhl34 · (2006 - 2024)

@eurostat.ilc_lvhl34

Table List

2 tables(441.28 KB)

Labour Transitions By Pay Level - Unpivoted

Labour Transitions By Pay Level - Unpivoted

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

184.91 KB
127918 rows
8 columns

freq Freq	trans1y Trans1y	sex Sex	quantile Quantile	unit Unit	geo Geo	time_period Time Period	value Value
Annual	No change	Females	First decile	Percentage	Austria	2006	48.2
Annual	No change	Females	First decile	Percentage	Belgium	2006	51.8
Annual	No change	Females	First decile	Percentage	Cyprus	2006	65.5
Annual	No change	Females	First decile	Percentage	Czechia	2006	43.2
Annual	No change	Females	First decile	Percentage	Denmark	2006	39.6
Annual	No change	Females	First decile	Percentage	Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)	2006	52.6
Annual	No change	Females	First decile	Percentage	Euro area - 18 countries (2014)	2006	51.9
Annual	No change	Females	First decile	Percentage	Euro area - 19 countries (2015-2022)	2006	51.9
Annual	No change	Females	First decile	Percentage	Estonia	2006	47.3
Annual	No change	Females	First decile	Percentage	Greece	2006	75


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

Share link

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