Show how many hospitals have a staffing shortage today

Note that not all hospitals answer this question.

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_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 from hospitals_state where date > '2020/10/01' group by date order by date desc;

Edit SQL

dateshortage_todayno_shortage_todaynot_reported
2022/07/01 298 3189 2604
2022/06/30 299 3206 2609
2022/06/29 294 3237 2585
2022/06/28 259 2778 2519
2022/06/27 253 2799 2515
2022/06/26 269 3317 2600
2022/06/25 269 3308 2616
2022/06/24 279 3270 2643
2022/06/23 284 3281 2628
2022/06/22 275 3321 2596
2022/06/21 260 2811 2509
2022/06/20 275 2810 2502
2022/06/19 279 3332 2594
2022/06/18 282 3322 2603
2022/06/17 290 3284 2635
2022/06/16 282 3288 2637
2022/06/15 279 3328 2599
2022/06/14 257 2843 2486
2022/06/13 269 2807 2503
2022/06/12 269 3359 2573
2022/06/11 278 3333 2596
2022/06/10 278 3285 2644
2022/06/09 276 3307 2624
2022/06/08 278 3313 2614
2022/06/07 267 2809 2510
2022/06/06 267 2816 2507
2022/06/05 276 3340 2585
2022/06/04 273 3345 2587
2022/06/03 278 3302 2625
2022/06/02 284 3287 2632
2022/06/01 265 3346 2588
2022/05/31 259 2813 2497
2022/05/30 245 2869 2458
2022/05/29 263 3348 2590
2022/05/28 275 3335 2593
2022/05/27 288 3290 2623
2022/05/26 283 3286 2631
2022/05/25 277 3320 2600
2022/05/24 279 2802 2494
2022/05/23 264 2820 2495
2022/05/22 268 3347 2585
2022/05/21 271 3339 2592
2022/05/20 298 3287 2618
2022/05/19 296 3287 2620
2022/05/18 287 3335 2579
2022/05/17 273 2815 2493
2022/05/16 279 2808 2494
2022/05/15 280 3339 2575
2022/05/14 277 3339 2580
2022/05/13 286 3288 2624
2022/05/12 298 3279 2624
2022/05/11 292 3310 2595
2022/05/10 271 2809 2493
2022/05/09 285 2809 2492
2022/05/08 272 3374 2555
2022/05/07 276 3342 2584
2022/05/06 298 3300 2609
2022/05/05 301 3288 2616
2022/05/04 294 3325 2581
2022/05/03 279 2805 2496
2022/05/02 276 2822 2487
2022/05/01 287 3339 2578
2022/04/30 299 3332 2575
2022/04/29 290 3286 2630
2022/04/28 284 3314 2608
2022/04/27 294 3331 2577
2022/04/26 281 2825 2478
2022/04/25 283 2821 2488
2022/04/24 284 3346 2577
2022/04/23 285 3334 2590
2022/04/22 286 3289 2635
2022/04/21 304 3273 2633
2022/04/20 305 3313 2586
2022/04/19 287 2798 2503
2022/04/18 291 2802 2493
2022/04/17 283 3342 2587
2022/04/16 281 3340 2593
2022/04/15 293 3304 2617
2022/04/14 303 3290 2620
2022/04/13 301 3322 2587
2022/04/12 281 2802 2503
2022/04/11 283 2811 2506
2022/04/10 287 3363 2560
2022/04/09 280 3340 2592
2022/04/08 304 3294 2618
2022/04/07 301 3289 2625
2022/04/06 297 3334 2579
2022/04/05 286 2815 2489
2022/04/04 280 2815 2503
2022/04/03 294 3335 2584
2022/04/02 299 3332 2585
2022/04/01 314 3297 2606
2022/03/31 306 3315 2594
2022/03/30 301 3332 2575
2022/03/29 282 2827 2483
2022/03/28 276 2847 2478
2022/03/27 287 3348 2579
2022/03/26 282 3361 2571
2022/03/25 295 3319 2601
2022/03/24 302 3324 2588
2022/03/23 294 3350 2569
2022/03/22 286 2843 2473
2022/03/21 282 2854 2480
2022/03/20 302 3360 2555
2022/03/19 299 3345 2573
2022/03/18 307 3376 2535
2022/03/17 313 3295 2610
2022/03/16 308 3353 2552
2022/03/15 292 2854 2476
2022/03/14 290 2858 2478
2022/03/13 305 3391 2520
2022/03/12 310 3342 2563
2022/03/11 319 3309 2587
2022/03/10 317 3311 2587
2022/03/09 327 3349 2530
2022/03/08 322 2834 2454
2022/03/07 319 2844 2456
2022/03/06 326 3353 2536
2022/03/05 315 3367 2534
2022/03/04 344 3295 2576
2022/03/03 346 3304 2564
2022/03/02 353 3315 2540
2022/03/01 339 2810 2460
2022/02/28 341 2828 2450
2022/02/27 355 3343 2526
2022/02/26 358 3338 2537
2022/02/25 375 3316 2544
2022/02/24 381 3345 2509
2022/02/23 362 3349 2520
2022/02/22 361 2870 2401
2022/02/21 361 2920 2351
2022/02/20 363 3419 2441
2022/02/19 370 3399 2454
2022/02/18 408 3309 2507
2022/02/17 404 3315 2505
2022/02/16 408 3392 2419
2022/02/15 403 2766 2464
2022/02/14 390 2805 2437
2022/02/13 411 3290 2523
2022/02/12 407 3284 2534
2022/02/11 432 3228 2566
2022/02/10 429 3235 2558
2022/02/09 438 3295 2479
2022/02/08 415 2783 2437
2022/02/07 431 2847 2365
2022/02/06 443 3324 2448
2022/02/05 448 3327 2447
2022/02/04 464 3231 2529
2022/02/03 462 3282 2478
2022/02/02 459 3428 2332
2022/02/01 525 2897 2221
2022/01/31 630 3066 1947
2022/01/30 635 3590 1993
2022/01/29 644 3595 1982
2022/01/28 681 3551 1989
2022/01/27 711 3584 1926
2022/01/26 722 3736 1761
2022/01/25 765 3154 1716
2022/01/24 761 3159 1716
2022/01/23 757 3633 1826
2022/01/22 756 3638 1822
2022/01/21 808 3598 1812
2022/01/20 790 3624 1802
2022/01/19 785 3856 1573
2022/01/18 956 3405 1276
2022/01/17 972 3412 1266
2022/01/16 957 3877 1387
2022/01/15 953 3884 1385
2022/01/14 1003 3861 1358
2022/01/13 1015 3847 1358
2022/01/12 1013 3972 1231
2022/01/11 986 3397 1250
2022/01/10 991 3400 1246
2022/01/09 1091 3951 1175
2022/01/08 1099 3942 1178
2022/01/07 1181 3889 1149
2022/01/06 1162 3919 1139
2022/01/05 1179 4006 1033
2022/01/04 1103 3471 1054
2022/01/03 1094 3470 1067
2022/01/02 1069 3983 1159
2022/01/01 1056 3993 1162
2021/12/31 1063 4009 1139
2021/12/30 1089 3988 1134
2021/12/29 1086 4075 1049
2021/12/28 1042 3525 1070
2021/12/27 1023 3553 1067
2021/12/26 998 4058 1146
2021/12/25 986 4050 1168
2021/12/24 1016 4050 1138
2021/12/23 1048 4021 1129
2021/12/22 1051 4109 1033
2021/12/21 1006 3571 1066
2021/12/20 1016 3577 1053
2021/12/19 1015 4066 1138
2021/12/18 1030 4050 1138
2021/12/17 1045 4043 1129
2021/12/16 1040 4041 1132
2021/12/15 1059 4122 1027
2021/12/14 987 3575 1071
2021/12/13 977 3587 1078
2021/12/12 976 4079 1161
2021/12/11 981 4081 1155
2021/12/10 1012 4068 1138
2021/12/09 1010 4061 1144
2021/12/08 1012 4169 1032
2021/12/07 980 3588 1067
2021/12/06 964 3621 1062
2021/12/05 966 4101 1152
2021/12/04 954 4112 1154
2021/12/03 981 4099 1140
2021/12/02 1002 4083 1135
2021/12/01 1014 4173 1030
2021/11/30 963 3609 1075
2021/11/29 968 3606 1076
2021/11/28 956 4066 1101
2021/11/27 944 4087 1101
2021/11/26 960 4078 1094
2021/11/25 951 4087 1092
2021/11/24 999 4173 957
2021/11/23 958 3630 1062
2021/11/22 957 3633 1059
2021/11/21 932 4124 1166
2021/11/20 941 4121 1160
2021/11/19 987 4094 1140
2021/11/18 980 4101 1139
2021/11/17 983 4201 1032
2021/11/16 952 3639 1058
2021/11/15 918 3657 1070
2021/11/14 902 4170 1145
2021/11/13 933 4135 1148
2021/11/12 957 4118 1138
2021/11/11 937 4146 1130
2021/11/10 971 4218 1023
2021/11/09 930 3644 1064
2021/11/08 916 3653 1073
2021/11/07 910 4144 1161
2021/11/06 924 4138 1154
2021/11/05 966 4113 1136
2021/11/04 951 4136 1128
2021/11/03 972 4181 1060
2021/11/02 947 3628 1068
2021/11/01 946 3636 1060
2021/10/31 978 4096 1143
2021/10/30 985 4087 1146
2021/10/29 997 4105 1116
2021/10/28 981 4119 1118
2021/10/27 993 4162 1056
2021/10/26 961 3631 1050
2021/10/25 973 3629 1049
2021/10/24 979 4117 1122
2021/10/23 977 4115 1127
2021/10/22 1014 4074 1131
2021/10/21 983 4107 1128
2021/10/20 1016 4177 1020
2021/10/19 952 3618 1067
2021/10/18 934 3639 1070
2021/10/17 949 4120 1149
2021/10/16 957 4113 1150
2021/10/15 976 4097 1147
2021/10/14 1018 4057 1144
2021/10/13 1002 4112 1102
2021/10/12 962 3623 1072
2021/10/11 967 3616 1074
2021/10/10 948 4112 1153
2021/10/09 956 4110 1150
2021/10/08 973 4089 1153
2021/10/07 968 4107 1140
2021/10/06 990 4161 1063
2021/10/05 944 3639 1083
2021/10/04 968 3639 1062
2021/10/03 944 4125 1147
2021/10/02 947 4128 1145
2021/10/01 997 4083 1139
2021/09/30 982 4109 1130
2021/09/29 1006 4169 1044
2021/09/28 959 3646 1065
2021/09/27 978 3624 1068
2021/09/26 957 4114 1152
2021/09/25 957 4110 1156
2021/09/24 985 4083 1155
2021/09/23 971 4098 1154
2021/09/22 1027 4133 1062
2021/09/21 970 3582 1113
2021/09/20 969 3573 1126
2021/09/19 940 4118 1166
2021/09/18 960 4095 1169
2021/09/17 993 4079 1153
2021/09/16 1010 4068 1147
2021/09/15 1024 4119 1079
2021/09/14 963 3615 1083
2021/09/13 967 3621 1078
2021/09/12 957 4099 1159
2021/09/11 964 4106 1145
2021/09/10 1013 4077 1125
2021/09/09 981 4109 1125
2021/09/08 1009 4156 1046
2021/09/07 933 3652 1068
2021/09/06 886 3676 1091
2021/09/05 905 4154 1153
2021/09/04 927 4138 1151
2021/09/03 957 4134 1126
2021/09/02 943 4158 1114
2021/09/01 950 4229 1031
2021/08/31 904 3686 1067
2021/08/30 915 3676 1066
2021/08/29 904 4169 1142
2021/08/28 902 4178 1138
2021/08/27 916 4143 1158
2021/08/26 905 4169 1141
2021/08/25 898 4268 1047
2021/08/24 843 3705 1115
2021/08/23 835 3719 1112
2021/08/22 794 4257 1162
2021/08/21 782 4205 1228
2021/08/20 827 4248 1140
2021/08/19 807 4264 1144
2021/08/18 816 4343 1052
2021/08/17 747 3758 1159
2021/08/16 740 3775 1143
2021/08/15 718 4275 1221
2021/08/14 707 4282 1223
2021/08/13 742 4253 1219
2021/08/12 734 4262 1218
2021/08/11 765 4412 1037
2021/08/10 713 3894 1055
2021/08/09 693 3831 1146
2021/08/08 686 4374 1157
2021/08/07 655 4333 1229
2021/08/06 678 4311 1229
2021/08/05 656 4343 1219
2021/08/04 670 4440 1099
2021/08/03 633 3844 1178
2021/08/02 612 3873 1174
2021/08/01 606 4314 1287
2021/07/31 609 4306 1293
2021/07/30 642 4269 1297
2021/07/29 625 4315 1268
2021/07/28 620 4479 1105
2021/07/27 570 3874 1215
2021/07/26 675 4175 813
2021/07/25 664 4726 816
2021/07/24 640 4756 812
2021/07/23 661 4692 855
2021/07/22 652 4742 812
2021/07/21 659 4846 699
2021/07/20 614 4130 791
2021/07/19 616 4136 784
2021/07/18 604 4778 818
2021/07/17 613 4761 826
2021/07/16 639 4762 803
2021/07/15 626 4779 799
2021/07/14 628 4906 675
2021/07/13 606 4154 786
2021/07/12 591 4165 791
2021/07/11 606 4779 825
2021/07/10 615 4777 817
2021/07/09 627 4763 818
2021/07/08 614 4792 802
2021/07/07 622 4915 670
2021/07/06 568 4198 785
2021/07/05 567 4190 803
2021/07/04 591 4789 827
2021/07/03 609 4777 824
2021/07/02 617 4780 814
2021/07/01 615 4794 799
2021/06/30 626 4894 680
2021/06/29 581 4183 787
2021/06/28 580 4192 791
2021/06/27 600 4784 822
2021/06/26 607 4781 818
2021/06/25 637 4772 797
2021/06/24 622 4788 795
2021/06/23 635 4874 687
2021/06/22 590 4233 822
2021/06/21 598 4210 819
2021/06/20 609 4737 835
2021/06/19 601 4742 838
2021/06/18 622 4732 825
2021/06/17 606 4795 782
2021/06/16 614 4905 660
2021/06/15 591 4286 787
2021/06/14 589 4421 657
2021/06/13 602 4928 680
2021/06/12 598 4940 675
2021/06/11 599 4945 668
2021/06/10 612 4939 660
2021/06/09 626 5036 543
2021/06/08 606 4413 655
2021/06/07 594 4420 661
2021/06/06 608 4916 682
2021/06/05 607 4924 676
2021/06/04 614 4935 660
2021/06/03 621 4933 652
2021/06/02 651 5013 541
2021/06/01 602 4409 656
2021/05/31 598 4414 659
2021/05/30 634 4896 667
2021/05/29 628 4905 664
2021/05/28 647 4889 660
2021/05/27 642 4902 654
2021/05/26 635 5018 543
2021/05/25 616 4400 655
2021/05/24 615 4414 650
2021/05/23 634 4885 686
2021/05/22 642 4886 679
2021/05/21 651 4891 665
2021/05/20 646 4882 678
2021/05/19 671 4986 545
2021/05/18 645 4358 668
2021/05/17 643 4365 665
2021/05/16 652 4877 672
2021/05/15 660 4872 668
2021/05/14 656 4875 671
2021/05/13 660 4868 673
2021/05/12 678 4979 539
2021/05/11 608 4387 668
2021/05/10 628 4366 677
2021/05/09 659 4856 693
2021/05/08 646 4854 712
2021/05/07 651 4857 709
2021/05/06 667 4841 708
2021/05/05 677 5013 524
2021/05/04 650 4384 654
2021/05/03 643 4372 671
2021/05/02 643 4903 668
2021/05/01 654 4899 663
2021/04/30 656 4898 663
2021/04/29 659 4885 671
2021/04/28 664 5009 539
2021/04/27 640 4380 666
2021/04/26 656 4370 655
2021/04/25 641 4902 662
2021/04/24 654 4890 661
2021/04/23 670 4892 644
2021/04/22 660 4896 649
2021/04/21 687 5005 511
2021/04/20 647 4374 654
2021/04/19 645 4379 655
2021/04/18 646 4894 667
2021/04/17 651 4892 666
2021/04/16 671 4878 660
2021/04/15 672 4887 652
2021/04/14 685 5004 519
2021/04/13 657 4369 664
2021/04/12 656 4407 643
2021/04/11 662 4882 661
2021/04/10 668 4880 657
2021/04/09 682 4865 659
2021/04/08 657 4894 655
2021/04/07 677 5005 519
2021/04/06 638 4489 643
2021/04/05 644 4486 643
2021/04/04 662 4893 647
2021/04/03 655 4909 641
2021/04/02 671 4904 631
2021/04/01 651 4912 643
2021/03/31 677 5094 433
2021/03/30 638 4392 649
2021/03/29 639 4404 643
2021/03/28 647 4898 659
2021/03/27 647 4896 661
2021/03/26 651 4896 659
2021/03/25 655 4894 659
2021/03/24 670 5071 465
2021/03/23 644 4357 694
2021/03/22 669 4494 534
2021/03/21 688 4986 533
2021/03/20 682 4994 533
2021/03/19 707 4972 530
2021/03/18 702 4975 532
2021/03/17 709 5094 402
2021/03/16 683 4469 536
2021/03/15 684 4483 526
2021/03/14 690 4891 627
2021/03/13 691 4895 624
2021/03/12 696 4985 529
2021/03/11 699 4986 525
2021/03/10 733 5084 392
2021/03/09 700 4386 609
2021/03/08 709 4473 520
2021/03/07 716 4966 523
2021/03/06 702 4980 525
2021/03/05 726 4967 515
2021/03/04 726 4866 617
2021/03/03 710 5032 402
2021/03/02 695 4326 614
2021/03/01 709 4406 519
2021/02/28 733 4854 618
2021/02/27 734 4950 524
2021/02/26 755 4837 616
2021/02/25 754 4933 520
2021/02/24 779 5026 402
2021/02/23 759 4325 613
2021/02/22 757 4362 581
2021/02/21 768 4840 599
2021/02/20 777 4927 506
2021/02/19 817 4783 611
2021/02/18 821 4865 525
2021/02/17 837 4971 399
2021/02/16 823 4354 523
2021/02/15 836 4270 591
2021/02/14 814 4787 606
2021/02/13 824 4778 603
2021/02/12 848 4773 587
2021/02/11 849 4772 588
2021/02/10 854 4812 541
2021/02/09 821 4271 610
2021/02/08 843 4270 592
2021/02/07 860 4756 591
2021/02/06 861 4757 590
2021/02/05 881 4738 592
2021/02/04 875 4832 504
2021/02/03 889 4924 397
2021/02/02 861 4349 495
2021/02/01 887 4324 494
2021/01/31 899 4800 515
2021/01/30 908 4807 499
2021/01/29 926 4787 500
2021/01/28 940 4778 495
2021/01/27 960 4858 393
2021/01/26 941 4204 555
2021/01/25 957 4182 562
2021/01/24 978 4699 529
2021/01/23 972 4688 548
2021/01/22 1011 4675 522
2021/01/21 1004 4683 519
2021/01/20 1031 4749 424
2021/01/19 995 4198 514
2021/01/18 1016 4173 511
2021/01/17 1062 4602 541
2021/01/16 1045 4548 612
2021/01/15 1071 4604 529
2021/01/14 1088 4602 513
2021/01/13 1098 4700 406
2021/01/12 1064 4124 515
2021/01/11 1074 4118 518
2021/01/10 1094 4594 519
2021/01/09 1090 4609 511
2021/01/08 1083 4619 508
2021/01/07 1105 4672 432
2021/01/06 1113 4787 300
2021/01/05 1082 4232 383
2021/01/04 1076 4244 381
2021/01/03 1076 4749 381
2021/01/02 1055 4766 389
2021/01/01 1023 4747 440
2020/12/31 1088 4738 383
2020/12/30 1062 4847 297
2020/12/29 1078 4237 381
2020/12/28 1210 4108 376
2020/12/27 1268 4537 387
2020/12/26 1261 4548 385
2020/12/25 1246 4476 474
2020/12/24 1269 4462 463
2020/12/23 1266 4640 288
2020/12/22 1211 4214 371
2020/12/21 1215 4120 372
2020/12/20 1236 4576 390
2020/12/19 1239 4578 385
2020/12/18 1250 4489 465
2020/12/17 1241 4584 378
2020/12/16 1265 4565 373
2020/12/15 1220 4121 381
2020/12/14 1241 4016 469
2020/12/13 1231 4526 433
2020/12/12 1233 4587 375
2020/12/11 1248 4477 470
2020/12/10 1228 4495 468
2020/12/09 1264 4639 288
2020/12/08 1180 4096 458
2020/12/07 1167 4205 364
2020/12/06 1180 4618 380
2020/12/05 1175 4622 383
2020/12/04 1183 4579 418
2020/12/03 1181 4667 329
2020/12/02 1179 4725 262
2020/12/01 1110 4272 337
2020/11/30 1132 4155 426
2020/11/29 1154 4653 344
2020/11/28 1158 4661 343
2020/11/27 1148 4578 439
2020/11/26 1135 4674 353
2020/11/25 1174 4727 259
2020/11/24 1122 4280 334
2020/11/23 1125 4168 423
2020/11/22 1120 4675 352
2020/11/21 1133 4678 343
2020/11/20 1146 4672 340
2020/11/19 1131 4680 342
2020/11/18 1136 4751 259
2020/11/17 1094 4286 343
2020/11/16 1083 4326 331
2020/11/15 1087 4629 412
2020/11/14 1092 4718 327
2020/11/13 1115 4691 335
2020/11/12 1117 4740 274
2020/11/11 1086 4762 251
2020/11/10 1047 4399 269
2020/11/09 1000 4430 278
2020/11/08 992 4841 264
2020/11/07 992 4848 262
2020/11/06 1025 4828 254
2020/11/05 1010 4856 233
2020/11/04 999 4876 202
2020/11/03 987 4527 210
2020/11/02 981 4545 213
2020/11/01 979 4829 261
2020/10/31 1015 4802 261
2020/10/30 993 4814 275
2020/10/29 976 4786 303
2020/10/28 966 4778 297
2020/10/27 938 4523 280
2020/10/26 951 4524 272
2020/10/25 932 4795 287
2020/10/24 946 4795 286
2020/10/23 976 4789 287
2020/10/22 975 4767 295
2020/10/21 957 4767 289
2020/10/20 940 4687 276
2020/10/19 954 4690 273
2020/10/18 955 4725 297
2020/10/17 949 4745 294
2020/10/16 979 4737 284
2020/10/15 964 4709 297
2020/10/14 950 4708 292
2020/10/13 932 4648 307
2020/10/12 923 4673 313
2020/10/11 913 4687 330
2020/10/10 921 4675 343
2020/10/09 933 4650 358
2020/10/08 920 4620 390
2020/10/07 905 4579 416
2020/10/06 893 4562 437
2020/10/05 899 4508 475
2020/10/04 849 4453 567
2020/10/03 858 4443 576
2020/10/02 892 4450 543
Powered by Datasette · Queries took 43.896ms