Performing Health-enhancing Physical Activity By Sex, Age And Educational Attainment Level

Eurostat code: hlth_ehis_pe9e$dv_469

@eurostat.hlth_ehis_pe9e_dv_469

Table List

2 tables(59.21 KB)

Performing Health-enhancing Physical Activity By Sex, Age And Educational Attainment Level - Raw

Performing Health-enhancing Physical Activity By Sex, Age And Educational Attainment Level - Unpivoted

Performing Health-enhancing Physical Activity By Sex, Age And Educational Attainment Level - Unpivoted

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

27.82 KB
13295 rows
9 columns

freq Freq	unit Unit	physact Physact	isced11 Isced11	sex Sex	age Age	geo Geo	time_period Time Period	value Value
Annual	Percentage	Aerobic	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Austria	2014	40.9
Annual	Percentage	Aerobic	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Bulgaria	2014	3.2
Annual	Percentage	Aerobic	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Cyprus	2014	14.3
Annual	Percentage	Aerobic	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Czechia	2014	15.7
Annual	Percentage	Aerobic	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Germany	2014	40.2
Annual	Percentage	Aerobic	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Denmark	2014	45.5
Annual	Percentage	Aerobic	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Estonia	2014	12.7
Annual	Percentage	Aerobic	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Greece	2014	5.5
Annual	Percentage	Aerobic	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Spain	2014	21.8
Annual	Percentage	Aerobic	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	European Union - 27 countries (from 2020)	2014	17.7


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