Quarterly Hospital Activity Dataset
Public Health & Epidemiology
Related Searches
Trusted By




"No reviews yet"
£249.99
About
This dataset provides a comprehensive overview of quarterly hospital activity, focusing on outpatient services and elective inpatient care across NHS Trusts in the UK. It includes data such as referrals, scheduled appointments, patient attendance, and elective admissions. The dataset is part of the Quarterly Activity Return (QAR) collected by NHS Trusts and independent sector providers offering services to NHS patients. It helps track healthcare provider performance, patient attendance trends, and hospital capacity, supporting strategic planning and resource allocation in the NHS.
This rich information allows for the thorough tracking of healthcare provider performance, identification of patient attendance trends, and assessment of overall hospital capacity. The dataset is a vital component of the Quarterly Activity Return (QAR), which is meticulously collected by NHS Trusts as well as independent sector providers that deliver services to NHS patients.
Stakeholders can gain valuable insights into healthcare service delivery and patient care pathways within the NHS framework. This dataset provides a detailed and comprehensive overview of hospital activity, with a particular emphasis on outpatient services and elective inpatient care across various NHS Trusts in the United Kingdom. It includes an extensive range of data elements, such as the total number of referrals from general practitioners and specialists, appointment scheduling details, patient attendance statistics, and records of elective admissions. The information contained within this dataset is essential for tracking the performance of healthcare providers, monitoring changes in patient attendance patterns, and evaluating the overall capacity and efficiency of hospitals.
Furthermore, this dataset is an integral part of the Quarterly Activity Return (QAR) initiative, which is systematically collected by NHS Trusts as well as independent sector providers that offer care to NHS patients. By analyzing the dataset, healthcare administrators, policymakers, and researchers can derive valuable insights regarding service utilization, resource allocation, and patient flow within the healthcare system. This comprehensive data not only aids in assessing current healthcare delivery but also serves as a foundation for strategic planning and improvements in patient care outcomes across the NHS.
Original Data Source: NHS ENGLAND (Discontinued) Quarterly Hospital Activity
Dataset Features
- Provider_Code: Unique identifier for the hospital or healthcare provider.
- Provider_Code_Name: Name of the healthcare provider (NHS Trust or hospital).
- Commissioner_Code: Code for the commissioner of the healthcare services.
- Commissioner_Code_Name: Name of the commissioning organization (e.g., PCTs).
- Number_of_Decisions_to_Admit: The number of elective admission decisions made.
- Patients_Admitted: The number of patients who were admitted following decisions to admit.
- Patients_Failed_to_Attend: The number of patients who did not attend their appointment without prior notice.
- Removals_Other_than_Admissions: Number of cases where patients were removed from the admission list for reasons other than being admitted.
- GP_Written_Referrals: Number of referrals received from General Practitioners (GPs).
- Other_Referrals: Number of referrals received from non-GP sources (e.g., other hospitals).
- First_Attendances_Seen: The number of first appointments attended by patients.
- First_Attendances_DNA (Did Not Attend): The number of first appointments where patients failed to attend.
- Subsequent_Attendances_Seen: The number of follow-up appointments attended by patients.
- Subsequent_Attendances_DNA: The number of follow-up appointments where patients did not attend.
- Effective_Snapshot_Date: The date when the data snapshot was recorded.
- Report_Period_Length: The time period of the data (e.g., quarterly).
Distribution


Usage
This dataset is ideal for a variety of applications:
- Healthcare Performance Monitoring: Analyzing hospital and PCT performance, including patient attendance and referral trends.
- Capacity Planning: Helping NHS administrators and planners allocate resources based on elective admissions and outpatient attendance.
- Patient Behavior Analysis: Investigating patterns of patient nonattendance for initial and follow-up appointments.
- Healthcare Research: Studying the effectiveness of referrals and attendance in outpatient clinics across regions.
Coverage
This dataset covers NHS Trusts and independent healthcare providers across the UK, spanning from 2010 to 2020, and includes data on patients treated within the NHS system, though it does not contain personal demographic information.
License
CUSTOM
Please review the respective licenses below:
-
Data Source License
-
Data Provider's License
You must comply with the licensing terms set by both the source and the data provider.
Who Can Use It?
- Data Scientists: For training predictive models related to patient attendance and healthcare provider efficiency.
- Healthcare Researchers: For studying healthcare utilization trends and patient attendance patterns.
- Policy Makers & NHS Administrators: For resource allocation and healthcare policy planning.
- Businesses: For developing healthcare analytics tools or performing market analysis.
Dataset Name Suggestions
- NHS Quarterly Hospital Activity Dataset
- Hospital Attendance and Referral Activity Dataset
- Quarterly Elective Admissions and Outpatient Activity Data
- NHS Patient Attendance and Referrals Statistics
- Quarterly NHS Hospital Utilization Database
- Hospital_Activity.rpt_Quarterly_Activity_Report_Data
Need Help with Open Data?
Struggling to access, curate, or organize open data? Let us know the source, and we’ll add it for you! If we already have the data you need, we can list it on Opendatabay for your convenience.
Our Open Data Offering
We currently host 7,217 open data tables across 381 schemas, all accessible via leading cloud platforms like Azure and Snowflake.