Health Facility Database

**Overview**
This data package contains the hospital bed availability and occupancy data by consultant main specialty and sector as well as data on inpatient and outpatient related hospital activity in England. It also contains information on Sub-Saharan public hospitals.

**Description**
This data package contains all NHS (National Health Service) organizations that operate beds, open overnight or day only, collect the total number of available bed days and the total number of occupied bed days by consultant main specialty and sector. The new quarterly KH03 collects bed occupancy data, for levels of care other than critical care (excludes Clinical Care Intensity for General Patients code 11 for intensive therapy, including high dependency care), by consultant main specialty and sector. It covers available and occupied bed days open overnight and day only, but not residential care beds. Inpatient and Outpatient Related Hospital Activity Data contains quarterly 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. Sub-Saharan Public Hospitals Database dataset provides a geocoded inventory of public hospitals across 48 countries and islands of sub-Saharan Africa from 100 different sources. This geo-coded inventory of hospital in Africa is created to enhance access to health services and hospitals.

**Benefits**
- Capacity planning of hospital. the prediction of hospital bed availability in next 72 hours. optimization of bed occupancy in a hospital. enhancement of the operation process. improved hospital efficiency in the health-care industry.

**License Information**
The use of John Snow Labs datasets is free for personal and research purposes. For commercial use please subscribe to the [Data Library](https://www.johnsnowlabs.com/marketplace/) on John Snow Labs website. The subscription will allow you to use all John Snow Labs datasets and data packages for commercial purposes.

**Included Datasets**
- [Hospital Bed Availability and Occupancy by Sector](https://www.johnsnowlabs.com/marketplace/hospital-bed-availability-and-occupancy-by-sector)
- This dataset provides information on the total number of available and occupied bed days for facility wards open "overnight" and "day only" by NHS (National Health Service) Trust by Sector.
- [Hospital Bed Occupancy by Consultant Main Specialty](https://www.johnsnowlabs.com/marketplace/hospital-bed-occupancy-by-consultant-main-specialty)
- This dataset provides information on the total number of occupied bed days for facility wards open "overnight" and "day only" by consultant main specialty.
- [Inpatient and Outpatient Related Hospital Activity Data](https://www.johnsnowlabs.com/marketplace/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.
- [Maryland Mortality Statistics by Hospital](https://www.johnsnowlabs.com/marketplace/maryland-mortality-statistics-by-hospital)
- This dataset contains Mortality Statistics for years 2015 and 2016 from Quality Based Reimbursement (QBR) Program for hospitals in Maryland. It includes Hospital ID, Hospital Name, Mortality Rate, Ratio of Observed to Predicted Mortality Rate, Risk Adjusted Mortality and Survival Rates, Number of Dead and time period covered for the data collected.
- [Maryland QBR Patient Safety Measures Data](https://www.johnsnowlabs.com/marketplace/maryland-qbr-patient-safety-measures-data)
- This dataset contains different Patient Safety Measures from Quality Based Reimbursement (QBR) Program for hospitals in Maryland. The Patient Safety measures include data for the base and performance periods for six different measures.
- [New York Medicaid Children Hospitalization Quality by County](https://www.johnsnowlabs.com/marketplace/new-york-medicaid-children-hospitalization-quality-by-county)
- This dataset displays the number of Medicaid Pediatric Quality Indicators (PDI) hospitalizations by county of The Agency for Healthcare Research and Quality (AHRQ). It covers patients from 2 to 17 years old, from 2011 to 2014. Risk-adjusted rates are included.
- [New York Medicaid Children Hospitalization Quality by Zip Code](https://www.johnsnowlabs.com/marketplace/new-york-medicaid-children-hospitalization-quality-by-zip-code)
- This dataset displays the number of Medicaid Pediatric Quality Indicators (PDI) hospitalizations by zip code of The Agency for Healthcare Research and Quality (AHRQ). It covers patients from 2 to 17 years old, from 2011 to 2014. Risk-adjusted rates are included.
- [Perinatal Care Early Elective Delivery Data](https://www.johnsnowlabs.com/marketplace/perinatal-care-early-elective-delivery-data)
- This dataset contains different Perinatal Care Early Elective Delivery Data for years 2014 and 2015 from Quality Based Reimbursement (QBR) Program for hospitals in Maryland. It includes Hospital ID, Hospital Name, Perinatal Care Score, Patient Sample and time period covered by the data collected.
- [Sub-Saharan Public Hospitals Database](https://www.johnsnowlabs.com/marketplace/sub-saharan-public-hospitals-database)
- This dataset provides a geocoded inventory of public hospitals across 48 countries and islands of sub-Saharan Africa from 100 different sources.

**Data Engineering Overview**
**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.

**Need Help?**
If you have questions about our products, contact us at [[e-mail]](mailto:[e-mail]).