Job-to-job Mobility Of HRST By NACE Rev. 2 Activity

Eurostat code: hrst_fl_mobsect2 · (2008 - 2020)

@eurostat.hrst_fl_mobsect2

Table List

2 tables(53.4 KB)

Job-to-job Mobility Of HRST By NACE Rev. 2 Activity - Raw

Job-to-job Mobility Of HRST By NACE Rev. 2 Activity - Unpivoted

Job-to-job Mobility Of HRST By NACE Rev. 2 Activity - Unpivoted

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

20.85 KB
5422 rows
7 columns

freq Freq	age Age	unit Unit	nace_r2 Nace R2	geo Geo	time_period Time Period	value Value
Annual	From 25 to 64 years	Percentage	Manufacturing	Austria	2008	6.4
Annual	From 25 to 64 years	Percentage	Manufacturing	Belgium	2008	8
Annual	From 25 to 64 years	Percentage	Manufacturing	Bulgaria	2008	4.8
Annual	From 25 to 64 years	Percentage	Manufacturing	Czechia	2008	4.8
Annual	From 25 to 64 years	Percentage	Manufacturing	Germany	2008	5.1
Annual	From 25 to 64 years	Percentage	Manufacturing	Denmark	2008	14.5
Annual	From 25 to 64 years	Percentage	Manufacturing	Euro area - 19 countries (2015-2022)	2008	5.8
Annual	From 25 to 64 years	Percentage	Manufacturing	Estonia	2008	5.4
Annual	From 25 to 64 years	Percentage	Manufacturing	Greece	2008	3.5
Annual	From 25 to 64 years	Percentage	Manufacturing	Spain	2008	6.4


CREATE TABLE tidy (
  "freq" VARCHAR,
  "age" VARCHAR,
  "unit" VARCHAR,
  "nace_r2" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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