Hospital Discharges By Diagnosis, In-patients, Per 100–000 Inhabitants

Eurostat code: hlth_co_disch2 · (1995 - 2021)

@eurostat.hlth_co_disch2

Table List

2 tables(24.77 MB)

Hospital Discharges By Diagnosis, In-patients, Per 100–000 Inhabitants - Raw

Hospital Discharges By Diagnosis, In-patients, Per 100–000 Inhabitants - Unpivoted

Hospital Discharges By Diagnosis, In-patients, Per 100–000 Inhabitants - Unpivoted

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

11.98 MB
4860042 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-patients (total number)	Per hundred thousand inhabitants	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Portugal	1995	8555.5
Annual	Total	in-patients (total number)	Per hundred thousand inhabitants	Females	All causes of diseases (A00-Z99) excluding V00-Y98 and Z38	Portugal	1995	7696.1
Annual	Total	in-patients (total number)	Per hundred thousand inhabitants	Females	Intestinal infectious diseases except diarrhoea	Portugal	1995	24
Annual	Total	in-patients (total number)	Per hundred thousand inhabitants	Females	Diarrhoea and gastroenteritis of presumed infectious origin	Portugal	1995	11.9
Annual	Total	in-patients (total number)	Per hundred thousand inhabitants	Females	Tuberculosis	Portugal	1995	22.8
Annual	Total	in-patients (total number)	Per hundred thousand inhabitants	Females	Septicaemia	Portugal	1995	6.7
Annual	Total	in-patients (total number)	Per hundred thousand inhabitants	Females	Other pregnancy with abortive outcome (O00-O03,O05-O08)	Portugal	1995	135.8
Annual	Total	in-patients (total number)	Per hundred thousand inhabitants	Females	Other arthropathies (M00-M15, M18-M22 ,M24-M25)	Portugal	1995	77.1
Annual	Total	in-patients (total number)	Per hundred thousand inhabitants	Females	Certain infectious and parasitic diseases (A00-B99)	Portugal	1995	1306.9
Annual	Total	in-patients (total number)	Per hundred thousand inhabitants	Females	Other infectious and parasitic diseases (remainder of A00-B99)	Portugal	1995	1132.1


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.