Baselight
Sign In

Performing (non-work-related) Physical Activities By Sex, Age And Income Quintile

Eurostat code: hlth_ehis_pe3i$dv_467

@eurostat.hlth_ehis_pe3i_dv_467

Performing (non-work-related) Physical Activities By Sex, Age And Income Quintile - Unpivoted
@eurostat.hlth_ehis_pe3i_dv_467.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.

  • 46.95 KB
  • 27179 rows
  • 9 columns
freq

Freq

unit

Unit

physact

Physact

quant_inc

Quant Inc

sex

Sex

age

Age

geo

Geo

time_period

Time Period

value

Value

AnnualPercentageAerobic sportsFirst quintileFemalesTotalAustria201467.6
AnnualPercentageAerobic sportsFirst quintileFemalesTotalBelgium2014
AnnualPercentageAerobic sportsFirst quintileFemalesTotalBulgaria20141.9
AnnualPercentageAerobic sportsFirst quintileFemalesTotalCyprus201425.4
AnnualPercentageAerobic sportsFirst quintileFemalesTotalCzechia201425.5
AnnualPercentageAerobic sportsFirst quintileFemalesTotalGermany201457.1
AnnualPercentageAerobic sportsFirst quintileFemalesTotalDenmark201473.5
AnnualPercentageAerobic sportsFirst quintileFemalesTotalEstonia201424.8
AnnualPercentageAerobic sportsFirst quintileFemalesTotalGreece201416
AnnualPercentageAerobic sportsFirst quintileFemalesTotalSpain201431.2

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