Share Of Households And Economic Resources By Income, Consumption And Wealth Quantiles - Experimental Statistics

Eurostat code: icw_res_01 · (2010 - 2020)

@eurostat.icw_res_01

Table List

2 tables(302.73 KB)

Share Of Households And Economic Resources By Income, Consumption And Wealth Quantiles - Experimental Statistics - Raw

Share Of Households And Economic Resources By Income, Consumption And Wealth Quantiles - Experimental Statistics - Unpivoted

Share Of Households And Economic Resources By Income, Consumption And Wealth Quantiles - Experimental Statistics - Unpivoted

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

141.44 KB
131536 rows
9 columns

freq Freq	quant_inc Quant Inc	quant_expn Quant Expn	quant_wlth Quant Wlth	indic_il Indic Il	unit Unit	geo Geo	time_period Time Period	value Value
Annual	First decile	First decile	First decile	Consumption expenditure	Percentage	Austria	2010	0.2
Annual	First decile	First decile	First decile	Consumption expenditure	Percentage	Belgium	2010	0.3
Annual	First decile	First decile	First decile	Consumption expenditure	Percentage	Cyprus	2010	0.2
Annual	First decile	First decile	First decile	Consumption expenditure	Percentage	Germany	2010	0.4
Annual	First decile	First decile	First decile	Consumption expenditure	Percentage	Greece	2010	0.2
Annual	First decile	First decile	First decile	Consumption expenditure	Percentage	Spain	2010	0.3
Annual	First decile	First decile	First decile	Consumption expenditure	Percentage	Finland	2010	0.1
Annual	First decile	First decile	First decile	Consumption expenditure	Percentage	France	2010	0.2
Annual	First decile	First decile	First decile	Consumption expenditure	Percentage	Italy	2010	0.1
Annual	First decile	First decile	First decile	Consumption expenditure	Percentage	Luxembourg	2010	0.2


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

Share link

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