Household Final Consumption Expenditure By Purpose (COICOP 2018)

Eurostat code: nama_10_cp18 · (1975 - 2024)

@eurostat.nama_10_cp18

Table List

2 tables(10.74 MB)

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

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

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

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

5.23 MB
1268007 rows
6 columns

freq Freq	unit Unit	coicop18 Coicop18	geo Geo	time_period Time Period	value Value
Annual	Chain linked volumes (2010), million euro	Food and non-alcoholic beverages	Denmark	1975	8951.8
Annual	Chain linked volumes (2010), million euro	Food and non-alcoholic beverages	France	1975	74284.4
Annual	Chain linked volumes (2010), million euro	Food	Denmark	1975	7661.1
Annual	Chain linked volumes (2010), million euro	Food	France	1975	70320.3
Annual	Chain linked volumes (2010), million euro	Non-alcoholic beverages	Denmark	1975	1320.1
Annual	Chain linked volumes (2010), million euro	Non-alcoholic beverages	France	1975	4114.2
Annual	Chain linked volumes (2010), million euro	Services for processing primary goods for food and non-alcoholic beverages	Denmark	1975	0.1
Annual	Chain linked volumes (2010), million euro	Alcoholic beverages, tobacco and narcotics	Denmark	1975	4866
Annual	Chain linked volumes (2010), million euro	Alcoholic beverages, tobacco and narcotics	France	1975	37336.9
Annual	Chain linked volumes (2010), million euro	Alcoholic beverages	Denmark	1975	1577.3


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

Share link

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