Employed Persons By Detailed Occupation (ISCO-08 Two Digit Level)

Eurostat code: lfsa_egai2d · (2011 - 2024)

@eurostat.lfsa_egai2d

Table List

2 tables(1.74 MB)

Employed Persons By Detailed Occupation (ISCO-08 Two Digit Level) - Raw

Employed Persons By Detailed Occupation (ISCO-08 Two Digit Level) - Unpivoted

Employed Persons By Detailed Occupation (ISCO-08 Two Digit Level) - Unpivoted

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

835.94 KB
298719 rows
8 columns

freq Freq	isco08 Isco08	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	No response	From 15 to 64 years	Females	Thousand persons	Switzerland	2011	8.3
Annual	No response	From 15 to 64 years	Females	Thousand persons	Czechia	2011	0.6
Annual	No response	From 15 to 64 years	Females	Thousand persons	Germany	2011	163
Annual	No response	From 15 to 64 years	Females	Thousand persons	Euro area – 20 countries (from 2023)	2011	219.3
Annual	No response	From 15 to 64 years	Females	Thousand persons	European Union - 27 countries (from 2020)	2011	229.7
Annual	No response	From 15 to 64 years	Females	Thousand persons	Finland	2011	4
Annual	No response	From 15 to 64 years	Females	Thousand persons	Ireland	2011	2.6
Annual	No response	From 15 to 64 years	Females	Thousand persons	Luxembourg	2011	0.9
Annual	No response	From 15 to 64 years	Females	Thousand persons	Netherlands	2011	44.6
Annual	No response	From 15 to 64 years	Females	Thousand persons	Norway	2011	72.6


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