Fraction of hospitals not reporting staffing shortages, by state

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 date, state, sum(critical_staffing_shortage_today_yes) as shortage_today, sum(critical_staffing_shortage_today_no) as no_shortage_today, sum(critical_staffing_shortage_today_not_reported) as not_reported, 100*critical_staffing_shortage_today_not_reported/(critical_staffing_shortage_today_not_reported + critical_staffing_shortage_today_no + critical_staffing_shortage_today_yes) as percent_not_reporting from hospitals_state where date = '2022/07/01' group by state, date order by 6 desc;

Edit SQL

datestateshortage_todayno_shortage_todaynot_reportedpercent_not_reporting
2022/07/01 DC 0 0 14 100
2022/07/01 LA 1 2 224 98
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 ND 0 5 45 90
2022/07/01 WV 0 8 55 87
2022/07/01 RI 1 1 13 86
2022/07/01 PR 0 11 55 83
2022/07/01 WY 0 5 26 83
2022/07/01 TX 7 104 482 81
2022/07/01 NV 1 12 51 79
2022/07/01 CA 9 114 279 69
2022/07/01 NM 2 16 37 67
2022/07/01 OK 3 46 99 66
2022/07/01 CT 0 13 25 65
2022/07/01 NH 2 10 18 60
2022/07/01 OH 2 96 134 57
2022/07/01 ID 1 23 26 52
2022/07/01 TN 3 63 71 51
2022/07/01 AZ 1 59 49 44
2022/07/01 PA 30 106 89 39
2022/07/01 ME 1 23 14 36
2022/07/01 IA 0 87 37 29
2022/07/01 CO 14 62 31 28
2022/07/01 FL 8 180 75 28
2022/07/01 MO 5 90 38 28
2022/07/01 MD 3 37 14 25
2022/07/01 VA 10 74 23 21
2022/07/01 OR 2 49 13 20
2022/07/01 IL 4 160 29 15
2022/07/01 KY 10 86 17 15
2022/07/01 SD 0 54 10 15
2022/07/01 UT 0 48 9 15
2022/07/01 WI 17 110 24 15
2022/07/01 NJ 5 75 14 14
2022/07/01 NE 16 69 13 13
2022/07/01 AR 4 90 13 12
2022/07/01 GA 34 114 21 12
2022/07/01 MS 2 96 10 9
2022/07/01 NC 12 105 12 9
2022/07/01 AK 1 21 2 8
2022/07/01 WA 0 94 9 8
2022/07/01 DE 1 14 1 6
2022/07/01 KS 10 125 10 6
2022/07/01 NY 2 186 14 6
2022/07/01 VT 4 11 1 6
2022/07/01 SC 20 63 5 5
2022/07/01 MT 5 57 3 4
2022/07/01 HI 3 22 1 3
2022/07/01 IN 13 146 4 2
2022/07/01 MI 25 131 4 2
2022/07/01 AS 0 1 0 0
2022/07/01 VI 0 2 0 0
Powered by Datasette · Queries took 17.45ms