Baselight

Structure Of Consumption Expenditure By COICOP Consumption Purpose

Eurostat code: hbs_str_t211 ยท (1988 - 2020)

@eurostat.hbs_str_t211

Structure Of Consumption Expenditure By COICOP Consumption Purpose - Unpivoted
@eurostat.hbs_str_t211.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.

  • 50.52 KB
  • 32266 rows
  • 6 columns
freq

Freq

coicop

Coicop

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualFood and non-alcoholic beveragesPer milleBelgium1988161
AnnualFood and non-alcoholic beveragesPer milleGermany1988148
AnnualFood and non-alcoholic beveragesPer milleGreece1988226
AnnualFood and non-alcoholic beveragesPer milleSpain1988262
AnnualFood and non-alcoholic beveragesPer milleFrance1988173
AnnualFood and non-alcoholic beveragesPer milleItaly1988238
AnnualFood and non-alcoholic beveragesPer milleLuxembourg1988151
AnnualFood and non-alcoholic beveragesPer milleNetherlands1988134
AnnualFood and non-alcoholic beveragesPer millePortugal1988296
AnnualFood and non-alcoholic beveragesPer milleUnited Kingdom1988143

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