Labour Transitions By Employment Status And Pay Level - Changes In Qualifications

Eurostat code: ilc_lvhl35 · (2006 - 2024)

@eurostat.ilc_lvhl35

Table List

2 tables(108.05 KB)

Labour Transitions By Employment Status And Pay Level - Changes In Qualifications - Raw

Labour Transitions By Employment Status And Pay Level - Changes In Qualifications - Unpivoted

Labour Transitions By Employment Status And Pay Level - Changes In Qualifications - Unpivoted

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

33.19 KB
18008 rows
8 columns

freq Freq	trans1y Trans1y	wstatus Wstatus	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Transition to the same or higher qualification level (employment status and pay) as previous year	Students	Females	Percentage	Austria	2006	97.5
Annual	Transition to the same or higher qualification level (employment status and pay) as previous year	Students	Females	Percentage	Belgium	2006	92.2
Annual	Transition to the same or higher qualification level (employment status and pay) as previous year	Students	Females	Percentage	Cyprus	2006	98
Annual	Transition to the same or higher qualification level (employment status and pay) as previous year	Students	Females	Percentage	Czechia	2006	96.2
Annual	Transition to the same or higher qualification level (employment status and pay) as previous year	Students	Females	Percentage	Denmark	2006	94.9
Annual	Transition to the same or higher qualification level (employment status and pay) as previous year	Students	Females	Percentage	Euro area - 18 countries (2014)	2006	93.5
Annual	Transition to the same or higher qualification level (employment status and pay) as previous year	Students	Females	Percentage	Estonia	2006	96.2
Annual	Transition to the same or higher qualification level (employment status and pay) as previous year	Students	Females	Percentage	Greece	2006	92
Annual	Transition to the same or higher qualification level (employment status and pay) as previous year	Students	Females	Percentage	Spain	2006	89.8
Annual	Transition to the same or higher qualification level (employment status and pay) as previous year	Students	Females	Percentage	Finland	2006	90.2


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.