Profile Picture HHS Office of the Chief Data Officer

created Dec 12 2020

updated Nov 28 2022

Description

The following dataset provides facility-level data for hospital utilization aggregated on a weekly basis (Friday to Thursday). These are derived from reports with facility-level granularity across two main sources: (1) HHS TeleTracking, and (2) reporting provided directly to HHS Protect by state/territorial health departments on behalf of their healthcare facilities.
The hospital population includes all hospitals registered with Centers for Medicare & Medicaid Services (CMS) as of June 1, 2020. It includes non-CMS hospitals that have reported since July 15, 2020. It does not include psychiatric, rehabilitation, Indian Health Service (IHS) facilities, U.S. Department of Veterans Affairs (VA) facilities, Defense Health Agency (DHA) facilities, and religious non-medical facilities.
For a given entry, the term “collection_week” signifies the start of the period that is aggregated. For example, a “collection_week” of 2020-11-20 means the average/sum/coverage of the elements captured from that given facility starting and including Friday, November 20, 2020, and ending and including reports for Thursday, November 26, 2020.
Reported elements include an append of either “_coverage”, “_sum”, or “_avg”.
  • A “_coverage” append denotes how many times the facility reported that element during that collection week.

  • A “_sum” append denotes the sum of the reports provided for that facility for that element during that collection week.

  • A “_avg” append is the average of the reports provided for that facility for that element during that collection week.
The file will be updated weekly. No statistical analysis is applied to impute non-response. For averages, calculations are based on the number of values collected for a given hospital in that collection week. Suppression is applied to the file for sums and averages less than four (4). In these cases, the field will be replaced with “-999,999”.
A story page was created to display both corrected and raw datasets and can be accessed at this link: https://healthdata.gov/stories/s/nhgk-5gpv
This data is preliminary and subject to change as more data become available. Data is available starting on July 31, 2020.
Sometimes, reports for a given facility will be provided to both HHS TeleTracking and HHS Protect. When this occurs, to ensure that there are not duplicate reports, deduplication is applied according to prioritization rules within HHS Protect.
For influenza fields listed in the file, the current HHS guidance marks these fields as optional. As a result, coverage of these elements are varied.
On May 3, 2021, the following fields have been added to this data set.
  • hhs_ids
  • previous_day_admission_adult_covid_confirmed_7_day_coverage
  • previous_day_admission_pediatric_covid_confirmed_7_day_coverage
  • previous_day_admission_adult_covid_suspected_7_day_coverage
  • previous_day_admission_pediatric_covid_suspected_7_day_coverage
  • previous_week_personnel_covid_vaccinated_doses_administered_7_day_sum
  • total_personnel_covid_vaccinated_doses_none_7_day_sum
  • total_personnel_covid_vaccinated_doses_one_7_day_sum
  • total_personnel_covid_vaccinated_doses_all_7_day_sum
  • previous_week_patients_covid_vaccinated_doses_one_7_day_sum
  • previous_week_patients_covid_vaccinated_doses_all_7_day_sum
On May 8, 2021, this data set has been converted to a corrected data set. The corrections applied to this data set are to smooth out data anomalies caused by keyed in data errors. To help determine which records have had corrections made to it. An additional Boolean field called is_corrected has been added.
On May 13, 2021 Changed vaccination fields from sum to max or min fields. This reflects the maximum or minimum number reported for that metric in a given week.
On June 7, 2021 Changed vaccination fields from max or min fields to Wednesday reported only. This reflects that the number reported for that metric is only reported on Wednesdays in a given week.
On September 20, 2021, the following has been updated: The use of analytic dataset as a source.
On January 19, 2022, the following fields have been added to this dataset:

  • inpatient_beds_used_covid_7_day_avg
  • inpatient_beds_used_covid_7_day_sum
  • inpatient_beds_used_covid_7_day_coverage
On April 28, 2022, the following pediatric fields have been added to this dataset:

  • all_pediatric_inpatient_bed_occupied_7_day_avg
  • all_pediatric_inpatient_bed_occupied_7_day_coverage
  • all_pediatric_inpatient_bed_occupied_7_day_sum
  • all_pediatric_inpatient_beds_7_day_avg
  • all_pediatric_inpatient_beds_7_day_coverage
  • all_pediatric_inpatient_beds_7_day_sum
  • previous_day_admission_pediatric_covid_confirmed_0_4_7_day_sum
  • previous_day_admission_pediatric_covid_confirmed_12_17_7_day_sum
  • previous_day_admission_pediatric_covid_confirmed_5_11_7_day_sum
  • previous_day_admission_pediatric_covid_confirmed_unknown_7_day_sum
  • staffed_icu_pediatric_patients_confirmed_covid_7_day_avg
  • staffed_icu_pediatric_patients_confirmed_covid_7_day_coverage
  • staffed_icu_pediatric_patients_confirmed_covid_7_day_sum
  • staffed_pediatric_icu_bed_occupancy_7_day_avg
  • staffed_pediatric_icu_bed_occupancy_7_day_coverage
  • staffed_pediatric_icu_bed_occupancy_7_day_sum
  • total_staffed_pediatric_icu_beds_7_day_avg
  • total_staffed_pediatric_icu_beds_7_day_coverage
  • total_staffed_pediatric_icu_beds_7_day_sum
On October 24, 2022, the data includes more analytical calculations in efforts to provide a cleaner dataset. For a raw version of this dataset, please follow this link: https://healthdata.gov/Hospital/COVID-19-Reported-Patient-Impact-and-Hospital-Capa/uqq2-txqb

Activity
Community Rating
Current value: 0 out of 5
Your Rating
Current value: 0 out of 5
Raters
0
Visits
368173
Downloads
303786
Comments
0
Contributors
0
Meta
Category
Hospital
Permissions
Public
Tags
covid-19, hhs covid-19
Row Label
Aggregated Facility Report for a Given Collection Week
SODA2 Only
Yes
Licensing and Attribution
Data Provided By
U.S. Department of Health & Human Services
Source Link
(none)
License
Public Domain U.S. Government
Common Core
Publisher
U.S. Department of Health & Human Services
Contact Name
HealthData.gov Team
Contact Email
HealthData@hhs.gov
Bureau Code
009:00
Program Code
009:028
Public Access Level
public
Is Quality Data
true
Update Frequency
R/P1W
Language
English
Last Update
November 28, 2022
This view cannot be displayed