In-patient Average Length Of Stay (days) By NUTS 2 Region - Males

Eurostat code: hlth_co_inpstm · (1999 - 2021)

@eurostat.hlth_co_inpstm

Table List

2 tables(25.37 MB)

In-patient Average Length Of Stay (days) By NUTS 2 Region - Males - Raw

In-patient Average Length Of Stay (days) By NUTS 2 Region - Males - Unpivoted

In-patient Average Length Of Stay (days) By NUTS 2 Region - Males - Unpivoted

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

12.71 MB
8473961 rows
9 columns

freq Freq	age Age	indic_he Indic He	unit Unit	sex Sex	icd10 Icd10	geo Geo	time_period Time Period	value Value
Annual	Total	In-patient average length of stay (in days)	Number	Males	All causes of diseases (A00-Z99) excluding V00-Y98	Iceland	1999	6.4
Annual	Total	In-patient average length of stay (in days)	Number	Males	All causes of diseases (A00-Z99) excluding V00-Y98 and Z38	Iceland	1999	6.7
Annual	Total	In-patient average length of stay (in days)	Number	Males	Intestinal infectious diseases except diarrhoea	Iceland	1999	3.6
Annual	Total	In-patient average length of stay (in days)	Number	Males	Diarrhoea and gastroenteritis of presumed infectious origin	Iceland	1999	2.5
Annual	Total	In-patient average length of stay (in days)	Number	Males	Tuberculosis	Iceland	1999	26
Annual	Total	In-patient average length of stay (in days)	Number	Males	Septicaemia	Iceland	1999	12.9
Annual	Total	In-patient average length of stay (in days)	Number	Males	Other arthropathies (M00-M15, M18-M22 ,M24-M25)	Iceland	1999	3.3
Annual	Total	In-patient average length of stay (in days)	Number	Males	Certain infectious and parasitic diseases (A00-B99)	Iceland	1999	4.8
Annual	Total	In-patient average length of stay (in days)	Number	Males	Other infectious and parasitic diseases (remainder of A00-B99)	Iceland	1999	5
Annual	Total	In-patient average length of stay (in days)	Number	Males	Human immunodeficiency virus [HIV] disease	Iceland	1999	6.3


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

Share link

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