Rank ICU covid occupancy by state for the most recent date available

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)

select state, date, 100*(staffed_icu_adult_patients_confirmed_and_suspected_covid)/(total_staffed_adult_icu_beds) as icu_adult_prnct, total_staffed_adult_icu_beds as tot_adult_icu_beds, staffed_icu_adult_patients_confirmed_and_suspected_covid as tot_adult_icu_covid from hospitals_state where date == '2022/07/01'  order by icu_adult_prnct desc;

Edit SQL

statedateicu_adult_prncttot_adult_icu_bedstot_adult_icu_covid
NV 2022/07/01 8 803 66
PR 2022/07/01 8 660 53
OR 2022/07/01 8 703 62
OK 2022/07/01 6 967 61
DC 2022/07/01 6 333 20
NC 2022/07/01 6 2206 151
TX 2022/07/01 6 6430 394
GA 2022/07/01 6 2495 162
ME 2022/07/01 6 321 21
NM 2022/07/01 6 388 26
WA 2022/07/01 6 1157 78
MO 2022/07/01 6 1681 101
FL 2022/07/01 6 6434 422
VI 2022/07/01 5 20 1
UT 2022/07/01 5 456 27
AR 2022/07/01 5 851 49
MN 2022/07/01 5 831 43
CA 2022/07/01 5 6823 374
NY 2022/07/01 5 4393 236
MS 2022/07/01 5 729 39
VA 2022/07/01 5 1880 95
WI 2022/07/01 4 1242 51
DE 2022/07/01 4 182 9
LA 2022/07/01 4 1436 58
ID 2022/07/01 4 268 12
CO 2022/07/01 4 1206 53
VT 2022/07/01 4 96 4
MD 2022/07/01 4 966 44
HI 2022/07/01 4 204 10
KY 2022/07/01 4 1316 59
SC 2022/07/01 4 1290 56
WV 2022/07/01 3 641 25
MA 2022/07/01 3 1218 46
MT 2022/07/01 3 221 7
WY 2022/07/01 3 121 4
AZ 2022/07/01 3 1626 61
SD 2022/07/01 3 230 9
CT 2022/07/01 3 903 32
NE 2022/07/01 3 478 18
IL 2022/07/01 3 3072 117
AL 2022/07/01 3 1548 61
MI 2022/07/01 2 2313 67
ND 2022/07/01 2 207 6
IN 2022/07/01 2 2073 60
TN 2022/07/01 2 2434 72
IA 2022/07/01 2 555 16
KS 2022/07/01 2 778 21
NJ 2022/07/01 2 2895 75
OH 2022/07/01 2 3698 95
NH 2022/07/01 2 228 5
AK 2022/07/01 2 131 3
PA 2022/07/01 2 3716 107
RI 2022/07/01 0 139 1
AS 2022/07/01 0 7 0
Powered by Datasette · Queries took 20.605ms