About this Dataset

Surgical Procedures

This dataset reports data for a selection of surgical procedures (by ICD-9-CM).

Surgical procedures are medical interventions involving an incision with instruments usually performed in an operating theatre and normally involving anaesthesia and/or respiratory assistance. Surgical procedures can be performed either as inpatient cases, day cases or, in certain instances, as outpatient cases.

Please refer to the Sources and Methods for detailed country-specific information.

Tables

Observations

@oecd.oecd_els_hd_dsd_health_proc_df_surg_proc_v1_1.observations

402.21 kB
122,718 rows
26 columns

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