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

14.97 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,
  "n__6_9_weeks" DOUBLE,
  "n__9_12_weeks" DOUBLE,
  "n__12_15_weeks" DOUBLE,
  "n__15_18_weeks" DOUBLE,
  "n__18_weeks" VARCHAR,
  "n__18_52_weeks" VARCHAR,
  "n__52_weeks" VARCHAR,
  "total_waiting" DOUBLE,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR
);

First Consultant Led Outpatient Waiting Times

@ukgov.outpatient_waiting_times.first_consultant_led_outpatient_waiting_times

144.79 KB
6139 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,
  "n__6_9_weeks" DOUBLE,
  "n__9_13_weeks" VARCHAR,
  "n__9_12_weeks" VARCHAR,
  "n__12_15_weeks" VARCHAR,
  "n__15_18_weeks" VARCHAR,
  "n__18_26_weeks" VARCHAR,
  "n__26_39_weeks" VARCHAR,
  "n__39_52_weeks" VARCHAR,
  "n__52_65_weeks" VARCHAR,
  "n__65_78_weeks" VARCHAR,
  "n__78_91_weeks" VARCHAR,
  "n__91_104_weeks" VARCHAR,
  "n__104_weeks" VARCHAR,
  "n__18_weeks" VARCHAR,
  "n__18_52_weeks" VARCHAR,
  "n__13_26_weeks" VARCHAR,
  "n__52_weeks" VARCHAR,
  "n__26_weeks" VARCHAR,
  "total_waiting" DOUBLE
);

ICATS Waiting Times

@ukgov.outpatient_waiting_times.icats_waiting_times

29.52 KB
1051 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,
  "n__6_9_weeks" DOUBLE,
  "n__9_13_weeks" VARCHAR,
  "n__9_12_weeks" VARCHAR,
  "n__12_15_weeks" VARCHAR,
  "n__15_18_weeks" VARCHAR,
  "n__18_weeks" VARCHAR,
  "n__13_26_weeks1" VARCHAR,
  "n__26_weeks" VARCHAR,
  "total_waiting" DOUBLE,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR
);