About this Dataset

Diagnostic Waiting Times

Details information on the number of patients waiting, and length of time waiting, for diagnostic services, as well as diagnostic reporting turnaround times at Health and Social Care (HSC) Trusts in Northern Ireland. Data are presented by HSC Trust, diagnostic service and time band.
Publisher name: OpenDataNI
Last updated: 2022-07-01T04:04:03Z

Tables

Diagnostic Reporting Turnaround Times

@ukgov.diagnostic_waiting_times.diagnostic_reporting_turnaround_times

151.84 kB
17,386 rows
17 columns

CREATE TABLE diagnostic_reporting_turnaround_times (
  "month" VARCHAR,
  "hsc_trust" VARCHAR,
  "category_of_test" VARCHAR,
  "test" VARCHAR,
  "priority" VARCHAR,
  "n_0_2_days" DOUBLE  -- 0-2 Days,
  "n_3_7_days" DOUBLE  -- 3-7 Days,
  "n_8_14_days" DOUBLE  -- 8-14 Days,
  "n_15_21_days" DOUBLE  -- 15-21 Days,
  "n_22_28_days" DOUBLE  -- 22-28 Days,
  "n__28_days" DOUBLE  -- >28 Days,
  "total" DOUBLE,
  "n__reported_within_2_days" DOUBLE  -- % Reported Within 2 Days,
  "n__reported_within_2_weeks" DOUBLE  -- % Reported Within 2 Weeks,
  "n__reported_within_4_weeks" DOUBLE  -- % Reported Within 4 Weeks,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" DOUBLE  -- Unnamed: 16
);

Diagnostic Waiting Times

@ukgov.diagnostic_waiting_times.diagnostic_waiting_times

126.38 kB
8,627 rows
22 columns

CREATE TABLE diagnostic_waiting_times (
  "quarter_ending" VARCHAR,
  "hsc_trust" VARCHAR,
  "diagnostic_service" VARCHAR,
  "recommended_waiting_time" VARCHAR,
  "category" VARCHAR,
  "n_0_6_weeks" DOUBLE  -- 0 - 6 Weeks,
  "n__6_9_weeks" DOUBLE  -- > 6 - 9 Weeks,
  "n__9_13_weeks" DOUBLE  -- > 9 - 13 Weeks,
  "n__13_21_weeks" DOUBLE  -- > 13 - 21 Weeks,
  "n__21_26_weeks" DOUBLE  -- > 21 - 26 Weeks,
  "n__26_weeks" DOUBLE  -- > 26 Weeks,
  "n__26_36_weeks" VARCHAR  -- > 26 - 36 Weeks,
  "n__36_weeks" DOUBLE  -- > 36 Weeks,
  "n__36_52_weeks" VARCHAR  -- > 36 - 52 Weeks,
  "n__52_65_weeks" VARCHAR  -- > 52 - 65 Weeks,
  "n__65_78_weeks" VARCHAR  -- > 65 - 78 Weeks,
  "n__78_weeks" VARCHAR  -- > 78 Weeks,
  "total" DOUBLE,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21
);