Self-reported Last Colonoscopy By Sex, Age And Degree Of Urbanisation

Eurostat code: hlth_ehis_pa6u · (2014 - 2019)

@eurostat.hlth_ehis_pa6u

Table List

2 tables(175.17 KB)

Self-reported Last Colonoscopy By Sex, Age And Degree Of Urbanisation - Raw

Self-reported Last Colonoscopy By Sex, Age And Degree Of Urbanisation - Unpivoted

Self-reported Last Colonoscopy By Sex, Age And Degree Of Urbanisation - Unpivoted

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

82.8 KB
56013 rows
9 columns

freq Freq	unit Unit	duration Duration	sex Sex	age Age	deg_urb Deg Urb	geo Geo	time_period Time Period	value Value
Annual	Percentage	Never	Females	Total	Cities	Austria	2014	64.8
Annual	Percentage	Never	Females	Total	Cities	Belgium	2014	82.5
Annual	Percentage	Never	Females	Total	Cities	Bulgaria	2014	97.3
Annual	Percentage	Never	Females	Total	Cities	Cyprus	2014	89.4
Annual	Percentage	Never	Females	Total	Cities	Czechia	2014	78.6
Annual	Percentage	Never	Females	Total	Cities	Germany	2014	61.5
Annual	Percentage	Never	Females	Total	Cities	Denmark	2014	77.8
Annual	Percentage	Never	Females	Total	Cities	Estonia	2014	87.1
Annual	Percentage	Never	Females	Total	Cities	Greece	2014	87.1
Annual	Percentage	Never	Females	Total	Cities	Spain	2014	86.5


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

Share link

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