This repository contains the data and preprocessing used for visualizing the Coronavirus pandemic using Flourish.

A collection of visualizations is available as a Flourish Story here

These visualizations were created for a data visualization course on the Data Science (BSc) programme at the IT University of Copenhagen.

The source data is stored in a Google Sheet updating daily from a GitHub repository maintained by the by the Johns Hopkins University Center for Systems Science and Engineering.

Simple data processing such as pivot tables aggregating data on a country-level is done in an Excel workbook available in CoronavirusTrendsMaster.xlsx.
For now, data is updated manually in the Excel workbook.

Finally, additional data preprocessing is performed using the Python script corona_data.py.
The Python script outputs a series of CSV files used for Rosling charts as well as visualizations of daily trends following a certain threshold, e.g. infection growth following the 50th confirmed infection.

For future work, the entire data pipeline both should and could be automated.

Bar chart animating daily number of confirmed infections:

Line chart race animating the infection counts following the 50th confirmed infection:

Rosling chart showing infection growth relative to total number of confirmed infections:

Johns Hopkins CSSE: https://github.com/CSSEGISandData/COVID-19]
Flourish Studio: https://flourish.studio/