Performing Health-enhancing Physical Activity By Level Of Disability (activity Limitation), Sex And Age

Eurostat code: hlth_ehis_pe9d · (2014 - 2019)

@eurostat.hlth_ehis_pe9d

Table List

2 tables(120.95 KB)

Performing Health-enhancing Physical Activity By Level Of Disability (activity Limitation), Sex And Age - Raw

Performing Health-enhancing Physical Activity By Level Of Disability (activity Limitation), Sex And Age - Unpivoted

Performing Health-enhancing Physical Activity By Level Of Disability (activity Limitation), Sex And Age - Unpivoted

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

57.95 KB
34625 rows
9 columns

freq Freq	unit Unit	physact Physact	sex Sex	age Age	lev_limit Lev Limit	geo Geo	time_period Time Period	value Value
Annual	Percentage	Aerobic	Females	Total	Moderate	Austria	2014	44.6
Annual	Percentage	Aerobic	Females	Total	Moderate	Bulgaria	2014	1.9
Annual	Percentage	Aerobic	Females	Total	Moderate	Cyprus	2014	14.2
Annual	Percentage	Aerobic	Females	Total	Moderate	Czechia	2014	15.7
Annual	Percentage	Aerobic	Females	Total	Moderate	Germany	2014	37.9
Annual	Percentage	Aerobic	Females	Total	Moderate	Denmark	2014	50
Annual	Percentage	Aerobic	Females	Total	Moderate	Estonia	2014	15.1
Annual	Percentage	Aerobic	Females	Total	Moderate	Greece	2014	7.5
Annual	Percentage	Aerobic	Females	Total	Moderate	Spain	2014	21.9
Annual	Percentage	Aerobic	Females	Total	Moderate	European Union - 27 countries (from 2020)	2014	19.9


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

Share link

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