Time Spent On Health-enhancing (non-work-related) Aerobic Physical Activity By Sex, Age And Educational Attainment Level

Eurostat code: hlth_ehis_pe2e$dv_1144

@eurostat.hlth_ehis_pe2e_dv_1144

Table List

2 tables(16.41 KB)

Time Spent On Health-enhancing (non-work-related) Aerobic Physical Activity By Sex, Age And Educational Attainment Level - Raw

Time Spent On Health-enhancing (non-work-related) Aerobic Physical Activity By Sex, Age And Educational Attainment Level - Unpivoted

Time Spent On Health-enhancing (non-work-related) Aerobic Physical Activity By Sex, Age And Educational Attainment Level - Unpivoted

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

8.09 KB
295 rows
9 columns

freq Freq	unit Unit	duration Duration	isced11 Isced11	sex Sex	age Age	geo Geo	time_period Time Period	value Value
Annual	Percentage	Zero minutes	All ISCED 2011 levels	Total	From 15 to 29 years	Austria	2014	18.4
Annual	Percentage	Zero minutes	All ISCED 2011 levels	Total	From 15 to 29 years	Bulgaria	2014	59.6
Annual	Percentage	Zero minutes	All ISCED 2011 levels	Total	From 15 to 29 years	Cyprus	2014	56.1
Annual	Percentage	Zero minutes	All ISCED 2011 levels	Total	From 15 to 29 years	Czechia	2014	23
Annual	Percentage	Zero minutes	All ISCED 2011 levels	Total	From 15 to 29 years	Germany	2014	20
Annual	Percentage	Zero minutes	All ISCED 2011 levels	Total	From 15 to 29 years	Denmark	2014	12.1
Annual	Percentage	Zero minutes	All ISCED 2011 levels	Total	From 15 to 29 years	Estonia	2014	35.8
Annual	Percentage	Zero minutes	All ISCED 2011 levels	Total	From 15 to 29 years	Greece	2014	47.3
Annual	Percentage	Zero minutes	All ISCED 2011 levels	Total	From 15 to 29 years	Spain	2014	34.4
Annual	Percentage	Zero minutes	All ISCED 2011 levels	Total	From 15 to 29 years	European Union - 27 countries (from 2020)	2014	34.5


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

Share link

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