Persons Reporting A Chronic Disease, By Disease, Sex, Age And Income Quintile

Eurostat code: hlth_ehis_cd1i · (2014 - 2019)

@eurostat.hlth_ehis_cd1i

Table List

2 tables(630.55 KB)

Persons Reporting A Chronic Disease, By Disease, Sex, Age And Income Quintile - Raw

Persons Reporting A Chronic Disease, By Disease, Sex, Age And Income Quintile - Unpivoted

Persons Reporting A Chronic Disease, By Disease, Sex, Age And Income Quintile - Unpivoted

@eurostat.hlth_ehis_cd1i.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.

305.48 KB
223038 rows
9 columns

freq Freq	hlth_pb Hlth Pb	sex Sex	age Age	quant_inc Quant Inc	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Allergy	Females	Total	First quintile	Percentage	Austria	2014	25.8
Annual	Allergy	Females	Total	First quintile	Percentage	Belgium	2014	13.4
Annual	Allergy	Females	Total	First quintile	Percentage	Bulgaria	2014	5.1
Annual	Allergy	Females	Total	First quintile	Percentage	Cyprus	2014	7.2
Annual	Allergy	Females	Total	First quintile	Percentage	Czechia	2014	13.6
Annual	Allergy	Females	Total	First quintile	Percentage	Germany	2014	31.6
Annual	Allergy	Females	Total	First quintile	Percentage	Denmark	2014	19.8
Annual	Allergy	Females	Total	First quintile	Percentage	Estonia	2014	12.6
Annual	Allergy	Females	Total	First quintile	Percentage	Greece	2014	11.4
Annual	Allergy	Females	Total	First quintile	Percentage	Spain	2014	17.9


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

Share link

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