Employment Rate Of Non-EU Nationals, Age Group 20-64

Eurostat code: tesem090 · (2005 - 2024)

@eurostat.tesem090

Table List

2 tables(29.94 KB)

Employment Rate Of Non-EU Nationals, Age Group 20-64 - Raw

Employment Rate Of Non-EU Nationals, Age Group 20-64 - Unpivoted

Employment Rate Of Non-EU Nationals, Age Group 20-64 - Unpivoted

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

8.72 KB
654 rows
8 columns

freq Freq	unit Unit	sex Sex	age Age	citizen Citizen	geo Geo	time_period Time Period	value Value
Annual	Percentage	Total	From 20 to 64 years	Non-EU27 countries (from 2020) nor reporting country	Austria	2005	59.1
Annual	Percentage	Total	From 20 to 64 years	Non-EU27 countries (from 2020) nor reporting country	Belgium	2005	38.8
Annual	Percentage	Total	From 20 to 64 years	Non-EU27 countries (from 2020) nor reporting country	Bulgaria	2005	45.8
Annual	Percentage	Total	From 20 to 64 years	Non-EU27 countries (from 2020) nor reporting country	Switzerland	2005	66.1
Annual	Percentage	Total	From 20 to 64 years	Non-EU27 countries (from 2020) nor reporting country	Cyprus	2005	71.6
Annual	Percentage	Total	From 20 to 64 years	Non-EU27 countries (from 2020) nor reporting country	Czechia	2005	75
Annual	Percentage	Total	From 20 to 64 years	Non-EU27 countries (from 2020) nor reporting country	Germany	2005	49.3
Annual	Percentage	Total	From 20 to 64 years	Non-EU27 countries (from 2020) nor reporting country	Denmark	2005	56.3
Annual	Percentage	Total	From 20 to 64 years	Non-EU27 countries (from 2020) nor reporting country	Euro area – 20 countries (from 2023)	2005	58.5
Annual	Percentage	Total	From 20 to 64 years	Non-EU27 countries (from 2020) nor reporting country	Estonia	2005	65.6


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

Share link

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