Expenditure For Selected Health Care Functions By Health Care Providers

Eurostat code: hlth_sha11_hchp · (1992 - 2023)

@eurostat.hlth_sha11_hchp

Table List

2 tables(2.69 MB)

Expenditure For Selected Health Care Functions By Health Care Providers - Raw

Expenditure For Selected Health Care Functions By Health Care Providers - Unpivoted

Expenditure For Selected Health Care Functions By Health Care Providers - Unpivoted

@eurostat.hlth_sha11_hchp.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.3 MB
561433 rows
7 columns

freq Freq	unit Unit	icha11_hc Icha11 Hc	icha11_hp Icha11 Hp	geo Geo	time_period Time Period	value Value
Annual	Euro per inhabitant	Inpatient curative and rehabilitative care	Hospitals	Germany	1992	551.26
Annual	Euro per inhabitant	Inpatient curative and rehabilitative care	Providers of ambulatory health care	Germany	1992	0.05
Annual	Euro per inhabitant	Inpatient curative and rehabilitative care	Rest of the world	Germany	1992	2.05
Annual	Euro per inhabitant	Inpatient curative and rehabilitative care	All providers of health care	Germany	1992	553.34
Annual	Euro per inhabitant	Day curative and rehabilitative care	Hospitals	Germany	1992	2.47
Annual	Euro per inhabitant	Day curative and rehabilitative care	All providers of health care	Germany	1992	2.47
Annual	Euro per inhabitant	Outpatient curative and rehabilitative care	Hospitals	Germany	1992	14.93
Annual	Euro per inhabitant	Outpatient curative and rehabilitative care	Providers of ambulatory health care	Germany	1992	454.94
Annual	Euro per inhabitant	Outpatient curative and rehabilitative care	Providers of health care system administration and financing	Germany	1992	4.5
Annual	Euro per inhabitant	Outpatient curative and rehabilitative care	Rest of the world	Germany	1992	2.14


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

Share link

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