1st Apr 2020

Analysing COVID-19 Flights in Australia with Python.

by Eric Jiang <eric@ericjiang.dev>

As you all may have been aware over the past few months, the COVID-19 Coronavirus outbreak started spreading all over the world and into Australia. I’ve been tracking the Australian cases as it started to slowly climb the exponential curve, with most of the cases being imported (and still is) and now central way of keeping track of it. I decided to build a tool which captures this data source from various government websites.

The entire script is automated with Python, and runs every two hours. So the script automatically crawls through various Department of Health websites across the various states (cause this is reported by the states not the Federal Government) and collects certain data points, for example: the Airline, Flight Number, Origin, Destination and Close Contact Rows, Arrival Date.

Then the symptom onset date is calculated by adding 2 weeks onto the arrival date, this is the standard as defined by both the World Health Organisation (WHO) and the Australian Federal Department of Health.

After the data is collated and wrangled with a simple GitHub Action script, it commits it to the Frontend/Backend Repository to be served over Google App Engine. One of the more complex tasks is finding all the edge cases of how to parse the dates, airline – cause this is all manually updated by humans (Humans, smh. Am i right?) and is really error prone.

One of the things I love to do especially is making information more readable and organise it in a way so that people can read it and access it via one single location or source of truth.

You can try the app at https://covid19-flights.ericjiang.dev

Enjoyed the post? You might want to read similar posts:

Static Site Deployments with Webhooks

Previously on my personal website, the blog content, after converting it back to Static Site Pages, I figured out that you can use webhooks to trigger rebuilds. As both Vercel (the hosting provider) and Prismic (the headless CMS provider) have support for webhooks. To do this, we are going to try and trigger a build on the creation and deletion of blog-posts documents.

Read Article

Published on 29 Oct 2020

October 2020 Site Upgrades

Something happened to my blog but you can't really tell if you visit the frontend of my blog! I migrated all my blog posts over to Prismic as a Headless CMS solution, after finding that I prefer writing my blog content over on a rich text editor and also having to roll out a change to my preview and main branches on my repository (github.com/ericjiang97/nextjs-personal) especially with blog posts.

Read Article

Published on 24 Oct 2020

Supercharging your development environment on Visual Studio Code

Like many developers out there, Visual Studio Code (VSCode) is now my go to editor for almost everything (with the exception for Android Studio (for Android) and IntelliJ IDEA (for Java)). I really like customising my VSCode, so that it is easier for me to develop on.

Read Article

Published on 23 Oct 2020

Like what you read? You may want to subscribe to my newsletter

I also occassionally write on my newsletter, so please subscribe below.

Powered by Buttondown

Copyright © Eric Jiang 2016 - 2021

Powered by Vercel & Prismic. Built in NextJS with Bumbag

Find the code on GitHub

Encoutering issues? Submit an issue