Hospital Discharges By Diagnosis And NUTS 2 Region, In-patients, Total Number - Total

Eurostat code: hlth_co_disch1t · (2000 - 2021)

@eurostat.hlth_co_disch1t

Table List

2 tables(43.41 MB)

Hospital Discharges By Diagnosis And NUTS 2 Region, In-patients, Total Number - Total - Raw

Hospital Discharges By Diagnosis And NUTS 2 Region, In-patients, Total Number - Total - Unpivoted

Hospital Discharges By Diagnosis And NUTS 2 Region, In-patients, Total Number - Total - Unpivoted

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

21.1 MB
11490302 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)	Number	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Belgium	2000	1671057
Annual	Total	in-patients (total number)	Number	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Bulgaria	2000	1181097
Annual	Total	in-patients (total number)	Number	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Czechia	2000	2080712
Annual	Total	in-patients (total number)	Number	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Praha	2000	291860
Annual	Total	in-patients (total number)	Number	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Střední Čechy	2000	190295
Annual	Total	in-patients (total number)	Number	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Jihozápad	2000	232306
Annual	Total	in-patients (total number)	Number	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Severozápad	2000	224080
Annual	Total	in-patients (total number)	Number	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Severovýchod	2000	292024
Annual	Total	in-patients (total number)	Number	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Jihovýchod	2000	359376
Annual	Total	in-patients (total number)	Number	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Střední Morava	2000	235878


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.