Mean Consumption Expenditure By Degree Of Urbanisation

Eurostat code: hbs_exp_t136 · (1988 - 2020)

@eurostat.hbs_exp_t136

Table List

2 tables(30.95 KB)

Mean Consumption Expenditure By Degree Of Urbanisation - Raw

Mean Consumption Expenditure By Degree Of Urbanisation - Unpivoted

Mean Consumption Expenditure By Degree Of Urbanisation - Unpivoted

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

13.97 KB
1354 rows
6 columns

freq Freq	deg_urb Deg Urb	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Cities	Purchasing power standard (PPS) per adult equivalent	Belgium	1988	9626
Annual	Cities	Purchasing power standard (PPS) per adult equivalent	Germany	1988	10584
Annual	Cities	Purchasing power standard (PPS) per adult equivalent	Greece	1988	9593
Annual	Cities	Purchasing power standard (PPS) per adult equivalent	France	1988	8426
Annual	Cities	Purchasing power standard (PPS) per adult equivalent	Italy	1988	9514
Annual	Cities	Purchasing power standard (PPS) per adult equivalent	Luxembourg	1988	17489
Annual	Cities	Purchasing power standard (PPS) per adult equivalent	Portugal	1988	7001
Annual	Cities	Purchasing power standard (PPS) per adult equivalent	United Kingdom	1988	13426
Annual	Cities	Purchasing power standard (PPS) per household	Belgium	1988	17030
Annual	Cities	Purchasing power standard (PPS) per household	Germany	1988	17618


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

Share link

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