Expenditure For Selected Health Care Functions By Health Care Financing Schemes

Eurostat code: hlth_sha11_hchf · (1992 - 2023)

@eurostat.hlth_sha11_hchf

Table List

2 tables(3.9 MB)

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

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

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

@eurostat.hlth_sha11_hchf.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.89 MB
618506 rows
7 columns

freq Freq	unit Unit	icha11_hc Icha11 Hc	icha11_hf Icha11 Hf	geo Geo	time_period Time Period	value Value
Annual	Euro per inhabitant	Inpatient curative and rehabilitative care	Government schemes and compulsory contributory health care financing schemes	Germany	1992	495.93
Annual	Euro per inhabitant	Inpatient curative and rehabilitative care	Government schemes	Germany	1992	34.46
Annual	Euro per inhabitant	Inpatient curative and rehabilitative care	Compulsory contributory health insurance schemes and compulsory medical saving accounts (CMSA)	Germany	1992	461.45
Annual	Euro per inhabitant	Inpatient curative and rehabilitative care	Voluntary health care payment schemes	Germany	1992	48.51
Annual	Euro per inhabitant	Inpatient curative and rehabilitative care	Voluntary health insurance schemes	Germany	1992	44.9
Annual	Euro per inhabitant	Inpatient curative and rehabilitative care	NPISH financing schemes	Germany	1992	2.91
Annual	Euro per inhabitant	Inpatient curative and rehabilitative care	Enterprise financing schemes	Germany	1992	0.71
Annual	Euro per inhabitant	Inpatient curative and rehabilitative care	Household out-of-pocket payment	Germany	1992	8.92
Annual	Euro per inhabitant	Inpatient curative and rehabilitative care	Rest of the world financing schemes (non-resident)	Germany	1992
Annual	Euro per inhabitant	Inpatient curative and rehabilitative care	All financing schemes	Germany	1992	553.34


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

Share link

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