Poverty Ratio

Eurostat code: med_ps313 · (2005 - 2018)

@eurostat.med_ps313

Table List

2 tables(16.88 KB)

Poverty Ratio - Unpivoted

@eurostat.med_ps313.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.69 KB
60 rows
5 columns

freq Freq	indic_md Indic Md	geo Geo	time_period Time Period	value Value
Annual	Poverty headcount ratio, total (%)	Egypt	2005	19.6
Annual	Poverty headcount ratio, total (%)	Israel	2005	19.8
Annual	Poverty headcount ratio, total (%)	Tunisia	2005	23.1
Annual	Income (or expenditure) distribution: S80/S20 quintile share ratio, total (ratio)	Egypt	2005	39
Annual	Income (or expenditure) distribution: S80/S20 quintile share ratio, total (ratio)	Israel	2005	8
Annual	Poverty headcount ratio, total (%)	Israel	2006	20.6
Annual	Poverty headcount ratio, total (%)	Jordan	2006	13
Annual	Income (or expenditure) distribution: S80/S20 quintile share ratio, total (ratio)	Israel	2006	8
Annual	Income (or expenditure) distribution: S80/S20 quintile share ratio, total (ratio)	Jordan	2006	2
Annual	Poverty headcount ratio, total (%)	Israel	2007	20.2


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.