Children By Household Type, Income Group, Degree Of Urbanisation And Main Reason For Not Meeting Needs For Formal Childcare Services

Eurostat code: ilc_ats04 · (2016 - 2016)

@eurostat.ilc_ats04

Table List

2 tables(55.29 KB)

Children By Household Type, Income Group, Degree Of Urbanisation And Main Reason For Not Meeting Needs For Formal Childcare Services - Raw

Children By Household Type, Income Group, Degree Of Urbanisation And Main Reason For Not Meeting Needs For Formal Childcare Services - Unpivoted

Children By Household Type, Income Group, Degree Of Urbanisation And Main Reason For Not Meeting Needs For Formal Childcare Services - Unpivoted

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

27.43 KB
13265 rows
9 columns

freq Freq	reason Reason	incgrp Incgrp	hhtyp Hhtyp	deg_urb Deg Urb	unit Unit	geo Geo	time_period Time Period
Annual	Distance	Above 60% of median equivalised income	Single person with dependent children	Cities	Percentage	Austria	2016
Annual	Distance	Above 60% of median equivalised income	Single person with dependent children	Cities	Percentage	Belgium	2016
Annual	Distance	Above 60% of median equivalised income	Single person with dependent children	Cities	Percentage	Switzerland	2016
Annual	Distance	Above 60% of median equivalised income	Single person with dependent children	Cities	Percentage	Czechia	2016
Annual	Distance	Above 60% of median equivalised income	Single person with dependent children	Cities	Percentage	Germany	2016
Annual	Distance	Above 60% of median equivalised income	Single person with dependent children	Cities	Percentage	Denmark	2016
Annual	Distance	Above 60% of median equivalised income	Single person with dependent children	Cities	Percentage	Greece	2016
Annual	Distance	Above 60% of median equivalised income	Single person with dependent children	Cities	Percentage	Spain	2016
Annual	Distance	Above 60% of median equivalised income	Single person with dependent children	Cities	Percentage	Finland	2016
Annual	Distance	Above 60% of median equivalised income	Single person with dependent children	Cities	Percentage	France	2016


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

Share link

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