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

Eurostat code: icw_res_02 · (2010 - 2020)

@eurostat.icw_res_02

Table List

2 tables(3.05 MB)

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

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

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

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

1.52 MB
210822 rows
10 columns

freq Freq	quant_inc Quant Inc	quant_expn Quant Expn	quant_wlth Quant Wlth	statinfo Statinfo	indic_il Indic Il	unit Unit	geo Geo	time_period Time Period	value Value
Annual	First decile	First decile	First decile	Average	Consumption expenditure	Euro	Austria	2010	10013.1
Annual	First decile	First decile	First decile	Average	Consumption expenditure	Euro	Belgium	2010	12622.2
Annual	First decile	First decile	First decile	Average	Consumption expenditure	Euro	Cyprus	2010	6118.4
Annual	First decile	First decile	First decile	Average	Consumption expenditure	Euro	Germany	2010	9249.4
Annual	First decile	First decile	First decile	Average	Consumption expenditure	Euro	Greece	2010	6759.9
Annual	First decile	First decile	First decile	Average	Consumption expenditure	Euro	Spain	2010	7552.6
Annual	First decile	First decile	First decile	Average	Consumption expenditure	Euro	Finland	2010	7318.3
Annual	First decile	First decile	First decile	Average	Consumption expenditure	Euro	France	2010	8521.4
Annual	First decile	First decile	First decile	Average	Consumption expenditure	Euro	Italy	2010	7392.5
Annual	First decile	First decile	First decile	Average	Consumption expenditure	Euro	Luxembourg	2010	14621.2


CREATE TABLE tidy (
  "freq" VARCHAR,
  "quant_inc" VARCHAR,
  "quant_expn" VARCHAR,
  "quant_wlth" VARCHAR,
  "statinfo" 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.