Structure Of Consumption Expenditure By Age Of The Reference Person And COICOP Consumption Purpose

Eurostat code: hbs_str_t225 · (1988 - 2020)

@eurostat.hbs_str_t225

Table List

2 tables(162.18 KB)

Structure Of Consumption Expenditure By Age Of The Reference Person And COICOP Consumption Purpose - Raw

Structure Of Consumption Expenditure By Age Of The Reference Person And COICOP Consumption Purpose - Unpivoted

Structure Of Consumption Expenditure By Age Of The Reference Person And COICOP Consumption Purpose - Unpivoted

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

76.93 KB
42418 rows
7 columns

freq Freq	age Age	coicop Coicop	unit Unit	geo Geo	time_period Time Period	value Value
Annual	From 30 to 44 years	Food and non-alcoholic beverages	Per mille	Belgium	1988	155.4
Annual	From 30 to 44 years	Food and non-alcoholic beverages	Per mille	Germany	1988	149.4
Annual	From 30 to 44 years	Food and non-alcoholic beverages	Per mille	Greece	1988	212.1
Annual	From 30 to 44 years	Food and non-alcoholic beverages	Per mille	Spain	1988	251.2
Annual	From 30 to 44 years	Food and non-alcoholic beverages	Per mille	France	1988	166.7
Annual	From 30 to 44 years	Food and non-alcoholic beverages	Per mille	Italy	1988	221.7
Annual	From 30 to 44 years	Food and non-alcoholic beverages	Per mille	Luxembourg	1988	144.3
Annual	From 30 to 44 years	Food and non-alcoholic beverages	Per mille	Netherlands	1988	136.5
Annual	From 30 to 44 years	Food and non-alcoholic beverages	Per mille	Portugal	1988	253.7
Annual	From 30 to 44 years	Food and non-alcoholic beverages	Per mille	United Kingdom	1988	139.3


CREATE TABLE tidy (
  "freq" VARCHAR,
  "age" 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.