Tyler Data & Insights

Close
Author
HHS Office of the Chief Data Officer
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”. <ul><li>A “_coverage” append denotes how many times the facility reported that element during that collection week.</li> <li>A “_sum” append denotes the sum of the reports provided for that facility for that element during that collection week.</li> <li>A “_avg” append is the average of the reports provided for that facility for that element during that collection week.</li></ul> 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”. <b> 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 </b> 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. <ul><li>hhs_ids <li>previous_day_admission_adult_covid_confirmed_7_day_coverage <li>previous_day_admission_pediatric_covid_confirmed_7_day_coverage <li>previous_day_admission_adult_covid_suspected_7_day_coverage <li>previous_day_admission_pediatric_covid_suspected_7_day_coverage <li>previous_week_personnel_covid_vaccinated_doses_administered_7_day_sum <li>total_personnel_covid_vaccinated_doses_none_7_day_sum <li>total_personnel_covid_vaccinated_doses_one_7_day_sum <li>total_personnel_covid_vaccinated_doses_all_7_day_sum <li>previous_week_patients_covid_vaccinated_doses_one_7_day_sum <li>previous_week_patients_covid_vaccinated_doses_all_7_day_sum</li></ul> 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: <ul> <li>inpatient_beds_used_covid_7_day_avg <li>inpatient_beds_used_covid_7_day_sum <li>inpatient_beds_used_covid_7_day_coverage </ul> On April 28, 2022, the following pediatric fields have been added to this dataset: <ul> <li>all_pediatric_inpatient_bed_occupied_7_day_avg <li>all_pediatric_inpatient_bed_occupied_7_day_coverage <li>all_pediatric_inpatient_bed_occupied_7_day_sum <li>all_pediatric_inpatient_beds_7_day_avg <li>all_pediatric_inpatient_beds_7_day_coverage <li>all_pediatric_inpatient_beds_7_day_sum <li>previous_day_admission_pediatric_covid_confirmed_0_4_7_day_sum <li>previous_day_admission_pediatric_covid_confirmed_12_17_7_day_sum <li>previous_day_admission_pediatric_covid_confirmed_5_11_7_day_sum <li>previous_day_admission_pediatric_covid_confirmed_unknown_7_day_sum <li>staffed_icu_pediatric_patients_confirmed_covid_7_day_avg <li>staffed_icu_pediatric_patients_confirmed_covid_7_day_coverage <li>staffed_icu_pediatric_patients_confirmed_covid_7_day_sum <li>staffed_pediatric_icu_bed_occupancy_7_day_avg <li>staffed_pediatric_icu_bed_occupancy_7_day_coverage <li>staffed_pediatric_icu_bed_occupancy_7_day_sum <li>total_staffed_pediatric_icu_beds_7_day_avg <li>total_staffed_pediatric_icu_beds_7_day_coverage <li>total_staffed_pediatric_icu_beds_7_day_sum </ul> 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
Category
Hospital
Tags
covid-19, hhs covid-19
Rating
Current value: 0 out of 5
Data Provided By
U.S. Department of Health & Human Services
License
Public Domain U.S. Government
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

