Revenues Of Health Care Financing Schemes By Health Care Financing Schemes

Eurostat code: hlth_sha11_hffs · (1992 - 2023)

@eurostat.hlth_sha11_hffs

Table List

2 tables(1.06 MB)

Revenues Of Health Care Financing Schemes By Health Care Financing Schemes - Raw

Revenues Of Health Care Financing Schemes By Health Care Financing Schemes - Unpivoted

Revenues Of Health Care Financing Schemes By Health Care Financing Schemes - Unpivoted

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

511.46 KB
354985 rows
7 columns

freq Freq	unit Unit	icha11_hf Icha11 Hf	icha11_fs Icha11 Fs	geo Geo	time_period Time Period	value Value
Annual	Euro per inhabitant	Government schemes and compulsory contributory health care financing schemes	Transfers from government domestic revenue	Germany	1992	246.01
Annual	Euro per inhabitant	Government schemes and compulsory contributory health care financing schemes	Internal transfers and grants	Germany	1992	229.23
Annual	Euro per inhabitant	Government schemes and compulsory contributory health care financing schemes	Transfers by government on behalf of specific groups	Germany	1992	16.79
Annual	Euro per inhabitant	Government schemes and compulsory contributory health care financing schemes	Social insurance contributions	Germany	1992	1196.62
Annual	Euro per inhabitant	Government schemes and compulsory contributory health care financing schemes	Social insurance contributions from employees	Germany	1992	455.24
Annual	Euro per inhabitant	Government schemes and compulsory contributory health care financing schemes	Social insurance contributions from employers	Germany	1992	472.54
Annual	Euro per inhabitant	Government schemes and compulsory contributory health care financing schemes	Other social insurance contributions	Germany	1992	268.84
Annual	Euro per inhabitant	Government schemes and compulsory contributory health care financing schemes	Other compulsory prepaid revenues	Germany	1992
Annual	Euro per inhabitant	Government schemes and compulsory contributory health care financing schemes	Other voluntary prepaid revenues	Germany	1992
Annual	Euro per inhabitant	Government schemes and compulsory contributory health care financing schemes	Other domestic revenues n.e.c.	Germany	1992	20.44


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

Share link

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