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 (show)

Edit SQL

statedateicu_adult_prncttot_adult_icu_bedstot_adult_icu_covid
OR 2022/08/03 10 690 69
MS 2022/08/03 9 733 70
NC 2022/08/03 9 2182 212
OK 2022/08/03 8 940 76
KY 2022/08/03 8 1288 113
ID 2022/08/03 8 257 23
TX 2022/08/03 8 6144 545
AR 2022/08/03 8 833 72
CA 2022/08/03 7 6618 522
WV 2022/08/03 7 595 44
AK 2022/08/03 7 140 10
WI 2022/08/03 7 1247 91
DE 2022/08/03 7 181 13
MO 2022/08/03 7 1678 133
NV 2022/08/03 7 767 58
GA 2022/08/03 7 2585 195
FL 2022/08/03 7 6485 508
WA 2022/08/03 7 1137 89
IA 2022/08/03 7 554 39
AL 2022/08/03 7 1535 110
UT 2022/08/03 6 433 27
LA 2022/08/03 6 1436 94
SC 2022/08/03 6 1282 82
PR 2022/08/03 6 602 39
VA 2022/08/03 6 1815 116
MN 2022/08/03 5 824 45
IL 2022/08/03 5 3107 158
MD 2022/08/03 5 1215 71
NY 2022/08/03 5 3950 236
NE 2022/08/03 5 488 26
NM 2022/08/03 5 393 22
KS 2022/08/03 5 659 34
ME 2022/08/03 5 327 17
IN 2022/08/03 5 2081 107
MI 2022/08/03 5 2359 126
MA 2022/08/03 4 1209 59
MT 2022/08/03 4 219 9
VT 2022/08/03 4 98 4
CO 2022/08/03 4 1227 52
SD 2022/08/03 4 242 10
PA 2022/08/03 4 3487 152
TN 2022/08/03 4 2413 119
AZ 2022/08/03 4 1585 70
OH 2022/08/03 4 3666 157
NH 2022/08/03 3 226 7
CT 2022/08/03 3 905 29
ND 2022/08/03 3 206 7
NJ 2022/08/03 3 2897 92
HI 2022/08/03 3 209 7
RI 2022/08/03 2 143 3
WY 2022/08/03 2 125 3
DC 2022/08/03 2 324 9
AS 2022/08/03 0 7 0
VI 2022/08/03 0 20 0
Powered by Datasette · Queries took 20.46ms