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 Sept. 20, 2021.

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

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


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

1,882 rows


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

378,598 rows

Download SQLite DB: hhs.db 167.2 MB

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