General

Discuss a wide range of topics! Questions about the Alteryx Platform should be directed to the appropriate Product discussion forum.

Johns Hopkins University COVID-19 daily data workflow

Highlighted
12 - Quasar

In the theme of additional sources, google has made the johns Hopkins CSSE dataset available via their bigquery platform.

 

I haven't thoroughly checked the accuracy, given how many changes the CSSE dataset has gone through regarding schema, but it's google so I trust them?

 

Obviously accessing via alteryx is as simple as using the big query input tool, or python!

 

Highlighted
7 - Meteor

There's been a lot of great ideas and discussion on here, thanks a lot for everyone's help! I've attached a workflow that uses the GeoJSON API that powers the Johns Hopkins COVID-19 dashboard. This should help in getting data more periodically throughout the day rather than at the end of the day when the csv files are posted to JHU's GitHub page. Here is the link on ESRI's site for more info on the data:

 

https://coronavirus-resources.esri.com/datasets/628578697fb24d8ea4c32fa0c5ae1843_0?geometry=13.259%2...

 

Thank you and be safe!

 

-Kevin Raj

Highlighted
5 - Atom

@LukeM 

 

I am getting the following error:

 

Error: Designer x64: The Designer x64 reported: Error running Event #1: The external program "gitpull.bat" returned an error code: 1: The system could not find the environment option that was entered. (203)

 

Is this because I've already run the git pull today?  The .bat itself will execute outside of Alteryx.

Highlighted
5 - Atom

David,

 

I downloaded your original workflow and I think it processed all the files in the daily reports directory, but I have just revisited it and it seems to only process up to the end of March.  Do you have a later version?

Highlighted
7 - Meteor

Hello Chriscuk - I had noticed some small tune up that might be required, I have seen for instance some column headers that may be affecting when you run but at the end I included a version based on David's that I am currently using to load my own dahsboard. Please take a look to the attached one, I just used it to load till April 12 Data that is the latest available Data file.

Highlighted
7 - Meteor

I missed the workflow, sorry.

Highlighted
5 - Atom

Thank you. I will give it a go. 

Highlighted
8 - Asteroid

Hi David, 

 

This workflow is wonderful!  I used it yesterday for the first time and worked well.  I used the latest daily reports from JHU which included all reports up to 5/7/2020, but when the flow ran, I only had up to 3/22/2020.  I went through the flow, but was unable to determine why.  

 

Any ideas?

 

Many thanks for this!

 

Bruce. 

Highlighted
7 - Meteor

Thanks for sharing, while analyzing the flow, does this only include US country? I could not handles to see a global overview but US only.

Highlighted
7 - Meteor

Hi - have you tried to use the Workflow I shared in this same previous post:  Daily_Import2.yxmd

I have been using it, I remember I had some issues while getting all of the files Data but I have made some adjustments to it and should be working okay now.

 Thanks

 
 
 
 
 
 
 
 
 
 
 
Sergio