Hospital Discharges By Diagnosis And NUTS 2 Region, Day Cases, Total Number - Total

Eurostat code: hlth_co_disch3t · (2000 - 2021)

@eurostat.hlth_co_disch3t

Table List

2 tables(31.42 MB)

Hospital Discharges By Diagnosis And NUTS 2 Region, Day Cases, Total Number - Total - Raw

Hospital Discharges By Diagnosis And NUTS 2 Region, Day Cases, Total Number - Total - Unpivoted

Hospital Discharges By Diagnosis And NUTS 2 Region, Day Cases, Total Number - Total - Unpivoted

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

15.39 MB
10569994 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	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Belgium	2000	916761
Annual	Total	Day cases (total number)	Number	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Czechia	2000	24401
Annual	Total	Day cases (total number)	Number	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Praha	2000	3958
Annual	Total	Day cases (total number)	Number	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Střední Čechy	2000	3313
Annual	Total	Day cases (total number)	Number	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Jihozápad	2000	2075
Annual	Total	Day cases (total number)	Number	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Severozápad	2000	4129
Annual	Total	Day cases (total number)	Number	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Severovýchod	2000	2990
Annual	Total	Day cases (total number)	Number	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Jihovýchod	2000	2672
Annual	Total	Day cases (total number)	Number	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Střední Morava	2000	2225
Annual	Total	Day cases (total number)	Number	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Moravskoslezsko	2000	3039


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.