Performing Health-enhancing Physical Activity By Sex, Age And Degree Of Urbanisation

Eurostat code: hlth_ehis_pe9u · (2014 - 2019)

@eurostat.hlth_ehis_pe9u

Table List

2 tables(130.77 KB)

Performing Health-enhancing Physical Activity By Sex, Age And Degree Of Urbanisation - Raw

Performing Health-enhancing Physical Activity By Sex, Age And Degree Of Urbanisation - Unpivoted

Performing Health-enhancing Physical Activity By Sex, Age And Degree Of Urbanisation - Unpivoted

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

61.46 KB
39179 rows
9 columns

freq Freq	physact Physact	deg_urb Deg Urb	sex Sex	age Age	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Aerobic	Cities	Females	Total	Percentage	Austria	2014	46.2
Annual	Aerobic	Cities	Females	Total	Percentage	Bulgaria	2014	7.6
Annual	Aerobic	Cities	Females	Total	Percentage	Cyprus	2014	23.6
Annual	Aerobic	Cities	Females	Total	Percentage	Czechia	2014	21.1
Annual	Aerobic	Cities	Females	Total	Percentage	Germany	2014	46.2
Annual	Aerobic	Cities	Females	Total	Percentage	Denmark	2014	66.1
Annual	Aerobic	Cities	Females	Total	Percentage	Estonia	2014	18.6
Annual	Aerobic	Cities	Females	Total	Percentage	Greece	2014	14.4
Annual	Aerobic	Cities	Females	Total	Percentage	Spain	2014	29.2
Annual	Aerobic	Cities	Females	Total	Percentage	European Union - 27 countries (from 2020)	2014	26


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

Share link

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