Together with Snowflake, Starschema, a leading data services and technology company, has been packaging and sharing data related to the pandemic to help inform better decision-making worldwide. The Starschema team created a robust COVID-19 epidemiological data set and made it available, for free, to thousands of companies via Snowflake Data Marketplace.
The data set has served as a single source of truth for COVID-19 incidence and mortality data throughout the pandemic, helping organisations build contingency plans and make more-informed decisions in response to the global health crisis. To date, hundreds of businesses and public sector bodies have leveraged the data in Snowflake Data Marketplace. Capital One, for example, uses Starschema’s data to forecast and plan response scenarios for its workforce and customers.
“It’s impressive what data allows us to do in a crisis, and especially for the COVID-19 crisis. We’re running what is probably the largest vaccination campaign in the world, and the data allows us to see, in near-real time and at a granular level, which areas are most affected, which areas are short on vaccine, which areas need to be resupplied and which areas need specific help.” says Chris von Csefalvay, VP of Special Projects, Starschema. “Our goal is to easily share data of the highest quality and granularity possible. Snowflake helps us achieve this goal with the power of its Data Marketplace and technology.”
The vaccination datasets aggregated by Starschema in Snowflake Data Marketplace are in addition to the previous COVID-19 data already shared in 2020 by Starschema, also at no cost through Snowflake Data Marketplace, to allow public and private authorities to follow the evolution of the pandemic.
Snowflake Data Marketplace is powered by Snowflake’s platform allowing public and private authorities to securely access live, governed, shared data sets and receive automatic updates to that data in real time. It’s the backbone that’s enabled Starschema to deliver COVID-19 and vaccination data easily and efficiently. Organisations can connect to Snowflake Data Marketplace from their Snowflake account for seamless integration of the immunisation dataset and initiate rapid query processing.
In building these datasets, Starschema aggregates, normalises, and integrates data from many sources, such as Our World in Data, JHU, hospitals, pharmacists, states, and WHO via the Data Cloud and then shares it through the Data Marketplace.
Starchema’s datasets are easily accessible from Snowflake Data Marketplace and SQL queries detailed in a dedicated blog post. It is also possible to build your own interfaces based on a combination of Snowflake, Tableau, Grafana and Kubernetes as detailed in this blog.
Summing up the initiative, Chris von Csefalvay stated: “good things happen when people share data, and few things confirm this more than this project.”