hospital_pk
hospital_pk
collection_week
collection_week
state
state
ccn
ccn
hospital_name
hospital_name
address
address
city
city
zip
zip
hospital_subtype
hospital_subtype
fips_code
fips_code
is_metro_micro
is_metro_micro
total_beds_7_day_avg
total_beds_7_day_avg
all_adult_hospital_beds_7_day_avg
all_adult_hospital_beds_7_day_avg
all_adult_hospital_inpatient_beds_7_day_avg
all_adult_hospital_inpatient_beds_7_day_avg
inpatient_beds_used_7_day_avg
inpatient_beds_used_7_day_avg
all_adult_hospital_inpatient_bed_occupied_7_day_avg
all_adult_hospital_inpatient_bed_occupied_7_day_avg
inpatient_beds_used_covid_7_day_avg
inpatient_beds_used_covid_7_day_avg
total_adult_patients_hospitalized_confirmed_and_suspected_covid_7_day_avg
total_adult_patients_hospitalized_confirmed_and_suspected_covid_7_day_avg
total_adult_patients_hospitalized_confirmed_covid_7_day_avg
total_adult_patients_hospitalized_confirmed_covid_7_day_avg
total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_7_day_avg
total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_7_day_avg
total_pediatric_patients_hospitalized_confirmed_covid_7_day_avg
total_pediatric_patients_hospitalized_confirmed_covid_7_day_avg
inpatient_beds_7_day_avg
inpatient_beds_7_day_avg
total_icu_beds_7_day_avg
total_icu_beds_7_day_avg
total_staffed_adult_icu_beds_7_day_avg
total_staffed_adult_icu_beds_7_day_avg
icu_beds_used_7_day_avg
icu_beds_used_7_day_avg
staffed_adult_icu_bed_occupancy_7_day_avg
staffed_adult_icu_bed_occupancy_7_day_avg
staffed_icu_adult_patients_confirmed_and_suspected_covid_7_day_avg
staffed_icu_adult_patients_confirmed_and_suspected_covid_7_day_avg
staffed_icu_adult_patients_confirmed_covid_7_day_avg
staffed_icu_adult_patients_confirmed_covid_7_day_avg
total_patients_hospitalized_confirmed_influenza_7_day_avg
total_patients_hospitalized_confirmed_influenza_7_day_avg
icu_patients_confirmed_influenza_7_day_avg
icu_patients_confirmed_influenza_7_day_avg
total_patients_hospitalized_confirmed_influenza_and_covid_7_day_avg
total_patients_hospitalized_confirmed_influenza_and_covid_7_day_avg
total_beds_7_day_sum
total_beds_7_day_sum
all_adult_hospital_beds_7_day_sum
all_adult_hospital_beds_7_day_sum
all_adult_hospital_inpatient_beds_7_day_sum
all_adult_hospital_inpatient_beds_7_day_sum
inpatient_beds_used_7_day_sum
inpatient_beds_used_7_day_sum
all_adult_hospital_inpatient_bed_occupied_7_day_sum
all_adult_hospital_inpatient_bed_occupied_7_day_sum
inpatient_beds_used_covid_7_day_sum
inpatient_beds_used_covid_7_day_sum
total_adult_patients_hospitalized_confirmed_and_suspected_covid_7_day_sum
total_adult_patients_hospitalized_confirmed_and_suspected_covid_7_day_sum
total_adult_patients_hospitalized_confirmed_covid_7_day_sum
total_adult_patients_hospitalized_confirmed_covid_7_day_sum
total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_7_day_sum
total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_7_day_sum
total_pediatric_patients_hospitalized_confirmed_covid_7_day_sum
total_pediatric_patients_hospitalized_confirmed_covid_7_day_sum
inpatient_beds_7_day_sum
inpatient_beds_7_day_sum
total_icu_beds_7_day_sum
total_icu_beds_7_day_sum
total_staffed_adult_icu_beds_7_day_sum
total_staffed_adult_icu_beds_7_day_sum
icu_beds_used_7_day_sum
icu_beds_used_7_day_sum
staffed_adult_icu_bed_occupancy_7_day_sum
staffed_adult_icu_bed_occupancy_7_day_sum
staffed_icu_adult_patients_confirmed_and_suspected_covid_7_day_sum
staffed_icu_adult_patients_confirmed_and_suspected_covid_7_day_sum
staffed_icu_adult_patients_confirmed_covid_7_day_sum
staffed_icu_adult_patients_confirmed_covid_7_day_sum
total_patients_hospitalized_confirmed_influenza_7_day_sum
total_patients_hospitalized_confirmed_influenza_7_day_sum
icu_patients_confirmed_influenza_7_day_sum
icu_patients_confirmed_influenza_7_day_sum
total_patients_hospitalized_confirmed_influenza_and_covid_7_day_sum
total_patients_hospitalized_confirmed_influenza_and_covid_7_day_sum
total_beds_7_day_coverage
total_beds_7_day_coverage
all_adult_hospital_beds_7_day_coverage
all_adult_hospital_beds_7_day_coverage
all_adult_hospital_inpatient_beds_7_day_coverage
all_adult_hospital_inpatient_beds_7_day_coverage
inpatient_beds_used_7_day_coverage
inpatient_beds_used_7_day_coverage
all_adult_hospital_inpatient_bed_occupied_7_day_coverage
all_adult_hospital_inpatient_bed_occupied_7_day_coverage
inpatient_beds_used_covid_7_day_coverage
inpatient_beds_used_covid_7_day_coverage
total_adult_patients_hospitalized_confirmed_and_suspected_covid_7_day_coverage
total_adult_patients_hospitalized_confirmed_and_suspected_covid_7_day_coverage
total_adult_patients_hospitalized_confirmed_covid_7_day_coverage
total_adult_patients_hospitalized_confirmed_covid_7_day_coverage
total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_7_day_coverage
total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_7_day_coverage
total_pediatric_patients_hospitalized_confirmed_covid_7_day_coverage
total_pediatric_patients_hospitalized_confirmed_covid_7_day_coverage
inpatient_beds_7_day_coverage
inpatient_beds_7_day_coverage
total_icu_beds_7_day_coverage
total_icu_beds_7_day_coverage
total_staffed_adult_icu_beds_7_day_coverage
total_staffed_adult_icu_beds_7_day_coverage
icu_beds_used_7_day_coverage
icu_beds_used_7_day_coverage
staffed_adult_icu_bed_occupancy_7_day_coverage
staffed_adult_icu_bed_occupancy_7_day_coverage
staffed_icu_adult_patients_confirmed_and_suspected_covid_7_day_coverage
staffed_icu_adult_patients_confirmed_and_suspected_covid_7_day_coverage
staffed_icu_adult_patients_confirmed_covid_7_day_coverage
staffed_icu_adult_patients_confirmed_covid_7_day_coverage
total_patients_hospitalized_confirmed_influenza_7_day_coverage
total_patients_hospitalized_confirmed_influenza_7_day_coverage
icu_patients_confirmed_influenza_7_day_coverage
icu_patients_confirmed_influenza_7_day_coverage
total_patients_hospitalized_confirmed_influenza_and_covid_7_day_coverage
total_patients_hospitalized_confirmed_influenza_and_covid_7_day_coverage
previous_day_admission_adult_covid_confirmed_7_day_sum
previous_day_admission_adult_covid_confirmed_7_day_sum
previous_day_admission_adult_covid_confirmed_18-19_7_day_sum
previous_day_admission_adult_covid_confirmed_18_19_7_day_sum
previous_day_admission_adult_covid_confirmed_20-29_7_day_sum
previous_day_admission_adult_covid_confirmed_20_29_7_day_sum
previous_day_admission_adult_covid_confirmed_30-39_7_day_sum
previous_day_admission_adult_covid_confirmed_30_39_7_day_sum
previous_day_admission_adult_covid_confirmed_40-49_7_day_sum
previous_day_admission_adult_covid_confirmed_40_49_7_day_sum
previous_day_admission_adult_covid_confirmed_50-59_7_day_sum
previous_day_admission_adult_covid_confirmed_50
previous_day_admission_adult_covid_confirmed_60-69_7_day_sum
previous_day_admission_adult_covid_confirmed_60
previous_day_admission_adult_covid_confirmed_70-79_7_day_sum
previous_day_admission_adult_covid_confirmed_70
previous_day_admission_adult_covid_confirmed_80+_7_day_sum
previous_day_admission_adult_covid_confirmed_80
previous_day_admission_adult_covid_confirmed_unknown_7_day_sum
previous_day_admission_adult_covid_confirmed_unknown_7_day_sum
previous_day_admission_pediatric_covid_confirmed_7_day_sum
previous_day_admission_pediatric_covid_confirmed_7_day_sum
previous_day_covid_ED_visits_7_day_sum
previous_day_covid_ed_visits_7_day_sum
previous_day_admission_adult_covid_suspected_7_day_sum
previous_day_admission_adult_covid_suspected_7_day_sum
previous_day_admission_adult_covid_suspected_18-19_7_day_sum
previous_day_admission_adult_covid_suspected_18
previous_day_admission_adult_covid_suspected_20-29_7_day_sum
previous_day_admission_adult_covid_suspected_20
previous_day_admission_adult_covid_suspected_30-39_7_day_sum
previous_day_admission_adult_covid_suspected_30
previous_day_admission_adult_covid_suspected_40-49_7_day_sum
previous_day_admission_adult_covid_suspected_40
previous_day_admission_adult_covid_suspected_50-59_7_day_sum
previous_day_admission_adult_covid_suspected_50
previous_day_admission_adult_covid_suspected_60-69_7_day_sum
previous_day_admission_adult_covid_suspected_60
previous_day_admission_adult_covid_suspected_70-79_7_day_sum
previous_day_admission_adult_covid_suspected_70_79_7_day_sum
previous_day_admission_adult_covid_suspected_80+_7_day_sum
previous_day_admission_adult_covid_suspected_80
previous_day_admission_adult_covid_suspected_unknown_7_day_sum
previous_day_admission_adult_covid_suspected_unknown_7_day_sum
previous_day_admission_pediatric_covid_suspected_7_day_sum
previous_day_admission_pediatric_covid_suspected_7_day_sum
previous_day_total_ED_visits_7_day_sum
previous_day_total_ed_visits_7_day_sum
previous_day_admission_influenza_confirmed_7_day_sum
previous_day_admission_influenza_confirmed_7_day_sum
geocoded_hospital_address
geocoded_hospital_address
hhs_ids
hhs_ids
previous_day_admission_adult_covid_confirmed_7_day_coverage
previous_day_admission_adult_covid_confirmed_7_day_coverage
previous_day_admission_pediatric_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_adult_covid_suspected_7_day_coverage
previous_day_admission_pediatric_covid_suspected_7_day_coverage
previous_day_admission_pediatric_covid_suspected_7_day_coverage
previous_week_personnel_covid_vaccinated_doses_administered_7_day
previous_week_personnel_covid_vaccinated_doses_administered_7_day
total_personnel_covid_vaccinated_doses_none_7_day
total_personnel_covid_vaccinated_doses_none_7_day
total_personnel_covid_vaccinated_doses_one_7_day
total_personnel_covid_vaccinated_doses_one_7_day
total_personnel_covid_vaccinated_doses_all_7_day
total_personnel_covid_vaccinated_doses_all_7_day
previous_week_patients_covid_vaccinated_doses_one_7_day
previous_week_patients_covid_vaccinated_doses_one_7_day
previous_week_patients_covid_vaccinated_doses_all_7_day
previous_week_patients_covid_vaccinated_doses_all_7_day
is_corrected
is_corrected
all_pediatric_inpatient_bed_occupied_7_day_avg
all_pediatric_inpatient_bed_occupied_7_day_avg
all_pediatric_inpatient_bed_occupied_7_day_coverage
all_pediatric_inpatient_bed_occupied_7_day_coverage
all_pediatric_inpatient_bed_occupied_7_day_sum
all_pediatric_inpatient_bed_occupied_7_day_sum
all_pediatric_inpatient_beds_7_day_avg
all_pediatric_inpatient_beds_7_day_avg
all_pediatric_inpatient_beds_7_day_coverage
all_pediatric_inpatient_beds_7_day_coverage
all_pediatric_inpatient_beds_7_day_sum
all_pediatric_inpatient_beds_7_day_sum
previous_day_admission_pediatric_covid_confirmed_0_4_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_12_17_7_day_sum
previous_day_admission_pediatric_covid_confirmed_5_11_7_day_sum
previous_day_admission_pediatric_covid_confirmed_5_11_7_day_sum
previous_day_admission_pediatric_covid_confirmed_unknown_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_avg
staffed_icu_pediatric_patients_confirmed_covid_7_day_coverage
staffed_icu_pediatric_patients_confirmed_covid_7_day_coverage
staffed_icu_pediatric_patients_confirmed_covid_7_day_sum
staffed_icu_pediatric_patients_confirmed_covid_7_day_sum
staffed_pediatric_icu_bed_occupancy_7_day_avg
staffed_pediatric_icu_bed_occupancy_7_day_avg
staffed_pediatric_icu_bed_occupancy_7_day_coverage
staffed_pediatric_icu_bed_occupancy_7_day_coverage
staffed_pediatric_icu_bed_occupancy_7_day_sum
staffed_pediatric_icu_bed_occupancy_7_day_sum
total_staffed_pediatric_icu_beds_7_day_avg
total_staffed_pediatric_icu_beds_7_day_avg
total_staffed_pediatric_icu_beds_7_day_coverage
total_staffed_pediatric_icu_beds_7_day_coverage
total_staffed_pediatric_icu_beds_7_day_sum
total_staffed_pediatric_icu_beds_7_day_sum
Demo | State Geographic Boundaries
:@computed_region_pqdx_y6mm

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.