Mean Consumption Expenditure By Main Source Of The Household's Income

Eurostat code: hbs_exp_t137 · (1988 - 2020)

@eurostat.hbs_exp_t137

Table List

2 tables(27.23 KB)

Mean Consumption Expenditure By Main Source Of The Household's Income - Raw

Mean Consumption Expenditure By Main Source Of The Household's Income - Unpivoted

Mean Consumption Expenditure By Main Source Of The Household's Income - Unpivoted

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

12.07 KB
1062 rows
6 columns

freq Freq	incsrc Incsrc	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Primary income	Purchasing power standard (PPS) per adult equivalent	Germany	1988	11904
Annual	Primary income	Purchasing power standard (PPS) per adult equivalent	Greece	1988	8184
Annual	Primary income	Purchasing power standard (PPS) per adult equivalent	Spain	1988	8058
Annual	Primary income	Purchasing power standard (PPS) per adult equivalent	France	1988	10984
Annual	Primary income	Purchasing power standard (PPS) per adult equivalent	Netherlands	1988	10935
Annual	Primary income	Purchasing power standard (PPS) per adult equivalent	Portugal	1988	6867
Annual	Primary income	Purchasing power standard (PPS) per adult equivalent	United Kingdom	1988	12042
Annual	Primary income	Purchasing power standard (PPS) per household	Germany	1988	19938
Annual	Primary income	Purchasing power standard (PPS) per household	Greece	1988	15805
Annual	Primary income	Purchasing power standard (PPS) per household	Spain	1988	17388


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

Share link

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