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

Eurostat code: hlth_ehis_pe2e$dv_300

@eurostat.hlth_ehis_pe2e_dv_300

Table List

2 tables(85 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_300.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.

39.59 KB
21948 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	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Austria	2014	34.6
Annual	Percentage	Zero minutes	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Bulgaria	2014	93
Annual	Percentage	Zero minutes	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Cyprus	2014	71.9
Annual	Percentage	Zero minutes	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Czechia	2014	68.1
Annual	Percentage	Zero minutes	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Germany	2014	38
Annual	Percentage	Zero minutes	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Denmark	2014	28.9
Annual	Percentage	Zero minutes	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Estonia	2014	70.7
Annual	Percentage	Zero minutes	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Greece	2014	90.5
Annual	Percentage	Zero minutes	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Spain	2014	66.2
Annual	Percentage	Zero minutes	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	European Union - 27 countries (from 2020)	2014	67


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.