Time Spent On Health-enhancing (non-work-related) Aerobic Physical Activity By Sex, Age And Income Quintile

Eurostat code: hlth_ehis_pe2i$dv_465

@eurostat.hlth_ehis_pe2i_dv_465

Table List

2 tables(85.21 KB)

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

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

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

@eurostat.hlth_ehis_pe2i_dv_465.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.62 KB
22130 rows
9 columns

freq Freq	unit Unit	quant_inc Quant Inc	duration Duration	sex Sex	age Age	geo Geo	time_period Time Period	value Value
Annual	Percentage	First quintile	Zero minutes	Females	Total	Austria	2014	29.4
Annual	Percentage	First quintile	Zero minutes	Females	Total	Bulgaria	2014	95.7
Annual	Percentage	First quintile	Zero minutes	Females	Total	Cyprus	2014	73.8
Annual	Percentage	First quintile	Zero minutes	Females	Total	Czechia	2014	61.4
Annual	Percentage	First quintile	Zero minutes	Females	Total	Germany	2014	36.8
Annual	Percentage	First quintile	Zero minutes	Females	Total	Denmark	2014	21.2
Annual	Percentage	First quintile	Zero minutes	Females	Total	Estonia	2014	61.8
Annual	Percentage	First quintile	Zero minutes	Females	Total	Greece	2014	83.3
Annual	Percentage	First quintile	Zero minutes	Females	Total	Spain	2014	65.9
Annual	Percentage	First quintile	Zero minutes	Females	Total	European Union - 27 countries (from 2020)	2014	61.1


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