Baselight

Difficulties In Personal Care Activities Or Household Activities By Sex, Age And Degree Of Urbanisation

Eurostat code: hlth_ehis_tau ยท (2014 - 2019)

@eurostat.hlth_ehis_tau

Difficulties In Personal Care Activities Or Household Activities By Sex, Age And Degree Of Urbanisation - Unpivoted
@eurostat.hlth_ehis_tau.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.

  • 26.56 KB
  • 12392 rows
  • 9 columns
freq

Freq

deg_urb

Deg Urb

sex

Sex

age

Age

lev_diff

Lev Diff

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualCitiesFemalesFrom 65 to 74 yearsLimitedPercentageAustria201429.9
AnnualCitiesFemalesFrom 65 to 74 yearsLimitedPercentageBelgium201441.3
AnnualCitiesFemalesFrom 65 to 74 yearsLimitedPercentageBulgaria201450.8
AnnualCitiesFemalesFrom 65 to 74 yearsLimitedPercentageCyprus201449.3
AnnualCitiesFemalesFrom 65 to 74 yearsLimitedPercentageCzechia201463.6
AnnualCitiesFemalesFrom 65 to 74 yearsLimitedPercentageGermany201434
AnnualCitiesFemalesFrom 65 to 74 yearsLimitedPercentageDenmark201429.8
AnnualCitiesFemalesFrom 65 to 74 yearsLimitedPercentageEstonia201414.5
AnnualCitiesFemalesFrom 65 to 74 yearsLimitedPercentageGreece201442.2
AnnualCitiesFemalesFrom 65 to 74 yearsLimitedPercentageSpain201440.9

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

Share link

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