So how to create above chart? Apparently it’s very simple. What you need are:

1. COVID-19 Data

   One of the best source of COVID-19 data is provided by Center for Systems Science and Engineering (CSSE) at Johns Hopkins University. You can clone their data from HERE. Use master branch. Open .\csse_covid_19_data\csse_covid_19_time_series\time_series_covid19_confirmed_global.csv

2. Basic Excel skills

   Since I’m only interested with the countries nearby to Indonesia. I need to filter out most countries and consolidate multiple rows into one (Australia has more than one rows as their data is at State/Province level). The last thing I need to do is to format the time-series header.

   So what I did is converting from this CSV:

   

   into this:

   

3. Flourish account

   Sign-up to Flourish using your Google account. Upload the CSV produced in step 2. You should have something like this:
   

   We then need to configure the columns:

   

   And that’s it. All left is to tweak the appearance, how fast the animation, etc. There are many options to explore. I’ll let you explore that on your own.

   

That’s all folks. I hope it helps. Cheers!

Incoming Search

covid, data, indonesia, singapore