Mean Consumption Expenditure By Income Quintile

Eurostat code: hbs_exp_t133 · (1988 - 2020)

@eurostat.hbs_exp_t133

Table List

2 tables(41.6 KB)

Mean Consumption Expenditure By Income Quintile - Raw

Mean Consumption Expenditure By Income Quintile - Unpivoted

Mean Consumption Expenditure By Income Quintile - Unpivoted

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

19.3 KB
2262 rows
6 columns

freq Freq	quantile Quantile	unit Unit	geo Geo	time_period Time Period	value Value
Annual	First quintile	Purchasing power standard (PPS) per adult equivalent	Belgium	1988	6419
Annual	First quintile	Purchasing power standard (PPS) per adult equivalent	Germany	1988	6049
Annual	First quintile	Purchasing power standard (PPS) per adult equivalent	Greece	1988	4994
Annual	First quintile	Purchasing power standard (PPS) per adult equivalent	Spain	1988	3984
Annual	First quintile	Purchasing power standard (PPS) per adult equivalent	France	1988	6531
Annual	First quintile	Purchasing power standard (PPS) per adult equivalent	Italy	1988	4042
Annual	First quintile	Purchasing power standard (PPS) per adult equivalent	Luxembourg	1988	12449
Annual	First quintile	Purchasing power standard (PPS) per adult equivalent	Netherlands	1988	6303
Annual	First quintile	Purchasing power standard (PPS) per adult equivalent	Portugal	1988	2655
Annual	First quintile	Purchasing power standard (PPS) per adult equivalent	United Kingdom	1988	6176


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

Share link

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