Wages

Eurostat code: med_ps43 · (2000 - 2010)

@eurostat.med_ps43

Table List

2 tables(16.48 KB)

Wages - Unpivoted

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

5.45 KB
149 rows
5 columns

freq Freq	indic_md Indic Md	geo Geo	time_period Time Period	value Value
Annual	Nominal wage index, ( A+B ) (index)	Egypt	2000	100
Annual	Nominal wage index, ( C ) (index)	Egypt	2000	100
Annual	Nominal wage index, ( D+E ) (index)	Egypt	2000	100
Annual	Nominal wage index, ( F ) (index)	Egypt	2000	100
Annual	Nominal wage index, ( G ) (index)	Egypt	2000	100
Annual	Nominal wage index, ( I ) (ondex)	Egypt	2000	100
Annual	Nominal wage index, ( H+J+K ) (index)	Egypt	2000	100
Annual	Nominal wage index, ( L+M+N+O ) (index)	Egypt	2000	100
Annual	Nominal wage index, ( A+B ) (index)	Egypt	2001	81.2
Annual	Nominal wage index, ( C ) (index)	Egypt	2001	83.9


CREATE TABLE tidy (
  "freq" VARCHAR,
  "indic_md" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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