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

Edit SQL

dateshortage_todayno_shortage_todaynot_reported
2022/08/03 304 2734 2449
2022/08/02 306 2774 2455
2022/08/01 298 2827 2434
2022/07/31 299 3346 2532
2022/07/30 292 3377 2516
2022/07/29 314 3302 2570
2022/07/28 307 3298 2580
2022/07/27 291 3358 2539
2022/07/26 295 2836 2443
2022/07/25 283 2881 2416
2022/07/24 297 3456 2448
2022/07/23 298 3443 2461
2022/07/22 308 3373 2523
2022/07/21 308 3402 2494
2022/07/20 309 3391 2499
2022/07/19 285 2896 2400
2022/07/18 292 2900 2396
2022/07/17 294 3424 2482
2022/07/16 299 3407 2495
2022/07/15 307 3374 2525
2022/07/14 316 3367 2523
2022/07/13 310 3429 2465
2022/07/12 301 2893 2394
2022/07/11 297 2899 2398
2022/07/10 299 3362 2539
2022/07/09 304 3337 2563
2022/07/08 310 3282 2612
2022/07/07 301 3299 2600
2022/07/06 287 3346 2563
2022/07/05 271 2830 2467
2022/07/04 268 2882 2427
2022/07/03 282 3408 2503
2022/07/02 283 3340 2573
2022/07/01 307 3290 2600
2022/06/30 306 3284 2607
2022/06/29 291 3328 2572
2022/06/28 254 2801 2518
2022/06/27 252 2816 2508
2022/06/26 270 3342 2583
2022/06/25 270 3319 2608
2022/06/24 279 3279 2638
2022/06/23 284 3287 2625
2022/06/22 274 3327 2594
2022/06/21 259 2813 2506
2022/06/20 274 2811 2500
2022/06/19 278 3332 2592
2022/06/18 281 3323 2600
2022/06/17 289 3283 2633
2022/06/16 281 3287 2635
2022/06/15 277 3327 2598
2022/06/14 256 2843 2485
2022/06/13 268 2807 2502
2022/06/12 268 3359 2571
2022/06/11 277 3332 2594
2022/06/10 277 3284 2642
2022/06/09 275 3306 2622
2022/06/08 276 3312 2613
2022/06/07 266 2809 2509
2022/06/06 266 2816 2506
2022/06/05 275 3339 2583
2022/06/04 272 3345 2585
2022/06/03 277 3302 2623
2022/06/02 283 3287 2630
2022/06/01 263 3346 2587
2022/05/31 258 2814 2496
2022/05/30 244 2870 2457
2022/05/29 262 3348 2588
2022/05/28 274 3335 2591
2022/05/27 287 3290 2621
2022/05/26 282 3286 2629
2022/05/25 275 3320 2599
2022/05/24 278 2803 2493
2022/05/23 263 2821 2494
2022/05/22 267 3347 2583
2022/05/21 270 3339 2590
2022/05/20 297 3287 2616
2022/05/19 295 3287 2618
2022/05/18 285 3335 2578
2022/05/17 272 2816 2492
2022/05/16 278 2809 2493
2022/05/15 279 3339 2574
2022/05/14 276 3339 2579
2022/05/13 285 3288 2623
2022/05/12 297 3279 2623
2022/05/11 290 3311 2594
2022/05/10 270 2810 2492
2022/05/09 284 2810 2491
2022/05/08 271 3374 2554
2022/05/07 275 3342 2583
2022/05/06 297 3300 2608
2022/05/05 300 3288 2615
2022/05/04 292 3326 2580
2022/05/03 278 2806 2495
2022/05/02 275 2823 2486
2022/05/01 286 3339 2577
2022/04/30 298 3332 2574
2022/04/29 289 3286 2629
2022/04/28 283 3314 2607
2022/04/27 292 3332 2576
2022/04/26 280 2826 2477
2022/04/25 282 2822 2487
2022/04/24 283 3346 2576
2022/04/23 284 3334 2589
2022/04/22 285 3289 2634
2022/04/21 303 3273 2632
2022/04/20 303 3314 2585
2022/04/19 286 2799 2502
2022/04/18 290 2803 2492
2022/04/17 282 3342 2586
2022/04/16 280 3340 2592
2022/04/15 292 3304 2616
2022/04/14 302 3290 2619
2022/04/13 299 3323 2586
2022/04/12 280 2803 2502
2022/04/11 282 2812 2505
2022/04/10 286 3363 2559
2022/04/09 279 3340 2591
2022/04/08 303 3294 2617
2022/04/07 300 3289 2624
2022/04/06 295 3335 2578
2022/04/05 285 2816 2488
2022/04/04 279 2816 2502
2022/04/03 293 3335 2583
2022/04/02 298 3332 2584
2022/04/01 313 3297 2605
2022/03/31 305 3315 2593
2022/03/30 299 3333 2574
2022/03/29 281 2828 2482
2022/03/28 275 2848 2477
2022/03/27 286 3348 2578
2022/03/26 281 3361 2570
2022/03/25 294 3319 2600
2022/03/24 301 3323 2587
2022/03/23 292 3350 2568
2022/03/22 285 2843 2472
2022/03/21 281 2854 2479
2022/03/20 301 3359 2554
2022/03/19 298 3344 2572
2022/03/18 306 3375 2534
2022/03/17 312 3294 2609
2022/03/16 307 3352 2551
2022/03/15 291 2853 2475
2022/03/14 289 2856 2477
2022/03/13 304 3389 2519
2022/03/12 309 3340 2562
2022/03/11 317 3309 2586
2022/03/10 315 3311 2586
2022/03/09 325 3350 2529
2022/03/08 321 2835 2453
2022/03/07 318 2845 2455
2022/03/06 325 3353 2535
2022/03/05 314 3367 2533
2022/03/04 343 3295 2575
2022/03/03 345 3304 2563
2022/03/02 351 3316 2539
2022/03/01 338 2811 2459
2022/02/28 340 2828 2449
2022/02/27 354 3341 2525
2022/02/26 357 3336 2536
2022/02/25 374 3314 2543
2022/02/24 380 3343 2508
2022/02/23 361 3348 2519
2022/02/22 361 2870 2400
2022/02/21 361 2920 2350
2022/02/20 363 3418 2440
2022/02/19 370 3398 2453
2022/02/18 409 3307 2506
2022/02/17 404 3314 2504
2022/02/16 407 3392 2418
2022/02/15 403 2765 2463
2022/02/14 390 2804 2436
2022/02/13 411 3288 2522
2022/02/12 407 3282 2533
2022/02/11 432 3226 2565
2022/02/10 429 3234 2557
2022/02/09 437 3295 2478
2022/02/08 415 2783 2436
2022/02/07 431 2847 2364
2022/02/06 443 3323 2447
2022/02/05 448 3326 2446
2022/02/04 464 3230 2528
2022/02/03 462 3281 2477
2022/02/02 459 3427 2331
2022/02/01 525 2897 2220
2022/01/31 630 3066 1946
2022/01/30 635 3589 1992
2022/01/29 644 3594 1981
2022/01/28 681 3550 1988
2022/01/27 711 3583 1925
2022/01/26 721 3736 1760
2022/01/25 765 3154 1715
2022/01/24 761 3159 1715
2022/01/23 757 3632 1825
2022/01/22 756 3637 1821
2022/01/21 808 3597 1811
2022/01/20 790 3623 1801
2022/01/19 784 3856 1572
2022/01/18 956 3405 1275
2022/01/17 972 3412 1265
2022/01/16 957 3876 1386
2022/01/15 953 3883 1384
2022/01/14 1003 3860 1357
2022/01/13 1015 3846 1357
2022/01/12 1012 3972 1230
2022/01/11 986 3397 1249
2022/01/10 991 3400 1245
2022/01/09 1091 3950 1174
2022/01/08 1099 3941 1177
2022/01/07 1181 3888 1148
2022/01/06 1162 3918 1138
2022/01/05 1178 4006 1032
2022/01/04 1103 3471 1053
2022/01/03 1093 3470 1067
2022/01/02 1069 3982 1158
2022/01/01 1056 3992 1161
2021/12/31 1063 4008 1138
2021/12/30 1089 3987 1133
2021/12/29 1085 4075 1048
2021/12/28 1042 3525 1069
2021/12/27 1023 3553 1066
2021/12/26 998 4057 1145
2021/12/25 986 4049 1167
2021/12/24 1016 4049 1137
2021/12/23 1048 4020 1128
2021/12/22 1050 4109 1032
2021/12/21 1006 3571 1065
2021/12/20 1016 3577 1052
2021/12/19 1015 4065 1137
2021/12/18 1030 4049 1137
2021/12/17 1045 4042 1128
2021/12/16 1040 4040 1131
2021/12/15 1058 4122 1026
2021/12/14 987 3575 1070
2021/12/13 977 3587 1077
2021/12/12 976 4078 1160
2021/12/11 981 4080 1154
2021/12/10 1012 4067 1137
2021/12/09 1010 4060 1143
2021/12/08 1011 4169 1031
2021/12/07 980 3588 1066
2021/12/06 964 3621 1061
2021/12/05 966 4100 1151
2021/12/04 954 4111 1153
2021/12/03 981 4098 1139
2021/12/02 1002 4082 1134
2021/12/01 1013 4173 1029
2021/11/30 963 3609 1074
2021/11/29 968 3606 1075
2021/11/28 956 4065 1100
2021/11/27 944 4086 1100
2021/11/26 960 4077 1093
2021/11/25 951 4086 1091
2021/11/24 998 4173 956
2021/11/23 958 3630 1061
2021/11/22 957 3633 1058
2021/11/21 932 4123 1165
2021/11/20 941 4120 1159
2021/11/19 987 4093 1139
2021/11/18 980 4100 1138
2021/11/17 982 4201 1031
2021/11/16 952 3639 1057
2021/11/15 918 3657 1069
2021/11/14 902 4169 1144
2021/11/13 933 4134 1147
2021/11/12 957 4117 1137
2021/11/11 937 4145 1129
2021/11/10 970 4218 1022
2021/11/09 930 3644 1063
2021/11/08 916 3653 1072
2021/11/07 910 4143 1160
2021/11/06 924 4137 1153
2021/11/05 966 4112 1135
2021/11/04 951 4135 1127
2021/11/03 971 4181 1059
2021/11/02 947 3628 1067
2021/11/01 946 3636 1059
2021/10/31 978 4095 1142
2021/10/30 985 4086 1145
2021/10/29 997 4104 1115
2021/10/28 981 4118 1117
2021/10/27 992 4162 1055
2021/10/26 961 3631 1049
2021/10/25 973 3629 1048
2021/10/24 979 4116 1121
2021/10/23 977 4114 1126
2021/10/22 1014 4073 1130
2021/10/21 983 4106 1127
2021/10/20 1015 4177 1019
2021/10/19 952 3618 1066
2021/10/18 934 3639 1069
2021/10/17 949 4119 1148
2021/10/16 957 4112 1149
2021/10/15 976 4096 1146
2021/10/14 1018 4056 1143
2021/10/13 1001 4112 1101
2021/10/12 962 3623 1071
2021/10/11 967 3616 1073
2021/10/10 948 4111 1152
2021/10/09 956 4109 1149
2021/10/08 973 4088 1152
2021/10/07 967 4106 1140
2021/10/06 989 4161 1062
2021/10/05 944 3639 1082
2021/10/04 968 3639 1061
2021/10/03 944 4124 1146
2021/10/02 947 4127 1144
2021/10/01 997 4082 1138
2021/09/30 982 4108 1129
2021/09/29 1005 4169 1043
2021/09/28 959 3646 1064
2021/09/27 978 3624 1067
2021/09/26 957 4113 1151
2021/09/25 957 4109 1155
2021/09/24 985 4082 1154
2021/09/23 971 4097 1153
2021/09/22 1026 4133 1061
2021/09/21 970 3582 1112
2021/09/20 969 3573 1125
2021/09/19 940 4117 1165
2021/09/18 960 4094 1168
2021/09/17 993 4078 1152
2021/09/16 1010 4067 1146
2021/09/15 1023 4119 1078
2021/09/14 963 3615 1082
2021/09/13 966 3621 1078
2021/09/12 957 4098 1158
2021/09/11 964 4105 1144
2021/09/10 1013 4076 1124
2021/09/09 981 4108 1124
2021/09/08 1008 4156 1045
2021/09/07 933 3652 1067
2021/09/06 886 3676 1090
2021/09/05 905 4153 1152
2021/09/04 927 4137 1150
2021/09/03 956 4133 1126
2021/09/02 943 4157 1113
2021/09/01 948 4229 1031
2021/08/31 903 3686 1067
2021/08/30 915 3676 1065
2021/08/29 904 4168 1141
2021/08/28 902 4177 1137
2021/08/27 916 4142 1157
2021/08/26 905 4168 1140
2021/08/25 897 4267 1047
2021/08/24 843 3705 1114
2021/08/23 835 3719 1111
2021/08/22 793 4256 1162
2021/08/21 781 4204 1228
2021/08/20 827 4247 1139
2021/08/19 807 4263 1143
2021/08/18 815 4343 1051
2021/08/17 747 3757 1159
2021/08/16 740 3775 1142
2021/08/15 718 4274 1220
2021/08/14 707 4281 1222
2021/08/13 742 4252 1218
2021/08/12 734 4261 1217
2021/08/11 764 4411 1037
2021/08/10 713 3894 1054
2021/08/09 693 3831 1145
2021/08/08 686 4373 1156
2021/08/07 655 4332 1228
2021/08/06 678 4310 1228
2021/08/05 656 4342 1218
2021/08/04 670 4438 1099
2021/08/03 633 3844 1177
2021/08/02 612 3873 1173
2021/08/01 606 4313 1286
2021/07/31 609 4305 1292
2021/07/30 642 4267 1297
2021/07/29 625 4314 1267
2021/07/28 620 4478 1104
2021/07/27 570 3874 1214
2021/07/26 675 4175 812
2021/07/25 664 4724 816
2021/07/24 640 4755 811
2021/07/23 661 4690 855
2021/07/22 652 4741 811
2021/07/21 659 4845 698
2021/07/20 614 4130 790
2021/07/19 616 4135 784
2021/07/18 604 4777 817
2021/07/17 613 4760 825
2021/07/16 639 4761 802
2021/07/15 626 4778 798
2021/07/14 628 4904 675
2021/07/13 606 4153 786
2021/07/12 591 4165 790
2021/07/11 606 4778 824
2021/07/10 615 4776 816
2021/07/09 627 4762 817
2021/07/08 614 4791 801
2021/07/07 622 4914 669
2021/07/06 568 4198 784
2021/07/05 567 4189 803
2021/07/04 591 4787 827
2021/07/03 609 4776 823
2021/07/02 617 4778 814
2021/07/01 615 4792 799
2021/06/30 626 4893 679
2021/06/29 581 4183 786
2021/06/28 580 4192 790
2021/06/27 600 4782 822
2021/06/26 607 4779 818
2021/06/25 637 4771 796
2021/06/24 622 4787 794
2021/06/23 635 4873 686
2021/06/22 590 4233 821
2021/06/21 598 4210 818
2021/06/20 609 4736 834
2021/06/19 601 4741 837
2021/06/18 622 4731 824
2021/06/17 606 4794 781
2021/06/16 614 4903 660
2021/06/15 591 4286 786
2021/06/14 589 4421 656
2021/06/13 602 4927 679
2021/06/12 598 4939 674
2021/06/11 599 4944 667
2021/06/10 612 4938 659
2021/06/09 626 5035 542
2021/06/08 606 4412 655
2021/06/07 594 4420 660
2021/06/06 608 4915 681
2021/06/05 607 4923 675
2021/06/04 614 4934 659
2021/06/03 621 4932 651
2021/06/02 651 5012 540
2021/06/01 602 4409 655
2021/05/31 598 4414 658
2021/05/30 634 4895 666
2021/05/29 628 4903 664
2021/05/28 647 4888 659
2021/05/27 642 4900 654
2021/05/26 635 5017 542
2021/05/25 616 4400 654
2021/05/24 615 4413 650
2021/05/23 634 4884 685
2021/05/22 642 4885 678
2021/05/21 651 4889 665
2021/05/20 646 4881 677
2021/05/19 671 4985 544
2021/05/18 645 4358 667
2021/05/17 643 4365 664
2021/05/16 652 4875 672
2021/05/15 660 4870 668
2021/05/14 656 4873 671
2021/05/13 660 4866 673
2021/05/12 678 4978 538
2021/05/11 608 4387 667
2021/05/10 628 4366 676
2021/05/09 659 4855 692
2021/05/08 646 4852 712
2021/05/07 651 4856 708
2021/05/06 667 4840 707
2021/05/05 677 5011 524
2021/05/04 650 4384 653
2021/05/03 643 4372 670
2021/05/02 643 4902 667
2021/05/01 654 4897 663
2021/04/30 656 4896 663
2021/04/29 659 4884 670
2021/04/28 664 5008 538
2021/04/27 640 4380 665
2021/04/26 656 4369 655
2021/04/25 641 4901 661
2021/04/24 654 4889 660
2021/04/23 670 4890 644
2021/04/22 660 4895 648
2021/04/21 687 5004 510
2021/04/20 647 4374 653
2021/04/19 645 4379 654
2021/04/18 646 4893 666
2021/04/17 651 4891 665
2021/04/16 671 4877 659
2021/04/15 672 4886 651
2021/04/14 685 5003 518
2021/04/13 657 4368 664
2021/04/12 656 4407 642
2021/04/11 662 4881 660
2021/04/10 668 4879 656
2021/04/09 682 4864 658
2021/04/08 657 4892 655
2021/04/07 677 5003 519
2021/04/06 638 4489 642
2021/04/05 644 4486 642
2021/04/04 662 4891 647
2021/04/03 655 4907 641
2021/04/02 671 4903 630
2021/04/01 651 4911 642
2021/03/31 677 5092 433
2021/03/30 638 4392 648
2021/03/29 639 4403 643
2021/03/28 647 4897 658
2021/03/27 647 4895 660
2021/03/26 651 4895 658
2021/03/25 655 4892 659
2021/03/24 670 5070 464
2021/03/23 644 4357 693
2021/03/22 669 4493 534
2021/03/21 688 4984 533
2021/03/20 682 4992 533
2021/03/19 707 4971 529
2021/03/18 702 4974 531
2021/03/17 709 5093 401
2021/03/16 683 4469 535
2021/03/15 684 4482 526
2021/03/14 690 4890 626
2021/03/13 691 4894 623
2021/03/12 696 4984 528
2021/03/11 699 4984 525
2021/03/10 733 5083 391
2021/03/09 700 4386 608
2021/03/08 709 4473 519
2021/03/07 716 4964 523
2021/03/06 702 4978 525
2021/03/05 726 4966 514
2021/03/04 726 4865 616
2021/03/03 710 5031 401
2021/03/02 695 4325 614
2021/03/01 709 4405 519
2021/02/28 733 4853 617
2021/02/27 734 4949 523
2021/02/26 755 4836 615
2021/02/25 754 4931 520
2021/02/24 779 5025 401
2021/02/23 759 4325 612
2021/02/22 757 4362 580
2021/02/21 768 4839 598
2021/02/20 777 4925 506
2021/02/19 817 4781 611
2021/02/18 821 4864 524
2021/02/17 837 4970 398
2021/02/16 823 4353 523
2021/02/15 836 4269 591
2021/02/14 814 4786 605
2021/02/13 824 4777 602
2021/02/12 848 4772 586
2021/02/11 849 4770 588
2021/02/10 853 4811 541
2021/02/09 821 4271 609
2021/02/08 843 4270 591
2021/02/07 860 4754 591
2021/02/06 861 4756 589
2021/02/05 881 4736 592
2021/02/04 875 4831 503
2021/02/03 888 4924 396
2021/02/02 861 4348 495
2021/02/01 887 4323 494
2021/01/31 899 4799 514
2021/01/30 908 4805 499
2021/01/29 926 4785 500
2021/01/28 940 4776 495
2021/01/27 959 4858 392
2021/01/26 941 4204 554
2021/01/25 957 4181 562
2021/01/24 978 4698 528
2021/01/23 972 4687 547
2021/01/22 1011 4674 521
2021/01/21 1004 4682 518
2021/01/20 1030 4749 423
2021/01/19 995 4197 514
2021/01/18 1016 4172 511
2021/01/17 1062 4601 540
2021/01/16 1045 4547 611
2021/01/15 1071 4602 529
2021/01/14 1088 4600 513
2021/01/13 1097 4700 405
2021/01/12 1064 4123 515
2021/01/11 1074 4117 518
2021/01/10 1094 4592 519
2021/01/09 1090 4607 511
2021/01/08 1083 4618 507
2021/01/07 1105 4670 432
2021/01/06 1113 4785 300
2021/01/05 1082 4232 382
2021/01/04 1076 4243 381
2021/01/03 1076 4748 380
2021/01/02 1055 4765 388
2021/01/01 1023 4745 440
2020/12/31 1088 4737 382
2020/12/30 1062 4846 296
2020/12/29 1078 4236 381
2020/12/28 1210 4107 376
2020/12/27 1268 4535 387
2020/12/26 1261 4546 385
2020/12/25 1246 4475 473
2020/12/24 1269 4460 463
2020/12/23 1266 4638 288
2020/12/22 1211 4213 371
2020/12/21 1215 4119 372
2020/12/20 1236 4574 390
2020/12/19 1239 4576 385
2020/12/18 1250 4487 465
2020/12/17 1241 4582 378
2020/12/16 1265 4563 373
2020/12/15 1220 4119 381
2020/12/14 1241 4014 469
2020/12/13 1231 4524 433
2020/12/12 1233 4585 375
2020/12/11 1248 4475 470
2020/12/10 1228 4493 468
2020/12/09 1264 4637 288
2020/12/08 1180 4095 458
2020/12/07 1167 4204 364
2020/12/06 1180 4616 380
2020/12/05 1175 4620 383
2020/12/04 1183 4577 418
2020/12/03 1181 4665 329
2020/12/02 1179 4723 262
2020/12/01 1110 4271 337
2020/11/30 1132 4154 426
2020/11/29 1154 4651 344
2020/11/28 1158 4659 343
2020/11/27 1148 4576 439
2020/11/26 1135 4672 353
2020/11/25 1174 4725 259
2020/11/24 1122 4278 334
2020/11/23 1125 4167 423
2020/11/22 1120 4673 352
2020/11/21 1133 4676 343
2020/11/20 1146 4670 340
2020/11/19 1131 4678 342
2020/11/18 1136 4749 259
2020/11/17 1094 4285 343
2020/11/16 1083 4325 331
2020/11/15 1087 4628 411
2020/11/14 1092 4717 326
2020/11/13 1115 4690 334
2020/11/12 1116 4740 273
2020/11/11 1086 4761 250
2020/11/10 1047 4398 269
2020/11/09 1000 4429 278
2020/11/08 992 4840 263
2020/11/07 992 4847 261
2020/11/06 1025 4827 253
2020/11/05 1010 4855 232
2020/11/04 999 4875 201
2020/11/03 987 4526 210
2020/11/02 981 4544 213
2020/11/01 980 4827 260
2020/10/31 1016 4800 260
2020/10/30 994 4812 274
2020/10/29 977 4784 302
2020/10/28 968 4775 296
2020/10/27 938 4522 279
2020/10/26 952 4522 271
2020/10/25 932 4794 287
2020/10/24 946 4794 286
2020/10/23 976 4788 287
2020/10/22 975 4766 295
2020/10/21 957 4766 289
2020/10/20 940 4686 276
2020/10/19 954 4689 273
2020/10/18 955 4724 297
2020/10/17 949 4744 294
2020/10/16 979 4736 284
2020/10/15 964 4708 297
2020/10/14 950 4707 292
2020/10/13 932 4648 306
2020/10/12 923 4673 312
2020/10/11 913 4687 329
2020/10/10 921 4674 343
2020/10/09 933 4650 357
2020/10/08 920 4620 389
2020/10/07 905 4579 415
2020/10/06 893 4562 436
2020/10/05 899 4508 474
2020/10/04 849 4453 566
2020/10/03 858 4443 575
2020/10/02 892 4449 543
Powered by Datasette · Queries took 61.338ms