Baselight

Persons Providing Informal Care Or Assistance By Sex, Age, Degree Of Urbanisation, Most Frequent Activity Status And Frequency

Eurostat code: ilc_ats18 ยท (2016 - 2016)

@eurostat.ilc_ats18

Persons Providing Informal Care Or Assistance By Sex, Age, Degree Of Urbanisation, Most Frequent Activity Status And Frequency - Unpivoted
@eurostat.ilc_ats18.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.

  • 55.56 KB
  • 30588 rows
  • 10 columns
freq

Freq

frequenc

Frequenc

deg_urb

Deg Urb

wstatus

Wstatus

age

Age

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualFrom 10 to 19 hours per weekCitiesEmployed personsFrom 16 to 24 yearsTotalPercentageNetherlands2016
AnnualFrom 10 to 19 hours per weekCitiesEmployed personsFrom 16 to 24 yearsTotalPercentageNorway201610.3
AnnualFrom 10 to 19 hours per weekCitiesEmployed personsFrom 16 to 24 yearsTotalPercentageUnited Kingdom20167
AnnualFrom 10 to 19 hours per weekCitiesEmployed personsFrom 25 to 34 yearsFemalesPercentageSpain201619.2
AnnualFrom 10 to 19 hours per weekCitiesEmployed personsFrom 25 to 34 yearsFemalesPercentageFrance201618.7
AnnualFrom 10 to 19 hours per weekCitiesEmployed personsFrom 25 to 34 yearsFemalesPercentageMalta201632.3
AnnualFrom 10 to 19 hours per weekCitiesEmployed personsFrom 25 to 34 yearsFemalesPercentageNetherlands20161.3
AnnualFrom 10 to 19 hours per weekCitiesEmployed personsFrom 25 to 34 yearsFemalesPercentageUnited Kingdom20166.8
AnnualFrom 10 to 19 hours per weekCitiesEmployed personsFrom 25 to 34 yearsMalesPercentageEstonia20168.2
AnnualFrom 10 to 19 hours per weekCitiesEmployed personsFrom 25 to 34 yearsMalesPercentageSpain201621.7

CREATE TABLE tidy (
  "freq" VARCHAR,
  "frequenc" VARCHAR,
  "deg_urb" VARCHAR,
  "wstatus" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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