Skip to content

Projects to explore detailed outbreak paths. Mostly dataviz using Power BI

License

Notifications You must be signed in to change notification settings

Mike-Honey/covid-19-outbreak-paths

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

covid-19-outbreak-paths

Projects to explore detailed outbreak paths. Mostly dataviz using Power BI


Australia - Outbreaks by Area

For NSW & VIC, analyses PCR and RAT reported cases down to LGA level, with derived metrics like Reff and Cases per 100K. Data is published weekly on Fridays.

For QLD, analyses RAT reported cases and tests down to LGA level, with added derived metrics like % Positive and Tests per 100K. Data is published on Wednesdays.

If you are dissappointed by the data provided by your state or jurisdiction, please contact your elected representatives and let them know.

Charts of Metrics by Area - State, Region and Local Government Area (LGA)

State, Region and Local Government Area (LGA) are available as options for presentation.

Column and stacked column charts are available on adjacent pages.

Link to interactive DataViz

Click to view and interact with the report

Map by LGA

Link to interactive DataViz

Click to view and interact with the report

Bubble Chart of Cases per 100k population vs Reff by LGA

Link to interactive DataViz

Click to view and interact with the report

Charts of Metrics by Age Group

Column and stacked column charts are available on adjacent pages.

Link to interactive DataViz

Click to view and interact with the report

Many other report pages are available, just click on one of the links above, then use the page navigation control at bottom-centre: < 1 of 15 >. Clicking the centre of that control will show a menu of pages.


New South Wales by Area

This report will not be updated after April 2023. Refer to the Australia report above for the the latest info.

NSW - Map of Case and Test metrics by LGA

Link to interactive DataViz

Click to view and interact with the report


Victoria by Area

This report will not be updated after April 2023. Refer to the Australia report above for the the latest info.

VIC - Map of Case metrics by LGA

Link to interactive DataViz

Click to view and interact with the report


Victoria: August 2021

Link to interactive DataViz

Click to view and interact with the report

Preview animation: https://youtu.be/aRyP7bmoBoc

Click to view an animated preview of the report


Queensland: July 2021

Link to interactive DataViz

Click to view and interact with the report

Preview animation: https://youtu.be/KLGz4zk6pbM

Click to view an animated preview of the report


Victoria: July 2021

Link to interactive DataViz

Click to view and interact with the report

Preview animation: https://youtu.be/eNPYLosZhvI

Click to view an animated preview of the report


South Australia: July 2021

Link to interactive DataViz

Click to view and interact with the report

Preview animation: https://youtu.be/kcwz9ZupVyU

Click to view an animated preview of the report


New South Wales: June 2021

Link to interactive DataViz

Click to view and interact with the report

Preview animation: https://youtu.be/84jbzh94jJ0

Click to view an animated preview of the report


Queensland: June 2021

Link to interactive DataViz

Click to view and interact with the report

Preview animation: YouTube: https://youtu.be/SMQNCCahJrg

[Click to view an animated preview of the report](YouTube: https://youtu.be/SMQNCCahJrg)


Northern Territory: June 2021

Link to interactive DataViz

Click to view and interact with the report

Preview animation: https://youtu.be/iXiemDw6L4A

Click to view an animated preview of the report


Victoria: May-June 2021

Link to interactive DataViz

Click to view and interact with the report

Preview animation: https://youtu.be/PTgq2XbJ83Q

Click to view an animated preview of the report


Summary

The "Australia Outbreak" report has the following features:

Data sources for older reports

Case-level data on:

  • Victoria outbreak during July 2021
  • Queensland / Northern Territory outbreak during June 2021
  • Victoria outbreak during May-June 2021

dbRaevn has manually constructed diagrams of the outbreak paths, based on information from daily press cases.

For the New South Wales June-July 2021 outbreak, manually constructed diagrams are not available after 7 July. So I have used the NSW COVID-19 cases by location dataset. Each day's new cases are arbitrarily linked to prior cases in the same local health district.

This project turns that information into structured data and feeds it through an interactive dataviz solution, using Power BI with the Drill Down Graph PRO Custom Visual by ZoomCharts. The interactive features allow the audience to filter the dataset by date, cluster or variant.

For this project, the manual diagram info is converted into a structured data table (Excel). Each row represents a transmission link between cases. The codes used for each node on the manual diagram are used as Source and Target nodes to drive the diagram visual. Cases with an unknown source are loaded with the same code for Source and Target. The dataviz tool used requires unique codes for each node, so suffixes have been added where the manual diagram codes were not unique. Once the initial dataset is established, ongoing updates are relatively simple.

Another sheet in the Excel file provides the colours assigned to each node by date. The preferred colours scheme is a steady gradient of purple. The colour scheme used on the manual diagram is also presented on an alternate page, for those who prefer that scheme.

Several dataviz variations are presented on alternate pages - use the page navigation controls at the bottom to view them. They explore different layout options and colour schemes, and some alternative visuals. The Drill Down Graph PRO Custom Visual by ZoomCharts is the preferred visual, and the kind folks at ZoomCharts have supported this project.

Here's how the animations are produced :

  1. screen capture using Windows 10 Game bar (Start-G)
  2. trim video using Windows 10 Photos app - aim for 1 second or less "paused" at the start and 2 at the end
  3. crop to focus on the animated part of the screen using https://www.freeconvert.com/crop-video. Save as mp4 (for twitter, youtube)
  4. convert to gif using https://ezgif.com/video-to-gif (for github)

THIS REPORT IS NOT HEALTH ADVICE - REFER TO YOUR LOCAL HEALTH AUTHORITY.

🤝 Support

Contributions, issues, feature requests and sponsorship are all welcome!

Give a ⭐️ if you like this project!

About

Projects to explore detailed outbreak paths. Mostly dataviz using Power BI

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Sponsor this project

 

Packages

No packages published

Languages