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 April 19 with data reported April 9 through April 16.

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

cbsaxfips

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

184,384 rows

Download SQLite DB: hhs.db 167.2 MB

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