Baselight

Need For Help With Personal Care Or Household Activities By Level Of Difficulty Experienced In Those Activities, Age And Income Quintile

Eurostat code: hlth_ehis_tadlhi ยท (2014 - 2019)

@eurostat.hlth_ehis_tadlhi

Need For Help With Personal Care Or Household Activities By Level Of Difficulty Experienced In Those Activities, Age And Income Quintile - Unpivoted
@eurostat.hlth_ehis_tadlhi.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.

  • 25.95 KB
  • 11040 rows
  • 9 columns
freq

Freq

unit

Unit

lev_diff

Lev Diff

assist

Assist

age

Age

quant_inc

Quant Inc

geo

Geo

time_period

Time Period

value

Value

AnnualPercentageLimitedGet enough assistanceFrom 65 to 74 yearsFirst quintileAustria201430.8
AnnualPercentageLimitedGet enough assistanceFrom 65 to 74 yearsFirst quintileBulgaria20146.5
AnnualPercentageLimitedGet enough assistanceFrom 65 to 74 yearsFirst quintileCyprus201429.8
AnnualPercentageLimitedGet enough assistanceFrom 65 to 74 yearsFirst quintileCzechia201415.1
AnnualPercentageLimitedGet enough assistanceFrom 65 to 74 yearsFirst quintileGermany201422.8
AnnualPercentageLimitedGet enough assistanceFrom 65 to 74 yearsFirst quintileDenmark201417.3
AnnualPercentageLimitedGet enough assistanceFrom 65 to 74 yearsFirst quintileGreece201446
AnnualPercentageLimitedGet enough assistanceFrom 65 to 74 yearsFirst quintileSpain201436.6
AnnualPercentageLimitedGet enough assistanceFrom 65 to 74 yearsFirst quintileEuropean Union - 27 countries (from 2020)201427.3
AnnualPercentageLimitedGet enough assistanceFrom 65 to 74 yearsFirst quintileEuropean Union - 28 countries (2013-2020)201432.3

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

Share link

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