Baselight
Sign In

Aggregate Propensity To Consume By Degree Of Urbanisation - Experimental Statistics

Eurostat code: icw_sr_14 ยท (2010 - 2020)

@eurostat.icw_sr_14

Aggregate Propensity To Consume By Degree Of Urbanisation - Experimental Statistics - Unpivoted
@eurostat.icw_sr_14.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.72 KB
  • 338 rows
  • 6 columns
freq

Freq

deg_urb

Deg Urb

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualCitiesPercentage of disposable incomeAustria2010101.1
AnnualCitiesPercentage of disposable incomeBelgium201089.7
AnnualCitiesPercentage of disposable incomeBulgaria201050.5
AnnualCitiesPercentage of disposable incomeCyprus201092.1
AnnualCitiesPercentage of disposable incomeCzechia201069.6
AnnualCitiesPercentage of disposable incomeGermany201084.3
AnnualCitiesPercentage of disposable incomeDenmark201096.1
AnnualCitiesPercentage of disposable incomeEstonia201068.3
AnnualCitiesPercentage of disposable incomeGreece2010122.3
AnnualCitiesPercentage of disposable incomeSpain201079.9

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