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/09/21' group by state, date order by 6 desc;

Edit SQL

datestateshortage_todayno_shortage_todaynot_reportedpercent_not_reporting
2022/09/21 DC 0 0 14 100
2022/09/21 MA 0 0 79 100
2022/09/21 AL 0 1 100 99
2022/09/21 LA 1 4 154 96
2022/09/21 WY 0 1 28 96
2022/09/21 MN 5 1 124 95
2022/09/21 ND 0 3 40 93
2022/09/21 RI 1 0 13 92
2022/09/21 WV 0 4 51 92
2022/09/21 PR 0 6 59 90
2022/09/21 TX 5 38 428 90
2022/09/21 NV 1 6 39 84
2022/09/21 PA 7 33 153 79
2022/09/21 CA 6 85 289 76
2022/09/21 CT 0 8 25 75
2022/09/21 NM 3 9 35 74
2022/09/21 NH 2 6 18 69
2022/09/21 OH 3 59 133 68
2022/09/21 OK 2 40 88 67
2022/09/21 TN 3 40 68 61
2022/09/21 ID 1 18 27 58
2022/09/21 WA 1 38 52 57
2022/09/21 AZ 1 39 45 52
2022/09/21 ME 1 20 13 38
2022/09/21 MD 12 20 19 37
2022/09/21 CO 14 44 31 34
2022/09/21 FL 7 136 74 34
2022/09/21 MO 4 71 39 34
2022/09/21 IA 0 80 38 32
2022/09/21 VA 10 59 23 25
2022/09/21 DE 2 5 2 22
2022/09/21 NE 11 63 20 21
2022/09/21 OR 2 45 13 21
2022/09/21 HI 3 16 5 20
2022/09/21 UT 0 41 9 18
2022/09/21 KY 7 76 17 17
2022/09/21 WI 17 102 24 16
2022/09/21 IL 5 145 27 15
2022/09/21 SD 1 52 10 15
2022/09/21 AR 0 75 13 14
2022/09/21 GA 29 97 22 14
2022/09/21 NJ 7 58 11 14
2022/09/21 NC 17 86 12 10
2022/09/21 AK 1 19 2 9
2022/09/21 MS 2 89 9 9
2022/09/21 NY 2 153 14 8
2022/09/21 KS 9 115 10 7
2022/09/21 SC 20 41 5 7
2022/09/21 VT 2 12 1 6
2022/09/21 MT 3 57 3 4
2022/09/21 IN 9 115 3 2
2022/09/21 MI 30 120 4 2
2022/09/21 AS 0 1 0 0
2022/09/21 VI 0 2 0 0
Powered by Datasette · Queries took 22.581ms