Free Republic
Browse · Search
General/Chat
Topics · Post Article

Skip to comments.

COVID-19 Reported Patient Impact and Hospital Capacity by Facility (Visualizer)
U.S. Department of Health & Human Services ^ | October 4, 2021 | U.S. Department of Health & Human Services

Posted on 10/04/2021 10:27:14 AM PDT by rarestia

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

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. To see the numbers as reported by the facilities, go to: https://healthdata.gov/Hospital/COVID-19-Reported-Patient-Impact-and-Hospital-Capa/uqq2-txqb

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 collected fields only. This reflects that these fields are only reported on Wednesdays in a given week.

On 9/20/2001, the following has been updated: The use of analytic dataset as a source. Less


TOPICS: Health/Medicine
KEYWORDS: covid
The article link is to the Microsoft Power BI visualization dashboard for the data found at this link:

COVID-19 Reported Patient Impact and Hospital Capacity by Facility

This is public information.

Current nationwide COVID hospitalization accounts for 12.32% of all hospital beds and 25.37% of all ICU beds.

1 posted on 10/04/2021 10:27:14 AM PDT by rarestia
[ Post Reply | Private Reply | View Replies]

To: rarestia

They are getting these types of datasets in place in order to show how the capacity of the medical facilities is being overrun by Covid cases.

They will loudly complain about lack of capacity in order to blame the unvaccinated. They will neglect to mention the reduction in hospital capacity caused by the vaccine mandates.


2 posted on 10/04/2021 10:39:28 AM PDT by the_Watchman
[ Post Reply | Private Reply | To 1 | View Replies]

To: the_Watchman

They run at 80 to 90% all the time...staffing is the real problem


3 posted on 10/04/2021 10:40:49 AM PDT by Hojczyk
[ Post Reply | Private Reply | To 2 | View Replies]

To: rarestia

Staffing is the issue, covid is not.


4 posted on 10/04/2021 10:43:30 AM PDT by foundedonpurpose (Praise Hashem, for his restoration of all things!)
[ Post Reply | Private Reply | To 1 | View Replies]

To: the_Watchman

I believe that data is reflected here, and the data does not indicate an “overrun” of COVID patients. <25% is pretty small overall.


5 posted on 10/04/2021 10:50:53 AM PDT by rarestia (Repeal the 17th Amendment and ratify Article the First to give the power back to the people!)
[ Post Reply | Private Reply | To 2 | View Replies]

To: rarestia
We already know the numbers are corrupted by the fact the CDC recommends hospitals send home symptomatic-only cases in order to deny treatment during the first stage of CoVID, leading to the second stage of hospitalization and ... KA-CHING!!! $50k bonus from Feds.

Take away the $50k, and watch the hospitals free up overnight.

6 posted on 10/04/2021 11:12:54 AM PDT by RideForever (One of the CoVID Conatrol Group of Naturally Immune)
[ Post Reply | Private Reply | To 1 | View Replies]

Disclaimer: Opinions posted on Free Republic are those of the individual posters and do not necessarily represent the opinion of Free Republic or its management. All materials posted herein are protected by copyright law and the exemption for fair use of copyrighted works.

Free Republic
Browse · Search
General/Chat
Topics · Post Article

FreeRepublic, LLC, PO BOX 9771, FRESNO, CA 93794
FreeRepublic.com is powered by software copyright 2000-2008 John Robinson