Newly Employed

Eurostat code: tesem200 · (2005 - 2024)

@eurostat.tesem200

Table List

2 tables(28.82 KB)

Newly Employed - Unpivoted

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

7.92 KB
717 rows
8 columns

freq Freq	unit Unit	citizen Citizen	wstatus Wstatus	age Age	geo Geo	time_period Time Period	value Value
Annual	Percentage	Total	Employed persons	From 15 to 64 years	Austria	2005	16
Annual	Percentage	Total	Employed persons	From 15 to 64 years	Belgium	2005	12.4
Annual	Percentage	Total	Employed persons	From 15 to 64 years	Bulgaria	2005	17.8
Annual	Percentage	Total	Employed persons	From 15 to 64 years	Switzerland	2005	15.2
Annual	Percentage	Total	Employed persons	From 15 to 64 years	Cyprus	2005	16.1
Annual	Percentage	Total	Employed persons	From 15 to 64 years	Czechia	2005	11.3
Annual	Percentage	Total	Employed persons	From 15 to 64 years	Germany	2005	14.2
Annual	Percentage	Total	Employed persons	From 15 to 64 years	Denmark	2005	23.1
Annual	Percentage	Total	Employed persons	From 15 to 64 years	Euro area – 20 countries (from 2023)	2005	14.6
Annual	Percentage	Total	Employed persons	From 15 to 64 years	Estonia	2005	18.1


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

Share link

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