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 Oct 12, 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/09/21 MA 0 0 102 100
2022/09/21 AL 0 1 101 99
2022/09/21 LA 3 4 155 95
2022/09/21 MN 5 1 132 95
2022/09/21 DC 0 1 13 92
2022/09/21 RI 1 0 13 92
2022/09/21 WV 0 4 51 92
2022/09/21 WY 0 3 27 90
2022/09/21 NV 0 5 43 89
2022/09/21 TX 5 58 415 86
2022/09/21 ND 0 10 39 79
2022/09/21 PA 8 41 151 75
2022/09/21 CA 6 98 282 73
2022/09/21 CT 0 9 25 73
2022/09/21 NM 2 13 37 71
2022/09/21 PR 0 19 46 70
2022/09/21 NH 2 6 18 69
2022/09/21 OH 3 62 132 67
2022/09/21 OK 3 47 87 63
2022/09/21 TN 3 42 70 60
2022/09/21 WA 1 40 56 57
2022/09/21 ID 1 21 26 54
2022/09/21 AZ 1 48 44 47
2022/09/21 ME 1 20 14 40
2022/09/21 CO 14 50 31 32
2022/09/21 MO 7 75 39 32
2022/09/21 FL 7 149 70 30
2022/09/21 IA 0 84 35 29
2022/09/21 GA 24 89 42 27
2022/09/21 MD 1 38 13 25
2022/09/21 VA 10 59 23 25
2022/09/21 NE 8 65 23 23
2022/09/21 UT 0 43 9 17
2022/09/21 KY 7 80 17 16
2022/09/21 WI 16 107 24 16
2022/09/21 IL 4 154 28 15
2022/09/21 SD 1 52 10 15
2022/09/21 AR 1 78 13 14
2022/09/21 OR 4 51 8 12
2022/09/21 NC 15 91 12 10
2022/09/21 AK 1 20 2 8
2022/09/21 DE 2 9 1 8
2022/09/21 MS 3 90 9 8
2022/09/21 KS 12 119 10 7
2022/09/21 NJ 6 80 7 7
2022/09/21 NY 4 164 14 7
2022/09/21 SC 20 43 5 7
2022/09/21 VT 2 14 1 5
2022/09/21 HI 3 20 1 4
2022/09/21 MT 2 59 2 3
2022/09/21 IN 8 130 3 2
2022/09/21 MI 30 121 4 2
2022/09/21 AS 0 1 0 0
2022/09/21 VI 0 2 0 0
Powered by Datasette · Queries took 18.165ms · Data source: U.S. Department of Health & Human Services