People Having A Long-standing Illness Or Health Problem, By Sex, Age And Income Quintile

Eurostat code: hlth_silc_11$dv_1148

@eurostat.hlth_silc_11_dv_1148

Table List

2 tables(25.56 KB)

People Having A Long-standing Illness Or Health Problem, By Sex, Age And Income Quintile - Raw

People Having A Long-standing Illness Or Health Problem, By Sex, Age And Income Quintile - Unpivoted

People Having A Long-standing Illness Or Health Problem, By Sex, Age And Income Quintile - Unpivoted

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

9.12 KB
1241 rows
8 columns

freq Freq	unit Unit	quantile Quantile	age Age	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Percentage	Total	From 16 to 19 years	Total	Austria	2015	11.6
Annual	Percentage	Total	From 16 to 19 years	Total	Belgium	2015	8.2
Annual	Percentage	Total	From 16 to 19 years	Total	Bulgaria	2015	5.1
Annual	Percentage	Total	From 16 to 19 years	Total	Switzerland	2015	21.4
Annual	Percentage	Total	From 16 to 19 years	Total	Cyprus	2015	6.5
Annual	Percentage	Total	From 16 to 19 years	Total	Czechia	2015	9
Annual	Percentage	Total	From 16 to 19 years	Total	Germany	2015	16.8
Annual	Percentage	Total	From 16 to 19 years	Total	Denmark	2015	15.6
Annual	Percentage	Total	From 16 to 19 years	Total	Estonia	2015	15.9
Annual	Percentage	Total	From 16 to 19 years	Total	Greece	2015	3.7


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