Baselight
Sign In

Persons Reporting A Chronic Disease, By Disease, Sex, Age And Degree Of Urbanisation

Eurostat code: hlth_ehis_cd1u ยท (2014 - 2019)

@eurostat.hlth_ehis_cd1u

Persons Reporting A Chronic Disease, By Disease, Sex, Age And Degree Of Urbanisation - Unpivoted
@eurostat.hlth_ehis_cd1u.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.

  • 211.62 KB
  • 156460 rows
  • 9 columns
freq

Freq

hlth_pb

Hlth Pb

deg_urb

Deg Urb

sex

Sex

age

Age

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualAllergyCitiesFemalesTotalPercentageAustria201427.5
AnnualAllergyCitiesFemalesTotalPercentageBelgium201416.5
AnnualAllergyCitiesFemalesTotalPercentageBulgaria20146
AnnualAllergyCitiesFemalesTotalPercentageCyprus20148.7
AnnualAllergyCitiesFemalesTotalPercentageCzechia201417
AnnualAllergyCitiesFemalesTotalPercentageGermany201434.2
AnnualAllergyCitiesFemalesTotalPercentageDenmark201418.8
AnnualAllergyCitiesFemalesTotalPercentageEstonia201414.9
AnnualAllergyCitiesFemalesTotalPercentageGreece201413
AnnualAllergyCitiesFemalesTotalPercentageSpain201416.9

CREATE TABLE tidy (
  "freq" VARCHAR,
  "hlth_pb" 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.