Number Of Employees By Economic Activity, Sex, Educational Attainment Level

Eurostat code: earn_ses_agt04 · (2002 - 2002)

@eurostat.earn_ses_agt04

Table List

2 tables(157.61 KB)

Number Of Employees By Economic Activity, Sex, Educational Attainment Level - Raw

Number Of Employees By Economic Activity, Sex, Educational Attainment Level - Unpivoted

Number Of Employees By Economic Activity, Sex, Educational Attainment Level - Unpivoted

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

79.1 KB
9191 rows
7 columns

freq Freq	nace_r1 Nace R1	isced97 Isced97	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Mining and quarrying	Pre-primary, primary and lower secondary education (levels 0-2)	Females	Austria	2002	118.38
Annual	Mining and quarrying	Pre-primary, primary and lower secondary education (levels 0-2)	Females	Belgium	2002	66
Annual	Mining and quarrying	Pre-primary, primary and lower secondary education (levels 0-2)	Females	Bulgaria	2002	1256.64
Annual	Mining and quarrying	Pre-primary, primary and lower secondary education (levels 0-2)	Females	Cyprus	2002	3.6
Annual	Mining and quarrying	Pre-primary, primary and lower secondary education (levels 0-2)	Females	Czechia	2002	1798.87
Annual	Mining and quarrying	Pre-primary, primary and lower secondary education (levels 0-2)	Females	Germany	2002	2289.71
Annual	Mining and quarrying	Pre-primary, primary and lower secondary education (levels 0-2)	Females	Denmark	2002	182.79
Annual	Mining and quarrying	Pre-primary, primary and lower secondary education (levels 0-2)	Females	Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)	2002	6966.64
Annual	Mining and quarrying	Pre-primary, primary and lower secondary education (levels 0-2)	Females	Euro area - 12 countries (2001-2006)	2002	6967
Annual	Mining and quarrying	Pre-primary, primary and lower secondary education (levels 0-2)	Females	Estonia	2002	76.55


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

Share link

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