About this Dataset

Inpatient Waiting Times

Details information on the number of patients waiting, and length of time waiting at the end of each quarter, for Inpatient and Day Case admissions at Health and Social Care (HSC) Trusts in Northern Ireland. Data are presented by HSC Trust, specialty, programme of care and time band.
Publisher name: OpenDataNI
Last updated: 2022-07-01T04:04:03Z

Tables

Day Case Waiting Times

@ukgov.inpatient_waiting_times.day_case_waiting_times

71.6 kB
4,413 rows
26 columns

CREATE TABLE day_case_waiting_times (
  "quarter_ending" VARCHAR,
  "hsc_trust" VARCHAR,
  "specialty" VARCHAR,
  "programme_of_care" VARCHAR,
  "n_0_6_weeks" DOUBLE  -- 0 - 6 Weeks,
  "n__6_13_weeks" DOUBLE  -- > 6 - 13 Weeks,
  "n__13_21_weeks" DOUBLE  -- > 13 - 21 Weeks,
  "n__21_26_weeks" DOUBLE  -- > 21 - 26 Weeks,
  "n__26_weeks" VARCHAR  -- > 26 Weeks,
  "n__26_52_weeks" DOUBLE  -- >26-52 Weeks,
  "n__52_weeks" DOUBLE  -- >52 Weeks,
  "n__26_30_weeks" VARCHAR  -- > 26-30 Weeks,
  "n__30_weeks" VARCHAR  -- > 30 Weeks,
  "n__30_36_weeks" VARCHAR  -- >30-36 Weeks,
  "n__26_36_weeks" VARCHAR  -- > 26 - 36 Weeks,
  "n__36_weeks" VARCHAR  -- > 36 Weeks,
  "total" DOUBLE,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25
);

Inpatient Admission Waiting Times

@ukgov.inpatient_waiting_times.inpatient_admission_waiting_times

50.1 kB
3,006 rows
19 columns

CREATE TABLE inpatient_admission_waiting_times (
  "quarter_ending" VARCHAR,
  "hsc_trust" VARCHAR,
  "specialty" VARCHAR,
  "programme_of_care" VARCHAR,
  "n_0_6_weeks" DOUBLE  -- 0 - 6 Weeks,
  "n__6_13_weeks" DOUBLE  -- > 6 - 13 Weeks,
  "n__13_21_weeks" DOUBLE  -- > 13 - 21 Weeks,
  "n__21_26_weeks" DOUBLE  -- > 21 - 26 Weeks,
  "n__26_weeks" VARCHAR  -- > 26 Weeks,
  "n__26_52_weeks" DOUBLE  -- >26-52 Weeks,
  "n__52_weeks" DOUBLE  -- >52 Weeks,
  "n__26_30_weeks" VARCHAR  -- > 26-30 Weeks,
  "n__30_weeks" VARCHAR  -- > 30 Weeks,
  "n__30_36_weeks" VARCHAR  -- >30-36 Weeks,
  "n__26_36_weeks" VARCHAR  -- > 26 - 36 Weeks,
  "n__36_weeks" VARCHAR  -- > 36 Weeks,
  "total" DOUBLE,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18
);

Total Admission Waiting Times

@ukgov.inpatient_waiting_times.total_admission_waiting_times

75.49 kB
4,562 rows
19 columns

CREATE TABLE total_admission_waiting_times (
  "quarter_ending" VARCHAR,
  "hsctrust" VARCHAR,
  "specialty" VARCHAR,
  "programme_of_care" VARCHAR,
  "n_0_6_weeks" DOUBLE  -- 0 - 6 Weeks,
  "n__6_13_weeks" DOUBLE  -- > 6 - 13 Weeks,
  "n__13_21_weeks" DOUBLE  -- > 13 - 21 Weeks,
  "n__21_26_weeks" DOUBLE  -- > 21 - 26 Weeks,
  "n__26_weeks" VARCHAR  -- > 26 Weeks,
  "n__26_52_weeks" DOUBLE  -- >26-52 Weeks,
  "n__52_weeks" DOUBLE  -- >52 Weeks,
  "n__26_30_weeks" VARCHAR  -- > 26-30 Weeks,
  "n__30_weeks" VARCHAR  -- > 30 Weeks,
  "n__30_36_weeks" VARCHAR  -- >30-36 Weeks,
  "n__26_36_weeks" VARCHAR  -- > 26 - 36 Weeks,
  "n__36_weeks" VARCHAR  -- > 36 Weeks,
  "total" DOUBLE,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18
);