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

Edit SQL

datestateshortage_todayno_shortage_todaynot_reportedpercent_not_reporting
2022/10/12 DC 0 0 14 100
2022/10/12 MA 0 0 79 100
2022/10/12 AL 0 1 100 99
2022/10/12 LA 1 4 154 96
2022/10/12 MN 5 1 124 95
2022/10/12 RI 1 0 12 92
2022/10/12 WV 0 4 51 92
2022/10/12 WY 0 2 26 92
2022/10/12 PR 0 6 60 90
2022/10/12 TX 5 47 417 88
2022/10/12 NM 1 5 40 86
2022/10/12 PA 1 28 166 85
2022/10/12 ND 0 8 37 82
2022/10/12 NV 1 7 38 82
2022/10/12 CA 9 84 291 75
2022/10/12 CT 0 8 25 75
2022/10/12 NH 2 6 18 69
2022/10/12 OH 2 56 132 69
2022/10/12 OK 3 41 88 66
2022/10/12 ID 1 17 27 60
2022/10/12 TN 3 40 66 60
2022/10/12 WA 1 39 53 56
2022/10/12 AZ 1 38 46 54
2022/10/12 NE 5 42 47 50
2022/10/12 ME 1 20 13 38
2022/10/12 MD 12 20 18 36
2022/10/12 CO 14 45 31 34
2022/10/12 MO 5 74 39 33
2022/10/12 FL 5 140 71 32
2022/10/12 IA 0 79 37 31
2022/10/12 VA 10 56 26 28
2022/10/12 DE 2 5 2 22
2022/10/12 HI 3 14 5 22
2022/10/12 OR 3 46 12 19
2022/10/12 UT 0 42 9 17
2022/10/12 KY 8 76 17 16
2022/10/12 SD 0 51 10 16
2022/10/12 WI 16 109 24 16
2022/10/12 IL 4 142 27 15
2022/10/12 AR 0 75 13 14
2022/10/12 GA 29 98 22 14
2022/10/12 NJ 8 58 10 13
2022/10/12 NC 19 86 12 10
2022/10/12 AK 1 18 2 9
2022/10/12 MS 3 87 9 9
2022/10/12 NY 2 152 14 8
2022/10/12 KS 11 106 10 7
2022/10/12 SC 20 40 5 7
2022/10/12 VT 3 11 1 6
2022/10/12 MT 3 57 3 4
2022/10/12 IN 9 114 3 2
2022/10/12 MI 30 121 4 2
2022/10/12 AS 0 1 0 0
2022/10/12 VI 0 1 0 0
Powered by Datasette · Queries took 21.622ms