People Having A Long-standing Illness Or Health Problem, By Sex, Age And Degree Of Urbanisation

Eurostat code: hlth_silc_19 · (2003 - 2024)

@eurostat.hlth_silc_19

Table List

2 tables(470.18 KB)

People Having A Long-standing Illness Or Health Problem, By Sex, Age And Degree Of Urbanisation - Raw

People Having A Long-standing Illness Or Health Problem, By Sex, Age And Degree Of Urbanisation - Unpivoted

People Having A Long-standing Illness Or Health Problem, By Sex, Age And Degree Of Urbanisation - Unpivoted

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

197.84 KB
127309 rows
8 columns

freq Freq	deg_urb Deg Urb	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Cities	From 16 to 24 years	Females	Percentage	Austria	2003	4.9
Annual	Cities	From 16 to 24 years	Females	Percentage	Belgium	2003	13.2
Annual	Cities	From 16 to 24 years	Females	Percentage	Denmark	2003	17.2
Annual	Cities	From 16 to 24 years	Females	Percentage	Greece	2003	1.7
Annual	Cities	From 16 to 24 years	Females	Percentage	Ireland	2003	8.7
Annual	Cities	From 16 to 24 years	Females	Percentage	Luxembourg	2003	10.9
Annual	Cities	From 16 to 24 years	Males	Percentage	Austria	2003	5.8
Annual	Cities	From 16 to 24 years	Males	Percentage	Belgium	2003	10.4
Annual	Cities	From 16 to 24 years	Males	Percentage	Denmark	2003	15.9
Annual	Cities	From 16 to 24 years	Males	Percentage	Greece	2003	3.4


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

Share link

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