Employees By Sex, Occupation And Size Class Of The Enterprise (2022)

Eurostat code: earn_ses22_53 · (2022 - 2022)

@eurostat.earn_ses22_53

Table List

2 tables(102.87 KB)

Employees By Sex, Occupation And Size Class Of The Enterprise (2022) - Raw

Employees By Sex, Occupation And Size Class Of The Enterprise (2022) - Unpivoted

Employees By Sex, Occupation And Size Class Of The Enterprise (2022) - Unpivoted

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

51.74 KB
6819 rows
8 columns

freq Freq	sex Sex	isco08 Isco08	sizeclas Sizeclas	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Females	Armed forces occupations	From 10 to 49 employees	Number	Germany	2022	94
Annual	Females	Armed forces occupations	From 10 to 49 employees	Number	Euro area - 19 countries (2015-2022)	2022	116
Annual	Females	Armed forces occupations	From 10 to 49 employees	Number	Euro area – 20 countries (from 2023)	2022	116
Annual	Females	Armed forces occupations	From 10 to 49 employees	Number	European Union - 27 countries (from 2020)	2022	116
Annual	Females	Armed forces occupations	From 250 to 499 employees	Number	Euro area - 19 countries (2015-2022)	2022	550
Annual	Females	Armed forces occupations	From 250 to 499 employees	Number	Euro area – 20 countries (from 2023)	2022	550
Annual	Females	Armed forces occupations	From 250 to 499 employees	Number	European Union - 27 countries (from 2020)	2022	550
Annual	Females	Armed forces occupations	From 50 to 249 employees	Number	Germany	2022	715
Annual	Females	Armed forces occupations	From 50 to 249 employees	Number	Euro area - 19 countries (2015-2022)	2022	976
Annual	Females	Armed forces occupations	From 50 to 249 employees	Number	Euro area – 20 countries (from 2023)	2022	976


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

Share link

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