Baselight
Sign In

Self-reported Unmet Needs For Health Care By Sex, Age, Specific Reasons And Income Quintile

Eurostat code: hlth_ehis_un1i ยท (2019 - 2019)

@eurostat.hlth_ehis_un1i

Self-reported Unmet Needs For Health Care By Sex, Age, Specific Reasons And Income Quintile - Unpivoted
@eurostat.hlth_ehis_un1i.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.

  • 42.57 KB
  • 24582 rows
  • 9 columns
freq

Freq

sex

Sex

age

Age

reason

Reason

quant_inc

Quant Inc

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualFemalesTotalDistance or transportationFirst quintilePercentageAustria20195
AnnualFemalesTotalDistance or transportationFirst quintilePercentageBelgium20193.7
AnnualFemalesTotalDistance or transportationFirst quintilePercentageBulgaria20196.4
AnnualFemalesTotalDistance or transportationFirst quintilePercentageCyprus20190.2
AnnualFemalesTotalDistance or transportationFirst quintilePercentageCzechia20199.3
AnnualFemalesTotalDistance or transportationFirst quintilePercentageGermany20197.6
AnnualFemalesTotalDistance or transportationFirst quintilePercentageDenmark20196
AnnualFemalesTotalDistance or transportationFirst quintilePercentageEstonia20195.7
AnnualFemalesTotalDistance or transportationFirst quintilePercentageGreece20199.9
AnnualFemalesTotalDistance or transportationFirst quintilePercentageSpain20192.1

CREATE TABLE tidy (
  "freq" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "reason" VARCHAR,
  "quant_inc" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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