Mean Consumption Expenditure Of Private Households On Sporting Goods And Services By COICOP Consumption Purpose

Eurostat code: sprt_pcs_hbs · (2010 - 2020)

@eurostat.sprt_pcs_hbs

Table List

2 tables(18.15 KB)

Mean Consumption Expenditure Of Private Households On Sporting Goods And Services By COICOP Consumption Purpose - Raw

Mean Consumption Expenditure Of Private Households On Sporting Goods And Services By COICOP Consumption Purpose - Unpivoted

Mean Consumption Expenditure Of Private Households On Sporting Goods And Services By COICOP Consumption Purpose - Unpivoted

@eurostat.sprt_pcs_hbs.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.62 KB
860 rows
6 columns

freq Freq	coicop Coicop	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Major durables for outdoor recreation	Purchasing power standard (PPS)	Austria	2010	89.1
Annual	Major durables for outdoor recreation	Purchasing power standard (PPS)	Belgium	2010	70.9
Annual	Major durables for outdoor recreation	Purchasing power standard (PPS)	Bulgaria	2010	1.8
Annual	Major durables for outdoor recreation	Purchasing power standard (PPS)	Cyprus	2010	13.9
Annual	Major durables for outdoor recreation	Purchasing power standard (PPS)	Czechia	2010	7.5
Annual	Major durables for outdoor recreation	Purchasing power standard (PPS)	Germany	2010	54.9
Annual	Major durables for outdoor recreation	Purchasing power standard (PPS)	Denmark	2010	63.9
Annual	Major durables for outdoor recreation	Purchasing power standard (PPS)	Estonia	2010	1.8
Annual	Major durables for outdoor recreation	Purchasing power standard (PPS)	Greece	2010	72.9
Annual	Major durables for outdoor recreation	Purchasing power standard (PPS)	Spain	2010	27.2


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.