Effort Involved In Performing Work-related Physical Activity By Sex, Age And Degree Of Urbanisation

Eurostat code: hlth_ehis_pe1u · (2014 - 2019)

@eurostat.hlth_ehis_pe1u

Table List

2 tables(175.7 KB)

Effort Involved In Performing Work-related Physical Activity By Sex, Age And Degree Of Urbanisation - Raw

Effort Involved In Performing Work-related Physical Activity By Sex, Age And Degree Of Urbanisation - Unpivoted

Effort Involved In Performing Work-related Physical Activity By Sex, Age And Degree Of Urbanisation - Unpivoted

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

83.18 KB
55152 rows
9 columns

freq Freq	levels Levels	deg_urb Deg Urb	sex Sex	age Age	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Heavy	Cities	Females	Total	Percentage	Austria	2014	1.4
Annual	Heavy	Cities	Females	Total	Percentage	Bulgaria	2014	1.4
Annual	Heavy	Cities	Females	Total	Percentage	Cyprus	2014	1.2
Annual	Heavy	Cities	Females	Total	Percentage	Czechia	2014	1.7
Annual	Heavy	Cities	Females	Total	Percentage	Germany	2014	1.7
Annual	Heavy	Cities	Females	Total	Percentage	Denmark	2014	1.8
Annual	Heavy	Cities	Females	Total	Percentage	Estonia	2014	4.6
Annual	Heavy	Cities	Females	Total	Percentage	Greece	2014	5.1
Annual	Heavy	Cities	Females	Total	Percentage	Spain	2014	1.5
Annual	Heavy	Cities	Females	Total	Percentage	European Union - 27 countries (from 2020)	2014	3.4


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