Baselight

Walking And Cycling At Least 30 Minutes Per Day By Sex, Age And Educational Attainment Level

Eurostat code: hlth_ehis_pe6e ยท (2019 - 2019)

@eurostat.hlth_ehis_pe6e

Walking And Cycling At Least 30 Minutes Per Day By Sex, Age And Educational Attainment Level - Unpivoted
@eurostat.hlth_ehis_pe6e.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.

  • 15.22 KB
  • 5694 rows
  • 8 columns
freq

Freq

isced11

Isced11

sex

Sex

age

Age

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualLess than primary, primary and lower secondary education (levels 0-2)FemalesTotalPercentageAustria201913.7
AnnualLess than primary, primary and lower secondary education (levels 0-2)FemalesTotalPercentageBelgium201910.9
AnnualLess than primary, primary and lower secondary education (levels 0-2)FemalesTotalPercentageBulgaria20195.6
AnnualLess than primary, primary and lower secondary education (levels 0-2)FemalesTotalPercentageCyprus2019
AnnualLess than primary, primary and lower secondary education (levels 0-2)FemalesTotalPercentageCzechia201914.7
AnnualLess than primary, primary and lower secondary education (levels 0-2)FemalesTotalPercentageGermany201913.4
AnnualLess than primary, primary and lower secondary education (levels 0-2)FemalesTotalPercentageDenmark201921.1
AnnualLess than primary, primary and lower secondary education (levels 0-2)FemalesTotalPercentageEstonia201912.3
AnnualLess than primary, primary and lower secondary education (levels 0-2)FemalesTotalPercentageGreece20193.4
AnnualLess than primary, primary and lower secondary education (levels 0-2)FemalesTotalPercentageSpain20192.4

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