Thread by @juliette_io

🧭Late-night NSW LGA monster wrap is back!👻

This one is proper late ... by 2 weeks!

To the loyal monster wrappers, pls forgive me 😭

It desperately needed improvements and automations (it was really manual)

Here's how it's improved ...

#covid19aus #COVID19Vic #COVID19nsw

1. I now think of NSW and VIC as 3 separate outbreaks each, so the wrap is built around that breakdown:

- High-growth regions / corridors
- Rest of metro
- Regional

Note, this means some of the 'LGAs of concern' have been separated into diff regions (e.g. Burwood > inner west)

2. 14-day change now included (%). I.e. the last 14 days compared with the previous (yes, small numbers might mean big % changes but still useful. Also, 0 cases in previous 14 days mean % change isn't possible. In this situation, there is a 👇 to see new cases below)

3. Previously, I used cases in NSW LHDs as a proxy for regions. I knew it wasn't perfect but recently realised how imperfect it is

Take Sydney LHD. >4000 cases in the last month. But > 3000 of them from Canterbury-Bankstown LGA

So new wrap has regions that better reflect LGAs

4. Unlinked cases removed for time being (there are so many they don't add a lot to reporting overall case numbers, right now)

Piecing this together was like passing a kidney stone. But I believed it would be worth it long-term and for the monster wrap lovers

So here goes -

1. NSW as 3 separate outbreaks

📈14-day change

Southwest / West: -13%
Rest of Greater Sydney: 71%
Regional NSW: 2%

🤧 Cases (Today = Last 14 days)

Southwest / West: +694 = 11,530
Rest of Greater Sydney: +364 = 4973
Regional NSW: +61 = 749

2. Regions - summary

📈14-day change

Western Sydney: -24%
Southwest Sydney: -1%
Northern Sydney: +31%
South Eastern Sydney: +76%
Sydney / Inner West: +39%
Central Coast: +204%
Illawarra Shoalhaven: +259%
Nepean Blue Mountains: +52%

Hunter New England: +216%
Mid North Coast: 0%
Northern NSW: n/a
Riverina / Murrumbidgee : n/a
Southern NSW: +176%
Western NSW: -58%
Far West: -1%

🤧 Cases (Today = Last 14 days)

Western Sydney: +257=4916
Southwest Sydney: +437=6614
Northern Sydney: +50=637
South Eastern Sydney: +115=1765
Sydney / Inner West: +90=1377
Central Coast: +37=319
Illawarra Shoalhaven: +64=0
Nepean Blue Mountains: +8=243

Hunter New England: +32=275
Mid North Coast: +1=6
Northern NSW: +1=3
Riverina / Murrumbidgee : +2=15
Southern NSW: +12=160
Western NSW: +8=209
Far West: +5=81

3. Southwest / West - LGAs

📈14-day change

📍 Western Sydney
Blacktown: -2%
Cumberland: -39%
Parramatta: -21%
Penrith: -21%

📍 Southwest Sydney
Camden: +29%
Campbelltown: +13%
Canterbury-Bankstown: -11%
Fairfield: -17%
Liverpool: +22%

🤧 Cases (Net today = Last 14 days)

📍 Western Syd
Blacktown: +105 = 1804
Cumberland: +68 = 1944
Parramatta: +32 = 476
Penrith: +51 = 690

📍 Southwest Syd
Camden: +14 = 324
Campbelltown: +45 = 640
Canterbury-Bankstown: +137 = 3015
Fairfield: +58 = 900
Liverpool: +97 = 1734

4. Rest of Greater Sydney - LGAs

📈14-day change

📍 Central Coast
Central Coast: 203%

📍 Illawarra Shoalhaven
Shellharbour: 315%
Shoalhaven: 200%
Wollongong: 227%

📍 Nepean Blue Mountains
Blue Mountains: -7%
Hawkesbury: 79%
Lithgow: 400%

📍 Northern Sydney
Hornsby: 69%
Hunters Hill: 158%
Ku-ring-gai: 100%
Lane Cove: 24%
Mosman: 100%
North Sydney: 38%
Northern Beaches: 71%
Ryde: -6%
The Hills Shire: 11%
Willoughby: 0%

📍 South Eastern Sydney
Bayside: 40%
Georges River: 40%
Randwick: 197%
Sutherland Shire: 69%

Waverley: 53%
Woollahra: 84%

📍 Sydney
Burwood: 63%
Canada Bay: 9%
Inner West: 2%
Strathfield: -4%
Sydney: 78%

🤧 Cases (Net today = Last 14 days)

📍 Central Coast
Central Coast: +31 = 318

📍 Illawarra Shoalhaven
Kiama: +2 = 20
Shellharbour: +12 = 191
Shoalhaven: +1 = 45
Wollongong: +50 = 376

📍 Nepean Blue Mountains
Blue Mountains: +3 = 50
Hawkesbury: +6 = 188
Lithgow: +3 = 5

📍 Northern Sydney
Hornsby: +2 = 98
Hunters Hill: +1 = 31
Ku-ring-gai: +14 = 32
Lane Cove: +2 = 21
Mosman: +0 = 10
North Sydney: +0 = 22
Northern Beaches: +12 = 130
Ryde: +7 = 112
The Hills Shire: +10 = 165
Willoughby: +1 = 16

📍 South Eastern Sydney
Bayside: +28 = 435
Georges River: +23 = 388
Randwick: +22 = 567
Sutherland Shire: +25 = 244
Waverley: +4 = 72
Woollahra: +4 = 57

📍 Sydney
Burwood: +0 = 57
Canada Bay: +4 = 109
Inner West: +15 = 235
Strathfield: +5 = 154
Sydney: +54 = 821

5. Regional NSW - LGAs

📈 14-day change

📍 Far West
Balranald: -100%
Broken Hill: 254%
Central Darling: -48%
Wentworth: -100%

📍 Hunter New England
Cessnock: 400%
Lake Macquarie: 405%
Maitland: 93%
Mid-Coast: 100%
Newcastle: 533%
Port Stephens: -25%

📍 Riverina/Murrumbidgee
Carrathool: -100%
Hilltops: 👇 (See new cases below)
Wagga Wagga: 👇

📍 Northern NSW
Lismore: 👇

📍 Southern NSW
Eurobodalla: 750%
Goulburn Mulwaree: 1400%
Queanbeyan-Palerang: -100%
Snowy Monaro: -26%
Upper Lachlan Shire: -80%

Wingecarribee: 42%
Wollondilly: 81%

📍 Western NSW
Bathurst: -26%
Blayney: -80%
Bogan: -100%
Bourke: -86%
Brewarrina: -100%
Cabonne: -100%
Dubbo: -62%
Forbes: -100%
Gilgandra: -100%
Mid-Western Regional: 167%
Narromine: -82%
Orange: -71%
Parkes: -100%
Walgett: 1200%
Warren: 200%

🤧 Cases (Net today = Last 14 days)

📍 Far West
Balranald: +0=0
Broken Hill: +6=46
Central Darling: +0=35
Wentworth: +0=0

📍 Hunter New England
Cessnock: +3=15
Glen Innes Severn: +0=2
Gunnedah: +0=1
Lake Macquarie: +26=101
Maitland: +1=27
Mid-Coast: +1=2
Muswellbrook: +2=1

Newcastle: +7=95
Port Stephens: +1=24
Singleton: +0=6
Tamworth Regional: +0=1
Upper Hunter Shire: -1=0

📍 Mid North Coast=
Coffs Harbour: +1=2
Kempsey: +0=2
Nambucca: +0=1
Walcha: +0=1

📍 Riverina / Murrumbidgee
Carrathool: +0=0
Hilltops: +2=12
Wagga Wagga: +2=2

📍 Northern NSW
Lismore: +0=2

📍 Southern NSW
Albury: +0=4
Bega Valley: +0=1
Eurobodalla: +0=17
Goulburn Mulwaree: +1=15
Snowy Monaro: +1=20
Upper Lachlan Shire: +0=1
Wingecarribee: +1=17
Wollondilly: +5=65
Yass Valley: -1=19

📍 Western NSW
Bathurst: +1=20
Blayney: +0=1
Bourke: +2=10
Dubbo: +3=130
Mid-Western Regional: +0=8
Narromine: +0=3
Orange: +0=6
Walgett: +0=26
Warren: +0=3

Finally, I just wanted to say thank you so much to the beautiful tweeps who checked in to see if I was ok during a period of radio silence. I did need a break but I didn't intend for it to be so long. I missed this community, feedback and ideas 💕