Baselight

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

Eurostat code: hlth_ehis_pc1u ยท (2014 - 2019)

@eurostat.hlth_ehis_pc1u

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

  • 104.91 KB
  • 72912 rows
  • 10 columns
freq

Freq

hlth_pb

Hlth Pb

lev_limit

Lev Limit

deg_urb

Deg Urb

sex

Sex

age

Age

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualBathing or showeringLimitedCitiesFemalesFrom 65 to 74 yearsPercentageAustria20146
AnnualBathing or showeringLimitedCitiesFemalesFrom 65 to 74 yearsPercentageBelgium201411.3
AnnualBathing or showeringLimitedCitiesFemalesFrom 65 to 74 yearsPercentageBulgaria201412.3
AnnualBathing or showeringLimitedCitiesFemalesFrom 65 to 74 yearsPercentageCyprus20147.6
AnnualBathing or showeringLimitedCitiesFemalesFrom 65 to 74 yearsPercentageCzechia201413.1
AnnualBathing or showeringLimitedCitiesFemalesFrom 65 to 74 yearsPercentageGermany201410.8
AnnualBathing or showeringLimitedCitiesFemalesFrom 65 to 74 yearsPercentageDenmark20144.5
AnnualBathing or showeringLimitedCitiesFemalesFrom 65 to 74 yearsPercentageEstonia20144.8
AnnualBathing or showeringLimitedCitiesFemalesFrom 65 to 74 yearsPercentageGreece201410.1
AnnualBathing or showeringLimitedCitiesFemalesFrom 65 to 74 yearsPercentageSpain20146.4

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

Share link

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