Others titles
- Hospital Activity Data
- Quarterly Hospital Activity Data
Keywords
- Clinical Commissioning Group Data
- Hospital Data
- The Quarterly Activity Return
- Provider Commissioner
- Inpatient Data
- Outpatient Data
- Quarterly Activity Return Hospital Data
Inpatient and Outpatient Related Hospital Activity Data
This dataset contains quarterly hospital activity data relating to inpatients (elective) and outpatients. All data items relate to all specialties. Figures are submitted quarterly on the Quarterly Activity Return (QAR) by National Health Service (NHS) Trusts and Independent sector providers treating NHS patients.
Get The Data
- ResearchNon-Commercial, Share-Alike, Attribution Free Forever
- CommercialCommercial Use, Remix & Adapt, White Label Log in to download
Description
The Quarterly Activity Return (QAR) is a Provider Commissioner collection with providers submitting their data broken down by commissioner. Commissioners extract the data from Extraction Viewer before validating and signing off their data. Commissioners do not need to upload a QAR return unless they need to add anything, for example, data for a non-English provider or Independent Sector provider.
Private patients should be recorded as Non-English Commissioner, code NONC. Commissioner returns should cover all activity for which the Clinical Commissioning Group (CCG) is financially responsible, regardless of whom it is commissioned from. They should include all NHS activity as well as non-NHS activity figures related to the volumes of total activity commissioned from non-NHS organizations e.g. voluntary, private and non-NHS statutory bodies.
From April 2013 nationally NHS England commissions specialized services, primary care, offender healthcare and some services for members of the armed forces. The Quarterly Activity Return is based on consultant specialties. From Q3 2007/08 only the ‘All specialties’ (specialty code: C_999) total has been required on the return, we no longer need the specialty breakdown.
Outpatient data include:
– The number of GP and other referrals for first consultant outpatient appointments
– The total number of attendances at consultant outpatient clinics including patients seen for their first appointments as well as those attending for subsequent or follow up appointments
– The number of patients who did not attend their outpatient appointment (first or subsequent) and gave no advance warning, or arrived too late to be seen.
Elective admission events are:
– Decisions to admit
– Patients admitted
– Patients failed to attend
– Removals other than admission
About this Dataset
Data Info
Date Created | 2017-08-25 |
---|---|
Last Modified | 2020-02-28 |
Version | 2020-02-28 |
Update Frequency |
Quarterly |
Temporal Coverage |
2018-2019 |
Spatial Coverage |
England |
Source | John Snow Labs; NHS England; |
Source License URL | |
Source License Requirements |
N/A |
Source Citation |
N/A |
Keywords | Clinical Commissioning Group Data, Hospital Data, The Quarterly Activity Return, Provider Commissioner, Inpatient Data, Outpatient Data, Quarterly Activity Return Hospital Data |
Other Titles | Hospital Activity Data, Quarterly Hospital Activity Data |
Data Fields
Name | Description | Type | Constraints |
---|---|---|---|
Year | Data collection Year | date | required : 1 |
Quarter | Period of the year in which the data was collected. | string | required : 1 |
Data_Type | Type of data, either commissioner based or provider based | string | required : 1 |
Region_Code | Region code of the NHS organizations. | string | - |
Region_Name | Region name of the NHS organizations. | string | - |
Organization_Code | NHS Organization unique code | string | - |
Organization_Name | Name of the NHS organizations. | string | required : 1 |
Decisions_to_Admit | Number of decisions to admit made in the given period. This count refers to patients for whom a clinical decision to admit to a hospital bed has been made during the quarter. It excludes Decisions to Admit for planned admissions. | integer | level : Ratio |
Number_of_Admissions | Number of patients admitted electively. It includes the count of those patients who are subsequently sent home without treatment. It excludes Patients Admitted for planned admissions. | integer | level : Ratio |
Patients_Failed_to_Attend | Number of patients for whom admission was arranged but who Failed to Attend and did not tell the hospital in advance that they would not be coming. It excludes Patients who Failed to Attend for planned admissions. | integer | level : Ratio |
Removals_Other_Than_Admissions | Number of patients removed from the elective admission list for reasons other than admission. It excludes Removals for planned admissions. It does not include suspended patients as they have not been removed from the elective admission list. | integer | level : Ratio |
GP_Referrals_Made | Number of written referrals from General Practitioners (GP), whether doctors or dentists, for first consultant outpatient appointment. All written GP referral requests to a Consultant whether directed to a specific consultant or not, should be recorded, regardless of whether they result in an outpatient attendance. | integer | level : Ratio |
Other_Referrals_Made | The total number of other Referral Requests (written or verbal) for a first Consultant Out-Patient Episode in the period. All referral requests to a Consultant whether directed to a specific consultant or not, should be recorded, regardless of whether they result in an outpatient attendance. | integer | level : Ratio |
First_Attendances_Seen | Number of first attendance appointments in all specialties, where the Out-Patient Attendance Consultant took place within the reporting period. These should be consultant outpatient appointments, whether taking place within a Consultant clinic session or outside a session. The only proviso is that the patient must have seen a Consultant (or a doctor acting for the Consultant) for examination or treatment. | integer | level : Ratio |
First_Attendances_DNA | The total number of accepted appointments which should have resulted in a first Out-Patient Attendance Consultant within the quarter which did not take place due to the patient not attending the appointment. | integer | level : Ratio |
Subsequent_Attendances_Seen | The total number of follow-up attendance appointments, where the Out-Patient Attendance Consultant took place within the quarter. This includes subsequent outpatient attendance for all consultant outpatient episodes for all sources of referral. | integer | level : Ratio |
Subsequent_Attendances_DNA | The total number of accepted appointments which should have resulted in a follow-up Out-Patient Attendance Consultant within the quarter which did not take place due to the patient not attending the appointment. | integer | level : Ratio |
Data Preview
Year | Quarter | Data Type | Region Code | Region Name | Organization Code | Organization Name | Decisions to Admit | Number of Admissions | Patients Failed to Attend | Removals Other Than Admissions | GP Referrals Made | Other Referrals Made | First Attendances Seen | First Attendances DNA | Subsequent Attendances Seen | Subsequent Attendances DNA |
2018 | April to June | Commissioner Based | England | 1578358 | 1448147 | 34279 | 234181 | 3546146 | 2285409 | 4996834 | 465169 | 10530172 | 968900 | |||
2018 | April to June | Commissioner Based | XDH | NHS ENGLAND | X24 | NHS ENGLAND | 65525 | 92041 | 1584 | 6784 | 164574 | 116989 | 398438 | 26729 | 1166026 | 55864 |
2018 | April to June | Commissioner Based | Y54 | NORTH OF ENGLAND COMMISSIONING REGION | 00C | NHS DARLINGTON CCG | 2301 | 2092 | 23 | 268 | 6246 | 6987 | 14183 | 1216 | 22858 | 2409 |
2018 | April to June | Commissioner Based | Y54 | NORTH OF ENGLAND COMMISSIONING REGION | 00D | NHS DURHAM DALES, EASINGTON AND SEDGEFIELD CCG | 7150 | 6483 | 82 | 884 | 17690 | 13677 | 27698 | 2391 | 49509 | 5305 |
2018 | April to June | Commissioner Based | Y54 | NORTH OF ENGLAND COMMISSIONING REGION | 00J | NHS NORTH DURHAM CCG | 5672 | 5256 | 96 | 743 | 14307 | 9416 | 22149 | 1720 | 40549 | 3868 |
2018 | April to June | Commissioner Based | Y54 | NORTH OF ENGLAND COMMISSIONING REGION | 00K | NHS HARTLEPOOL AND STOCKTON-ON-TEES CCG | 6831 | 6682 | 59 | 706 | 15906 | 9189 | 18034 | 1732 | 30063 | 3601 |
2018 | April to June | Commissioner Based | Y54 | NORTH OF ENGLAND COMMISSIONING REGION | 00L | NHS NORTHUMBERLAND CCG | 9924 | 9450 | 154 | 1011 | 18230 | 12278 | 27005 | 2029 | 63963 | 5568 |
2018 | April to June | Commissioner Based | Y54 | NORTH OF ENGLAND COMMISSIONING REGION | 00M | NHS SOUTH TEES CCG | 6047 | 5474 | 94 | 673 | 15040 | 11703 | 19127 | 2192 | 37326 | 4265 |
2018 | April to June | Commissioner Based | Y54 | NORTH OF ENGLAND COMMISSIONING REGION | 00N | NHS SOUTH TYNESIDE CCG | 5906 | 5240 | 178 | 681 | 10309 | 8039 | 15688 | 1598 | 33509 | 3477 |
2018 | April to June | Commissioner Based | Y54 | NORTH OF ENGLAND COMMISSIONING REGION | 00P | NHS SUNDERLAND CCG | 8937 | 8009 | 248 | 949 | 21266 | 14100 | 34738 | 2745 | 53902 | 5633 |