Income Quintile Share Ratio - S80/S20

Eurostat code: enps_ilc_di11 · (2005 - 2021)

@eurostat.enps_ilc_di11

Table List

2 tables(17.49 KB)

Income Quintile Share Ratio - S80/S20 - Raw

Income Quintile Share Ratio - S80/S20 - Unpivoted

Income Quintile Share Ratio - S80/S20 - Unpivoted

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

4.12 KB
30 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Ratio	Egypt	2005	39
Annual	Ratio	Israel	2005	7.8
Annual	Ratio	Israel	2006	7.5
Annual	Ratio	Jordan	2006	1.7
Annual	Ratio	Israel	2007	7.3
Annual	Ratio	Morocco	2007	8.8
Annual	Ratio	Israel	2008	7.6
Annual	Ratio	Jordan	2008	1.7
Annual	Ratio	Libya	2008	1.4
Annual	Ratio	Israel	2009	8.1


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

Share link

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