Job-to-job Mobility Of HRST By NACE Rev. 1.1 Activity (1996-2008)

Eurostat code: hrst_fl_mobsect · (1996 - 2008)

@eurostat.hrst_fl_mobsect

Table List

2 tables(42.83 KB)

Job-to-job Mobility Of HRST By NACE Rev. 1.1 Activity (1996-2008) - Raw

Job-to-job Mobility Of HRST By NACE Rev. 1.1 Activity (1996-2008) - Unpivoted

Job-to-job Mobility Of HRST By NACE Rev. 1.1 Activity (1996-2008) - Unpivoted

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

16.3 KB
3272 rows
7 columns

freq Freq	age Age	unit Unit	nace_r1 Nace R1	geo Geo	time_period Time Period	value Value
Annual	From 25 to 64 years	Percentage	Manufacturing	Austria	1996	6.3
Annual	From 25 to 64 years	Percentage	Manufacturing	Belgium	1996	6.8
Annual	From 25 to 64 years	Percentage	Manufacturing	Switzerland	1996	6.8
Annual	From 25 to 64 years	Percentage	Manufacturing	Germany	1996	5.8
Annual	From 25 to 64 years	Percentage	Manufacturing	Denmark	1996	12.9
Annual	From 25 to 64 years	Percentage	Manufacturing	Greece	1996	3.5
Annual	From 25 to 64 years	Percentage	Manufacturing	Spain	1996	12
Annual	From 25 to 64 years	Percentage	Manufacturing	European Union - 15 countries (1995-2004)	1996	7.3
Annual	From 25 to 64 years	Percentage	Manufacturing	Finland	1996	22.7
Annual	From 25 to 64 years	Percentage	Manufacturing	France	1996	5.6


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

Share link

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