Hospital Discharges By Diagnosis, Day Cases, Per 100–000 Inhabitants

Eurostat code: hlth_co_disch4 · (1995 - 2021)

@eurostat.hlth_co_disch4

Table List

2 tables(17.93 MB)

Hospital Discharges By Diagnosis, Day Cases, Per 100–000 Inhabitants - Raw

Hospital Discharges By Diagnosis, Day Cases, Per 100–000 Inhabitants - Unpivoted

Hospital Discharges By Diagnosis, Day Cases, Per 100–000 Inhabitants - Unpivoted

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

8.6 MB
4478474 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	Day cases (total number)	Per hundred thousand inhabitants	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Portugal	1995	713.4
Annual	Total	Day cases (total number)	Per hundred thousand inhabitants	Females	All causes of diseases (A00-Z99) excluding V00-Y98 and Z38	Portugal	1995	706
Annual	Total	Day cases (total number)	Per hundred thousand inhabitants	Females	Intestinal infectious diseases except diarrhoea	Portugal	1995	1
Annual	Total	Day cases (total number)	Per hundred thousand inhabitants	Females	Diarrhoea and gastroenteritis of presumed infectious origin	Portugal	1995	1.2
Annual	Total	Day cases (total number)	Per hundred thousand inhabitants	Females	Tuberculosis	Portugal	1995	0.9
Annual	Total	Day cases (total number)	Per hundred thousand inhabitants	Females	Septicaemia	Portugal	1995	0.3
Annual	Total	Day cases (total number)	Per hundred thousand inhabitants	Females	Other pregnancy with abortive outcome (O00-O03,O05-O08)	Portugal	1995	23.2
Annual	Total	Day cases (total number)	Per hundred thousand inhabitants	Females	Other arthropathies (M00-M15, M18-M22 ,M24-M25)	Portugal	1995	1.9
Annual	Total	Day cases (total number)	Per hundred thousand inhabitants	Females	Certain infectious and parasitic diseases (A00-B99)	Portugal	1995	48
Annual	Total	Day cases (total number)	Per hundred thousand inhabitants	Females	Other infectious and parasitic diseases (remainder of A00-B99)	Portugal	1995	40.6


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.