Structure Of Consumption Expenditure By Degree Of Urbanisation And COICOP Consumption Purpose

Eurostat code: hbs_str_t226 · (1988 - 2020)

@eurostat.hbs_str_t226

Table List

2 tables(105.49 KB)

Structure Of Consumption Expenditure By Degree Of Urbanisation And COICOP Consumption Purpose - Raw

Structure Of Consumption Expenditure By Degree Of Urbanisation And COICOP Consumption Purpose - Unpivoted

Structure Of Consumption Expenditure By Degree Of Urbanisation And COICOP Consumption Purpose - Raw

@eurostat.hbs_str_t226.raw

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

58.98 KB
8828 rows
12 columns

freq Freq	deg_urb Deg Urb	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	Cities	Food and non-alcoholic beverages	Per mille	Austria			115	121	116	116	120
Annual	Cities	Food and non-alcoholic beverages	Per mille	Belgium	169	119	132	134	131	129	158
Annual	Cities	Food and non-alcoholic beverages	Per mille	Bulgaria				250	240	231	214
Annual	Cities	Food and non-alcoholic beverages	Per mille	Cyprus				140	114	140	140
Annual	Cities	Food and non-alcoholic beverages	Per mille	Czechia				194	189	200	186
Annual	Cities	Food and non-alcoholic beverages	Per mille	Germany	147	131		110	115	115	113
Annual	Cities	Food and non-alcoholic beverages	Per mille	Denmark		141	131	121	118	125	123
Annual	Cities	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)				142	139
Annual	Cities	Food and non-alcoholic beverages	Per mille	Euro area - 12 countries (2001-2006)				142	137
Annual	Cities	Food and non-alcoholic beverages	Per mille	Euro area - 13 countries (2007)				142	137


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