Distribution Of Population Aged 18 And Over By Health Status, Age Group, Sex And Degree Of Urbanisation

Eurostat code: ilc_lvhl01 · (2003 - 2024)

@eurostat.ilc_lvhl01

Table List

2 tables(436.76 KB)

Distribution Of Population Aged 18 And Over By Health Status, Age Group, Sex And Degree Of Urbanisation - Raw

Distribution Of Population Aged 18 And Over By Health Status, Age Group, Sex And Degree Of Urbanisation - Unpivoted

Distribution Of Population Aged 18 And Over By Health Status, Age Group, Sex And Degree Of Urbanisation - Unpivoted

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

184.59 KB
130455 rows
9 columns

freq Freq	deg_urb Deg Urb	levels Levels	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Cities	Bad	From 18 to 64 years	Females	Percentage	Austria	2003	2.3
Annual	Cities	Bad	From 18 to 64 years	Females	Percentage	Belgium	2003	6.4
Annual	Cities	Bad	From 18 to 64 years	Females	Percentage	Denmark	2003	4
Annual	Cities	Bad	From 18 to 64 years	Females	Percentage	Greece	2003	3.2
Annual	Cities	Bad	From 18 to 64 years	Females	Percentage	Ireland	2003	2.2
Annual	Cities	Bad	From 18 to 64 years	Females	Percentage	Luxembourg	2003	7.5
Annual	Cities	Bad	From 18 to 64 years	Males	Percentage	Austria	2003	4.4
Annual	Cities	Bad	From 18 to 64 years	Males	Percentage	Belgium	2003	4.6
Annual	Cities	Bad	From 18 to 64 years	Males	Percentage	Denmark	2003	3.3
Annual	Cities	Bad	From 18 to 64 years	Males	Percentage	Greece	2003	2.6


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