Baselight

Self-reported Unmet Needs For Specific Health Care-related Services Due To Financial Reasons By Sex, Age And Income Quintile

Eurostat code: hlth_ehis_un2i ยท (2019 - 2019)

@eurostat.hlth_ehis_un2i

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

  • 53.24 KB
  • 31594 rows
  • 9 columns
freq

Freq

sex

Sex

age

Age

hlthcare

Hlthcare

quant_inc

Quant Inc

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualFemalesTotalDental careFirst quintilePercentageAustria201912.6
AnnualFemalesTotalDental careFirst quintilePercentageBulgaria201922.5
AnnualFemalesTotalDental careFirst quintilePercentageCyprus20196.8
AnnualFemalesTotalDental careFirst quintilePercentageCzechia20195.8
AnnualFemalesTotalDental careFirst quintilePercentageGermany201914.1
AnnualFemalesTotalDental careFirst quintilePercentageDenmark201924
AnnualFemalesTotalDental careFirst quintilePercentageEstonia201932.6
AnnualFemalesTotalDental careFirst quintilePercentageGreece201927
AnnualFemalesTotalDental careFirst quintilePercentageSpain201919.7
AnnualFemalesTotalDental careFirst quintilePercentageEuropean Union - 27 countries (from 2020)201919

CREATE TABLE tidy (
  "freq" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "hlthcare" 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.