Hospital Discharges By Diagnosis And NUTS 2 Region, Day Cases, Per 100–000 Inhabitants - Total

Eurostat code: hlth_co_disch4t · (2000 - 2021)

@eurostat.hlth_co_disch4t

Table List

2 tables(37.53 MB)

Hospital Discharges By Diagnosis And NUTS 2 Region, Day Cases, Per 100–000 Inhabitants - Total - Raw

Hospital Discharges By Diagnosis And NUTS 2 Region, Day Cases, Per 100–000 Inhabitants - Total - Unpivoted

Hospital Discharges By Diagnosis And NUTS 2 Region, Day Cases, Per 100–000 Inhabitants - Total - Unpivoted

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

18.02 MB
9876996 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	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Belgium	2000	8942.9
Annual	Total	Day cases (total number)	Per hundred thousand inhabitants	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Czechia	2000	237.5
Annual	Total	Day cases (total number)	Per hundred thousand inhabitants	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Praha	2000	334.3
Annual	Total	Day cases (total number)	Per hundred thousand inhabitants	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Střední Čechy	2000	297.6
Annual	Total	Day cases (total number)	Per hundred thousand inhabitants	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Jihozápad	2000	176.2
Annual	Total	Day cases (total number)	Per hundred thousand inhabitants	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Severozápad	2000	364.9
Annual	Total	Day cases (total number)	Per hundred thousand inhabitants	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Severovýchod	2000	200.8
Annual	Total	Day cases (total number)	Per hundred thousand inhabitants	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Jihovýchod	2000	161.2
Annual	Total	Day cases (total number)	Per hundred thousand inhabitants	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Střední Morava	2000	179.5
Annual	Total	Day cases (total number)	Per hundred thousand inhabitants	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Moravskoslezsko	2000	237.5


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.