Health Care Expenditure By Provider

Eurostat code: hlth_sha11_hp · (1992 - 2023)

@eurostat.hlth_sha11_hp

Table List

2 tables(1.05 MB)

Health Care Expenditure By Provider - Raw

Health Care Expenditure By Provider - Unpivoted

Health Care Expenditure By Provider - Unpivoted

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

494.52 KB
118143 rows
6 columns

freq Freq	unit Unit	icha11_hp Icha11 Hp	geo Geo	time_period Time Period	value Value
Annual	Euro per inhabitant	Hospitals	Germany	1992	580.7
Annual	Euro per inhabitant	General hospitals	Germany	1992	511.68
Annual	Euro per inhabitant	Specialised hospitals (other than mental health hospitals)	Germany	1992	69.02
Annual	Euro per inhabitant	Residential long-term care facilities	Germany	1992	122.14
Annual	Euro per inhabitant	Long-term nursing care facilities	Germany	1992	122.14
Annual	Euro per inhabitant	Providers of ambulatory health care	Germany	1992	569.01
Annual	Euro per inhabitant	Medical practices	Germany	1992	267.49
Annual	Euro per inhabitant	Dental practice	Germany	1992	206.2
Annual	Euro per inhabitant	Other health care practitioners	Germany	1992	46.24
Annual	Euro per inhabitant	Ambulatory health care centres	Germany	1992	9.75


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

Share link

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