Children Receiving Paid Formal Childcare Services By Age, Household Type, Income Group And Contributor

Eurostat code: ilc_ats02 · (2016 - 2016)

@eurostat.ilc_ats02

Table List

2 tables(42.15 KB)

Children Receiving Paid Formal Childcare Services By Age, Household Type, Income Group And Contributor - Raw

Children Receiving Paid Formal Childcare Services By Age, Household Type, Income Group And Contributor - Unpivoted

Children Receiving Paid Formal Childcare Services By Age, Household Type, Income Group And Contributor - Unpivoted

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

20.73 KB
10164 rows
9 columns

freq Freq	hhtyp Hhtyp	incgrp Incgrp	contrib Contrib	age Age	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Single person with dependent children	Above 60% of median equivalised income	Employer	From minimum compulsory school age to 12 years	Percentage	Austria	2016
Annual	Single person with dependent children	Above 60% of median equivalised income	Employer	From minimum compulsory school age to 12 years	Percentage	Belgium	2016
Annual	Single person with dependent children	Above 60% of median equivalised income	Employer	From minimum compulsory school age to 12 years	Percentage	Switzerland	2016	2.8
Annual	Single person with dependent children	Above 60% of median equivalised income	Employer	From minimum compulsory school age to 12 years	Percentage	Czechia	2016
Annual	Single person with dependent children	Above 60% of median equivalised income	Employer	From minimum compulsory school age to 12 years	Percentage	Denmark	2016
Annual	Single person with dependent children	Above 60% of median equivalised income	Employer	From minimum compulsory school age to 12 years	Percentage	Greece	2016
Annual	Single person with dependent children	Above 60% of median equivalised income	Employer	From minimum compulsory school age to 12 years	Percentage	European Union - 27 countries (2007-2013)	2016	0.4
Annual	Single person with dependent children	Above 60% of median equivalised income	Employer	From minimum compulsory school age to 12 years	Percentage	European Union - 28 countries (2013-2020)	2016	0.4
Annual	Single person with dependent children	Above 60% of median equivalised income	Employer	From minimum compulsory school age to 12 years	Percentage	France	2016
Annual	Single person with dependent children	Above 60% of median equivalised income	Employer	From minimum compulsory school age to 12 years	Percentage	Ireland	2016


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