Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

Sign in
Your Saved List Become a Channel Partner Sell in AWS Marketplace Amazon Web Services Home Help

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

DescriptionValue
Data Package ComplexitySimple
Available EnrichmentsN/A
KeywordsBed 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 TitlesDay Bed Occupancy in England Hospitals, NHS Hospital Bed Occupancy Rate, Quarterly Hospital Activity Data, Sub-Saharan Public Hospitals Geo-Coded database

Included Datasets

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

  7. 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.

  8. 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.

  9. 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?


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
Refund policy
“No refunds offered. For any questions email us at info@johnsnowlabs.com”.
General AWS Data Exchange support