Baselight
Sign In

Performing (non-work-related) Physical Activities By Sex, Age And Educational Attainment Level

Eurostat code: hlth_ehis_pe3e$dv_296

@eurostat.hlth_ehis_pe3e_dv_296

Performing (non-work-related) Physical Activities By Sex, Age And Educational Attainment Level - Unpivoted
@eurostat.hlth_ehis_pe3e_dv_296.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.

  • 8.12 KB
  • 250 rows
  • 9 columns
freq

Freq

unit

Unit

physact

Physact

isced11

Isced11

sex

Sex

age

Age

geo

Geo

time_period

Time Period

value

Value

AnnualPercentageAerobic sportsAll ISCED 2011 levelsTotalTotalAustria201472
AnnualPercentageAerobic sportsAll ISCED 2011 levelsTotalTotalBulgaria201410.8
AnnualPercentageAerobic sportsAll ISCED 2011 levelsTotalTotalCyprus201438.8
AnnualPercentageAerobic sportsAll ISCED 2011 levelsTotalTotalCzechia201434.7
AnnualPercentageAerobic sportsAll ISCED 2011 levelsTotalTotalGermany201465.7
AnnualPercentageAerobic sportsAll ISCED 2011 levelsTotalTotalDenmark201473.8
AnnualPercentageAerobic sportsAll ISCED 2011 levelsTotalTotalEstonia201435.2
AnnualPercentageAerobic sportsAll ISCED 2011 levelsTotalTotalGreece201422.8
AnnualPercentageAerobic sportsAll ISCED 2011 levelsTotalTotalSpain201446.3
AnnualPercentageAerobic sportsAll ISCED 2011 levelsTotalTotalEuropean Union - 27 countries (from 2020)201442.8

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