Persons Participating In Training Related To Hobbies By Sex, Age, Income Group, Most Frequent Activity Status And Educational Attainment Level

Eurostat code: ilc_ats09 · (2016 - 2016)

@eurostat.ilc_ats09

Table List

2 tables(126.42 KB)

Persons Participating In Training Related To Hobbies By Sex, Age, Income Group, Most Frequent Activity Status And Educational Attainment Level - Raw

Persons Participating In Training Related To Hobbies By Sex, Age, Income Group, Most Frequent Activity Status And Educational Attainment Level - Unpivoted

Persons Participating In Training Related To Hobbies By Sex, Age, Income Group, Most Frequent Activity Status And Educational Attainment Level - Unpivoted

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

65.07 KB
35990 rows
10 columns

freq Freq	isced11 Isced11	wstatus Wstatus	incgrp Incgrp	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Less than primary, primary and lower secondary education (levels 0-2)	Employed persons	Above 60% of median equivalised income	From 16 to 18 years	Females	Percentage	Austria	2016	24.2
Annual	Less than primary, primary and lower secondary education (levels 0-2)	Employed persons	Above 60% of median equivalised income	From 16 to 18 years	Females	Percentage	Switzerland	2016	59.1
Annual	Less than primary, primary and lower secondary education (levels 0-2)	Employed persons	Above 60% of median equivalised income	From 16 to 18 years	Females	Percentage	Iceland	2016	62.5
Annual	Less than primary, primary and lower secondary education (levels 0-2)	Employed persons	Above 60% of median equivalised income	From 16 to 18 years	Males	Percentage	Austria	2016	33.2
Annual	Less than primary, primary and lower secondary education (levels 0-2)	Employed persons	Above 60% of median equivalised income	From 16 to 18 years	Males	Percentage	Switzerland	2016	23.9
Annual	Less than primary, primary and lower secondary education (levels 0-2)	Employed persons	Above 60% of median equivalised income	From 16 to 18 years	Males	Percentage	Germany	2016	30.1
Annual	Less than primary, primary and lower secondary education (levels 0-2)	Employed persons	Above 60% of median equivalised income	From 16 to 18 years	Males	Percentage	Iceland	2016	64
Annual	Less than primary, primary and lower secondary education (levels 0-2)	Employed persons	Above 60% of median equivalised income	From 16 to 18 years	Total	Percentage	Austria	2016	29.5
Annual	Less than primary, primary and lower secondary education (levels 0-2)	Employed persons	Above 60% of median equivalised income	From 16 to 18 years	Total	Percentage	Switzerland	2016	35.5
Annual	Less than primary, primary and lower secondary education (levels 0-2)	Employed persons	Above 60% of median equivalised income	From 16 to 18 years	Total	Percentage	Germany	2016	35


CREATE TABLE tidy (
  "freq" VARCHAR,
  "isced11" VARCHAR,
  "wstatus" VARCHAR,
  "incgrp" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.