Baselight

Persons With Disabilities By Sex, Need For Assistance And Having A Longstanding Health Problem

Eurostat code: hlth_dpeh170 ยท (2012 - 2012)

@eurostat.hlth_dpeh170

Persons With Disabilities By Sex, Need For Assistance And Having A Longstanding Health Problem - Unpivoted
@eurostat.hlth_dpeh170.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.

  • 10.56 KB
  • 719 rows
  • 8 columns
freq

Freq

unit

Unit

hlth_pb

Hlth Pb

assist

Assist

sex

Sex

geo

Geo

time_period

Time Period

value

Value

AnnualThousandLong-standing health condition, illness or diseaseAssistance neededFemalesAustria2012141.7
AnnualThousandLong-standing health condition, illness or diseaseAssistance neededFemalesBelgium2012379.6
AnnualThousandLong-standing health condition, illness or diseaseAssistance neededFemalesBulgaria2012252.7
AnnualThousandLong-standing health condition, illness or diseaseAssistance neededFemalesCyprus201218.3
AnnualThousandLong-standing health condition, illness or diseaseAssistance neededFemalesCzechia2012239
AnnualThousandLong-standing health condition, illness or diseaseAssistance neededFemalesGermany20122301.6
AnnualThousandLong-standing health condition, illness or diseaseAssistance neededFemalesDenmark2012135.2
AnnualThousandLong-standing health condition, illness or diseaseAssistance neededFemalesEstonia201261.3
AnnualThousandLong-standing health condition, illness or diseaseAssistance neededFemalesEuropean Economic Area (EEA18-1995, EEA28-2004, EEA30-2007, EEA31-2013, EEA30-2020)201216499.4
AnnualThousandLong-standing health condition, illness or diseaseAssistance neededFemalesGreece2012435.9

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

Share link

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