Structure Of Consumption Expenditure By Type Of Household And COICOP Consumption Purpose

Eurostat code: hbs_str_t224 · (1988 - 2020)

@eurostat.hbs_str_t224

Table List

2 tables(246.82 KB)

Structure Of Consumption Expenditure By Type Of Household And COICOP Consumption Purpose - Raw

Structure Of Consumption Expenditure By Type Of Household And COICOP Consumption Purpose - Unpivoted

Structure Of Consumption Expenditure By Type Of Household And COICOP Consumption Purpose - Raw

@eurostat.hbs_str_t224.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

129.81 KB
19855 rows
12 columns

freq Freq	hhtyp Hhtyp	coicop Coicop	unit Unit	geo Geo	n_1988 1988	n_1994 1994	n_1999 1999	n_2005 2005	n_2010 2010	n_2015 2015	n_2020 2020
Annual	Single person	Food and non-alcoholic beverages	Per mille	Austria		134.3	106.6	119	106	106	112
Annual	Single person	Food and non-alcoholic beverages	Per mille	Belgium	128	119.8	110.4	110	112	111	140
Annual	Single person	Food and non-alcoholic beverages	Per mille	Bulgaria				301	285	254	242
Annual	Single person	Food and non-alcoholic beverages	Per mille	Cyprus				168	126	152	152
Annual	Single person	Food and non-alcoholic beverages	Per mille	Czechia				212	194	205	196
Annual	Single person	Food and non-alcoholic beverages	Per mille	Germany	139.1	121.2	94.7	99	104	105	103
Annual	Single person	Food and non-alcoholic beverages	Per mille	Denmark		125	122.3	104	103	107	111
Annual	Single person	Food and non-alcoholic beverages	Per mille	Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)		149.2	129.5	173	134
Annual	Single person	Food and non-alcoholic beverages	Per mille	Euro area - 12 countries (2001-2006)				173	131
Annual	Single person	Food and non-alcoholic beverages	Per mille	Euro area - 13 countries (2007)				173	131


CREATE TABLE raw (
  "freq" VARCHAR,
  "hhtyp" VARCHAR,
  "coicop" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_1988" DOUBLE,
  "n_1994" DOUBLE,
  "n_1999" DOUBLE,
  "n_2005" DOUBLE,
  "n_2010" DOUBLE,
  "n_2015" DOUBLE,
  "n_2020" DOUBLE
);

Share link

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