COVID-19 | Data Sources

[LeahK]

Starting a thread to consolidate various data sources shared across the community. Please reply to share any useful and reliable COVID-19 related data sources or dashboards, and we'll update the post!

Data Sources

• Johns Hopkins University COVID-19 Github: https://github.com/CSSEGISandData/COVID-19 (shared by @DavidW)
• New York Times COVID-19 US County Data: https://www.nytimes.com/article/coronavirus-county-data-us.html (shared by Ned Harding)

Blog Articles

shared by @Ken_Black 

• How to Predict the 1,000,000th confirmed Coronavirus Case  -  Ken Black
• A Tale of Two Maps - Ned Harding

Shared by @klpenney_Raytheon 

• https://informationisbeautiful.net/visualizations/covid-19-coronavirus-infographic-datapack/

• https://docs.google.com/spreadsheets/d/1g_YxmDfQx7aOU2DKzNZo9b-NTk62Bju6X3z6OuCa6gw/edit#gid=5156844...

• https://www.worldometers.info/coronavirus/

• https://raw.githubusercontent.com/AdmitHub/us-zcta-counties/master/zip_state_county.json

Dashboards

• https://coronavirus.1point3acres.com/en (shared by @Abeavan)
• https://co.vid19.sg/dashboard (shared by @Abeavan)

[Abeavan]

Here are some good links for data sources:

1- https://coronavirus.1point3acres.com/en

2- https://co.vid19.sg/dashboard

3- https://github.com/CSSEGISandData/COVID-19

I'm interested to see how we can use this data (Specially from the first source)  to compare  outcome from predicted vs actual and how to identify if there are any countries or states in US that are close to 'flattening the curve'. 

[klpenney_Raytheon]

Resources

https://informationisbeautiful.net/visualizations/covid-19-coronavirus-infographic-datapack/

https://docs.google.com/spreadsheets/d/1g_YxmDfQx7aOU2DKzNZo9b-NTk62Bju6X3z6OuCa6gw/edit#gid=5156844...

https://www.worldometers.info/coronavirus/

https://github.com/CSSEGISandData/COVID-19/tree/master/csse_covid_19_data/csse_covid_19_daily_report...

https://github.com/CSSEGISandData/COVID-19/tree/2033baa5196ce81dab845eb97335cc10de754d4b/csse_covid_...

https://raw.githubusercontent.com/AdmitHub/us-zcta-counties/master/zip_state_county.json

[Abeavan]

Here's few more data sets and Viz...

NextStrain (Bioinformatics)

https://nextstrain.org/ncov 

https://github.com/nextstrain/ncov

CDC:

https://www.cdc.gov/coronavirus/2019-ncov/cases-updates/cases-in-us.html

https://www.cdc.gov/coronavirus/2019-ncov/cases-updates/testing-in-us.html

WHO:

https://worldhealthorg-my.sharepoint.com/personal/garnicacarrenoj_who_int/_layouts/15/onedrive.aspx?

id=%2Fpersonal%2Fgarnicacarrenoj%5Fwho%5Fint%2FDocuments%2FCOVID%2D19%2DDatabase%2DFiles&originalPat...

JHU:

https://github.com/CSSEGISandData/COVID-19

[Ken_Black]

Blog Articles:

How to Predict the 1,000,000th confirmed Coronavirus Case  -  Ken Black

A Tale of Two Maps - Ned Harding

[LeahK]

Thanks for sharing @Ken_Black !  I was ecstatic to see Ned sharing his perspective on the data on his blog. It made me sooooo happy!

For those who don't know, Ned Harding is one of the Alteryx founders -- he's legit. Definitely check out the articles Ken shared. Both from Ned and Ken himself, ACE extraordinaire!

[DanHare]

Hello everybody, and thanks to @Ken_Black and @Ned for sharing the posts - legends on the case !

I wonder if anyone has used Alteryx to connect to the https://closedloop.ai/c19index/ open source model for identifying "At Risk" patients based on customer static data ?  ( we won't have the Medicare claims data being outside US)

Python isn't my strong point, but I'm all over Alteryx 😃

Thanks in advance !

[JohnJPS]

Wow, what a tremendous wealth of curated links here - thank you, @LeahK! Inspired by@Ned's work, I created a viz that shows spread over time where the coloration (by county) is based on percentage of population of said county. I wanted to do that since all the charts I ever see just draw absolute numbers, not per capita. It's quite rudimentary as I (gratefully) still have the day job keeping me busy, (and my guitars have really been bugging me to be played lately too, haha). If anybody wanted to improve upon it, the code is here: https://github.com/johnjps111/covid19?files=1

[JohnJPS]

Yet another repository: https://github.com/starschema/COVID-19-data

[javila]

This set of dashboards (click into the Spotfire app link) by Tibco is pretty fantastic, definitely among the best I've seen: https://www.tibco.com/covid19

And this covid state tracker is pretty interesting too: https://public.tableau.com/profile/jeremyblaney#!/vizhome/COVIDStateTracker/COVIDStateTracker

One question - anybody have any thoughts as to where to find county level testing data? 

Update: Still doing some validation but I may have just answered my own question, check this out: https://coronadatascraper.com/#home