Persons Paying For Formal Education By Household Type, Income Group, Degree Of Urbanisation And Level Of Difficulty To Pay

Eurostat code: ilc_ats07$dv_2703

@eurostat.ilc_ats07_dv_2703

Table List

2 tables(17.34 KB)

Persons Paying For Formal Education By Household Type, Income Group, Degree Of Urbanisation And Level Of Difficulty To Pay - Raw

Persons Paying For Formal Education By Household Type, Income Group, Degree Of Urbanisation And Level Of Difficulty To Pay - Unpivoted

Persons Paying For Formal Education By Household Type, Income Group, Degree Of Urbanisation And Level Of Difficulty To Pay - Unpivoted

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

8.96 KB
648 rows
9 columns

freq Freq	deg_urb Deg Urb	incgrp Incgrp	lev_diff Lev Diff	hhtyp Hhtyp	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Total	Above 60% of median equivalised income	Easy	Households with dependent children	Percentage	Austria	2016	24.9
Annual	Total	Above 60% of median equivalised income	Easy	Households with dependent children	Percentage	Belgium	2016	34.4
Annual	Total	Above 60% of median equivalised income	Easy	Households with dependent children	Percentage	Bulgaria	2016	6.7
Annual	Total	Above 60% of median equivalised income	Easy	Households with dependent children	Percentage	Switzerland	2016	30.7
Annual	Total	Above 60% of median equivalised income	Easy	Households with dependent children	Percentage	Cyprus	2016	6.9
Annual	Total	Above 60% of median equivalised income	Easy	Households with dependent children	Percentage	Czechia	2016	14.5
Annual	Total	Above 60% of median equivalised income	Easy	Households with dependent children	Percentage	Germany	2016	32.9
Annual	Total	Above 60% of median equivalised income	Easy	Households with dependent children	Percentage	Denmark	2016	27.2
Annual	Total	Above 60% of median equivalised income	Easy	Households with dependent children	Percentage	Estonia	2016	28.5
Annual	Total	Above 60% of median equivalised income	Easy	Households with dependent children	Percentage	Greece	2016	3.5


CREATE TABLE tidy (
  "freq" VARCHAR,
  "deg_urb" VARCHAR,
  "incgrp" VARCHAR,
  "lev_diff" VARCHAR,
  "hhtyp" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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