Hospital Discharges By Diagnosis, Day Cases, Total Number

Eurostat code: hlth_co_disch3 · (1995 - 2021)

@eurostat.hlth_co_disch3

Table List

2 tables(17.82 MB)

Hospital Discharges By Diagnosis, Day Cases, Total Number - Raw

Hospital Discharges By Diagnosis, Day Cases, Total Number - Unpivoted

Hospital Discharges By Diagnosis, Day Cases, Total Number - Raw

@eurostat.hlth_co_disch3.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

9.22 MB
334259 rows
34 columns

freq Freq	age Age	indic_he Indic He	unit Unit	sex Sex	icd10 Icd10	geo Geo	n_2000 2000	n_2001 2001	n_2002 2002	n_2003 2003	n_2004 2004	n_2005 2005	n_2006 2006	n_2007 2007	n_2008 2008	n_2009 2009	n_2010 2010	n_2011 2011	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020	n_2021 2021
Annual	Total	Day cases (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Austria																328461
Annual	Total	Day cases (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Belgium	483480	542282	594398	522264	563692	596918	619686	651096	720448	742256		897592	923520	911423	941414			1001494	1030126	1074396	894158	1083289
Annual	Total	Day cases (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Switzerland			100683	112363	109269	134179	138932	137809	144086
Annual	Total	Day cases (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Cyprus												5765		7025	7357	7259	7140	8313	7250
Annual	Total	Day cases (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Czechia	15368	15876	17520	19123	19408	21896	23999	25608	31429	31369	32914	36491	41270	46839	49223	48763	49850	49083	49710	50629	45670	46070
Annual	Total	Day cases (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Germany					316988	259298	250242	246733	250470	252997	256791	260538	264258	262707	269859	272100	281004	271541	262495	251222	216711	207277
Annual	Total	Day cases (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Denmark	104077	84551	97965	108822	115191	120126	130871	138549	142153	156218	166402	175221	175905	176662	184541	183907	183256
Annual	Total	Day cases (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Spain																1967990	1828626	2495449	2064492	2448405	2109805	2473227
Annual	Total	Day cases (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Finland													151355	150180	149633	147568	144390	139180	144065		103900	103158
Annual	Total	Day cases (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	France	2281005	2450350	2575688	2711572	2902798	3212176	3429077	3192267	3213543	3168513	3233986	3346788	3442114	3534673	3655115	3775512	7606460	7792585	8062613	8343265	6440450	8135062


CREATE TABLE raw (
  "freq" VARCHAR,
  "age" VARCHAR,
  "indic_he" VARCHAR,
  "unit" VARCHAR,
  "sex" VARCHAR,
  "icd10" VARCHAR,
  "geo" VARCHAR,
  "n_1995" DOUBLE,
  "n_1996" DOUBLE,
  "n_1997" DOUBLE,
  "n_1998" DOUBLE,
  "n_1999" DOUBLE,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE
);