Employment By Job Satisfaction, Sex, Age, Citizenship And Occupation

Eurostat code: lfso_21jsat03 · (2021 - 2021)

@eurostat.lfso_21jsat03

Table List

2 tables(360.41 KB)

Employment By Job Satisfaction, Sex, Age, Citizenship And Occupation - Raw

Employment By Job Satisfaction, Sex, Age, Citizenship And Occupation - Unpivoted

Employment By Job Satisfaction, Sex, Age, Citizenship And Occupation - Unpivoted

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

172.13 KB
55248 rows
10 columns

freq Freq	citizen Citizen	isco08 Isco08	lev_satis Lev Satis	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	EU27 countries (from 2020) except reporting country	No response	High	From 15 to 64 years	Females	Thousand persons	Luxembourg	2021	0.6
Annual	EU27 countries (from 2020) except reporting country	No response	High	From 15 to 64 years	Females	Thousand persons	Netherlands	2021	2.7
Annual	EU27 countries (from 2020) except reporting country	No response	High	From 15 to 64 years	Males	Thousand persons	Luxembourg	2021	0.7
Annual	EU27 countries (from 2020) except reporting country	No response	High	From 15 to 64 years	Males	Thousand persons	Netherlands	2021	1.6
Annual	EU27 countries (from 2020) except reporting country	No response	High	From 15 to 64 years	Total	Thousand persons	Switzerland	2021	2.4
Annual	EU27 countries (from 2020) except reporting country	No response	High	From 15 to 64 years	Total	Thousand persons	Luxembourg	2021	1.3
Annual	EU27 countries (from 2020) except reporting country	No response	High	From 15 to 64 years	Total	Thousand persons	Netherlands	2021	4.3
Annual	EU27 countries (from 2020) except reporting country	No response	High	From 15 to 74 years	Females	Thousand persons	Luxembourg	2021	0.6
Annual	EU27 countries (from 2020) except reporting country	No response	High	From 15 to 74 years	Females	Thousand persons	Netherlands	2021	2.7
Annual	EU27 countries (from 2020) except reporting country	No response	High	From 15 to 74 years	Males	Thousand persons	Luxembourg	2021	0.7


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

Share link

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