Persons By Sex, Age, Household Type, Income Group, Degree Of Urbanisation And Main Reason For Not Meeting Needs For Formal Education

Eurostat code: ilc_ats08 · (2016 - 2016)

@eurostat.ilc_ats08

Table List

2 tables(678.82 KB)

Persons By Sex, Age, Household Type, Income Group, Degree Of Urbanisation And Main Reason For Not Meeting Needs For Formal Education - Raw

Persons By Sex, Age, Household Type, Income Group, Degree Of Urbanisation And Main Reason For Not Meeting Needs For Formal Education - Unpivoted

Persons By Sex, Age, Household Type, Income Group, Degree Of Urbanisation And Main Reason For Not Meeting Needs For Formal Education - Unpivoted

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

311.56 KB
190530 rows
11 columns

freq Freq	reason Reason	incgrp Incgrp	deg_urb Deg Urb	hhtyp Hhtyp	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Not admitted to the course or programme	Above 60% of median equivalised income	Cities	Single person	From 19 to 24 years	Females	Percentage	Greece	2016
Annual	Not admitted to the course or programme	Above 60% of median equivalised income	Cities	Single person	From 19 to 24 years	Males	Percentage	Greece	2016
Annual	Not admitted to the course or programme	Above 60% of median equivalised income	Cities	Single person	From 19 to 24 years	Total	Percentage	Greece	2016
Annual	Not admitted to the course or programme	Above 60% of median equivalised income	Cities	Single person	From 19 to 24 years	Total	Percentage	Finland	2016	0.7
Annual	Not admitted to the course or programme	Above 60% of median equivalised income	Cities	Single person	From 19 to 24 years	Total	Percentage	France	2016
Annual	Not admitted to the course or programme	Above 60% of median equivalised income	Cities	Single person	From 19 to 24 years	Total	Percentage	Netherlands	2016
Annual	Not admitted to the course or programme	Above 60% of median equivalised income	Cities	Single person	From 19 to 24 years	Total	Percentage	Poland	2016
Annual	Not admitted to the course or programme	Above 60% of median equivalised income	Cities	Single person	From 25 to 34 years	Females	Percentage	Spain	2016
Annual	Not admitted to the course or programme	Above 60% of median equivalised income	Cities	Single person	From 25 to 34 years	Females	Percentage	Finland	2016	1.7
Annual	Not admitted to the course or programme	Above 60% of median equivalised income	Cities	Single person	From 25 to 34 years	Females	Percentage	France	2016


CREATE TABLE tidy (
  "freq" VARCHAR,
  "reason" VARCHAR,
  "incgrp" VARCHAR,
  "deg_urb" VARCHAR,
  "hhtyp" 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.