Average Annual Gross Earnings By Sex And NACE Rev. 1.1 Activity

Eurostat code: earn_gr_nace · (1995 - 2008)

@eurostat.earn_gr_nace

Table List

2 tables(975.46 KB)

Average Annual Gross Earnings By Sex And NACE Rev. 1.1 Activity - Raw

Average Annual Gross Earnings By Sex And NACE Rev. 1.1 Activity - Unpivoted

Average Annual Gross Earnings By Sex And NACE Rev. 1.1 Activity - Unpivoted

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

481.3 KB
77979 rows
8 columns

freq Freq	currency Currency	worktime Worktime	sex Sex	nace_r1 Nace R1	geo Geo	time_period Time Period	value Value
Annual	Euro	Full-time	Females	Mining and quarrying	Belgium	1995	27765
Annual	Euro	Full-time	Females	Mining and quarrying	Greece	1995	9411.1
Annual	Euro	Full-time	Females	Mining and quarrying	Finland	1995	17637
Annual	Euro	Full-time	Females	Mining and quarrying	France	1995	27730
Annual	Euro	Full-time	Females	Mining and quarrying	Hungary	1995	2896.4
Annual	Euro	Full-time	Females	Industry (except construction)	Belgium	1995	23535
Annual	Euro	Full-time	Females	Industry (except construction)	Greece	1995	8446.5
Annual	Euro	Full-time	Females	Industry (except construction)	France	1995	20293
Annual	Euro	Full-time	Females	Industry (except construction)	Hungary	1995	2379.4
Annual	Euro	Full-time	Females	Industry (except construction)	Lithuania	1995	1417.4


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

Share link

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