Mean Consumption Expenditure Per Household And Per Adult Equivalent

Eurostat code: hbs_exp_t111 · (1988 - 2020)

@eurostat.hbs_exp_t111

Table List

2 tables(25.81 KB)

Mean Consumption Expenditure Per Household And Per Adult Equivalent - Raw

Mean Consumption Expenditure Per Household And Per Adult Equivalent - Unpivoted

Mean Consumption Expenditure Per Household And Per Adult Equivalent - Unpivoted

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

11.41 KB
1156 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Euro per adult equivalent	Belgium	1988	10447
Annual	Euro per adult equivalent	Germany	1988	12145
Annual	Euro per adult equivalent	Greece	1988	5937
Annual	Euro per adult equivalent	Spain	1988	6103
Annual	Euro per adult equivalent	France	1988	10389
Annual	Euro per adult equivalent	Italy	1988	9066
Annual	Euro per adult equivalent	Luxembourg	1988	15019
Annual	Euro per adult equivalent	Netherlands	1988	10657
Annual	Euro per adult equivalent	Portugal	1988	3425
Annual	Euro per adult equivalent	United Kingdom	1988	9857


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

Share link

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