Baselight
Sign In

Performing (non-work-related) Physical Activities By Sex, Age And Degree Of Urbanisation

Eurostat code: hlth_ehis_pe3u ยท (2014 - 2019)

@eurostat.hlth_ehis_pe3u

Performing (non-work-related) Physical Activities By Sex, Age And Degree Of Urbanisation - Unpivoted
@eurostat.hlth_ehis_pe3u.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.

  • 84.16 KB
  • 54919 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

AnnualAerobic sportsCitiesFemalesTotalPercentageAustria201469.8
AnnualAerobic sportsCitiesFemalesTotalPercentageBulgaria201411.3
AnnualAerobic sportsCitiesFemalesTotalPercentageCyprus201439.3
AnnualAerobic sportsCitiesFemalesTotalPercentageCzechia201438.7
AnnualAerobic sportsCitiesFemalesTotalPercentageGermany201466.6
AnnualAerobic sportsCitiesFemalesTotalPercentageDenmark201478.5
AnnualAerobic sportsCitiesFemalesTotalPercentageEstonia201443.5
AnnualAerobic sportsCitiesFemalesTotalPercentageGreece201422.4
AnnualAerobic sportsCitiesFemalesTotalPercentageSpain201443.2
AnnualAerobic sportsCitiesFemalesTotalPercentageEuropean Union - 27 countries (from 2020)201441.5

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.