This time last year, the race to create a COVID-19 vaccine began. Many experts, including Dr. Anthony Fauci, the Director of The National Institute of Allergy and Infectious Diseases (NIAID), predicted it would take around 18 months to develop. Bill Gates agreed in a piece written last April, and remarked that it could take as little as 9 months or as long as two years. Since development of a vaccine usually takes around 5 years these estimates would be ‘the fastest scientists have created a new vaccine’ by quite a margin.
As of this month, a total of 13 vaccines have been authorized by at least one national regulatory authority for public use representing a historic achievement. Likewise, over 800 million doses of the COVID‑19 vaccine have been administered worldwide, based on official reports from national health agencies, since vaccination began in December 2020. In the US close to 50% of the adult population have received at least one dose with nearly 80 million Americans fully vaccinated.
Of course all eyes are focused not only on the performance of the vaccines themselves but also on their effective rollout to ensure we can return to a degree of normality as quickly as possible. Having the ability to quickly analyze vaccination data can give important insights to the general public, governments, policy makers, pharma companies, health professionals, and broader business communities (retail, travel, public services etc.). As an example, visualizing where and how the rollout is progressing can be used as an important indicator for relaxation of strict confinement measures.
A number of COVID vaccine trackers already exist, ranging from simple graphs to choropleth maps but we wanted to present an alternative representation by providing the first visualization of the progression at an individual level within the US.
Taking inspiration from Ryan McCullough’s excellent map visualizing big census data we built an app able to dynamically represent the vaccination status of each citizen and give the ability to project how the rollout is likely to progress.
Want to view vaccination progress in your area?Click to launch the app
Within this dynamic app it will be possible to track the continuing progression of this historic vaccination effort with a goal to reaching herd immunity and ensuring the country is able to return to a degree of normality.
This visualization has been achieved using the CDC vaccination data. We have used both data by state and by county since coverage data at the county level appears artificially low. Therefore for higher zoom levels of the map we present the data aggregated at state level.
In addition, we have incorporated socio demographic population data from the 2018 American Community Survey, expressed at the block group level.
Want to learn more about how the app was made?Check out the full story
By combining these data sources and performing dasymetric analysis it is possible to calculate a percentage of individuals vaccinated per block group. By leveraging our BigQuery Spatial Extension, random points are generated and filled within the cells with the correct proportional amount marked as vaccinated. BigQuery Tiler is then used to create a TileSet with CARTO for React employed to create the map and visualization app. We will follow up in a future post detailing in depth how our core technologies were used in the creation of this app.
This spatial application provides a unique way of visualizing the speed and efficacy of the vaccine rollout across the US. Insights derived from this type of analysis can be invaluable for citizen visibility, guiding vaccine distribution, and wider health authority policy decision-making.
Want to enhance the geospatial capabilities of BigQuery?Check out the new CARTO Spatial Extension for BigQuery
Today at the Spatial Data Science Conference in New York City we announced CARTO Workflows, an exciting new tool that enables users of all types and skill levels to harness...Use Cases
Please fill out the below form and we'll be in touch real soon.