Baselight

Aggregate Propensity To Consume By Activity Status Of The Reference Person - Experimental Statistics

Eurostat code: icw_sr_16 ยท (2010 - 2020)

@eurostat.icw_sr_16

Aggregate Propensity To Consume By Activity Status Of The Reference Person - Experimental Statistics - Unpivoted
@eurostat.icw_sr_16.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.

  • 7.31 KB
  • 471 rows
  • 6 columns
freq

Freq

wstatus

Wstatus

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualEmployed personsPercentage of disposable incomePortugal201096
AnnualOther persons outside the labour forcePercentage of disposable incomePortugal2010115.2
AnnualNot employed personsPercentage of disposable incomePortugal201082.1
AnnualRetired personsPercentage of disposable incomePortugal201076.7
AnnualEmployeesPercentage of disposable incomePortugal201096.2
AnnualSelf-employed personsPercentage of disposable incomePortugal201097.3
AnnualTotalPercentage of disposable incomeAustria201089.1
AnnualTotalPercentage of disposable incomeBelgium201089.3
AnnualTotalPercentage of disposable incomeCyprus201093
AnnualTotalPercentage of disposable incomeGermany201082.9

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

Share link

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