Hourly Earnings By Economic Activity And Contractual Working Time (enterprises With 10 Employed Persons Or More)

Eurostat code: earn_ses_hftpt · (2006 - 2006)

@eurostat.earn_ses_hftpt

Table List

2 tables(15.92 KB)

Hourly Earnings By Economic Activity And Contractual Working Time (enterprises With 10 Employed Persons Or More) - Raw

Hourly Earnings By Economic Activity And Contractual Working Time (enterprises With 10 Employed Persons Or More) - Unpivoted

Hourly Earnings By Economic Activity And Contractual Working Time (enterprises With 10 Employed Persons Or More) - Unpivoted

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

8.24 KB
312 rows
7 columns

freq Freq	unit Unit	nace_r1 Nace R1	worktime Worktime	geo Geo	time_period Time Period	value Value
Annual	Euro	Industry	Full-time	Austria	2006	14.16
Annual	Euro	Industry	Full-time	Belgium	2006	16.1
Annual	Euro	Industry	Full-time	Bulgaria	2006	1.07
Annual	Euro	Industry	Full-time	Cyprus	2006	9.71
Annual	Euro	Industry	Full-time	Czechia	2006	4.09
Annual	Euro	Industry	Full-time	Germany	2006	17.6
Annual	Euro	Industry	Full-time	Denmark	2006	24.78
Annual	Euro	Industry	Full-time	Euro area - 16 countries (2009-2010)	2006	13.73
Annual	Euro	Industry	Full-time	Estonia	2006	3.61
Annual	Euro	Industry	Full-time	Greece	2006	8.83


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "nace_r1" VARCHAR,
  "worktime" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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