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

Eurostat code: hlth_co_disch1f · (2000 - 2021)

@eurostat.hlth_co_disch1f

Table List

2 tables(38.94 MB)

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

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

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

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

19.16 MB
11233053 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	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Belgium	2000	914303
Annual	Total	in-patients (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Czechia	2000	1173197
Annual	Total	in-patients (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Praha	2000	159562
Annual	Total	in-patients (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Střední Čechy	2000	110253
Annual	Total	in-patients (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Jihozápad	2000	131227
Annual	Total	in-patients (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Severozápad	2000	129822
Annual	Total	in-patients (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Severovýchod	2000	165924
Annual	Total	in-patients (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Jihovýchod	2000	199864
Annual	Total	in-patients (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Střední Morava	2000	133913
Annual	Total	in-patients (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Moravskoslezsko	2000	142632


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.