In-patient Average Length Of Stay (days)

Eurostat code: hlth_co_inpst · (1995 - 2021)

@eurostat.hlth_co_inpst

Table List

2 tables(13.58 MB)

In-patient Average Length Of Stay (days) - Raw

In-patient Average Length Of Stay (days) - Unpivoted

In-patient Average Length Of Stay (days) - Raw

@eurostat.hlth_co_inpst.raw

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

6.73 MB
295646 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-patient average length of stay (in days)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Austria																8.5
Annual	Total	In-patient average length of stay (in days)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Belgium	8	7.9	7.7	8.1	8	7.7	7.8	7.7	7.4	7.3		7.1	7	6.9	6.7		6.5	6.4	6.3	6.1	6.2	5.8
Annual	Total	In-patient average length of stay (in days)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Switzerland			11.5	11.4	10.9	10.7	10.2	9.8	9.6	9.3	9	8.8	8.6	8.5	8.4	8.3	8.2	8.1	8.1	8.1	8.1	7.9
Annual	Total	In-patient average length of stay (in days)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Cyprus												5.7		5.6	5.7	5.6	5.9	6	5.9
Annual	Total	In-patient average length of stay (in days)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Czechia	11.1	11	10.8	10.8	10.6	10.5	10.3	10.2	10.1	10	10	9.7	9.5	9.3	9.2	9.2	9.2	9.2	9.2	9.4	10.1	9
Annual	Total	In-patient average length of stay (in days)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Germany					10.3	10.2	10.1	10.1	9.8	9.7	9.5	9.3	9.3	9.2	9	9	8.9	8.8	8.8	8.8	8.6	8.7
Annual	Total	In-patient average length of stay (in days)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Denmark	6.2	8	7.5	7.3	7	6.9	6.6	6.4	6.5	5.9	5.6	5.5	5.4	5.4	5.3	5.2	5.1
Annual	Total	In-patient average length of stay (in days)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Spain																6.2	6.5	6.9	7.7	7.5	8	7.6
Annual	Total	In-patient average length of stay (in days)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	Finland													11.5	10.9	10.9	9.5	8.6	7.7	7.7		7.2	7.1
Annual	Total	In-patient average length of stay (in days)	Number	Females	All causes of diseases (A00-Z99) excluding V00-Y98	France	5.9	5.9	6	5.9	5.8	5.7	5.6	5.6	5.6	5.6	5.6	5.5	5.5	5.5	5.4	5.4	8.8	8.7	8.7	8.7	8.9	8.6


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