Household Final Consumption Expenditure By Purpose (COICOP 1999)

Eurostat code: nama_10_co3_p3$dv_1002

@eurostat.nama_10_co3_p3_dv_1002

Table List

2 tables(95.45 KB)

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_dv_1002.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.

43.36 KB
8856 rows
6 columns

freq Freq	unit Unit	coicop Coicop	geo Geo	time_period Time Period	value Value
Annual	Chain linked volumes, index 2015=100	Recreation and culture	Albania	2015	100
Annual	Chain linked volumes, index 2015=100	Recreation and culture	Austria	2015	100
Annual	Chain linked volumes, index 2015=100	Recreation and culture	Bosnia and Herzegovina	2015	100
Annual	Chain linked volumes, index 2015=100	Recreation and culture	Belgium	2015	100
Annual	Chain linked volumes, index 2015=100	Recreation and culture	Bulgaria	2015	100
Annual	Chain linked volumes, index 2015=100	Recreation and culture	Switzerland	2015	100
Annual	Chain linked volumes, index 2015=100	Recreation and culture	Cyprus	2015	100
Annual	Chain linked volumes, index 2015=100	Recreation and culture	Czechia	2015	100
Annual	Chain linked volumes, index 2015=100	Recreation and culture	Germany	2015	100
Annual	Chain linked volumes, index 2015=100	Recreation and culture	Denmark	2015	100


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.