Non-residents Among All Hospital Discharges, %

Eurostat code: hlth_co_dischnr · (2003 - 2019)

@eurostat.hlth_co_dischnr

Table List

2 tables(26.37 KB)

Non-residents Among All Hospital Discharges, % - Raw

Non-residents Among All Hospital Discharges, % - Unpivoted

Non-residents Among All Hospital Discharges, % - Unpivoted

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

7.57 KB
793 rows
6 columns

freq Freq	unit Unit	indic_he Indic He	geo Geo	time_period Time Period	value Value
Annual	Percentage	Bed-days	Switzerland	2003	3.56
Annual	Percentage	in-patients (total number)	Switzerland	2003	3.1
Annual	Percentage	Bed-days	Switzerland	2004	3.15
Annual	Percentage	Bed-days	Hungary	2004	0.54
Annual	Percentage	Discharges	Hungary	2004	0.69
Annual	Percentage	in-patients (total number)	Switzerland	2004	2.97
Annual	Percentage	in-patients (total number)	Hungary	2004	0.69
Annual	Percentage	Day cases (total number)	Hungary	2004	0.86
Annual	Percentage	Bed-days	Austria	2005	1.15
Annual	Percentage	Bed-days	Switzerland	2005	2.71


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

Share link

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