Hospital Aggregates
OECD dataset from agency OECD.ELS.HD: DSD_HEALTH_PROC@DF_AGGR (1960 - 2024)
@oecd.oecd_els_hd_dsd_health_proc_df_aggr_v1_1
OECD dataset from agency OECD.ELS.HD: DSD_HEALTH_PROC@DF_AGGR (1960 - 2024)
@oecd.oecd_els_hd_dsd_health_proc_df_aggr_v1_1
This dataset reports data for key hospital aggregates: inpatient care discharges and average length of stay; and curative care discharges, bed-days, average length of stay and occupancy rate.
Please refer to the Sources and Methods for detailed country-specific information.
CREATE TABLE observations (
"dataflow" VARCHAR,
"ref_area" VARCHAR,
"measure" VARCHAR,
"unit_measure" VARCHAR,
"medical_procedure" VARCHAR,
"occupation" VARCHAR,
"diagnostic_type" VARCHAR,
"provider" VARCHAR,
"function" VARCHAR,
"mode_provision" VARCHAR,
"care_type" VARCHAR,
"health_facility" VARCHAR,
"age" VARCHAR,
"sex" VARCHAR,
"data_srce" VARCHAR,
"waiting_time" VARCHAR,
"disease" VARCHAR,
"cancer_site" VARCHAR,
"consultation_type" VARCHAR,
"time_period" BIGINT,
"obs_value" DOUBLE,
"obs_status" VARCHAR,
"obs_status2" VARCHAR,
"obs_status3" VARCHAR,
"unit_mult" VARCHAR,
"decimals" VARCHAR
);Anyone who has the link will be able to view this.