Vaccination Rollout

The CDC tracks this data at this site.  I was unaware of this site until Saturday, January 23, 2021. Starting this weekend I will switch to using this data rather than the sites I used previously. In addition, there will now be two spreadsheets: a) vaccine delivered and administered; b) number of folks actually immunized.

Vaccinations doses distributed / vaccinations given (per cent delivered doses used)

January 22, 2021, Bloomberg:
39,892,400 / 19,841,721 (49.7%)

January 21, 2021 (Bloomberg)
37,960,000 / 18,449,288 (48.6)

January 20, 2021 (Johns Hopkins-MIT-WSJ)
35,990,150 / 16,525,281 (45.9)

For the US:

	A	B	C	D	E
	Doses of vaccine distributed to health facilities	Change from day before	Vaccinations given	Change from day before	Percent of doses given/doses received over previous 24 hours
January 22, 2021	39,892,400	1,932,400	19,841,721	1,392,433	72.06%
January 21, 2021	37,960,000	1,969,850	18,449,288	1,924,007	97.67%
January 20, 2021	35,990,150		16,525,281

The numbers above come from Bloomberg and Johns Hopkins. I assume the numbers provided lag by at least one day. If we get incomplete data over weekends or holidays, averages will be used.

It appears, for example, that about 2 million new doses are distributed to health facilities each day (column B).

It appears that in the last two days, "shootists/jabbers" gave fewer vaccinations than dosages received. For example, on January 21, 2021, 97.67% of newly received doses were administered (column E), meaning that the "supply on hand" actually increased slightly.

On January 22, 2021, only 72.06% of newly received doses were administered (column E), meaning that a significant number of newly distributed doses failed to actually make it into anyone's arms. The "supply on hand" should be increasing. If the "supply on hand" is not increasing, then the numbers are wrong, or there is wastage, spoilage, theft, or "who knows what."

I am unaware of a source for the amount of "supply on hand" provided to the media on a daily basis. One cannot determine (or even estimate) the "supply on hand" given the information above. 

For example, due to the size of the needles and syringes used and other variables, it is likely there is some wastage. For example, in a 10-dose vial, only nine doses might actually be obtained. This was discussed by public health officials and the media has reported that. That "lost" one dose per vial would simply be "lost." It happens. Moms who are given a ten-day supply of liquid antibiotic for their toddler know what I'm talking about. The 20-dose plastic bottle generally runs out before the 20th dose is given.

Disclaimer: I often make simple arithmetic errors. I am posting this for my benefit only. If this is important to you, go to the source. Don't quote me on any of my data. It's probably wrong, but it gives me an idea of what is going on.

By the way, to the best of my knowledge, I'm the first blogger to provide a spreadsheet of this sort. Right now, it doesn't provide much information, but my hunch is that thirty days from now, it's going to be very, very helpful or enlightening. These are the kind of spreadsheets that Dr Fauci is looking at. 

Hey, by the way, there's a story / article / report out there that a physician has been arrested for stealing nine doses of the vaccine. Now you know why it nine doses. It was a ten-dose vial from which one dose had been given. 

Number of people vaccinated, link here:

	A	B	C	D
	Total Doses Administered	Number of People Receiving 1 Or More Doses	Number of People Receiving 2 Doses	Number of People Considered Fully Immunized
Jan 22, 2021	19,107,959	16,243,093	2,756,953