COVID-19 Reported Patient Impact and Hospital Capacity by State

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

This data was updated Aug 3, 2022.

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.

Custom SQL query returning 54 rows (hide)

datestateshortage_todayno_shortage_todaynot_reportedpercent_not_reporting
2022/07/01 DC 0 0 14 100
2022/07/01 LA 1 1 225 99
2022/07/01 MA 0 4 97 96
2022/07/01 MN 4 1 135 96
2022/07/01 AL 0 8 109 93
2022/07/01 WV 0 8 55 87
2022/07/01 WY 0 4 27 87
2022/07/01 RI 1 1 13 86
2022/07/01 NV 0 9 54 85
2022/07/01 PR 0 11 55 83
2022/07/01 ND 0 9 41 82
2022/07/01 TX 6 106 483 81
2022/07/01 CA 9 124 275 67
2022/07/01 NM 2 18 35 63
2022/07/01 CT 0 15 25 62
2022/07/01 NH 2 10 18 60
2022/07/01 OK 0 63 88 58
2022/07/01 OH 3 99 133 56
2022/07/01 TN 3 65 71 51
2022/07/01 ID 1 28 24 45
2022/07/01 AZ 2 68 48 40
2022/07/01 PA 31 114 84 36
2022/07/01 ME 2 23 14 35
2022/07/01 IA 0 88 37 29
2022/07/01 CO 15 62 31 28
2022/07/01 MD 6 37 17 28
2022/07/01 FL 10 187 72 26
2022/07/01 MO 5 98 38 26
2022/07/01 VA 10 74 23 21
2022/07/01 GA 29 106 35 20
2022/07/01 OR 3 48 13 20
2022/07/01 HI 3 18 5 19
2022/07/01 NJ 6 75 15 15
2022/07/01 SD 0 55 10 15
2022/07/01 UT 0 50 9 15
2022/07/01 WI 14 114 24 15
2022/07/01 IL 4 171 29 14
2022/07/01 KY 9 89 17 14
2022/07/01 NE 16 70 13 13
2022/07/01 DE 1 13 2 12
2022/07/01 AR 5 93 13 11
2022/07/01 MS 2 99 10 9
2022/07/01 NC 19 100 12 9
2022/07/01 AK 1 21 2 8
2022/07/01 WA 1 95 9 8
2022/07/01 KS 10 130 10 6
2022/07/01 NY 2 191 14 6
2022/07/01 SC 20 63 5 5
2022/07/01 VT 3 13 1 5
2022/07/01 MT 6 56 3 4
2022/07/01 IN 13 152 4 2
2022/07/01 MI 27 130 4 2
2022/07/01 AS 0 1 0 0
2022/07/01 VI 0 2 0 0
Powered by Datasette · Queries took 17.373ms · Data source: U.S. Department of Health & Human Services