COVID-19 Reported Patient Impact and Hospital Capacity by Facility

This dataset provides facility-level data for hospital utilization overall, and for COVID patients, on a weekly basis (Friday to Thursday) since July 31. The data come directly from the U.S. Department of Health and Human Services. We have not reviewed the data for accuracy.

The data is released each Monday with data for the prior week. This data was updated Mar 21, 2022.

Numbers smaller than 4 have been replaced, by HHS, with the value -999999. See the data dictionary for more details.

The 'collection_week' date is the start of a seven day period including Friday and ending and including reports for the following Thursday

Data source: U.S. Department of Health & Human Services

This database can be queried directly using Structured Query Language (SQL) supported by SQLite. For more on that syntax, see here. Read more about datasette, the technology powering these interactive queries.

Custom SQL query (hide)

select rowid, collection_week, state, ccn, hospital_name, address, city, zip, hospital_subtype, 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_and_suspected_covid_7_day_sum, total_pediatric_patients_hospitalized_confirmed_covid_7_day_sum, total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_7_day_coverage, total_pediatric_patients_hospitalized_confirmed_covid_7_day_coverage, previous_day_admission_pediatric_covid_confirmed_7_day_sum, previous_day_admission_pediatric_covid_suspected_7_day_sum, previous_day_admission_pediatric_covid_confirmed_7_day_coverage, previous_day_admission_pediatric_covid_suspected_7_day_coverage, is_corrected from hosp_capacity where ccn = :ccn order by collection_week desc;

Query parameters

ccn

0 results