Reference:
Data on Australian Vaccinations from covidlive.com.au. This is the source for Australian numbers presented in Our World In Data. Unfortunately concise government sources are not available, so there is a significant citizen data science effort to collate these figures in a consistent way.
Data on Australian Population from abs.gov.au. Summarised population is unsuitable as their bands of age ranges do not align with the "Adult = 16+" definition used by Health Departments. So the method used is to get the most detailed time series spreadsheets, e.g. "Population - Victoria". Each column represents a single year age, by Gender. The columns for "Persons" Gender are selected. "Adult" is derived by summing the columns for ages 16+ (note: split across 2 sheets). The latest row available (dated June 2020) is selected.
Following the visualisation design of Marta Fioni, as featured on the UK government "equivalent" dashboard - we can dream...
Summary
This project seeks to boil down the many figures on vaccinations into an easily digested infographic. I've been looking for inspiration on this for quite a while - the key questions in my mind are:
- How many people are protected?
- How many to go?
The "waffle chart" visual chosen by Andrew presents the vaccination data, standardised by the population of various Geographies. Geographies of wildly differing populations (e.g. New South Wales vs Tasmania) can be easily compared.
The data is presented in an interactive data visualisation tool: Power BI. This allows interactive filtering of the data (e.g. by Geography or Date), and includes supporting charts and data tables.
The dataviz is refreshed automatically, roughly every 2 hours during the daytime (AEST GMT+10).
DataViz with State/Territory updates, source code here:
https://github.com/Mike-Honey/covid-19-au-vaccinations#readme
eyJrIjoiMDNjZDY3YzEtMmM3OC00YWVkLTlmODUtNmRlMTM2YTJmMTg5IiwidCI6ImRjMWYwNGY1LWMxZTUtNDQyOS1hODEyLTU3OTNiZTQ1YmY5ZCIsImMiOjEwfQ%3D%3D
