People Reporting A Chronic Disease, By Disease, Sex, Age And Educational Attainment Level (%)

Eurostat code: hlth_ehis_st1 · (2008 - 2008)

@eurostat.hlth_ehis_st1

Table List

2 tables(41.76 KB)

People Reporting A Chronic Disease, By Disease, Sex, Age And Educational Attainment Level (%) - Raw

People Reporting A Chronic Disease, By Disease, Sex, Age And Educational Attainment Level (%) - Unpivoted

People Reporting A Chronic Disease, By Disease, Sex, Age And Educational Attainment Level (%) - Unpivoted

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

20.92 KB
7547 rows
8 columns

freq Freq	icd10 Icd10	sex Sex	age Age	isced97 Isced97	geo Geo	time_period Time Period	value Value
Annual	Diabetes mellitus	Females	Total	Pre-primary, primary and lower secondary education (levels 0-2)	Austria	2008	10.7
Annual	Diabetes mellitus	Females	Total	Pre-primary, primary and lower secondary education (levels 0-2)	Belgium	2008	7.1
Annual	Diabetes mellitus	Females	Total	Pre-primary, primary and lower secondary education (levels 0-2)	Bulgaria	2008	7.2
Annual	Diabetes mellitus	Females	Total	Pre-primary, primary and lower secondary education (levels 0-2)	Cyprus	2008	9.4
Annual	Diabetes mellitus	Females	Total	Pre-primary, primary and lower secondary education (levels 0-2)	Czechia	2008	10.6
Annual	Diabetes mellitus	Females	Total	Pre-primary, primary and lower secondary education (levels 0-2)	Germany	2008	11.5
Annual	Diabetes mellitus	Females	Total	Pre-primary, primary and lower secondary education (levels 0-2)	Estonia	2008	7.6
Annual	Diabetes mellitus	Females	Total	Pre-primary, primary and lower secondary education (levels 0-2)	Greece	2008	15.2
Annual	Diabetes mellitus	Females	Total	Pre-primary, primary and lower secondary education (levels 0-2)	Spain	2008	9
Annual	Diabetes mellitus	Females	Total	Pre-primary, primary and lower secondary education (levels 0-2)	France	2008	8.3


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

Share link

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