Persistent At-risk-of-poverty Rate By Household Type

Eurostat code: ilc_li23 · (2007 - 2024)

@eurostat.ilc_li23

Table List

2 tables(44.09 KB)

Persistent At-risk-of-poverty Rate By Household Type - Raw

Persistent At-risk-of-poverty Rate By Household Type - Unpivoted

Persistent At-risk-of-poverty Rate By Household Type - Unpivoted

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

13.35 KB
3732 rows
7 columns

freq Freq	unit Unit	indic_il Indic Il	hhtyp Hhtyp	geo Geo	time_period Time Period	value Value
Annual	Percentage	At persistent risk of poverty rate by age and gender (cut-off point: 60% of median equivalised income)	Single person	Austria	2007	13.5
Annual	Percentage	At persistent risk of poverty rate by age and gender (cut-off point: 60% of median equivalised income)	Single person	Belgium	2007	16.8
Annual	Percentage	At persistent risk of poverty rate by age and gender (cut-off point: 60% of median equivalised income)	Single person	Denmark	2007	6.7
Annual	Percentage	At persistent risk of poverty rate by age and gender (cut-off point: 60% of median equivalised income)	Single person	Estonia	2007	29.3
Annual	Percentage	At persistent risk of poverty rate by age and gender (cut-off point: 60% of median equivalised income)	Single person	Greece	2007	22.8
Annual	Percentage	At persistent risk of poverty rate by age and gender (cut-off point: 60% of median equivalised income)	Single person	Spain	2007	24.1
Annual	Percentage	At persistent risk of poverty rate by age and gender (cut-off point: 60% of median equivalised income)	Single person	Finland	2007	21.3
Annual	Percentage	At persistent risk of poverty rate by age and gender (cut-off point: 60% of median equivalised income)	Single person	France	2007	9.3
Annual	Percentage	At persistent risk of poverty rate by age and gender (cut-off point: 60% of median equivalised income)	Single person	Ireland	2007	38.3
Annual	Percentage	At persistent risk of poverty rate by age and gender (cut-off point: 60% of median equivalised income)	Single person	Iceland	2007	11.5


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

Share link

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