Baselight
Sign In

Hospital Discharges And Length Of Stay For Inpatient And Curative Care - Historical Data (until 2021)

Eurostat code: hlth_co_dischls ยท (1960 - 2021)

@eurostat.hlth_co_dischls

Hospital Discharges And Length Of Stay For Inpatient And Curative Care - Historical Data (until 2021) - Unpivoted
@eurostat.hlth_co_dischls.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.

  • 34.64 KB
  • 5202 rows
  • 7 columns
freq

Freq

icha_hc

Icha Hc

indic_he

Indic He

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualServices of curative careIn-patient average length of stay (in days)NumberFinland196012.5
AnnualServices of curative careIn-patient average length of stay (in days)NumberHungary196011.3
AnnualServices of curative careIn-patient average length of stay (in days)NumberNetherlands196020.1
AnnualIn-patient careIn-patient average length of stay (in days)NumberAustria196024.31
AnnualIn-patient careIn-patient average length of stay (in days)NumberSwitzerland196031.7
AnnualIn-patient careIn-patient average length of stay (in days)NumberFinland196027.3
AnnualIn-patient careIn-patient average length of stay (in days)NumberHungary196016.4
AnnualIn-patient careIn-patient average length of stay (in days)NumberItaly196027
AnnualIn-patient careIn-patient average length of stay (in days)NumberSweden196031.8
AnnualServices of curative careIn-patient average length of stay (in days)NumberFinland196112.6

CREATE TABLE tidy (
  "freq" VARCHAR,
  "icha_hc" VARCHAR,
  "indic_he" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.