Structure Of Consumption Expenditure By Number Of Active Persons And COICOP Consumption Purpose

Eurostat code: hbs_str_t222 · (1988 - 2020)

@eurostat.hbs_str_t222

Table List

2 tables(167.43 KB)

Structure Of Consumption Expenditure By Number Of Active Persons And COICOP Consumption Purpose - Raw

Structure Of Consumption Expenditure By Number Of Active Persons And COICOP Consumption Purpose - Unpivoted

Structure Of Consumption Expenditure By Number Of Active Persons And COICOP Consumption Purpose - Raw

@eurostat.hbs_str_t222.raw

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

90.2 KB
12029 rows
12 columns

freq Freq	n_activ N Activ	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	No active persons	Food and non-alcoholic beverages	Per mille	Austria		165.7	146.8	145	132	125	128
Annual	No active persons	Food and non-alcoholic beverages	Per mille	Belgium	161.3	116	137.8	140	141	134	155
Annual	No active persons	Food and non-alcoholic beverages	Per mille	Bulgaria				347	307	291	267
Annual	No active persons	Food and non-alcoholic beverages	Per mille	Cyprus				228	203	217	217
Annual	No active persons	Food and non-alcoholic beverages	Per mille	Czechia				268	238	245	229
Annual	No active persons	Food and non-alcoholic beverages	Per mille	Germany	148	143.3	106.6	114	116	116	112
Annual	No active persons	Food and non-alcoholic beverages	Per mille	Denmark		140.2	139.4	121	116		121
Annual	No active persons	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)		187.5	161	164	163
Annual	No active persons	Food and non-alcoholic beverages	Per mille	Euro area - 12 countries (2001-2006)				164	160
Annual	No active persons	Food and non-alcoholic beverages	Per mille	Euro area - 13 countries (2007)				164	160


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