Poverty Headcount Ratio By Sex: Proportion Of Persons Below The National Poverty Line

Eurostat code: enps_ilc_natln · (2005 - 2021)

@eurostat.enps_ilc_natln

Table List

2 tables(19.43 KB)

Poverty Headcount Ratio By Sex: Proportion Of Persons Below The National Poverty Line - Raw

Poverty Headcount Ratio By Sex: Proportion Of Persons Below The National Poverty Line - Unpivoted

Poverty Headcount Ratio By Sex: Proportion Of Persons Below The National Poverty Line - Unpivoted

@eurostat.enps_ilc_natln.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.04 KB
104 rows
6 columns

freq Freq	unit Unit	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Rate	Females	Egypt	2005	18.9
Annual	Rate	Females	Israel	2005	20.1
Annual	Rate	Males	Egypt	2005	20.2
Annual	Rate	Males	Israel	2005	19.5
Annual	Rate	Total	Egypt	2005	19.6
Annual	Rate	Total	Israel	2005	19.8
Annual	Rate	Total	Tunisia	2005	23.1
Annual	Rate	Females	Israel	2006	20.4
Annual	Rate	Males	Israel	2006	20.9
Annual	Rate	Total	Israel	2006	20.6


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

Share link

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