Baselight

Persons Using Or Not Professional Homecare Services By Household Type, Income Group, Degree Of Urbanisation And Reason For Not Using Professional Homecare Services

Eurostat code: ilc_ats15 ยท (2016 - 2016)

@eurostat.ilc_ats15

Persons Using Or Not Professional Homecare Services By Household Type, Income Group, Degree Of Urbanisation And Reason For Not Using Professional Homecare Services - Unpivoted
@eurostat.ilc_ats15.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.

  • 37.28 KB
  • 18396 rows
  • 9 columns
freq

Freq

reason

Reason

deg_urb

Deg Urb

incgrp

Incgrp

hhtyp

Hhtyp

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualFinancial reasonsCitiesAbove 60% of median equivalised incomeSingle personPercentageAustria201633.3
AnnualFinancial reasonsCitiesAbove 60% of median equivalised incomeSingle personPercentageBelgium201620.1
AnnualFinancial reasonsCitiesAbove 60% of median equivalised incomeSingle personPercentageBulgaria201655.8
AnnualFinancial reasonsCitiesAbove 60% of median equivalised incomeSingle personPercentageSwitzerland20169.5
AnnualFinancial reasonsCitiesAbove 60% of median equivalised incomeSingle personPercentageCzechia201625.9
AnnualFinancial reasonsCitiesAbove 60% of median equivalised incomeSingle personPercentageGreece201648.7
AnnualFinancial reasonsCitiesAbove 60% of median equivalised incomeSingle personPercentageSpain201645.3
AnnualFinancial reasonsCitiesAbove 60% of median equivalised incomeSingle personPercentageFinland20168.3
AnnualFinancial reasonsCitiesAbove 60% of median equivalised incomeSingle personPercentageFrance201622.9
AnnualFinancial reasonsCitiesAbove 60% of median equivalised incomeSingle personPercentageIceland20162.4

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