Structure Of Consumption Expenditure By Main Source Of Income And COICOP Consumption Purpose

Eurostat code: hbs_str_t227 · (1988 - 2020)

@eurostat.hbs_str_t227

Table List

2 tables(76.24 KB)

Structure Of Consumption Expenditure By Main Source Of Income And COICOP Consumption Purpose - Raw

Structure Of Consumption Expenditure By Main Source Of Income And COICOP Consumption Purpose - Unpivoted

Structure Of Consumption Expenditure By Main Source Of Income And COICOP Consumption Purpose - Unpivoted

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

32.91 KB
19137 rows
7 columns

freq Freq	incsrc Incsrc	coicop Coicop	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Primary income	Food and non-alcoholic beverages	Per mille	Germany	1988	147
Annual	Primary income	Food and non-alcoholic beverages	Per mille	Greece	1988	227
Annual	Primary income	Food and non-alcoholic beverages	Per mille	Spain	1988	251
Annual	Primary income	Food and non-alcoholic beverages	Per mille	France	1988	162
Annual	Primary income	Food and non-alcoholic beverages	Per mille	Netherlands	1988	131
Annual	Primary income	Food and non-alcoholic beverages	Per mille	Portugal	1988	283
Annual	Primary income	Food and non-alcoholic beverages	Per mille	United Kingdom	1988	134
Annual	Primary income	Food	Per mille	Greece	1988	220
Annual	Primary income	Food	Per mille	Spain	1988	243
Annual	Primary income	Food	Per mille	France	1988	152


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