Employees By Sex, Economic Activity And Employment Contract (2022)

Eurostat code: earn_ses22_52 · (2022 - 2022)

@eurostat.earn_ses22_52

Table List

2 tables(146.85 KB)

Employees By Sex, Economic Activity And Employment Contract (2022) - Raw

Employees By Sex, Economic Activity And Employment Contract (2022) - Unpivoted

Employees By Sex, Economic Activity And Employment Contract (2022) - Unpivoted

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

73.45 KB
9611 rows
8 columns

freq Freq	sex Sex	emp_cont Emp Cont	nace_r2 Nace R2	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Females	Apprentice or trainee	Mining and quarrying	Number	Germany	2022	134
Annual	Females	Apprentice or trainee	Mining and quarrying	Number	Denmark	2022	14
Annual	Females	Apprentice or trainee	Mining and quarrying	Number	Euro area - 19 countries (2015-2022)	2022	246
Annual	Females	Apprentice or trainee	Mining and quarrying	Number	Euro area – 20 countries (from 2023)	2022	248
Annual	Females	Apprentice or trainee	Mining and quarrying	Number	European Union - 27 countries (from 2020)	2022	262
Annual	Females	Apprentice or trainee	Mining and quarrying	Number	Norway	2022	212
Annual	Females	Apprentice or trainee	Industry (except construction)	Number	Austria	2022	5056
Annual	Females	Apprentice or trainee	Industry (except construction)	Number	Germany	2022	58512
Annual	Females	Apprentice or trainee	Industry (except construction)	Number	Denmark	2022	2432
Annual	Females	Apprentice or trainee	Industry (except construction)	Number	Euro area - 19 countries (2015-2022)	2022	132480


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

Share link

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