Expenditure For Selected Health Care Providers By Health Care Financing Schemes

Eurostat code: hlth_sha11_hphf · (1992 - 2023)

@eurostat.hlth_sha11_hphf

Table List

2 tables(2.33 MB)

Expenditure For Selected Health Care Providers By Health Care Financing Schemes - Raw

Expenditure For Selected Health Care Providers By Health Care Financing Schemes - Unpivoted

Expenditure For Selected Health Care Providers By Health Care Financing Schemes - Unpivoted

@eurostat.hlth_sha11_hphf.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.

1.11 MB
364375 rows
7 columns

freq Freq	unit Unit	icha11_hp Icha11 Hp	icha11_hf Icha11 Hf	geo Geo	time_period Time Period	value Value
Annual	Euro per inhabitant	Hospitals	Government schemes and compulsory contributory health care financing schemes	Germany	1992	517.97
Annual	Euro per inhabitant	Hospitals	Government schemes	Germany	1992	37.01
Annual	Euro per inhabitant	Hospitals	Compulsory contributory health insurance schemes and compulsory medical saving accounts (CMSA)	Germany	1992	480.98
Annual	Euro per inhabitant	Hospitals	Voluntary health care payment schemes	Germany	1992	53.71
Annual	Euro per inhabitant	Hospitals	Voluntary health insurance schemes	Germany	1992	50.02
Annual	Euro per inhabitant	Hospitals	NPISH financing schemes	Germany	1992	2.93
Annual	Euro per inhabitant	Hospitals	Enterprise financing schemes	Germany	1992	0.76
Annual	Euro per inhabitant	Hospitals	Household out-of-pocket payment	Germany	1992	9.03
Annual	Euro per inhabitant	Hospitals	Rest of the world financing schemes (non-resident)	Germany	1992
Annual	Euro per inhabitant	Hospitals	All financing schemes	Germany	1992	580.7


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "icha11_hp" VARCHAR,
  "icha11_hf" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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