Last active
May 11, 2022 23:24
-
-
Save rrelyea/9aa52cdf0a7e20768f51b245d6d9810e to your computer and use it in GitHub Desktop.
Total doses given of covid prevention (Evusheld) and treatments (Paxlovid, Bebtelovimab, Lagevrio)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DosesGiven is calcuated based on doses available reporting from each provider. | |
I've downloaded all this data (check for new data every 20 minutes) from healthdata.gov. | |
Note: to develop these totals, I'm looping through the current list of providers. If somebody had given doses, but no longer is listed, those doses are ignored. | |
(sotrivimab shows 0 doses given...because there are no current providers, for example.) | |
Inventory goes up when a provider gets more supply. | |
Inventory goes down when a provider gives doses to a patient, or transfers them to another provider. | |
Somedays inventory goes up and down in the same day, up 20 doses net...but that was becuase they got a box of 24 and gave 4 doses to patients. | |
My dosesGiven tries to calculate that. | |
Currently my logic doesn't count big drops in inventory as does given. It allows a box per day. | |
Currently, if doses go up by less than half a box, it doesn't count any doses as given. | |
I originally developed this dosesGiven logic based on Evusheld, which had some strange events which influenced reporting. On 2/24, FDA said a normal doses was now double the original dose. Some providers dropped their numbers by half right away. Some did it later. Some did something different. | |
Evusheld patients who got doses before 2/24, had to go back to get another dose. So some people count as 2 patients. | |
Paxlovid and others don't have this problem. | |
Would love any feedback to rob@relyeas.net or https://twitter.com/rrelyea (DMs open) | |
PS C:\Users\rob\repos\covid-therapeutics> python .\src\dose-history-totals.py | |
Explore evusheld data at https://rrelyea.github.io/evusheld (data originally from healthdata.gov) | |
drugName state providers dosesGiven | |
Evusheld AK 7 93 | |
Evusheld AL 22 369 | |
Evusheld AR 26 931 | |
Evusheld AS 1 15 | |
Evusheld AZ 23 790 | |
Evusheld CA 181 11897 | |
Evusheld CO 72 2876 | |
Evusheld CT 16 1525 | |
Evusheld DC 5 322 | |
Evusheld DE 5 167 | |
Evusheld FL 89 3416 | |
Evusheld GA 13 728 | |
Evusheld HI 20 546 | |
Evusheld IA 69 1894 | |
Evusheld ID 16 862 | |
Evusheld IL 93 4435 | |
Evusheld IN 60 2232 | |
Evusheld KS 94 1535 | |
Evusheld KY 27 1841 | |
Evusheld LA 15 795 | |
Evusheld MA 45 5686 | |
Evusheld MD 61 3515 | |
Evusheld ME 14 766 | |
Evusheld MI 63 3253 | |
Evusheld MN 45 2878 | |
Evusheld MO 31 1438 | |
Evusheld MP 1 21 | |
Evusheld MS 36 642 | |
Evusheld MT 12 567 | |
Evusheld NC 101 4856 | |
Evusheld ND 13 132 | |
Evusheld NE 22 1949 | |
Evusheld NH 18 786 | |
Evusheld NJ 58 2107 | |
Evusheld NM 28 1464 | |
Evusheld NV 20 489 | |
Evusheld NY 119 4517 | |
Evusheld OH 75 3469 | |
Evusheld OK 53 1316 | |
Evusheld OR 36 1717 | |
Evusheld PA 71 2388 | |
Evusheld PR 3 208 | |
Evusheld PW 1 11 | |
Evusheld RI 8 391 | |
Evusheld SC 13 741 | |
Evusheld SD 8 115 | |
Evusheld TN 19 1731 | |
Evusheld TX 85 5013 | |
Evusheld UT 19 1439 | |
Evusheld VA 68 2628 | |
Evusheld VT 10 824 | |
Evusheld WA 54 2309 | |
Evusheld WI 46 2682 | |
Evusheld WV 10 352 | |
Evusheld WY 3 67 | |
Evusheld USA 2123 99736 | |
Explore paxlovid data at https://rrelyea.github.io/paxlovid (data originally from healthdata.gov) | |
NOTE: these are only totals per state...I've already started breaking it down weekly. | |
see new data here: https://github.com/rrelyea/covid-therapeutics/blob/main/data/therapeutics/paxlovid/doses-given-per-week.csv | |
see it live at https://rrelyea.github.io/paxlovid?state=NY | |
drugName state providers dosesGiven | |
Paxlovid AK 72 925 | |
Paxlovid AL 424 3787 | |
Paxlovid AR 244 2412 | |
Paxlovid AS 3 150 | |
Paxlovid AZ 523 5839 | |
Paxlovid CA 3096 48339 | |
Paxlovid CO 441 4153 | |
Paxlovid CT 515 11059 | |
Paxlovid DC 79 2008 | |
Paxlovid DE 94 967 | |
Paxlovid FL 2039 23838 | |
Paxlovid GA 959 7059 | |
Paxlovid HI 113 1936 | |
Paxlovid IA 189 2302 | |
Paxlovid ID 91 1313 | |
Paxlovid IL 1100 15437 | |
Paxlovid IN 830 5322 | |
Paxlovid KS 256 2738 | |
Paxlovid KY 481 2618 | |
Paxlovid LA 458 2038 | |
Paxlovid MA 696 31106 | |
Paxlovid MD 567 10784 | |
Paxlovid ME 88 3876 | |
Paxlovid MI 1133 16052 | |
Paxlovid MN 453 6605 | |
Paxlovid MO 406 3517 | |
Paxlovid MP 1 47 | |
Paxlovid MS 283 1370 | |
Paxlovid MT 82 542 | |
Paxlovid NC 1126 13704 | |
Paxlovid ND 27 497 | |
Paxlovid NE 108 1032 | |
Paxlovid NH 195 3408 | |
Paxlovid NJ 911 21082 | |
Paxlovid NM 223 2595 | |
Paxlovid NV 246 2204 | |
Paxlovid NY 1506 52254 | |
Paxlovid OH 1156 8453 | |
Paxlovid OK 317 2294 | |
Paxlovid OR 292 3239 | |
Paxlovid PA 1527 21518 | |
Paxlovid PR 220 3261 | |
Paxlovid PW 1 13 | |
Paxlovid RI 97 4383 | |
Paxlovid SC 539 5820 | |
Paxlovid SD 43 237 | |
Paxlovid TN 522 6076 | |
Paxlovid TX 2546 24403 | |
Paxlovid UT 169 2160 | |
Paxlovid VA 896 12796 | |
Paxlovid VI 5 118 | |
Paxlovid VT 42 2525 | |
Paxlovid WA 769 9546 | |
Paxlovid WI 575 6274 | |
Paxlovid WV 172 1681 | |
Paxlovid WY 36 244 | |
Paxlovid USA 29946 429956 | |
drugName state providers dosesGiven | |
Sotrovimab USA 0 0 | |
Explore Bebtelovimab data at https://rrelyea.github.io/bebtelovimab (data originally from healthdata.gov) | |
drugName state providers dosesGiven | |
Bebtelovimab AK 19 74 | |
Bebtelovimab AL 77 169 | |
Bebtelovimab AR 40 176 | |
Bebtelovimab AS 3 63 | |
Bebtelovimab AZ 24 150 | |
Bebtelovimab CA 157 757 | |
Bebtelovimab CO 41 164 | |
Bebtelovimab CT 20 321 | |
Bebtelovimab DC 3 17 | |
Bebtelovimab DE 5 47 | |
Bebtelovimab FL 121 719 | |
Bebtelovimab GA 20 79 | |
Bebtelovimab HI 15 188 | |
Bebtelovimab IA 100 313 | |
Bebtelovimab ID 17 34 | |
Bebtelovimab IL 104 698 | |
Bebtelovimab IN 66 519 | |
Bebtelovimab KS 82 243 | |
Bebtelovimab KY 32 246 | |
Bebtelovimab LA 32 122 | |
Bebtelovimab MA 40 551 | |
Bebtelovimab MD 38 488 | |
Bebtelovimab ME 20 182 | |
Bebtelovimab MI 98 691 | |
Bebtelovimab MN 70 497 | |
Bebtelovimab MO 34 151 | |
Bebtelovimab MP 1 4 | |
Bebtelovimab MS 50 99 | |
Bebtelovimab MT 15 14 | |
Bebtelovimab NC 79 666 | |
Bebtelovimab ND 13 150 | |
Bebtelovimab NE 21 39 | |
Bebtelovimab NH 31 226 | |
Bebtelovimab NJ 57 531 | |
Bebtelovimab NM 31 106 | |
Bebtelovimab NV 20 41 | |
Bebtelovimab NY 166 1064 | |
Bebtelovimab OH 98 569 | |
Bebtelovimab OK 44 144 | |
Bebtelovimab OR 23 138 | |
Bebtelovimab PA 48 278 | |
Bebtelovimab PR 6 36 | |
Bebtelovimab RI 8 92 | |
Bebtelovimab SC 24 128 | |
Bebtelovimab SD 11 42 | |
Bebtelovimab TN 20 131 | |
Bebtelovimab TX 81 271 | |
Bebtelovimab UT 13 86 | |
Bebtelovimab VA 48 318 | |
Bebtelovimab VT 11 98 | |
Bebtelovimab WA 51 288 | |
Bebtelovimab WI 58 450 | |
Bebtelovimab WV 15 55 | |
Bebtelovimab WY 5 16 | |
Bebtelovimab USA 2321 13739 | |
Explore lagevrio data at https://rrelyea.github.io/lagevrio (data originally from healthdata.gov) | |
drugName state providers dosesGiven | |
lagevrio AK 78 705 | |
lagevrio AL 405 2258 | |
lagevrio AR 247 1538 | |
lagevrio AS 3 53 | |
lagevrio AZ 384 1167 | |
lagevrio CA 2816 9681 | |
lagevrio CO 274 1013 | |
lagevrio CT 452 1768 | |
lagevrio DC 68 176 | |
lagevrio DE 90 706 | |
lagevrio FL 1872 4846 | |
lagevrio GA 781 1816 | |
lagevrio HI 93 426 | |
lagevrio IA 199 1184 | |
lagevrio ID 76 220 | |
lagevrio IL 1110 3463 | |
lagevrio IN 686 3416 | |
lagevrio KS 190 365 | |
lagevrio KY 390 2313 | |
lagevrio LA 443 2855 | |
lagevrio MA 668 1759 | |
lagevrio MD 475 1421 | |
lagevrio ME 91 788 | |
lagevrio MI 926 3393 | |
lagevrio MN 359 1624 | |
lagevrio MO 397 868 | |
lagevrio MP 1 17 | |
lagevrio MS 267 1131 | |
lagevrio MT 79 440 | |
lagevrio NC 948 6000 | |
lagevrio ND 25 166 | |
lagevrio NE 103 441 | |
lagevrio NH 180 414 | |
lagevrio NJ 808 3910 | |
lagevrio NM 207 866 | |
lagevrio NV 193 1281 | |
lagevrio NY 1448 9221 | |
lagevrio OH 836 1746 | |
lagevrio OK 307 1094 | |
lagevrio OR 235 985 | |
lagevrio PA 1460 5833 | |
lagevrio PR 250 3378 | |
lagevrio PW 1 0 | |
lagevrio RI 90 744 | |
lagevrio SC 515 1860 | |
lagevrio SD 31 130 | |
lagevrio TN 467 1772 | |
lagevrio TX 2269 12837 | |
lagevrio UT 138 435 | |
lagevrio VA 775 3876 | |
lagevrio VI 3 27 | |
lagevrio VT 26 387 | |
lagevrio WA 695 3934 | |
lagevrio WI 442 2570 | |
lagevrio WV 104 307 | |
lagevrio WY 25 84 | |
lagevrio USA 26476 115708 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment