Correction Of Vision Problems By Sex, Age And Degree Of Urbanisation

Eurostat code: hlth_ehis_viu · (2014 - 2019)

@eurostat.hlth_ehis_viu

Table List

2 tables(185.39 KB)

Correction Of Vision Problems By Sex, Age And Degree Of Urbanisation - Raw

Correction Of Vision Problems By Sex, Age And Degree Of Urbanisation - Unpivoted

Correction Of Vision Problems By Sex, Age And Degree Of Urbanisation - Unpivoted

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

87.62 KB
59922 rows
9 columns

freq Freq	hlth_pb Hlth Pb	deg_urb Deg Urb	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Vision difficulty corrected with remaining eye health problem	Cities	Total	Females	Percentage	Austria	2014	12.3
Annual	Vision difficulty corrected with remaining eye health problem	Cities	Total	Females	Percentage	Belgium	2014	14.3
Annual	Vision difficulty corrected with remaining eye health problem	Cities	Total	Females	Percentage	Bulgaria	2014	15.3
Annual	Vision difficulty corrected with remaining eye health problem	Cities	Total	Females	Percentage	Cyprus	2014	4.4
Annual	Vision difficulty corrected with remaining eye health problem	Cities	Total	Females	Percentage	Czechia	2014	19.1
Annual	Vision difficulty corrected with remaining eye health problem	Cities	Total	Females	Percentage	Germany	2014	16.3
Annual	Vision difficulty corrected with remaining eye health problem	Cities	Total	Females	Percentage	Denmark	2014	14.5
Annual	Vision difficulty corrected with remaining eye health problem	Cities	Total	Females	Percentage	Estonia	2014	11.2
Annual	Vision difficulty corrected with remaining eye health problem	Cities	Total	Females	Percentage	Greece	2014	15.2
Annual	Vision difficulty corrected with remaining eye health problem	Cities	Total	Females	Percentage	Spain	2014	9.3


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