Baselight

Children Receiving Formal Childcare Services By Household Type, Income Group, Degree Of Urbanisation And Level Of Difficulty To Afford Formal Childcare Services

Eurostat code: ilc_ats03 ยท (2016 - 2016)

@eurostat.ilc_ats03

Children Receiving Formal Childcare Services By Household Type, Income Group, Degree Of Urbanisation And Level Of Difficulty To Afford Formal Childcare Services - Unpivoted
@eurostat.ilc_ats03.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.

  • 24.44 KB
  • 10032 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

AnnualCitiesAbove 60% of median equivalised incomeEasySingle person with dependent childrenPercentageAustria20163.8
AnnualCitiesAbove 60% of median equivalised incomeEasySingle person with dependent childrenPercentageBelgium201640.4
AnnualCitiesAbove 60% of median equivalised incomeEasySingle person with dependent childrenPercentageSwitzerland201618.5
AnnualCitiesAbove 60% of median equivalised incomeEasySingle person with dependent childrenPercentageCzechia201619
AnnualCitiesAbove 60% of median equivalised incomeEasySingle person with dependent childrenPercentageGermany201623.3
AnnualCitiesAbove 60% of median equivalised incomeEasySingle person with dependent childrenPercentageDenmark201624.8
AnnualCitiesAbove 60% of median equivalised incomeEasySingle person with dependent childrenPercentageFinland201610.1
AnnualCitiesAbove 60% of median equivalised incomeEasySingle person with dependent childrenPercentageFrance20169
AnnualCitiesAbove 60% of median equivalised incomeEasySingle person with dependent childrenPercentageIreland20163.2
AnnualCitiesAbove 60% of median equivalised incomeEasySingle person with dependent childrenPercentageIceland201610.7

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.