Connect to GitHub to download data files

[nischalvadari]

I am trying to download data from GitHub to connect to Alteryx. I am trying to download CSV files from this github repository, but unable to, as I have never done this before. Can you please help me with this?

I would like to get the underlying CSV files with all data points. From what I noticed, https://github.com/owid/covid-19-data/tree/master/public/data is the actual repository and  https://github.com/owid/covid-19-data/find/master is where all the latest updated files are. 

I need help in understanding how I can download these files and create a copy of it for myself, or read from it directly. Whichever is feasible. I would also want my workflow to come back and find the latest updates and refresh data when there are new files available. 

[danilang]

Hi @nischalvadari 

The actual data behind the github formatted display is stored at https://raw.githubusercontent.com

For instance the data behind the Covid-2019 - ECDC (2020).csv page at 

https://github.com/owid/covid-19-data/blob/master/public/data/ecdc/COVID-2019%20-%20ECDC%20(2020).cs...

is stored at 

https://raw.githubusercontent.com/owid/covid-19-data/master/public/data/ecdc/COVID-2019%20-%20ECDC%2...

You can get the "raw" links by clicking on the View Raw link on the page

To learn how to download and parse the data, check out the solution to the post

Dan