Structure Of Earnings Survey: Monthly Earnings

Eurostat code: earn_ses_monthly$dv_221

@eurostat.earn_ses_monthly_dv_221

Table List

2 tables(151.36 KB)

Structure Of Earnings Survey: Monthly Earnings - Raw

Structure Of Earnings Survey: Monthly Earnings - Unpivoted

Structure Of Earnings Survey: Monthly Earnings - Unpivoted

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

62.03 KB
18273 rows
10 columns

freq Freq	nace_r2 Nace R2	isco08 Isco08	worktime Worktime	age Age	sex Sex	indic_se Indic Se	geo Geo	time_period Time Period	value Value
Annual	Industry and construction	Managers	Total	Total	Females	Mean earnings in euro	Austria	2002	3532
Annual	Industry and construction	Managers	Total	Total	Females	Mean earnings in euro	Belgium	2002	3597
Annual	Industry and construction	Managers	Total	Total	Females	Mean earnings in euro	Bulgaria	2002	253
Annual	Industry and construction	Managers	Total	Total	Females	Mean earnings in euro	Cyprus	2002	3031
Annual	Industry and construction	Managers	Total	Total	Females	Mean earnings in euro	Czechia	2002	758
Annual	Industry and construction	Managers	Total	Total	Females	Mean earnings in euro	Germany	2002	3538
Annual	Industry and construction	Managers	Total	Total	Females	Mean earnings in euro	Denmark	2002	4200
Annual	Industry and construction	Managers	Total	Total	Females	Mean earnings in euro	Estonia	2002	645
Annual	Industry and construction	Managers	Total	Total	Females	Mean earnings in euro	Greece	2002	2346
Annual	Industry and construction	Managers	Total	Total	Females	Mean earnings in euro	Spain	2002	2858


CREATE TABLE tidy (
  "freq" VARCHAR,
  "nace_r2" VARCHAR,
  "isco08" VARCHAR,
  "worktime" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "indic_se" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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