Hospital Discharges By Diagnosis, Day Cases, Total Number

Eurostat code: hlth_co_disch3 · (1995 - 2021)

@eurostat.hlth_co_disch3

Table List

2 tables(17.82 MB)

Hospital Discharges By Diagnosis, Day Cases, Total Number - Raw

Hospital Discharges By Diagnosis, Day Cases, Total Number - Unpivoted

Hospital Discharges By Diagnosis, Day Cases, Total Number - Unpivoted

@eurostat.hlth_co_disch3.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
5025125 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)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Portugal	1995	37062
Annual	Total	Day cases (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98 and Z38	Portugal	1995	36679
Annual	Total	Day cases (total number)	Number	Females	Intestinal infectious diseases except diarrhoea	Portugal	1995	51
Annual	Total	Day cases (total number)	Number	Females	Diarrhoea and gastroenteritis of presumed infectious origin	Portugal	1995	63
Annual	Total	Day cases (total number)	Number	Females	Tuberculosis	Portugal	1995	45
Annual	Total	Day cases (total number)	Number	Females	Septicaemia	Portugal	1995	15
Annual	Total	Day cases (total number)	Number	Females	Other pregnancy with abortive outcome (O00-O03,O05-O08)	Portugal	1995	1206
Annual	Total	Day cases (total number)	Number	Females	Other arthropathies (M00-M15, M18-M22 ,M24-M25)	Portugal	1995	99
Annual	Total	Day cases (total number)	Number	Females	Certain infectious and parasitic diseases (A00-B99)	Portugal	1995	2495
Annual	Total	Day cases (total number)	Number	Females	Other infectious and parasitic diseases (remainder of A00-B99)	Portugal	1995	2109


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.