Employment In Current Job By Duration

Eurostat code: tepsr_wc220 · (2005 - 2024)

@eurostat.tepsr_wc220

Table List

2 tables(44.12 KB)

Employment In Current Job By Duration - Raw

Employment In Current Job By Duration - Unpivoted

Employment In Current Job By Duration - Unpivoted

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

12.57 KB
3953 rows
8 columns

freq Freq	duration Duration	sex Sex	age Age	unit Unit	geo Geo	time_period Time Period	value Value
Annual	From 0 to 11 months	Total	From 20 to 64 years	Percentage	Austria	2005	13.5
Annual	From 0 to 11 months	Total	From 20 to 64 years	Percentage	Belgium	2005	11
Annual	From 0 to 11 months	Total	From 20 to 64 years	Percentage	Bulgaria	2005	16.2
Annual	From 0 to 11 months	Total	From 20 to 64 years	Percentage	Switzerland	2005	12.5
Annual	From 0 to 11 months	Total	From 20 to 64 years	Percentage	Cyprus	2005	14.6
Annual	From 0 to 11 months	Total	From 20 to 64 years	Percentage	Czechia	2005	10
Annual	From 0 to 11 months	Total	From 20 to 64 years	Percentage	Germany	2005	12
Annual	From 0 to 11 months	Total	From 20 to 64 years	Percentage	Denmark	2005	19.6
Annual	From 0 to 11 months	Total	From 20 to 64 years	Percentage	Euro area – 20 countries (from 2023)	2005	12.8
Annual	From 0 to 11 months	Total	From 20 to 64 years	Percentage	Estonia	2005	15.8


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

Share link

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