Hospital Discharges By Diagnosis, In-patients, Total Number

Eurostat code: hlth_co_disch1 · (1995 - 2021)

@eurostat.hlth_co_disch1

Table List

2 tables(23.84 MB)

Hospital Discharges By Diagnosis, In-patients, Total Number - Raw

Hospital Discharges By Diagnosis, In-patients, Total Number - Unpivoted

Hospital Discharges By Diagnosis, In-patients, Total Number - Raw

@eurostat.hlth_co_disch1.raw

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

12.26 MB
347219 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	in-patients (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Belgium	914303	913173	905403	917480	922297	985763	930130	927903	1000389	1005191		1022895	1030782	1023165	1032955			1029003	1036923	1030712	859502	939374
Annual	Total	in-patients (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Bulgaria														1247473	1306416	1295078	1265396	1306679	1344220	1347279	1085673	1107126
Annual	Total	in-patients (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Switzerland			616093	626001	639788	644999	658460	679294	696571	704045	711849	720624	716274	726599	739390	753530	771290	768139	766829	767798	721069	762429
Annual	Total	in-patients (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Cyprus												33415		32982	32479	31884	31644	32620	33193
Annual	Total	in-patients (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Czechia	1173197	1179570	1217406	1251195	1284338	1285267	1254400	1257816	1240169	1224880	1207720	1181970	1167551	1188123	1205625	1183479	1165041	1155423	1142014	1115424	937906	919871
Annual	Total	in-patients (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Germany					9722928	9640884	9701719	9993472	10190721	10308975	10422274	10517857	10682230	10752527	10965624	10986756	11134486	11062567	10965441	10988168	9446938	9470850
Annual	Total	in-patients (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Denmark	511203	460163	467905	470004	472894	472308	474541	476986	468799	480305	483954	469904	459965	454087	455611	446329	440622
Annual	Total	in-patients (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Spain																2501723	2547666	2542894	2550779	2528917	2197234	2333089
Annual	Total	in-patients (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Finland													529799	519526	516981	506565	502774	491292	483392		425096	430563
Annual	Total	in-patients (total number)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	France	6244447	6136468	6022884	5954114	5958934	5936020	5956010	5907579	5928307	5925199	5919988	5950284	5952108	5912108	5905248	5864906	6754775	6668605	6639653	6563722	5750192	5945210


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
);