Baselight
Sign In

Children Receiving Formal Childcare Services By Age, Income Group And Degree Of Urbanisation

Eurostat code: ilc_ats01 ยท (2016 - 2016)

@eurostat.ilc_ats01

Children Receiving Formal Childcare Services By Age, Income Group And Degree Of Urbanisation - Unpivoted
@eurostat.ilc_ats01.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.

  • 17.48 KB
  • 4722 rows
  • 9 columns
freq

Freq

deg_urb

Deg Urb

cost

Cost

incgrp

Incgrp

age

Age

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualCitiesCost freeAbove 60% of median equivalised incomeFrom minimum compulsory school age to 12 yearsPercentageAustria20162.5
AnnualCitiesCost freeAbove 60% of median equivalised incomeFrom minimum compulsory school age to 12 yearsPercentageBelgium20165.3
AnnualCitiesCost freeAbove 60% of median equivalised incomeFrom minimum compulsory school age to 12 yearsPercentageBulgaria201619.7
AnnualCitiesCost freeAbove 60% of median equivalised incomeFrom minimum compulsory school age to 12 yearsPercentageSwitzerland20165.3
AnnualCitiesCost freeAbove 60% of median equivalised incomeFrom minimum compulsory school age to 12 yearsPercentageCyprus20164.4
AnnualCitiesCost freeAbove 60% of median equivalised incomeFrom minimum compulsory school age to 12 yearsPercentageCzechia20166
AnnualCitiesCost freeAbove 60% of median equivalised incomeFrom minimum compulsory school age to 12 yearsPercentageGermany201613.3
AnnualCitiesCost freeAbove 60% of median equivalised incomeFrom minimum compulsory school age to 12 yearsPercentageDenmark20165.9
AnnualCitiesCost freeAbove 60% of median equivalised incomeFrom minimum compulsory school age to 12 yearsPercentageEstonia201611.2
AnnualCitiesCost freeAbove 60% of median equivalised incomeFrom minimum compulsory school age to 12 yearsPercentageGreece201629.7

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