About this Dataset

Outpatient Waiting Times

Details information on the number of patients waiting, and length of time waiting, for a first appointment at a consultant-led outpatient service and integrated clinical assessment and treatment services (ICATS) 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

Centralised Consultant Led Outpatient Waiting Times

@ukgov.outpatient_waiting_times.centralised_consultant_led_outpatient_waiting_times

15.33 kB
72 rows
17 columns

CREATE TABLE centralised_consultant_led_outpatient_waiting_times (
  "quarter_ending" VARCHAR,
  "hsc_trust" VARCHAR,
  "specialty" VARCHAR,
  "programme_of_care" VARCHAR,
  "n_0_6_weeks" DOUBLE  -- 0 - 6 Weeks,
  "n__6_9_weeks" DOUBLE  -- > 6 - 9 Weeks,
  "n__9_12_weeks" DOUBLE  -- > 9 - 12 Weeks,
  "n__12_15_weeks" DOUBLE  -- > 12-15 Weeks,
  "n__15_18_weeks" DOUBLE  -- > 15-18 Weeks,
  "n__18_weeks" VARCHAR  -- > 18 Weeks,
  "n__18_52_weeks" VARCHAR  -- >18-52 Weeks,
  "n__52_weeks" VARCHAR  -- >52 Weeks,
  "total_waiting" DOUBLE,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16
);

First Consultant Led Outpatient Waiting Times

@ukgov.outpatient_waiting_times.first_consultant_led_outpatient_waiting_times

148.26 kB
6,139 rows
24 columns

CREATE TABLE first_consultant_led_outpatient_waiting_times (
  "quarter_ending" VARCHAR,
  "hsc_trust" VARCHAR,
  "specialty" VARCHAR,
  "programme_of_care" VARCHAR,
  "n_0_6_weeks" DOUBLE  -- 0 - 6 Weeks,
  "n__6_9_weeks" DOUBLE  -- > 6 - 9 Weeks,
  "n__9_13_weeks" VARCHAR  -- > 9 - 13 Weeks,
  "n__9_12_weeks" VARCHAR  -- > 9 - 12 Weeks,
  "n__12_15_weeks" VARCHAR  -- > 12-15 Weeks,
  "n__15_18_weeks" VARCHAR  -- > 15-18 Weeks,
  "n__18_26_weeks" VARCHAR  -- >18-26 Weeks,
  "n__26_39_weeks" VARCHAR  -- >26-39 Weeks,
  "n__39_52_weeks" VARCHAR  -- >39-52 Weeks,
  "n__52_65_weeks" VARCHAR  -- >52-65 Weeks,
  "n__65_78_weeks" VARCHAR  -- >65-78 Weeks,
  "n__78_91_weeks" VARCHAR  -- >78-91 Weeks,
  "n__91_104_weeks" VARCHAR  -- >91-104 Weeks,
  "n__104_weeks" VARCHAR  -- >104 Weeks,
  "n__18_weeks" VARCHAR  -- >18 Weeks,
  "n__18_52_weeks" VARCHAR  -- >18-52 Weeks,
  "n__13_26_weeks" VARCHAR  -- > 13 - 26 Weeks,
  "n__52_weeks" VARCHAR  -- >52 Weeks,
  "n__26_weeks" VARCHAR  -- > 26 Weeks,
  "total_waiting" DOUBLE
);

ICATS Waiting Times

@ukgov.outpatient_waiting_times.icats_waiting_times

30.22 kB
1,051 rows
25 columns

CREATE TABLE icats_waiting_times (
  "quarter_ending" VARCHAR,
  "hsc_trust" VARCHAR,
  "specialty" VARCHAR,
  "programme_of_care" VARCHAR,
  "n_0_6_weeks" DOUBLE  -- 0 - 6 Weeks,
  "n__6_9_weeks" DOUBLE  -- > 6 - 9 Weeks,
  "n__9_13_weeks" VARCHAR  -- > 9 - 13 Weeks,
  "n__9_12_weeks" VARCHAR  -- > 9 - 12 Weeks,
  "n__12_15_weeks" VARCHAR  -- > 12-15 Weeks,
  "n__15_18_weeks" VARCHAR  -- > 15-18 Weeks,
  "n__18_weeks" VARCHAR  -- >18 Weeks,
  "n__13_26_weeks1" VARCHAR  -- > 13 - 26 Weeks1,
  "n__26_weeks" VARCHAR  -- > 26 Weeks,
  "total_waiting" DOUBLE,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "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
);