COVID-19 Vaccine Allocation

As the vaccine roll-out began, I found myself wanting more than the (very good) graphs tracking vaccinations on DC’s coronavirus website. In particular, I wanted to understand the flow of vaccine supply, especially while events like EAUs were happening in real-time. I threw some datasets into plotly & set up a very simple pipeline to poll the CDC’s API for new data every day. This Python-based flow used the infrastructure I had erected for the Cases + Deaths data, but I had a lot of success playing with something other than Observable.*

As new vaccines become available, I’ll be adding to this dataflow. Notice in particular the spike for J&J on Feb 28 that was followed by a week of no J&J doses (manufacturing ramp up?), and how Alaska and American Samoa get their vaccine allocations once a month.

If you’re on mobile, here’s another view of these charts.

First Dose Allocation of Vaccines By Geography

See the data used for yourself:

Pfizer

Moderna

Johnson & Johnson

These CDC source datasets are pulled into this graph daily via the Socrata API.

*My hot take is that plotly is much easier to use to whip up some straightforward charts, but Observable gives you all of the flexibility that plotly does not. The ability to manipulate anything in the chart or the data in d3 from user interactions is unmatched and extremely valuable (cf. the process for getting the state dropdown in plotly. In a word: clunky).