Household Final Consumption Expenditure By Purpose (COICOP 1999)

Eurostat code: nama_10_co3_p3 · (1975 - 2024)

@eurostat.nama_10_co3_p3

Table List

2 tables(16.3 MB)

Household Final Consumption Expenditure By Purpose (COICOP 1999) - Raw

Household Final Consumption Expenditure By Purpose (COICOP 1999) - Unpivoted

Household Final Consumption Expenditure By Purpose (COICOP 1999) - Unpivoted

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

8.05 MB
1886060 rows
6 columns

freq Freq	unit Unit	coicop Coicop	geo Geo	time_period Time Period	value Value
Annual	Chain linked volumes (2005), million euro	Food and non-alcoholic beverages	Denmark	1975	7935.2
Annual	Chain linked volumes (2005), million euro	Food and non-alcoholic beverages	France	1975	76668.3
Annual	Chain linked volumes (2005), million euro	Food and non-alcoholic beverages	Norway	1975	8268.1
Annual	Chain linked volumes (2005), million euro	Food	Denmark	1975	6821.9
Annual	Chain linked volumes (2005), million euro	Food	France	1975	72801.6
Annual	Chain linked volumes (2005), million euro	Food	Norway	1975	7593.9
Annual	Chain linked volumes (2005), million euro	Non-alcoholic beverages	Denmark	1975	1129
Annual	Chain linked volumes (2005), million euro	Non-alcoholic beverages	France	1975	4037.5
Annual	Chain linked volumes (2005), million euro	Non-alcoholic beverages	Norway	1975	703.2
Annual	Chain linked volumes (2005), million euro	Alcoholic beverages, tobacco and narcotics	Denmark	1975	4250.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.