Here is post #1 in a new thread explaining by sequential build up my crazily complex pinned chart. I know this is long overdue after all the views it has gathered!
First, that chart is possible since Larimer County, CO actually publishes both Covid cases and deaths by date **and age**. Please let me know if you have found this level of detail for any other county in the US — I haven’t so far.
Here’s what that base layer looks like for deaths (I have a mode where I can show cases as well but that becomes fairly overwhelming so I have mostly held that aside for now).
Pretty straightforward actually. The X axis is time from the spring 2020 start of Covid to current May 2022 and the Y axis is age. We will be overlaying some rates other than age on this as we build up as you can see by the complexity of the Y axis label over on the left but this base level of the chart is not hard to understand.
(Also note that the Y age scale is linear and zero based. Common modes of lying with charts include being non-zero based and inappropriate use of log scales just so you know...)
Note especially that there are **NO** Covid deaths to date below college age and oddly to some, the only deaths below 30 started occurring after the shots rolled out which will become more obvious as we progress.
The next thing we will add is to “heatmap” the deaths by month and 5 year age band. So the month and 5 year range with the most deaths will be close to solid red and those without any deaths will be left as white. This shading is also applied in a linear proportional manner.
This should also be quite intuitive to understand and gives you the ability to slightly squint your eyes and better recognize the pattern of what is happening.
I also put red highlight “corners” on months and age ranges that stand out. First, the odd “off season” “death stripe” in May 2021 and second, the youngest death in late Sep 2021 to make it stand out that at least in Larimer County, there have literally been ZERO Covid deaths in kids through high-school aged!
Finally, for those of you lacking patience, here’s a sneak peak of where we will progress to a little further along in this thread where the rubber begins to meet the road. This includes complicating the vertical Y axis by adding proportioned instantaneous yearly death rates per 10 deaths (red stepped “skylines”) and proportioned number of dose 1’s and 2’s administered daily (green line for dose 1 and filled green line for dose 2).
Stay tuned. And I will add a link to this thread from my pinned main chart post.
Share this post
Better Explaining That Chart #1
Share this post
Here is post #1 in a new thread explaining by sequential build up my crazily complex pinned chart. I know this is long overdue after all the views it has gathered!
First, that chart is possible since Larimer County, CO actually publishes both Covid cases and deaths by date **and age**. Please let me know if you have found this level of detail for any other county in the US — I haven’t so far.
Here’s what that base layer looks like for deaths (I have a mode where I can show cases as well but that becomes fairly overwhelming so I have mostly held that aside for now).
Pretty straightforward actually. The X axis is time from the spring 2020 start of Covid to current May 2022 and the Y axis is age. We will be overlaying some rates other than age on this as we build up as you can see by the complexity of the Y axis label over on the left but this base level of the chart is not hard to understand.
(Also note that the Y age scale is linear and zero based. Common modes of lying with charts include being non-zero based and inappropriate use of log scales just so you know...)
Note especially that there are **NO** Covid deaths to date below college age and oddly to some, the only deaths below 30 started occurring after the shots rolled out which will become more obvious as we progress.
The next thing we will add is to “heatmap” the deaths by month and 5 year age band. So the month and 5 year range with the most deaths will be close to solid red and those without any deaths will be left as white. This shading is also applied in a linear proportional manner.
This should also be quite intuitive to understand and gives you the ability to slightly squint your eyes and better recognize the pattern of what is happening.
I also put red highlight “corners” on months and age ranges that stand out. First, the odd “off season” “death stripe” in May 2021 and second, the youngest death in late Sep 2021 to make it stand out that at least in Larimer County, there have literally been ZERO Covid deaths in kids through high-school aged!
Finally, for those of you lacking patience, here’s a sneak peak of where we will progress to a little further along in this thread where the rubber begins to meet the road. This includes complicating the vertical Y axis by adding proportioned instantaneous yearly death rates per 10 deaths (red stepped “skylines”) and proportioned number of dose 1’s and 2’s administered daily (green line for dose 1 and filled green line for dose 2).
Stay tuned. And I will add a link to this thread from my pinned main chart post.