You are probably going to have to count the mentions of Pfizer, Moderna, and J&J (case insensitive) in the SYMPTOM_TEXT field. It's bad because the SYMPTOM_TEXT is user-entered and very inconsistent. But there might be enough mentions to get some very rough statistics.
Please let me know if you have any luck with that or figure out something else.
The SPLTTYPE mentions some of the pharmas, too. I suspect my machine won’t be able to handle this, so will have to take some shortcuts.
Thanks, again.