2002 - Number Of Employees By Economic Activity, Collective Pay Agreement, Sex, Employment Contract

Eurostat code: earn_ses_agt01 · (2002 - 2002)

@eurostat.earn_ses_agt01

Table List

2 tables(490.8 KB)

2002 - Number Of Employees By Economic Activity, Collective Pay Agreement, Sex, Employment Contract - Raw

2002 - Number Of Employees By Economic Activity, Collective Pay Agreement, Sex, Employment Contract - Unpivoted

2002 - Number Of Employees By Economic Activity, Collective Pay Agreement, Sex, Employment Contract - Unpivoted

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

245.69 KB
41556 rows
8 columns

freq Freq	nace_r1 Nace R1	cpayagr Cpayagr	emp_cont Emp Cont	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Mining and quarrying	Enterprise or single-employer agreement	Apprentice or trainee	Females	Germany	2002	63
Annual	Mining and quarrying	Enterprise or single-employer agreement	Apprentice or trainee	Females	Euro area - 12 countries (2001-2006)	2002	63
Annual	Mining and quarrying	Enterprise or single-employer agreement	Apprentice or trainee	Females	European Union - 15 countries (1995-2004)	2002	63
Annual	Mining and quarrying	Enterprise or single-employer agreement	Apprentice or trainee	Females	European Union - 25 countries (2004-2006)	2002	63
Annual	Mining and quarrying	Enterprise or single-employer agreement	Apprentice or trainee	Males	Germany	2002	129
Annual	Mining and quarrying	Enterprise or single-employer agreement	Apprentice or trainee	Males	Euro area - 12 countries (2001-2006)	2002	129
Annual	Mining and quarrying	Enterprise or single-employer agreement	Apprentice or trainee	Males	European Union - 15 countries (1995-2004)	2002	129
Annual	Mining and quarrying	Enterprise or single-employer agreement	Apprentice or trainee	Males	European Union - 25 countries (2004-2006)	2002	129
Annual	Mining and quarrying	Enterprise or single-employer agreement	Apprentice or trainee	Total	Germany	2002	191
Annual	Mining and quarrying	Enterprise or single-employer agreement	Apprentice or trainee	Total	Euro area - 12 countries (2001-2006)	2002	191


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

Share link

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