Page 1 of 2

COVID-19 Tracker (based on John Hopkins CSSE)

Posted: 10 Mar 2020 05:58
by Desmanto
COVID-19 Tracker (based on John Hopkins CSSE)

Prologue
I have created this flow since the end of January and use it until now. I see there are some apps trying to show the tracking data. I thought it might be useful for Automagic user, so you don't have to install separate app or open up browser just to know the latest statistic.

Download
COVID-19 Tracker : http://automagic4android.com/flow.php?i ... 07bf429ec7
Import the flow and create shortcut to the home screen for quick access.
COVID-19 Tracker.png
COVID-19 Tracker.png (226.16 KiB) Viewed 33649 times
Source Data
The data query from https://www.arcgis.com/apps/opsdashboar ... 7b48e9ecf6
Coronavirus COVID-19 Global Cases by the Center for Systems Science and Engineering (CSSE) at Johns Hopkins University (JHU)
If you want to view this in full information, you should open the link in browser

The main source of the json file is at
https://services1.arcgis.com/0MSEUqKaxR ... eHint=true
It is approximately 30-40 Kb, much faster than loading the whole website.
(if you want to find the json file yourself, use Chrome developer tools (F12), at the network tab, reload the tab, use search to find something like "Mainland China". You have a lot of json, use the one that show multiple countries. It takes a while to pick the good one.)

Explanation
The data has been sorted per confirmed case by descending order. I group the region to the country, so it only show the country total cases. This flow just show you the quick summary, which I think what most users need. (too much information can cause information overload).

Short Explanation :
Confirmed : Total confirmed cases from the lab test
Deaths : Total death
Recovered : Total recovery cases

Diagnosed : Number of death + recovered, means the case has been finished, not ongoing
Mortality : Number of death divided by total Confirmed cases, in percentage
Recovery : Number of recovered divided by total Confirmed cases, in percentage
Fatality : Different from Mortality, this is number of death divided by total Diagnosed (finished cases), in percentage.

In detail for each country, the same number, but with initial
C : Confirmed
D : Deaths
R : Recovered
Di : Diagnosed
M : Mortality
Rr : Recovery (rates)
F : Fatality

F number with value NaN means there is no death or recovered cases yet in that country.
Press Yes to copy to clipboard.

Extra Feature
I have another extra script at the end to prepare the speech output in Indonesian. I trigger it using my ticwatch. If you don't use it, you can remove it.

Default sort order from the json is based on highest confimed cases. If you need to sort based on Country names, uncomment the sort country section.

Epilogue
I create this to maintain quick updated summary of the COVID-19, so we can make our decision based on data. (to approximate the risk of travelling). I hope we don't need this flow for too long. I hopes everyone stay healthy and for the confirmed ones to recover soon.

Re: COVID-19 Tracker (based on John Hopkins CSSE)

Posted: 10 Mar 2020 10:14
by Yam
I love you.

Re: COVID-19 Tracker (based on John Hopkins CSSE)

Posted: 12 Mar 2020 16:57
by Horschte
Thanks for your effort.

But they seem to have adjusted their service. So no results anymore. :cry:

Re: COVID-19 Tracker (based on John Hopkins CSSE)

Posted: 12 Mar 2020 19:08
by Horschte
Working again. :D

Re: COVID-19 Tracker (based on John Hopkins CSSE)

Posted: 12 Mar 2020 19:26
by Desmanto
@Horschte : The sites is used by many others out there. There are apps, other website, script and many link to itt. So at times it can be down.

The list is getting longer as WHO already declared as pandemic. I think this will last another 3 months. Maybe I need to add more features, such as showing only total, top 5 countries, save 5 countries to be on watched, and maybe country specific link.

Re: COVID-19 Tracker (based on John Hopkins CSSE)

Posted: 17 Mar 2020 18:17
by gilanxcheetz
good work ! makasih

Re: COVID-19 Tracker (based on John Hopkins CSSE)

Posted: 18 Mar 2020 08:14
by erdiburak
Nice work thank you.

Re: COVID-19 Tracker (based on John Hopkins CSSE)

Posted: 26 Mar 2020 16:20
by Jumar
Thanks a lot.

I don't know if symbols in notifications are working on all devices, but this is how my customization looks like:

20200326_165130.jpg
notification screenshot
20200326_165130.jpg (238.74 KiB) Viewed 30974 times

Re: COVID-19 Tracker (based on John Hopkins CSSE)

Posted: 26 Mar 2020 17:37
by Desmanto
Wow, that's colorful. One way to easily identify the numbers. I prefer text based, as some users might be using it to share to other platform. But you are free to modify to your own needs.

Approx 2 weeks have passed, my v2 flow is almost finished. It has a lot of calculation and many more extra information. Actually have completed already yesterday, but I want to add the default watchlist region directly and do some more testing. I will share it maybe tomorrow or saturday.

Re: COVID-19 Tracker (based on John Hopkins CSSE)

Posted: 27 Mar 2020 18:07
by gilanxcheetz
wow, i'll download that v2 version. maybe i can learn more of your flows. :D