Mean Consumption Expenditure Per Household By COICOP Consumption Purpose

Eurostat code: hbs_exp_t121 · (1988 - 2020)

@eurostat.hbs_exp_t121

Table List

2 tables(161.44 KB)

Mean Consumption Expenditure Per Household By COICOP Consumption Purpose - Raw

Mean Consumption Expenditure Per Household By COICOP Consumption Purpose - Unpivoted

Mean Consumption Expenditure Per Household By COICOP Consumption Purpose - Unpivoted

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

70.37 KB
30561 rows
6 columns

freq Freq	coicop Coicop	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Food and non-alcoholic beverages	Purchasing power standard (PPS) per household	Belgium	1988	2724
Annual	Food and non-alcoholic beverages	Purchasing power standard (PPS) per household	Germany	1988	2487
Annual	Food and non-alcoholic beverages	Purchasing power standard (PPS) per household	Greece	1988	3498
Annual	Food and non-alcoholic beverages	Purchasing power standard (PPS) per household	Spain	1988	4027
Annual	Food and non-alcoholic beverages	Purchasing power standard (PPS) per household	France	1988	2866
Annual	Food and non-alcoholic beverages	Purchasing power standard (PPS) per household	Italy	1988	4068
Annual	Food and non-alcoholic beverages	Purchasing power standard (PPS) per household	Luxembourg	1988	4022
Annual	Food and non-alcoholic beverages	Purchasing power standard (PPS) per household	Netherlands	1988	2214
Annual	Food and non-alcoholic beverages	Purchasing power standard (PPS) per household	Portugal	1988	3527
Annual	Food and non-alcoholic beverages	Purchasing power standard (PPS) per household	United Kingdom	1988	2479


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

Share link

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