Hospital Days Of In-patients

Eurostat code: hlth_co_hosday · (1995 - 2021)

@eurostat.hlth_co_hosday

Table List

2 tables(32.28 MB)

Hospital Days Of In-patients - Raw

Hospital Days Of In-patients - Unpivoted

Hospital Days Of In-patients - Raw

@eurostat.hlth_co_hosday.raw

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

16.71 MB
346063 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	Bed-days	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Austria																9964283
Annual	Total	Bed-days	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Belgium	7331952	7175830	6969806	7452322	7380691	7619356	7230168	7115697	7429086	7293442		7221355	7173190	7052105	6958304		2902810	6564505	6537671	6307266	5290199	5416988
Annual	Total	Bed-days	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Switzerland			7093089	7148943	7003459	6902528	6741043	6654434	6674124	6548276	6376569	6323617	6158706	6196116	6217687	6244495	6328343	6216943	6175148	6190821	5830594	6046591
Annual	Total	Bed-days	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Cyprus												189447		185063	185341	180005	187744	196728	195556
Annual	Total	Bed-days	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Czechia	12996412	12950986	13116393	13498522	13624525	13537469	12923773	12861789	12513790	12223991	12081142	11484742	11050250	11012576	11133581	10844517	10728485	10592959	10550785	10473578	9433025	8307711
Annual	Total	Bed-days	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Germany					99853474	98518314	97795891	100451577	100120090	99977312	99398199	98308678	98872061	98455956	98996417	98464667	98729027	97806398	96975884	96997429	81365294	82455234
Annual	Total	Bed-days	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Denmark	3165316	3675745	3531132	3448310	3313014	3258049	3125980	3044553	3037295	2821183	2731363	2577324	2485874	2437325	2400734	2306982	2257514
Annual	Total	Bed-days	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Spain																15475066	16609875	17653059	19514473	18964178	17595357	17620059
Annual	Total	Bed-days	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Finland													6107816	5651461	5625542	4813234	4329648	3775699	3710464		3049662	3064903
Annual	Total	Bed-days	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	France	37012933	36376459	35930849	35031157	34600711	33978880	33590802	33251952	33158600	32973401	33030937	32810982	32653459	32430317	32126121	31660108	59185702	58020380.5	57907802	57218650	51455894	51289562


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