I produce the map for locations where's there been coronavirus in the community, but that's really half the picture. For privacy reasons data on where the people with coronavirus are located is limited to local government areas. It would be much better if the data was provided to postcode or suburb area, but at the moment's that's not the case.
Using the local government area (LGA) we can get a very rough idea of how many cases there have been around us. The data provided by the government is total number of infections and active cases.
What I feel is important is the number of infections that have occurred over the last 14 days, but because that data isn't provided, we have to calculate the data ourselves. To make it easier to compare one area to another, we work out how many cases per hundred thousand people (CPHT).
Now we can easily see which areas are the hotspots and which areas have had little or no cases reported over the last 14 days as at the 20th of July 2020.
| Local Government Area | People | CPHT |
| Moonee Valley (C) | 130,294 | 213 |
| Melbourne (C) | 178,955 | 160 |
| Wyndham (C) | 270,487 | 149 |
| Hume (C) | 233,471 | 149 |
| Brimbank (C) | 209,523 | 145 |
| Yarra (C) | 101,495 | 119 |
| Maribyrnong (C) | 93,448 | 111 |
| Banyule (C) | 131,631 | 102 |
| Moreland (C) | 185,767 | 100 |
| Melton (C) | 164,895 | 84 |
| Whittlesea (C) | 230,238 | 73 |
| Hobsons Bay (C) | 97,751 | 73 |
| Colac-Otway (S) | 21,564 | 56 |
| Darebin (C) | 164,184 | 55 |
| Stonnington (C) | 117,768 | 33 |
| Manningham (C) | 127,573 | 31 |
| Port Phillip (C) | 115,601 | 30 |
| Whitehorse (C) | 178,739 | 29 |
| Mitchell (S) | 46,082 | 28 |
| Casey (C) | 353,872 | 26 |
| Greater Dandenong (C) | 168,201 | 24 |
| Boroondara (C) | 183,199 | 23 |
| Golden Plains (S) | 23,722 | 21 |
| Nillumbik (S) | 65,094 | 20 |
| Cardinia (S) | 112,159 | 20 |
| Monash (C) | 202,847 | 18 |
| Horsham (RC) | 19,921 | 15 |
| Loddon (S) | 7,504 | 13 |
| Kingston (C) (Vic.) | 165,782 | 13 |
| Bayside (C) | 106,862 | 13 |
| Glen Eira (C) | 156,511 | 11 |
| Glenelg (S) | 19,674 | 10 |
| South Gippsland (S) | 29,914 | 10 |
| Macedon Ranges (S) | 50,231 | 10 |
| Moorabool (S) | 35,049 | 9 |
| Knox (C) | 164,538 | 9 |
| Maroondah (C) | 118,558 | 8 |
| Frankston (C) | 142,643 | 8 |
| Ballarat (C) | 109,505 | 8 |
| Greater Geelong (C) | 258,934 | 6 |
| Baw Baw (S) | 53,396 | 6 |
| Bass Coast (S) | 36,320 | 6 |
| Mornington Peninsula (S) | 167,636 | 5 |
| Yarra Ranges (S) | 159,462 | 5 |
| Swan Hill (RC) | 20,649 | 5 |
| Latrobe (C) (Vic.) | 75,561 | 4 |
| Greater Bendigo (C) | 118,093 | 3 |
| Greater Shepparton (C) | 66,498 | 3 |
| Surf Coast (S) | 33,456 | 3 |
| Wellington (S) | 44,380 | 2 |
| Alpine (S) | 12,814 | 0 |
| Ararat (RC) | 11,845 | 0 |
| Benalla (RC) | 14,037 | 0 |
| Buloke (S) | 6,124 | 0 |
| Campaspe (S) | 37,622 | 0 |
| Central Goldfields (S) | 13,186 | 0 |
| Corangamite (S) | 16,020 | 0 |
| East Gippsland (S) | 47,316 | 0 |
| Gannawarra (S) | 10,472 | 0 |
| Hepburn (S) | 15,975 | 0 |
| Hindmarsh (S) | 5,588 | 0 |
| Indigo (S) | 16,701 | 0 |
| Mansfield (S) | 9,176 | 0 |
| Mildura (RC) | 55,777 | 0 |
| Moira (S) | 29,925 | 0 |
| Mount Alexander (S) | 19,754 | 0 |
| Moyne (S) | 16,953 | 0 |
| Murrindindi (S) | 14,570 | 0 |
| Northern Grampians (S) | 11,402 | 0 |
| Pyrenees (S) | 7,472 | 0 |
| Queenscliffe (B) | 2,940 | 0 |
| Southern Grampians (S) | 16,100 | 0 |
| Strathbogie (S) | 10,781 | 0 |
| Towong (S) | 6,040 | 0 |
| Wangaratta (RC) | 29,187 | 0 |
| Warrnambool (C) | 35,181 | 0 |
| West Wimmera (S) | 3,841 | 0 |
| Yarriambiack (S) | 6,639 | 0 |
| Wodonga (C) | 42,083 | -2 |
Analysing the data in this way does reveal that some regional local government areas have a higher number than would be desired since they are not locked down. A good thing to notice is there's also many local government areas that have no cases.
For me this data enables me to be aware of the risk whilst moving around in my own local area. I have to say, without knowing it the number of infections in my local area recently has grown quite a bit and that is a concern. A nudge to make sure I take the appropriate precautions.
Kelvin Eldridge
PS. For those eagle eyed amongst you, the result for Wodonga will most likely be because the figures were adjusted from an earlier period due to reassignment or duplication and hence the negative result.
No comments:
Post a Comment