Number Of Employees By Sex, Age, Occupation - NACE Rev. 1.1, C-O Excluding L

Eurostat code: earn_ses06_03 · (2006 - 2006)

@eurostat.earn_ses06_03

Table List

2 tables(162.99 KB)

Number Of Employees By Sex, Age, Occupation - NACE Rev. 1.1, C-O Excluding L - Raw

Number Of Employees By Sex, Age, Occupation - NACE Rev. 1.1, C-O Excluding L - Unpivoted

Number Of Employees By Sex, Age, Occupation - NACE Rev. 1.1, C-O Excluding L - Unpivoted

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

81.63 KB
11206 rows
8 columns

freq Freq	sizeclas Sizeclas	age Age	isco88 Isco88	sex Sex	geo Geo	time_period Time Period	value Value
Annual	From 10 to 49 employees	Total	Legislators, senior officials and managers	Females	Belgium	2006	3205
Annual	From 10 to 49 employees	Total	Legislators, senior officials and managers	Males	Belgium	2006	9629
Annual	From 10 to 49 employees	Total	Legislators, senior officials and managers	Total	Belgium	2006	12834
Annual	From 10 to 49 employees	Total	Non manual workers	Females	Belgium	2006	128929
Annual	From 10 to 49 employees	Total	Non manual workers	Males	Belgium	2006	105224
Annual	From 10 to 49 employees	Total	Non manual workers	Total	Belgium	2006	234153
Annual	From 10 to 49 employees	Total	Professionals	Females	Belgium	2006	27677
Annual	From 10 to 49 employees	Total	Professionals	Males	Belgium	2006	24510
Annual	From 10 to 49 employees	Total	Professionals	Total	Belgium	2006	52186
Annual	From 10 to 49 employees	Total	Technicians and associate professionals	Females	Belgium	2006	15808


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

Share link

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