Persons In Formal Education By Sex, Age, Income Group And Contributor

Eurostat code: ilc_ats06 · (2016 - 2016)

@eurostat.ilc_ats06

Table List

2 tables(51.61 KB)

Persons In Formal Education By Sex, Age, Income Group And Contributor - Raw

Persons In Formal Education By Sex, Age, Income Group And Contributor - Unpivoted

Persons In Formal Education By Sex, Age, Income Group And Contributor - Unpivoted

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

25.59 KB
13335 rows
9 columns

freq Freq	contrib Contrib	incgrp Incgrp	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Employer	Above 60% of median equivalised income	From 13 to 16 years	Females	Percentage	Austria	2016	0.4
Annual	Employer	Above 60% of median equivalised income	From 13 to 16 years	Females	Percentage	Belgium	2016
Annual	Employer	Above 60% of median equivalised income	From 13 to 16 years	Females	Percentage	Bulgaria	2016	0.4
Annual	Employer	Above 60% of median equivalised income	From 13 to 16 years	Females	Percentage	Switzerland	2016	2.5
Annual	Employer	Above 60% of median equivalised income	From 13 to 16 years	Females	Percentage	Cyprus	2016
Annual	Employer	Above 60% of median equivalised income	From 13 to 16 years	Females	Percentage	Czechia	2016
Annual	Employer	Above 60% of median equivalised income	From 13 to 16 years	Females	Percentage	Denmark	2016
Annual	Employer	Above 60% of median equivalised income	From 13 to 16 years	Females	Percentage	Estonia	2016
Annual	Employer	Above 60% of median equivalised income	From 13 to 16 years	Females	Percentage	Greece	2016	0.1
Annual	Employer	Above 60% of median equivalised income	From 13 to 16 years	Females	Percentage	Spain	2016


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