Persons Receiving Benefits By Risk Of Poverty Thresholds, Work Intensity Of The Household And Percentage Of The Benefits In Total Disposable Income (population Aged 18-64)

Eurostat code: ilc_li71 · (2015 - 2024)

@eurostat.ilc_li71

Table List

2 tables(36.46 KB)

Persons Receiving Benefits By Risk Of Poverty Thresholds, Work Intensity Of The Household And Percentage Of The Benefits In Total Disposable Income (population Aged 18-64) - Raw

Persons Receiving Benefits By Risk Of Poverty Thresholds, Work Intensity Of The Household And Percentage Of The Benefits In Total Disposable Income (population Aged 18-64) - Unpivoted

Persons Receiving Benefits By Risk Of Poverty Thresholds, Work Intensity Of The Household And Percentage Of The Benefits In Total Disposable Income (population Aged 18-64) - Unpivoted

@eurostat.ilc_li71.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.44 KB
2240 rows
9 columns

freq Freq	percent Percent	rskpovth Rskpovth	age Age	workint Workint	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Over 50 percent	Below 60%	From 18 to 64 years	Total	Percentage	Austria	2015	59.5
Annual	Over 50 percent	Below 60%	From 18 to 64 years	Total	Percentage	Belgium	2015	60.4
Annual	Over 50 percent	Below 60%	From 18 to 64 years	Total	Percentage	Bulgaria	2015	48.9
Annual	Over 50 percent	Below 60%	From 18 to 64 years	Total	Percentage	Cyprus	2015	39
Annual	Over 50 percent	Below 60%	From 18 to 64 years	Total	Percentage	Czechia	2015	50.1
Annual	Over 50 percent	Below 60%	From 18 to 64 years	Total	Percentage	Germany	2015	60.3
Annual	Over 50 percent	Below 60%	From 18 to 64 years	Total	Percentage	Euro area – 20 countries (from 2023)	2015	48.7
Annual	Over 50 percent	Below 60%	From 18 to 64 years	Total	Percentage	Estonia	2015	42.9
Annual	Over 50 percent	Below 60%	From 18 to 64 years	Total	Percentage	Greece	2015	22.6
Annual	Over 50 percent	Below 60%	From 18 to 64 years	Total	Percentage	Spain	2015	51


CREATE TABLE tidy (
  "freq" VARCHAR,
  "percent" VARCHAR,
  "rskpovth" VARCHAR,
  "age" VARCHAR,
  "workint" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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