
Health Facility Database
Provided By: John Snow Labs

Health Facility Database
Provided By: John Snow Labs
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.
Product offers
The following offers are available for this product. Choose an offer to view the pricing and access duration options for the offer. Select an offer and continue to subscribe. Your subscription begins on the date that you accept the offer. Additional taxes or fees might apply.
Public offer
Payment schedule: Upfront payment | Offer auto-renewal: Supported
$0 for 12 months
Overview
Overview
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.
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 on AWS. The subscription will allow you to use all John Snow Labs datasets and data packages for commercial purposes.
Metadata
Description | Value |
---|---|
Data Package Complexity | Simple |
Available Enrichments | N/A |
Keywords | Bed Occupancy Data, Bed Availability Data, Types of Hospital Beds, Hospital Bed Occupancy, Used Hospital Beds, Clinical Commissioning Group Data, Hospital Data, Quarterly Activity Return Hospital Data, Health Facilities in Sub-Sahara |
Other Titles | Day Bed Occupancy in England Hospitals, NHS Hospital Bed Occupancy Rate, Quarterly Hospital Activity Data, Sub-Saharan Public Hospitals Geo-Coded database |
Included Datasets
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
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
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
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
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
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
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
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
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 info@johnsnowlabs.com.
About Us
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.
Provided By
Fulfillment Method
AWS Data Exchange
Data dictionaries
A data dictionary is a visual representation of the contents of a data set. The data represented here is for evaluation purposes only and may not accurately represent the actual content of the product.
- ...
Field name | Description | Example | Data type | Primary key | Nullable | Max length | Data set | Table name | Table description |
---|---|---|---|---|---|---|---|---|---|
Bed_Type | Type of beds open "overnight" or "day only" | - | string | - | false | - | Hospital Bed Availability and Occupancy by Sector | hospital_bed_availability_and_occupancy_by_sector | |
Quarter | Quarter of the year in which the data was collected. | Q2 | string | - | false | - | Hospital Bed Availability and Occupancy by Sector | hospital_bed_availability_and_occupancy_by_sector | |
Year | Data collection Year | 2017 | date | - | false | - | Hospital Bed Availability and Occupancy by Sector | hospital_bed_availability_and_occupancy_by_sector | |
Period | Data collection period | July to September | string | - | false | - | Hospital Bed Availability and Occupancy by Sector | hospital_bed_availability_and_occupancy_by_sector | |
Region_Code | Region code of the NHS organizations that operate beds. | - | string | - | - | - | Hospital Bed Availability and Occupancy by Sector | hospital_bed_availability_and_occupancy_by_sector | |
Organization_Code | NHS Organization unique code | - | string | - | - | - | Hospital Bed Availability and Occupancy by Sector | hospital_bed_availability_and_occupancy_by_sector | |
Organization_Name | Name of the NHS organizations that operate beds | - | string | - | - | - | Hospital Bed Availability and Occupancy by Sector | hospital_bed_availability_and_occupancy_by_sector | |
Available_Beds_in_Total | Total available bed days | - | integer | - | - | - | Hospital Bed Availability and Occupancy by Sector | hospital_bed_availability_and_occupancy_by_sector | |
Available_Beds_in_General_and_Acute | Beds available in general and acute sectors | - | integer | - | - | - | Hospital Bed Availability and Occupancy by Sector | hospital_bed_availability_and_occupancy_by_sector | |
Available_Beds_in_Learning_Disabilities | Beds available in Learning Disabilities | - | integer | - | - | - | Hospital Bed Availability and Occupancy by Sector | hospital_bed_availability_and_occupancy_by_sector |
Data sets (9)
You will receive access to the following data sets
Revision access rules
All historical revisions | All future revisions
Name | Type | Data dictionary | AWS Region |
---|---|---|---|
Sub-Saharan Public Hospitals Database | Included | US East (N. Virginia) | |
Perinatal Care Early Elective Delivery Data | Included | US East (N. Virginia) | |
New York Medicaid Children Hospitalization Quality by Zip Code | Included | US East (N. Virginia) | |
New York Medicaid Children Hospitalization Quality by County | Included | US East (N. Virginia) | |
Maryland QBR Patient Safety Measures Data | Included | US East (N. Virginia) | |
Maryland Mortality Statistics by Hospital | Included | US East (N. Virginia) | |
Inpatient and Outpatient Related Hospital Activity Data | Included | US East (N. Virginia) | |
Hospital Bed Occupancy by Consultant Main Specialty | Included | US East (N. Virginia) | |
Hospital Bed Availability and Occupancy by Sector | Included | US East (N. Virginia) |
Data dictionaries and samples
Sample data is for evaluation purposes only and may not accurately represent the actual content of the product.
Name | Resource | File type | File size | Description | ||
---|---|---|---|---|---|---|
Hospital Bed Availability and Occupancy by Sector | Data set | - | - | - | ||
Data dictionary | Data dictionary | text/csv | - | |||
data_preview.csv | Sample | text/csv | Preview of Hospital Bed Availability and Occupancy by Sector dataset | |||
Hospital Bed Occupancy by Consultant Main Specialty | Data set | - | - | - | ||
Inpatient and Outpatient Related Hospital Activity Data | Data set | - | - | - | ||
Maryland Mortality Statistics by Hospital | Data set | - | - | - | ||
Maryland QBR Patient Safety Measures Data | Data set | - | - | - | ||
New York Medicaid Children Hospitalization Quality by County | Data set | - | - | - | ||
New York Medicaid Children Hospitalization Quality by Zip Code | Data set | - | - | - | ||
Perinatal Care Early Elective Delivery Data | Data set | - | - | - | ||
Sub-Saharan Public Hospitals Database | Data set | - | - | - |
Usage information
By subscribing to this product, you agree that your use of this product is subject to the provider's offer terms including pricing information and Data Subscription Agreement . Your use of AWS services remains subject to the AWS Customer Agreement or other agreement with AWS governing your use of such services.
Support information
Support contact email address
Support contact URL
Refund policy
“No refunds offered. For any questions email us at info@johnsnowlabs.com”.
General AWS Data Exchange support