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

Eurostat code: hlth_co_disch2t · (2000 - 2021)

@eurostat.hlth_co_disch2t

Table List

2 tables(52.65 MB)

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

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

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

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

25.28 MB
10736776 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)	Per hundred thousand inhabitants	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Belgium	2000	16301
Annual	Total	in-patients (total number)	Per hundred thousand inhabitants	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Bulgaria	2000	14456.2
Annual	Total	in-patients (total number)	Per hundred thousand inhabitants	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Czechia	2000	20255.5
Annual	Total	in-patients (total number)	Per hundred thousand inhabitants	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Praha	2000	24650.5
Annual	Total	in-patients (total number)	Per hundred thousand inhabitants	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Střední Čechy	2000	17094.5
Annual	Total	in-patients (total number)	Per hundred thousand inhabitants	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Jihozápad	2000	19727.6
Annual	Total	in-patients (total number)	Per hundred thousand inhabitants	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Severozápad	2000	19800.4
Annual	Total	in-patients (total number)	Per hundred thousand inhabitants	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Severovýchod	2000	19612.9
Annual	Total	in-patients (total number)	Per hundred thousand inhabitants	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Jihovýchod	2000	21681.1
Annual	Total	in-patients (total number)	Per hundred thousand inhabitants	Total	All causes of diseases (A00-Z99) excluding V00-Y98	Střední Morava	2000	19027.7


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.