Mean Consumption Expenditure Of Private Households On Sporting Goods And Services By Income Quintile

Eurostat code: sprt_pcs_qnt · (2015 - 2020)

@eurostat.sprt_pcs_qnt

Table List

2 tables(13.03 KB)

Mean Consumption Expenditure Of Private Households On Sporting Goods And Services By Income Quintile - Raw

Mean Consumption Expenditure Of Private Households On Sporting Goods And Services By Income Quintile - Unpivoted

Mean Consumption Expenditure Of Private Households On Sporting Goods And Services By Income Quintile - Unpivoted

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

6.45 KB
282 rows
6 columns

freq Freq	quant_inc Quant Inc	unit Unit	geo Geo	time_period Time Period	value Value
Annual	First quintile	Purchasing power standard (PPS)	Austria	2015	199
Annual	First quintile	Purchasing power standard (PPS)	Belgium	2015	90
Annual	First quintile	Purchasing power standard (PPS)	Czechia	2015	37
Annual	First quintile	Purchasing power standard (PPS)	Germany	2015	107
Annual	First quintile	Purchasing power standard (PPS)	Greece	2015	26
Annual	First quintile	Purchasing power standard (PPS)	Spain	2015	67
Annual	First quintile	Purchasing power standard (PPS)	Finland	2015	204
Annual	First quintile	Purchasing power standard (PPS)	France	2015	99
Annual	First quintile	Purchasing power standard (PPS)	Hungary	2015	11
Annual	First quintile	Purchasing power standard (PPS)	Ireland	2015	162


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

Share link

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