Acute Hospital Activity and NHS Beds Information

This data package contains the Acute Hospital Outpatient Activity By Health Board Residence and Treatment includes information split by location for health board of residence/treatment, hospital and council area, specialty, age and sex, and Scottish Index of Multiple Deprivation (SIMD) for new and Did Not Attend (DNA) appointments; and split by specialty and health board of treatment for return and total appointments and the number of attendances for outpatient activity for acute hospital care services. Acute Hospital Outpatient Activity Cross Boundary Flow includes a list of locations for health board of treatment/residence hospital and council area and the number of attendances for the outpatient activity for acute hospital care services. Cross-boundary flow shows the relationship between where patients live and where they are treated.

Accident and Emergency waiting times and activity includes performance against the 4-hour waiting time standard and the target to reduce attendances at Emergency Departments. Hospital admissions and deaths from unintentional injuries and assaults, sourced from hospital administrative systems across Scotland and the National Records of Scotland. Unintentional injury is one of the main causes of death and is one of the common causes of emergency hospital admissions in children. Unintentional injuries are also a common cause for emergency hospital admissions among adults. The term "unintentional injury" is preferred to "accidents" as the latter implies events are inevitable and unavoidable whereas a high proportion of these incidents are now regarded as being preventable. Inpatient and Daycase Activity Stays By Health Board Residence/Treatment includes information split by location for health board of residence/treatment, hospital and council area, specialty, age and sex, and Scottish Index of Multiple Deprivation (SIMD) for the length of stays in the specific hospital. Measures include emergency admissions, elective admissions, transfers, inpatients, day cases, and total inpatients and day cases activity stays for acute hospital care services.

NHS Staffed Beds and Percentage Occupancy includes information split by location for health board of available staffed beds, hospital and council area. Due to the variability in the number of available beds in a ward or specialty, the total number of available beds is calculated by taking the average of the number of beds available in each day of the quarter and percentage occupancy for acute specialties for acute hospital care services. Procedures Performed For Children and Adults in an Acute Setting for NHS Scotland provides information about procedures performed in acute hospitals by treatment across Scotland. It includes statistics which are derived from data collected on discharges from non-obstetric and non-psychiatric hospitals (SMR01) in Scotland.

The use of John Snow Labs datasets is free for personal and research purposes. For commercial use please subscribe to the Data Library  on AWS. The subscription will allow you to use all John Snow Labs datasets and data packages for commercial purposes.

1. Acute Hospital Outpatient Activity By Health Board Residence

This dataset includes information split by location for health board of residence, hospital and council area, specialty, age and sex, and Scottish Index of Multiple Deprivation (SIMD) for new and Did Not Attend (DNA) appointments; and split by specialty and health board of treatment for return and total appointments and the number of attendances for outpatient activity for acute hospital care services.

2. Acute Hospital Outpatient Activity By Health Board Treatment

This dataset includes information split by location for health board of treatment, hospital and council area, specialty, age and sex, and Scottish Index of Multiple Deprivation (SIMD) for new and Did Not Attend (DNA) appointments; and split by specialty and health board of treatment for return and total appointments and the number of attendances for outpatient activity for acute hospital care services.

3. Acute Hospital Outpatient Activity Cross Boundary Flow

This dataset includes a list of locations for health board of treatment/residence hospital and council area and the number of attendances for outpatient activity for acute hospital care services. Cross boundary flow shows the relationship between where patients live and where they are treated.

4. Attendances at Accident and Emergency Services in Scottish Hospitals

This dataset provides information about statistics on attendances at Accident and Emergency (A&E) services across Scotland. The information includes trends in the number of attendances and performance against the 4-hour standard.

5. Emergency Hospital Admissions Due to Unintentional Injuries

This dataset includes information about the Information Services Division reports on emergency hospital admissions and deaths as a result of unintentional injury. Unintentional injuries can occur in any age group, but children and the elderly are generally more vulnerable.

6. Inpatient and Daycase Activity Cross Boundary Flow

This dataset includes a list of locations for health board of treatment/residence, hospital and council area and the number of stays and episodes for inpatient and day case activity for acute hospital care services. Cross boundary flow shows the relationship between where patients live and where they are treated.

