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.

Example Queries

Custom SQL query

cbsa2fips

cbsacode, metrodivisioncode, csacode, cbsatitle, metropolitanmicropolitanstatis, metropolitandivisiontitle, csatitle, countycountyequivalent, statename...

1,882 rows

hosp_capacity

hospital_pk, collection_week, state, ccn, hospital_name, address, city, zip, hospital_subtype...

419,754 rows

Download SQLite DB: hhs.db 155.6 MB

Powered by Datasette · Queries took 6.725ms · Data source: U.S. Department of Health & Human Services