Disposable Income Of Households (with Expenditure Greater Than Zero) Spent On Essential Goods And Services By Risk Of Income Poverty, Level Of Expenditure And Material Deprivation - Experimental Statistics

Eurostat code: icw_aff_02 · (2015 - 2020)

@eurostat.icw_aff_02

Table List

2 tables(209.43 KB)

Disposable Income Of Households (with Expenditure Greater Than Zero) Spent On Essential Goods And Services By Risk Of Income Poverty, Level Of Expenditure And Material Deprivation - Experimental Statistics - Raw

Disposable Income Of Households (with Expenditure Greater Than Zero) Spent On Essential Goods And Services By Risk Of Income Poverty, Level Of Expenditure And Material Deprivation - Experimental Statistics - Unpivoted

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

101.87 KB
60013 rows
9 columns

freq Freq	lev_expn Lev Expn	lev_depr Lev Depr	yn_rskpov Yn Rskpov	coicop Coicop	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Low	Non severe	Not at risk of poverty	All-items HICP	Percentage of disposable income	Austria	2015	49.9
Annual	Low	Non severe	Not at risk of poverty	All-items HICP	Percentage of disposable income	Belgium	2015	61.2
Annual	Low	Non severe	Not at risk of poverty	All-items HICP	Percentage of disposable income	Bulgaria	2015	60.1
Annual	Low	Non severe	Not at risk of poverty	All-items HICP	Percentage of disposable income	Cyprus	2015	71.2
Annual	Low	Non severe	Not at risk of poverty	All-items HICP	Percentage of disposable income	Czechia	2015	46.2
Annual	Low	Non severe	Not at risk of poverty	All-items HICP	Percentage of disposable income	Germany	2015	70.2
Annual	Low	Non severe	Not at risk of poverty	All-items HICP	Percentage of disposable income	Denmark	2015	70.7
Annual	Low	Non severe	Not at risk of poverty	All-items HICP	Percentage of disposable income	Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)	2015	60.9
Annual	Low	Non severe	Not at risk of poverty	All-items HICP	Percentage of disposable income	Euro area – 20 countries (from 2023)	2015	61.1
Annual	Low	Non severe	Not at risk of poverty	All-items HICP	Percentage of disposable income	Estonia	2015	34.3


CREATE TABLE tidy (
  "freq" VARCHAR,
  "lev_expn" VARCHAR,
  "lev_depr" VARCHAR,
  "yn_rskpov" VARCHAR,
  "coicop" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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