Employment Rate, By Citizenship

Eurostat code: sdg_08_30a · (2000 - 2024)

@eurostat.sdg_08_30a

Table List

2 tables(43.95 KB)

Employment Rate, By Citizenship - Unpivoted

Employment Rate, By Citizenship - Unpivoted

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

11.64 KB
2305 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	EU27 countries (from 2020) except reporting country	Austria	2000	73.3
Annual	Percentage	Total	From 20 to 64 years	EU27 countries (from 2020) except reporting country	Belgium	2000	61.1
Annual	Percentage	Total	From 20 to 64 years	EU27 countries (from 2020) except reporting country	Switzerland	2000	78.6
Annual	Percentage	Total	From 20 to 64 years	EU27 countries (from 2020) except reporting country	Cyprus	2000	75
Annual	Percentage	Total	From 20 to 64 years	EU27 countries (from 2020) except reporting country	Czechia	2000	63
Annual	Percentage	Total	From 20 to 64 years	EU27 countries (from 2020) except reporting country	Germany	2000	69.6
Annual	Percentage	Total	From 20 to 64 years	EU27 countries (from 2020) except reporting country	Denmark	2000	75.7
Annual	Percentage	Total	From 20 to 64 years	EU27 countries (from 2020) except reporting country	Estonia	2000	62.9
Annual	Percentage	Total	From 20 to 64 years	EU27 countries (from 2020) except reporting country	Greece	2000	64.9
Annual	Percentage	Total	From 20 to 64 years	EU27 countries (from 2020) except reporting country	Spain	2000	63.8


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.