Baselight

Not Employed People Having A Longstanding Health Problem Or A Difficulty In Basic Activities By The Type Of Special Assistance Needed, Sex And Age

Eurostat code: hlth_dlm190 ยท (2011 - 2011)

@eurostat.hlth_dlm190

Not Employed People Having A Longstanding Health Problem Or A Difficulty In Basic Activities By The Type Of Special Assistance Needed, Sex And Age - Unpivoted
@eurostat.hlth_dlm190.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.

  • 27.88 KB
  • 3152 rows
  • 8 columns
freq

Freq

unit

Unit

assist

Assist

age

Age

sex

Sex

geo

Geo

time_period

Time Period

value

Value

AnnualThousandAssistance neededTotalFemalesAustria2011136.331
AnnualThousandAssistance neededTotalFemalesBelgium2011197.136
AnnualThousandAssistance neededTotalFemalesBulgaria201168.416
AnnualThousandAssistance neededTotalFemalesSwitzerland2011122.372
AnnualThousandAssistance neededTotalFemalesCyprus201113.11
AnnualThousandAssistance neededTotalFemalesCzechia2011159.278
AnnualThousandAssistance neededTotalFemalesGermany2011855.912
AnnualThousandAssistance neededTotalFemalesDenmark2011132.678
AnnualThousandAssistance neededTotalFemalesEstonia201116.253
AnnualThousandAssistance neededTotalFemalesGreece2011105.343

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

Share link

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