I made a simple dashboard over the weekend to monitor the Coronavirus situation.
It all started last friday and I learned a lot on this journey. First I started to mess with jq
to convert the CSV files in a more friendly format (JSON). Then I figured that D3.js
and Lodash
can parse CSV files and transform the data on the fly. π€―
Soon I had a beautiful and less stressful chart. π₯³
Let me know what you think. I will try to add a few features on the next hours/days.
Thank you!
Top comments (30)
The chart doesn't fit on my screen. It renders to large.
Also, it would be nice if we could:
country input
, I don't want to scroll. I just want to start typing.Thank you for your feedback! π The URL on my todo list and should rollout very soon.
Great work Pascal! The chart by country is really nice and I'd miss it in others dashboards.
Is it possible to inform the data when hovering the line? Also would be nice to improve the chart labels, it feels a bit confusing. But thats all from me, good job! :)
Thank you! Yes, I will add the tooltips on the chart very soon. π
How often is it being updated? Is it automatic, periodic, etc.? I've checked the stats for Lebanon and they're outdated.
I'd like to point out the same thing as @stephan Mejjer, the graph should be resizable as per the screen size.
Other than that, really neat job mate. gg
Thank you for the feedback. π The source is updated every 24h right now, they used to update it on a more regular basis but I think they are overloaded.
Fixed. π
the url slug still wrong
I can't change it :\
information outdated because it shows no recovery in Brazil. this country has already had 2 recoveries. the arcgis map shows 1 recovery and the bing map shows 2.
I know, the source has not updated since 20 hours now, sorry for this. I'm monitoring the update on the GitHub repo, if they don't push an update soon I will look for an alternative.
github.com/CSSEGISandData/COVID-19...
Not sure if it makes sense to plot the deaths and recovered on the same chart, since most (almost all the time they will be less than 1% or close to 0% of the confirmed cases)
I would put these on different charts, or at least have them toggle.
I would also add the number of new cases each day
Perhaps a toggle between linear and log scale.
Does it automatically update?
Otherwise good work so far. I am sure you learned a ton doing it
Also see:
arcgis.com/apps/opsdashboard/index...
from Johns Hopkins.
The data is fetched directly from them (the GitHub repo) to your browser.
github.com/CSSEGISandData/COVID-19
Gotcha. They already have a mobile-friendly view and graphs/maps. I thought you were doing something on your own.
Awesome!
nicely done.
I suggest you adding mouse over to show number on timeline
bl.ocks.org/larsenmtl/e3b8b7c2ca47...
Thank you! I will add this soon. π
Hey man, please drop a post when you find a regular and reliable data update source
I haven't looked over it too closely but ecdc.europa.eu seems like a pretty reliable source. They also seem to upload a file every day.
I made a little github repo that uses a github action to download and parse the xls file every day and publishes it as json for easier use.
The main source is updated every 24h right now. They seem a bit overloaded with the amount of work required to crawl the data and summerize it. There is more info here if you want to follow how the crew is doing. github.com/CSSEGISandData/COVID-19...