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/08/03 DC 0 0 14 100
2022/08/03 LA 0 2 225 99
2022/08/03 MN 4 1 126 96
2022/08/03 MA 0 4 79 95
2022/08/03 ND 0 3 41 93
2022/08/03 WY 0 2 27 93
2022/08/03 AL 0 8 104 92
2022/08/03 RI 1 0 13 92
2022/08/03 PR 0 8 57 87
2022/08/03 WV 0 8 54 87
2022/08/03 TX 6 68 427 85
2022/08/03 NV 1 10 38 77
2022/08/03 NM 2 10 38 76
2022/08/03 CT 0 8 25 75
2022/08/03 CA 6 91 276 73
2022/08/03 NH 2 7 20 68
2022/08/03 OH 3 62 133 67
2022/08/03 OK 2 42 88 66
2022/08/03 TN 3 49 68 56
2022/08/03 WA 1 40 53 56
2022/08/03 ID 1 21 27 55
2022/08/03 AZ 0 46 48 51
2022/08/03 ME 1 21 13 37
2022/08/03 MD 4 30 18 34
2022/08/03 CO 14 49 31 32
2022/08/03 IA 0 82 38 31
2022/08/03 MO 6 77 39 31
2022/08/03 FL 6 163 71 29
2022/08/03 DE 2 6 2 20
2022/08/03 HI 3 16 5 20
2022/08/03 OR 2 45 12 20
2022/08/03 VA 9 67 19 20
2022/08/03 GA 29 97 26 17
2022/08/03 UT 0 42 9 17
2022/08/03 WI 21 96 24 17
2022/08/03 KY 10 74 17 16
2022/08/03 IL 5 150 28 15
2022/08/03 SD 1 52 10 15
2022/08/03 AR 0 75 13 14
2022/08/03 NE 16 64 13 13
2022/08/03 NJ 6 64 9 11
2022/08/03 NC 20 86 12 10
2022/08/03 AK 1 19 2 9
2022/08/03 MS 3 90 10 9
2022/08/03 NY 2 144 14 8
2022/08/03 KS 8 112 10 7
2022/08/03 SC 20 50 5 6
2022/08/03 VT 2 14 1 5
2022/08/03 MT 4 55 3 4
2022/08/03 PA 38 156 7 3
2022/08/03 IN 10 122 3 2
2022/08/03 MI 29 123 4 2
2022/08/03 AS 0 1 0 0
2022/08/03 VI 0 2 0 0
Powered by Datasette · Queries took 26.559ms