Health Care Expenditure By Function

Eurostat code: hlth_sha11_hc · (1992 - 2023)

@eurostat.hlth_sha11_hc

Table List

2 tables(1.46 MB)

Health Care Expenditure By Function - Raw

Health Care Expenditure By Function - Unpivoted

Health Care Expenditure By Function - Unpivoted

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

698.61 KB
160957 rows
6 columns

freq Freq	unit Unit	icha11_hc Icha11 Hc	geo Geo	time_period Time Period	value Value
Annual	Euro per inhabitant	Curative care	Germany	1992	974.13
Annual	Euro per inhabitant	Inpatient curative care	Germany	1992	488.16
Annual	Euro per inhabitant	Inpatient curative and rehabilitative care	Germany	1992	553.34
Annual	Euro per inhabitant	Day curative care	Germany	1992	2.47
Annual	Euro per inhabitant	Day curative and rehabilitative care	Germany	1992	2.47
Annual	Euro per inhabitant	Outpatient curative care	Germany	1992	473.02
Annual	Euro per inhabitant	General outpatient curative care	Germany	1992	127.59
Annual	Euro per inhabitant	Dental outpatient curative care	Germany	1992	201.46
Annual	Euro per inhabitant	Specialised outpatient curative care	Germany	1992	98.08
Annual	Euro per inhabitant	All other outpatient curative care n.e.c.	Germany	1992	45.88


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

Share link

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