Low-wage Earners As A Proportion Of All Employees (excluding Apprentices) By Economic Activity

Eurostat code: earn_ses_pub1n · (2010 - 2022)

@eurostat.earn_ses_pub1n

Table List

2 tables(41.91 KB)

Low-wage Earners As A Proportion Of All Employees (excluding Apprentices) By Economic Activity - Raw

Low-wage Earners As A Proportion Of All Employees (excluding Apprentices) By Economic Activity - Unpivoted

Low-wage Earners As A Proportion Of All Employees (excluding Apprentices) By Economic Activity - Unpivoted

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

19.09 KB
2709 rows
7 columns

freq Freq	unit Unit	sizeclas Sizeclas	nace_r2 Nace R2	geo Geo	time_period Time Period	value Value
Annual	Percentage	10 employees or more	Mining and quarrying	Austria	2010	2.25
Annual	Percentage	10 employees or more	Mining and quarrying	Belgium	2010	0.17
Annual	Percentage	10 employees or more	Mining and quarrying	Bulgaria	2010	3.49
Annual	Percentage	10 employees or more	Mining and quarrying	Switzerland	2010	2.7
Annual	Percentage	10 employees or more	Mining and quarrying	Cyprus	2010	2.97
Annual	Percentage	10 employees or more	Mining and quarrying	Czechia	2010	3.63
Annual	Percentage	10 employees or more	Mining and quarrying	Germany	2010	5.91
Annual	Percentage	10 employees or more	Mining and quarrying	Denmark	2010	0.52
Annual	Percentage	10 employees or more	Mining and quarrying	Euro area - 17 countries (2011-2013)	2010	4.23
Annual	Percentage	10 employees or more	Mining and quarrying	Estonia	2010	4.67


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

Share link

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