DEV Community

loading...
Cover image for Impact of COVID-19 on people's habits worldwide

Impact of COVID-19 on people's habits worldwide

Igor Lukanin
Developer relations 🥑 and data analytics 📊 Speaker, cinephile, space exploration enthusiast 👨‍🚀
・2 min read

TL;DR. I've built a web application that reveals the impact of the COVID-19 pandemic on people's lives and habits. Also, I tell how I built it.

Here's how this application looks like:

Alt Text

Surely, you can select any country — definitely try your own. You will explore how COVID-19 affected social mobility or how "stay at home" requirements were followed (or not).

Insights

Let's take Israel. You can clearly see three waves and the positive effect of "stay at home" requirements — after they are introduced, every wave spreads with lesser speed.

Alt Text

Let's take Germany. You can see how Germans interact with the rules: after the first "stay at home" requirements are lifted, park activity grows, and after the second "stay at home" requirements are introduced, parks instantly become deserted.

Alt Text

Let's take Singapore. Obviously enough, you can see Singapore doing a great job containing the virus. The third wave is nearly unexistent.

Alt Text

Tutorial

You can build this application from scratch using BigQuery public datasets, JavaScript, React, and Cube.js. Read on:

Also, don't hesitate to share your insights in the comments 🙏

Discussion (5)

Collapse
patarapolw profile image
Pacharapol Withayasakpunt • Edited

Why everything is 0 or 0%?

Collapse
igorlukanin profile image
Igor Lukanin Author

Oops! I've fixed it. Could you check again, please? 🙏

Everything was 0 or 0% because some zero values were appended to the public datasets. It doesn't make much sense since the number of confirmed cases cannot drop down instantly. I worked around that by skipping a few days on the rightmost part of the timeline.

Collapse
patarapolw profile image
Pacharapol Withayasakpunt • Edited

You forgot to smooth the curve.

43%

I think it matters a lot when the graph isn't interactive.

Thread Thread
igorlukanin profile image
Igor Lukanin Author

Could you please elaborate on smoothing? The ups and downs that you see on the charts are not some glitches, they are actual changes due to people's weekly activity patterns. Anyway, thank you for the feedback :)

Thread Thread
patarapolw profile image
Pacharapol Withayasakpunt

An idea is last 7 days' average.