7. Inpatient and Daycase Activity Episodes By Health Board Residence

This dataset includes information split by location for health board of residence, hospital and council area, specialty, age and sex, and Scottish Index of Multiple Deprivation (SIMD) for episodes and length of stays in the specific hospital. Measures include emergency admissions, elective admissions, transfers, inpatients, day cases, and total inpatients and day cases activity for acute hospital care services.

8. Inpatient and Daycase Activity Episodes By Health Board Treatment

This dataset includes information split by location for health board of treatment, hospital and council area, specialty, age and sex, and Scottish Index of Multiple Deprivation (SIMD) for episodes and length of stays in the specific hospital. Measures include emergency admissions, elective admissions, transfers, inpatients, day cases, and total inpatients and day cases activity for acute hospital care services.

9. Inpatient and Daycase Activity Stays By Health Board Residence

This dataset includes information split by location for health board of residence, hospital and council area, specialty, age and sex, and Scottish Index of Multiple Deprivation (SIMD) for the length of stays in the specific hospital. Measures include emergency admissions, elective admissions, transfers, inpatients, day cases, and total inpatients and day cases activity stays for acute hospital care services.

10. Inpatient and Daycase Activity Stays By Health Board Treatment

This dataset includes information split by location for health board of treatment, hospital and council area, specialty, age and sex, and Scottish Index of Multiple Deprivation (SIMD) for the length of stays in the specific hospital. Measures include emergency admissions, elective admissions, transfers, inpatients, day cases, and total inpatients and day cases activity stays for acute hospital care services.

11. NHS Staffed Beds and Percentage Occupancy

This dataset includes information split by location for health board of available staffed beds, hospital and council area. Due to the variability in the number of available beds in a ward or specialty, the total number of available beds is calculated by taking the average of the number of beds available in each day of the quarter and percentage occupancy for acute specialties for acute hospital care services.

12. Outpatient Consultant Led Activity Annual Trends

This dataset includes a list of locations for New and Return attendances and Did Not Attend (DNA) rates by specialty for Scotland and National Health Service (NHS) Boards of treatment for financial years 2009-10 to 2018-19.

13. Procedures Performed For Children In An Acute Setting For NHS Scotland

This dataset provides information about procedures performed for children in an acute setting across Scotland. It includes admission type, operations group and episodes for operation group information for acute care hospital services.

14. Procedures Performed in Acute Hospitals by Treatment Setting

This dataset provides information about NHS procedures performed in acute hospitals by treatment across Scotland. It includes procedure, procedure type and admission type information for acute care hospital services.

We deliver high-quality data

• Each dataset goes through 3 levels of quality review
  • 2 Manual reviews are done by domain experts
  • Then, an automated set of 60+ validations enforces every datum matches metadata & defined constraints
• Data is normalized into one unified type system
  • All dates, unites, codes, currencies look the same
  • All null values are normalized to the same value
  • All dataset and field names are SQL and Hive compliant
• Data and Metadata
  • Data is available in both CSV and Apache Parquet format, optimized for high read performance on distributed Hadoop, Spark & MPP clusters
  • Metadata is provided in the open Frictionless Data standard, and its every field is normalized & validated
• Data Updates
  • Data updates support replace-on-update: outdated foreign keys are deprecated, not deleted

Our data is curated and enriched by domain experts

Each dataset is manually curated by our team of doctors, pharmacists, public health & medical billing experts:

• Field names, descriptions, and normalized values are chosen by people who actually understand their meaning
• Healthcare & life science experts add categories, search keywords, descriptions and more to each dataset
• Both manual and automated data enrichment supported for clinical codes, providers, drugs, and geo-locations
• The data is always kept up to date – even when the source requires manual effort to get updates
• Support for data subscribers is provided directly by the domain experts who curated the data sets
• Every data source’s license is manually verified to allow for royalty-free commercial use and redistribution.

• If you have questions about our products, contact us at info@johnsnowlabs.com .

John Snow Labs , an AI and NLP for healthcare company, provides state-of-the-art software, models, and data to help healthcare and life science organizations build, deploy, and operate AI projects.