Households With Expenditure Greater Than Zero By COICOP Consumption Purpose

Eurostat code: hbs_exp_t123b · (1988 - 2020)

@eurostat.hbs_exp_t123b

Table List

2 tables(86.91 KB)

Households With Expenditure Greater Than Zero By COICOP Consumption Purpose - Raw

Households With Expenditure Greater Than Zero By COICOP Consumption Purpose - Unpivoted

Households With Expenditure Greater Than Zero By COICOP Consumption Purpose - Unpivoted

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

40.17 KB
27642 rows
6 columns

freq Freq	unit Unit	coicop Coicop	geo Geo	time_period Time Period	value Value
Annual	Percentage of households	Food and non-alcoholic beverages	Belgium	1988	100
Annual	Percentage of households	Food and non-alcoholic beverages	Germany	1988	100
Annual	Percentage of households	Food and non-alcoholic beverages	Greece	1988	100
Annual	Percentage of households	Food and non-alcoholic beverages	Spain	1988	100
Annual	Percentage of households	Food and non-alcoholic beverages	France	1988	99
Annual	Percentage of households	Food and non-alcoholic beverages	Italy	1988	99
Annual	Percentage of households	Food and non-alcoholic beverages	Luxembourg	1988	100
Annual	Percentage of households	Food and non-alcoholic beverages	Netherlands	1988	100
Annual	Percentage of households	Food and non-alcoholic beverages	Portugal	1988	99
Annual	Percentage of households	Food and non-alcoholic beverages	United Kingdom	1988	100


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

Share link

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