Pascal Meunier

Posted on Mar 16, 2020

A simple COVID-19 dashboard I made on the weekend

#webdev #javascript #showdev

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. 🥳

https://covid.ninja/

Let me know what you think. I will try to add a few features on the next hours/days.

Thank you!

Latest comments (30)

Deepak Bhaskaran • Apr 2 '20

I really liked your UI, here is a simple version that I built using Spring Boot covid-dashboard.herokuapp.com/

Alex Quasar • Mar 21 '20

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

23n6 • Mar 18 '20

Like!

ICreativeKid • Mar 17 '20

can u share the code please?

Pascal Meunier • Mar 17 '20

I will probably open source it, how would you contribute ? There is a lot to do right now. 🤓

Christophe El-Khoury • Mar 17 '20

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

Pascal Meunier • Mar 17 '20

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.

Ben Halpern • Mar 17 '20

Not a good looking graph for New York

Pascal Meunier • Mar 17 '20

Yeah, I had the idea to have the amount of new cases (not just the sum) so we might be able to actually see if it there is more new cases than yesterday. 🤔

Gabriel Azevedo • Mar 17 '20

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! :)

Pascal Meunier • Mar 17 '20

Thank you! Yes, I will add the tooltips on the chart very soon. 👍

Stephan Meijer • Mar 17 '20 • Edited

The chart doesn't fit on my screen. It renders to large.

Also, it would be nice if we could:

use the keyboard in the country input, I don't want to scroll. I just want to start typing.
compare the current country with another country or global (the world). Using a secondary axis, so that we can see how the development is doing comparing the world.
save the current form state in the URL, so we can use F5 to refresh and share the URL with friends

Pascal Meunier • Mar 17 '20

Thank you for your feedback! 👍 The URL on my todo list and should rollout very soon.

yokotobe • Mar 17 '20 • Edited

nicely done.
I suggest you adding mouse over to show number on timeline
bl.ocks.org/larsenmtl/e3b8b7c2ca47...

Pascal Meunier • Mar 17 '20

Thank you! I will add this soon. 👍

Seanmclem • Mar 17 '20

Recovered should maybe be a negative number? Otherwise it will only ever go up

Pascal Meunier • Mar 17 '20 • Edited

That's the point. The amount of recovered is already a negative number in how the stats are compiled. Let me know is it's still confusing, you might not be the only one.

Morobi • Mar 17 '20

Hey man, please drop a post when you find a regular and reliable data update source

Pascal Meunier • Mar 17 '20

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...

Tim Bachmann • Mar 17 '20

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.

Hacker Gaucho • Mar 16 '20 • Edited

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.

Pascal Meunier • Mar 16 '20

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...