Baselight

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

Eurostat code: hlth_ehis_tadlh ยท (2014 - 2019)

@eurostat.hlth_ehis_tadlh

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

  • 18.92 KB
  • 6618 rows
  • 9 columns
freq

Freq

unit

Unit

lev_diff

Lev Diff

sex

Sex

age

Age

assist

Assist

geo

Geo

time_period

Time Period

value

Value

AnnualPercentageLimitedFemalesFrom 65 to 74 yearsGet enough assistanceAustria201438.5
AnnualPercentageLimitedFemalesFrom 65 to 74 yearsGet enough assistanceBulgaria201411.8
AnnualPercentageLimitedFemalesFrom 65 to 74 yearsGet enough assistanceCyprus201434.5
AnnualPercentageLimitedFemalesFrom 65 to 74 yearsGet enough assistanceCzechia201411.4
AnnualPercentageLimitedFemalesFrom 65 to 74 yearsGet enough assistanceGermany201431.4
AnnualPercentageLimitedFemalesFrom 65 to 74 yearsGet enough assistanceDenmark201418
AnnualPercentageLimitedFemalesFrom 65 to 74 yearsGet enough assistanceEstonia201462.1
AnnualPercentageLimitedFemalesFrom 65 to 74 yearsGet enough assistanceGreece201446.8
AnnualPercentageLimitedFemalesFrom 65 to 74 yearsGet enough assistanceSpain201439.2
AnnualPercentageLimitedFemalesFrom 65 to 74 yearsGet enough assistanceEuropean Union - 27 countries (from 2020)201432.5

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

Share link

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