Final Consumption Expenditure Of Households, By Consumption Purpose

Eurostat code: tec00134 · (1990 - 2024)

@eurostat.tec00134

Table List

2 tables(86.01 KB)

Final Consumption Expenditure Of Households, By Consumption Purpose - Raw

Final Consumption Expenditure Of Households, By Consumption Purpose - Unpivoted

Final Consumption Expenditure Of Households, By Consumption Purpose - Unpivoted

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

23.12 KB
14613 rows
6 columns

freq Freq	unit Unit	coicop Coicop	geo Geo	time_period Time Period	value Value
Annual	Percentage of total	Food and non-alcoholic beverages	Denmark	1990	13.9
Annual	Percentage of total	Food and non-alcoholic beverages	Finland	1990	16.3
Annual	Percentage of total	Food and non-alcoholic beverages	France	1990	14.8
Annual	Percentage of total	Food and non-alcoholic beverages	Norway	1990	16.8
Annual	Percentage of total	Alcoholic beverages, tobacco and narcotics	Denmark	1990	6.1
Annual	Percentage of total	Alcoholic beverages, tobacco and narcotics	Finland	1990	6.6
Annual	Percentage of total	Alcoholic beverages, tobacco and narcotics	France	1990	3.4
Annual	Percentage of total	Alcoholic beverages, tobacco and narcotics	Norway	1990	5
Annual	Percentage of total	Clothing and footwear	Denmark	1990	4.8
Annual	Percentage of total	Clothing and footwear	Finland	1990	5.6


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "coicop" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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