Employed Persons By Level Of Standardization Of Tasks, Economic Activity And Occupation

Eurostat code: lfso_22wrkm11 · (2022 - 2022)

@eurostat.lfso_22wrkm11

Table List

2 tables(5.57 MB)

Employed Persons By Level Of Standardization Of Tasks, Economic Activity And Occupation - Raw

Employed Persons By Level Of Standardization Of Tasks, Economic Activity And Occupation - Unpivoted

Employed Persons By Level Of Standardization Of Tasks, Economic Activity And Occupation - Unpivoted

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

2.41 MB
953045 rows
10 columns

freq Freq	isco08 Isco08	nace_r2 Nace R2	levels Levels	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	No response	Agriculture, forestry and fishing	Total	From 15 to 64 years	Total	Thousand persons	Poland	2022	11.9
Annual	No response	Agriculture, forestry and fishing	Total	From 15 to 74 years	Total	Thousand persons	Poland	2022	11.9
Annual	No response	Agriculture, forestry and fishing	Total	From 20 to 64 years	Total	Thousand persons	Poland	2022	11.9
Annual	No response	Industry (except construction)	High	From 15 to 64 years	Males	Thousand persons	Switzerland	2022	6.3
Annual	No response	Industry (except construction)	High	From 15 to 64 years	Total	Thousand persons	Switzerland	2022	8.3
Annual	No response	Industry (except construction)	High	From 15 to 74 years	Males	Thousand persons	Switzerland	2022	6.3
Annual	No response	Industry (except construction)	High	From 15 to 74 years	Total	Thousand persons	Switzerland	2022	8.3
Annual	No response	Industry (except construction)	High	From 20 to 34 years	Total	Thousand persons	Switzerland	2022	5.7
Annual	No response	Industry (except construction)	High	From 20 to 64 years	Males	Thousand persons	Switzerland	2022	5.3
Annual	No response	Industry (except construction)	High	From 20 to 64 years	Total	Thousand persons	Switzerland	2022	7.3


CREATE TABLE tidy (
  "freq" VARCHAR,
  "isco08" VARCHAR,
  "nace_r2" VARCHAR,
  "levels" 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.