Show how many hospitals anticipate a staffing shortage this week

Note that not all hospitals answer this question. Refer to the corresponding _coverage variables for specifics.

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 638 rows (hide)

select date, sum(critical_staffing_shortage_anticipated_within_week_yes) as shortage_anticipated, sum(critical_staffing_shortage_anticipated_within_week_no) as no_shortage_anticipated, sum(critical_staffing_shortage_anticipated_within_week_not_reported) as not_reported from hospitals_state where date > '2020/10/01' group by date order by date desc;

Edit SQL

dateshortage_anticipatedno_shortage_anticipatednot_reported
2022/07/01 822 3828 1441
2022/06/30 823 3846 1445
2022/06/29 865 3954 1297
2022/06/28 798 3392 1366
2022/06/27 788 3417 1362
2022/06/26 799 3939 1448
2022/06/25 800 3945 1448
2022/06/24 833 3902 1457
2022/06/23 840 3920 1433
2022/06/22 865 4051 1276
2022/06/21 792 3410 1378
2022/06/20 802 3409 1376
2022/06/19 793 3971 1441
2022/06/18 796 3965 1446
2022/06/17 845 3916 1448
2022/06/16 828 3932 1447
2022/06/15 874 4048 1284
2022/06/14 789 3432 1365
2022/06/13 796 3421 1362
2022/06/12 789 3976 1436
2022/06/11 792 3966 1449
2022/06/10 829 3918 1460
2022/06/09 838 3920 1449
2022/06/08 877 4043 1285
2022/06/07 803 3404 1379
2022/06/06 793 3421 1376
2022/06/05 786 3974 1441
2022/06/04 780 3990 1435
2022/06/03 817 3923 1465
2022/06/02 833 3910 1460
2022/06/01 862 4053 1284
2022/05/31 786 3428 1355
2022/05/30 758 3448 1366
2022/05/29 787 3967 1447
2022/05/28 797 3951 1455
2022/05/27 837 3888 1476
2022/05/26 830 3906 1464
2022/05/25 872 4031 1294
2022/05/24 811 3388 1376
2022/05/23 793 3408 1378
2022/05/22 795 3948 1457
2022/05/21 802 3955 1445
2022/05/20 849 3900 1454
2022/05/19 852 3903 1448
2022/05/18 906 4006 1289
2022/05/17 814 3401 1366
2022/05/16 812 3395 1374
2022/05/15 810 3938 1446
2022/05/14 801 3938 1457
2022/05/13 851 3888 1459
2022/05/12 862 3883 1456
2022/05/11 900 3996 1301
2022/05/10 801 3394 1378
2022/05/09 810 3397 1379
2022/05/08 810 3953 1438
2022/05/07 816 3944 1442
2022/05/06 857 3892 1458
2022/05/05 869 3982 1354
2022/05/04 909 4114 1177
2022/05/03 826 3466 1288
2022/05/02 815 3498 1272
2022/05/01 821 4014 1369
2022/04/30 832 4008 1366
2022/04/29 860 3985 1361
2022/04/28 852 3992 1362
2022/04/27 903 4118 1181
2022/04/26 825 3505 1254
2022/04/25 834 3476 1282
2022/04/24 820 4013 1374
2022/04/23 834 3996 1379
2022/04/22 866 3982 1362
2022/04/21 885 3968 1357
2022/04/20 920 4108 1176
2022/04/19 843 3463 1282
2022/04/18 840 3450 1296
2022/04/17 824 4015 1373
2022/04/16 832 4011 1371
2022/04/15 863 3994 1357
2022/04/14 877 3967 1369
2022/04/13 921 4123 1166
2022/04/12 842 3459 1285
2022/04/11 841 3453 1306
2022/04/10 827 3983 1400
2022/04/09 829 3985 1398
2022/04/08 883 3955 1378
2022/04/07 873 3956 1386
2022/04/06 938 4105 1167
2022/04/05 840 3453 1297
2022/04/04 839 3460 1299
2022/04/03 831 3999 1383
2022/04/02 856 4016 1344
2022/04/01 879 3968 1370
2022/03/31 890 3957 1368
2022/03/30 940 4099 1169
2022/03/29 833 3456 1303
2022/03/28 842 3475 1284
2022/03/27 856 4018 1340
2022/03/26 836 3987 1391
2022/03/25 892 3943 1380
2022/03/24 877 3968 1369
2022/03/23 946 4109 1158
2022/03/22 860 3442 1300
2022/03/21 864 3460 1292
2022/03/20 876 3960 1381
2022/03/19 881 3973 1363
2022/03/18 901 3967 1350
2022/03/17 912 3936 1370
2022/03/16 983 4080 1150
2022/03/15 877 3452 1293
2022/03/14 876 3469 1281
2022/03/13 883 3991 1342
2022/03/12 897 3938 1380
2022/03/11 953 3942 1320
2022/03/10 936 3912 1367
2022/03/09 994 4080 1132
2022/03/08 931 3388 1291
2022/03/07 949 3383 1287
2022/03/06 929 3910 1376
2022/03/05 938 3918 1360
2022/03/04 986 3887 1342
2022/03/03 999 3853 1362
2022/03/02 1064 4006 1138
2022/03/01 958 3382 1269
2022/02/28 965 3371 1283
2022/02/27 989 3870 1365
2022/02/26 997 3857 1379
2022/02/25 1034 3845 1356
2022/02/24 1045 3887 1303
2022/02/23 1096 4005 1130
2022/02/22 1010 3390 1232
2022/02/21 1018 3440 1174
2022/02/20 1038 3910 1275
2022/02/19 1026 3937 1260
2022/02/18 1092 3831 1301
2022/02/17 1095 3816 1313
2022/02/16 1164 3946 1109
2022/02/15 1071 3287 1275
2022/02/14 1069 3282 1281
2022/02/13 1072 3787 1365
2022/02/12 1064 3791 1370
2022/02/11 1146 3776 1304
2022/02/10 1144 3729 1349
2022/02/09 1233 3864 1115
2022/02/08 1123 3228 1284
2022/02/07 1151 3254 1238
2022/02/06 1152 3696 1367
2022/02/05 1165 3740 1317
2022/02/04 1216 3653 1355
2022/02/03 1221 3660 1341
2022/02/02 1305 3833 1081
2022/02/01 1207 3159 1277
2022/01/31 1252 3150 1241
2022/01/30 1247 3650 1321
2022/01/29 1235 3666 1320
2022/01/28 1314 3607 1300
2022/01/27 1336 3573 1312
2022/01/26 1401 3770 1048
2022/01/25 1288 3083 1264
2022/01/24 1290 3084 1262
2022/01/23 1304 3561 1351
2022/01/22 1306 3564 1346
2022/01/21 1362 3527 1329
2022/01/20 1339 3585 1292
2022/01/19 1423 3761 1030
2022/01/18 1335 3221 1081
2022/01/17 1365 3167 1118
2022/01/16 1371 3659 1191
2022/01/15 1371 3663 1188
2022/01/14 1430 3619 1173
2022/01/13 1411 3641 1168
2022/01/12 1448 3733 1035
2022/01/11 1341 3196 1096
2022/01/10 1360 3175 1102
2022/01/09 1305 3731 1181
2022/01/08 1300 3738 1181
2022/01/07 1325 3741 1153
2022/01/06 1290 3785 1145
2022/01/05 1295 3883 1040
2022/01/04 1217 3346 1065
2022/01/03 1217 3340 1074
2022/01/02 1191 3851 1169
2022/01/01 1171 3873 1167
2021/12/31 1181 3883 1147
2021/12/30 1201 3869 1141
2021/12/29 1204 3946 1060
2021/12/28 1133 3425 1079
2021/12/27 1121 3446 1076
2021/12/26 1119 3924 1159
2021/12/25 1101 3930 1173
2021/12/24 1121 3931 1152
2021/12/23 1168 3890 1140
2021/12/22 1187 3963 1043
2021/12/21 1133 3431 1079
2021/12/20 1122 3463 1061
2021/12/19 1119 3950 1150
2021/12/18 1122 3946 1150
2021/12/17 1139 3938 1140
2021/12/16 1137 3936 1140
2021/12/15 1161 4006 1041
2021/12/14 1081 3469 1083
2021/12/13 1074 3478 1090
2021/12/12 1076 3966 1174
2021/12/11 1084 3965 1168
2021/12/10 1097 3973 1148
2021/12/09 1103 3956 1156
2021/12/08 1110 4053 1050
2021/12/07 1072 3482 1081
2021/12/06 1064 3507 1076
2021/12/05 1063 3988 1168
2021/12/04 1056 3993 1171
2021/12/03 1087 3979 1154
2021/12/02 1098 3973 1149
2021/12/01 1109 4066 1042
2021/11/30 1047 3507 1093
2021/11/29 1060 3498 1092
2021/11/28 1058 3958 1107
2021/11/27 1055 3968 1109
2021/11/26 1056 3974 1102
2021/11/25 1059 3970 1101
2021/11/24 1119 4041 969
2021/11/23 1067 3512 1071
2021/11/22 1061 3520 1068
2021/11/21 1051 3993 1178
2021/11/20 1055 3997 1170
2021/11/19 1092 3979 1150
2021/11/18 1082 3991 1147
2021/11/17 1082 4093 1041
2021/11/16 1042 3540 1067
2021/11/15 1009 3559 1077
2021/11/14 1012 4054 1151
2021/11/13 1045 4018 1153
2021/11/12 1057 4010 1146
2021/11/11 1054 4019 1140
2021/11/10 1087 4093 1032
2021/11/09 1028 3540 1070
2021/11/08 1005 3560 1077
2021/11/07 1005 4046 1164
2021/11/06 1025 4035 1156
2021/11/05 1050 4024 1141
2021/11/04 1052 4032 1131
2021/11/03 1064 4085 1064
2021/11/02 1032 3539 1072
2021/11/01 1031 3546 1065
2021/10/31 1066 4005 1146
2021/10/30 1068 4002 1148
2021/10/29 1074 4025 1119
2021/10/28 1076 4022 1120
2021/10/27 1095 4058 1058
2021/10/26 1057 3532 1053
2021/10/25 1052 3547 1052
2021/10/24 1064 4029 1125
2021/10/23 1070 4021 1128
2021/10/22 1102 3984 1133
2021/10/21 1069 4018 1131
2021/10/20 1110 4080 1023
2021/10/19 1046 3521 1070
2021/10/18 1029 3542 1072
2021/10/17 1039 4030 1149
2021/10/16 1042 4027 1151
2021/10/15 1066 4007 1147
2021/10/14 1109 3966 1144
2021/10/13 1102 4010 1104
2021/10/12 1053 3528 1076
2021/10/11 1044 3536 1077
2021/10/10 1038 4018 1157
2021/10/09 1037 4026 1153
2021/10/08 1062 3993 1160
2021/10/07 1059 4011 1145
2021/10/06 1089 4056 1069
2021/10/05 1033 3544 1089
2021/10/04 1048 3549 1072
2021/10/03 1028 4034 1154
2021/10/02 1033 4037 1150
2021/10/01 1084 3989 1146
2021/09/30 1081 4002 1138
2021/09/29 1107 4057 1055
2021/09/28 1053 3545 1072
2021/09/27 1062 3535 1073
2021/09/26 1045 4021 1157
2021/09/25 1057 4002 1164
2021/09/24 1079 3983 1161
2021/09/23 1075 3988 1160
2021/09/22 1119 4035 1068
2021/09/21 1057 3491 1117
2021/09/20 1029 3509 1130
2021/09/19 1019 4033 1172
2021/09/18 1033 4017 1174
2021/09/17 1064 4003 1158
2021/09/16 1058 4014 1153
2021/09/15 1098 4040 1084
2021/09/14 1024 3550 1087
2021/09/13 1010 3570 1086
2021/09/12 1025 4028 1162
2021/09/11 1035 4033 1147
2021/09/10 1079 4007 1129
2021/09/09 1067 4016 1132
2021/09/08 1087 4070 1054
2021/09/07 1013 3566 1074
2021/09/06 964 3593 1096
2021/09/05 971 4085 1156
2021/09/04 989 4071 1156
2021/09/03 1030 4055 1132
2021/09/02 1023 4075 1117
2021/09/01 1025 4150 1035
2021/08/31 991 3597 1069
2021/08/30 977 3610 1070
2021/08/29 956 4113 1146
2021/08/28 961 4116 1141
2021/08/27 985 4071 1161
2021/08/26 993 4078 1144
2021/08/25 973 4189 1051
2021/08/24 913 3632 1118
2021/08/23 899 3650 1117
2021/08/22 866 4184 1163
2021/08/21 882 4189 1144
2021/08/20 903 4167 1145
2021/08/19 878 4188 1149
2021/08/18 896 4258 1057
2021/08/17 826 3764 1074
2021/08/16 817 3784 1057
2021/08/15 814 4264 1136
2021/08/14 803 4272 1137
2021/08/13 845 4238 1131
2021/08/12 832 4251 1131
2021/08/11 843 4328 1043
2021/08/10 784 3822 1056
2021/08/09 770 3842 1058
2021/08/08 742 4321 1154
2021/08/07 736 4340 1141
2021/08/06 760 4317 1141
2021/08/05 755 4332 1131
2021/08/04 760 4438 1011
2021/08/03 721 3844 1090
2021/08/02 690 3884 1085
2021/08/01 686 4370 1151
2021/07/31 683 4320 1205
2021/07/30 711 4289 1208
2021/07/29 714 4315 1179
2021/07/28 714 4470 1020
2021/07/27 669 3864 1126
2021/07/26 783 4156 724
2021/07/25 773 4707 726
2021/07/24 752 4733 723
2021/07/23 779 4661 768
2021/07/22 768 4713 725
2021/07/21 771 4824 609
2021/07/20 720 4111 704
2021/07/19 709 4131 696
2021/07/18 712 4757 731
2021/07/17 705 4756 739
2021/07/16 745 4743 716
2021/07/15 739 4753 712
2021/07/14 743 4877 589
2021/07/13 715 4130 701
2021/07/12 699 4143 705
2021/07/11 710 4763 737
2021/07/10 723 4756 730
2021/07/09 725 4751 732
2021/07/08 717 4775 716
2021/07/07 735 4887 585
2021/07/06 683 4169 699
2021/07/05 672 4173 715
2021/07/04 708 4757 742
2021/07/03 725 4746 739
2021/07/02 736 4746 729
2021/07/01 726 4768 714
2021/06/30 732 4875 593
2021/06/29 700 4152 699
2021/06/28 691 4169 703
2021/06/27 723 4746 737
2021/06/26 721 4753 732
2021/06/25 743 4752 711
2021/06/24 741 4755 709
2021/06/23 748 4846 602
2021/06/22 702 4207 736
2021/06/21 703 4190 734
2021/06/20 711 4724 746
2021/06/19 713 4716 752
2021/06/18 731 4710 738
2021/06/17 722 4763 698
2021/06/16 726 4878 575
2021/06/15 704 4263 697
2021/06/14 740 4357 570
2021/06/13 759 4859 592
2021/06/12 760 4867 586
2021/06/11 762 4871 579
2021/06/10 779 4859 573
2021/06/09 781 4963 461
2021/06/08 752 4354 568
2021/06/07 746 4354 575
2021/06/06 767 4845 594
2021/06/05 766 4853 588
2021/06/04 775 4862 572
2021/06/03 780 4862 564
2021/06/02 795 4957 453
2021/06/01 758 4341 568
2021/05/31 750 4348 573
2021/05/30 788 4830 579
2021/05/29 781 4840 576
2021/05/28 800 4825 571
2021/05/27 806 4824 568
2021/05/26 799 4936 461
2021/05/25 773 4327 571
2021/05/24 767 4349 563
2021/05/23 786 4820 599
2021/05/22 793 4822 592
2021/05/21 799 4830 578
2021/05/20 796 4817 593
2021/05/19 809 4934 459
2021/05/18 763 4327 581
2021/05/17 769 4327 577
2021/05/16 788 4827 586
2021/05/15 785 4835 580
2021/05/14 782 4838 582
2021/05/13 793 4823 585
2021/05/12 805 4936 455
2021/05/11 745 4333 585
2021/05/10 757 4324 590
2021/05/09 793 4810 605
2021/05/08 783 4804 625
2021/05/07 792 4803 622
2021/05/06 811 4783 622
2021/05/05 811 4963 440
2021/05/04 776 4343 569
2021/05/03 771 4331 584
2021/05/02 793 4840 581
2021/05/01 792 4847 577
2021/04/30 797 4844 576
2021/04/29 799 4833 583
2021/04/28 811 4946 455
2021/04/27 778 4331 577
2021/04/26 780 4334 567
2021/04/25 790 4842 573
2021/04/24 796 4837 572
2021/04/23 796 4852 558
2021/04/22 800 4843 562
2021/04/21 819 4960 424
2021/04/20 775 4334 566
2021/04/19 770 4340 569
2021/04/18 789 4838 580
2021/04/17 801 4828 580
2021/04/16 799 4838 572
2021/04/15 802 4846 563
2021/04/14 800 4974 434
2021/04/13 778 4336 576
2021/04/12 777 4373 556
2021/04/11 801 4832 572
2021/04/10 802 4835 568
2021/04/09 803 4832 571
2021/04/08 797 4843 566
2021/04/07 796 4971 434
2021/04/06 761 4454 555
2021/04/05 775 4442 556
2021/04/04 790 4853 559
2021/04/03 787 4863 555
2021/04/02 804 4859 543
2021/04/01 785 4865 556
2021/03/31 818 4951 435
2021/03/30 766 4350 563
2021/03/29 778 4352 556
2021/03/28 784 4850 570
2021/03/27 772 4858 574
2021/03/26 786 4850 570
2021/03/25 795 4843 570
2021/03/24 806 4933 467
2021/03/23 781 4308 606
2021/03/22 801 4361 535
2021/03/21 827 4845 535
2021/03/20 833 4841 535
2021/03/19 852 4825 532
2021/03/18 859 4815 535
2021/03/17 877 4922 406
2021/03/16 837 4315 536
2021/03/15 836 4329 528
2021/03/14 851 4816 541
2021/03/13 850 4825 535
2021/03/12 858 4822 530
2021/03/11 850 4832 528
2021/03/10 881 4932 396
2021/03/09 860 4316 519
2021/03/08 865 4315 522
2021/03/07 886 4794 525
2021/03/06 883 4799 525
2021/03/05 906 4786 516
2021/03/04 915 4767 527
2021/03/03 905 4838 401
2021/03/02 880 4231 524
2021/03/01 893 4220 521
2021/02/28 917 4758 530
2021/02/27 928 4753 527
2021/02/26 941 4738 529
2021/02/25 922 4763 522
2021/02/24 933 4868 406
2021/02/23 922 4251 524
2021/02/22 928 4189 583
2021/02/21 936 4762 509
2021/02/20 946 4757 507
2021/02/19 969 4720 522
2021/02/18 986 4698 527
2021/02/17 1014 4791 402
2021/02/16 996 4179 525
2021/02/15 1004 4129 564
2021/02/14 1004 4685 518
2021/02/13 1028 4663 514
2021/02/12 1021 4686 501
2021/02/11 1014 4693 502
2021/02/10 1029 4782 396
2021/02/09 1001 4179 522
2021/02/08 1019 4183 503
2021/02/07 1034 4669 504
2021/02/06 1047 4661 500
2021/02/05 1067 4638 506
2021/02/04 1071 4635 505
2021/02/03 1068 4742 400
2021/02/02 1055 4153 497
2021/02/01 1065 4144 496
2021/01/31 1090 4607 517
2021/01/30 1109 4603 502
2021/01/29 1119 4591 503
2021/01/28 1132 4585 496
2021/01/27 1137 4678 396
2021/01/26 1126 4016 558
2021/01/25 1136 3999 566
2021/01/24 1182 4490 534
2021/01/23 1189 4463 556
2021/01/22 1222 4460 526
2021/01/21 1237 4447 522
2021/01/20 1250 4524 430
2021/01/19 1217 3972 518
2021/01/18 1237 3949 514
2021/01/17 1274 4386 545
2021/01/16 1276 4402 527
2021/01/15 1293 4379 532
2021/01/14 1287 4399 517
2021/01/13 1313 4483 408
2021/01/12 1275 3909 519
2021/01/11 1259 3930 521
2021/01/10 1295 4389 523
2021/01/09 1293 4402 515
2021/01/08 1287 4409 514
2021/01/07 1305 4468 436
2021/01/06 1307 4590 303
2021/01/05 1257 4054 386
2021/01/04 1250 4069 382
2021/01/03 1267 4555 384
2021/01/02 1267 4491 452
2021/01/01 1234 4533 443
2020/12/31 1273 4548 388
2020/12/30 1269 4638 299
2020/12/29 1292 4023 381
2020/12/28 1448 3868 378
2020/12/27 1516 4289 387
2020/12/26 1505 4306 383
2020/12/25 1503 4303 390
2020/12/24 1524 4298 372
2020/12/23 1537 4367 290
2020/12/22 1455 3912 429
2020/12/21 1461 3872 374
2020/12/20 1497 4312 393
2020/12/19 1495 4322 385
2020/12/18 1511 4313 380
2020/12/17 1518 4299 386
2020/12/16 1529 4386 288
2020/12/15 1460 3881 381
2020/12/14 1492 3853 381
2020/12/13 1509 4309 372
2020/12/12 1516 4304 375
2020/12/11 1525 4294 376
2020/12/10 1527 4285 379
2020/12/09 1552 4350 289
2020/12/08 1450 3917 367
2020/12/07 1424 3945 367
2020/12/06 1457 4338 383
2020/12/05 1442 4351 387
2020/12/04 1446 4312 422
2020/12/03 1450 4392 335
2020/12/02 1452 4448 266
2020/12/01 1384 3991 344
2020/11/30 1374 4000 339
2020/11/29 1415 4390 346
2020/11/28 1421 4393 348
2020/11/27 1411 4402 352
2020/11/26 1408 4397 357
2020/11/25 1430 4468 262
2020/11/24 1360 4037 339
2020/11/23 1364 4018 334
2020/11/22 1367 4423 357
2020/11/21 1376 4432 346
2020/11/20 1383 4433 342
2020/11/19 1366 4443 344
2020/11/18 1362 4525 259
2020/11/17 1316 4063 344
2020/11/16 1285 4126 329
2020/11/15 1294 4510 324
2020/11/14 1296 4515 326
2020/11/13 1307 4500 334
2020/11/12 1288 4567 276
2020/11/11 1264 4583 252
2020/11/10 1206 4240 269
2020/11/09 1174 4258 276
2020/11/08 1182 4653 262
2020/11/07 1198 4644 260
2020/11/06 1207 4643 257
2020/11/05 1193 4673 233
2020/11/04 1192 4684 201
2020/11/03 1157 4354 213
2020/11/02 1158 4364 217
2020/11/01 1173 4627 269
2020/10/31 1177 4630 271
2020/10/30 1171 4612 299
2020/10/29 1175 4581 309
2020/10/28 1163 4572 306
2020/10/27 1120 4337 284
2020/10/26 1128 4340 279
2020/10/25 1133 4576 305
2020/10/24 1137 4587 303
2020/10/23 1147 4598 307
2020/10/22 1137 4594 306
2020/10/21 1123 4576 314
2020/10/20 1104 4497 302
2020/10/19 1130 4487 300
2020/10/18 1127 4524 326
2020/10/17 1126 4540 322
2020/10/16 1142 4542 316
2020/10/15 1133 4507 330
2020/10/14 1112 4507 331
2020/10/13 1089 4454 344
2020/10/12 1073 4485 351
2020/10/11 1062 4490 378
2020/10/10 1056 4492 391
2020/10/09 1082 4459 400
2020/10/08 1079 4419 432
2020/10/07 1064 4371 465
2020/10/06 1031 4367 494
2020/10/05 1021 4332 529
2020/10/04 984 4256 629
2020/10/03 987 4254 636
2020/10/02 1022 4264 599
Powered by Datasette · Queries took 44.833ms