Covid Update: 29 September

Last week when I wrote my update on Covid-19, we had seen a few signs for optimism, but in other states the news was hard to interpret or, in the case of Pennsylvania, not going the right way at all. So where are we this week? In some ways, not a lot has changed over the last seven days.

New case curves for PA, NJ, DE, VA, & IL.

Last week, we had positive developments in both New Jersey and Illinois. There cases had begun to noticeably and consistently fall with clear peaks in this fourth wave of infections. Their seven-day averages were decidedly below their recent peaks. That trend continued last week. In fact, in Illinois the seven-day average is now also below the peak from not just this fourth wave, but also the third wave. That’s good.

New Jersey’s fourth wave was nowhere near as impactful as its first three. It helps to have one of the highest vaccination rates in the United States. But the Garden State’s seven-day average is also falling, though not as quickly as in Illinois. You could even make the argument that over the last week cases have really remained flat, though the last few days I would contend are evidence of a slow slowdown.

Delaware had been a tricky state to judge given some recent volatility in its average. But as we can see over the last week the new case curve clearly has flattened. The flat line, however, remains just that, a flat line. This is more of a plateau shape than a descending hill shape. That means that cases are continuing to spread, but at a steady rate of about 450 new cases per day. This isn’t uncommon, but hopefully it precedes a fall in new cases rather than serving as a respite on an ever upward climb.

In Virginia I had mentioned some early indications of a potential flattening, the first step towards a decline in the average. That flattening appears to be taking hold. In the chart above you can clearly see a sharp decline beginning to take root in Old Dominion. The curve here most closely resembles Illinois in what, at least for now, is a fairly symmetrical increase and decrease.

Finally we have Pennsylvania. I was pretty short in my analysis last week, the state was headed in the wrong direction. The latest data shows that the Commonwealth may just be beginning to turn the corner and flatten the curve. However, after the pre-Labour Day slowdown that then erupted into a full-blown outbreak, I’m wary of saying anything definitive about Pennsylvania. All we can do is hope that these early trends hold true.

So what about deaths? Are we seeing any progress on that front? Last week I noted that it was almost all bad news. In all but Illinois we had death rates continuing to climb.

Death curves for PA, NJ, DE, VA, & IL.

That story, sadly, remains largely the same. Illinois, unfortunately has actually seen its seven-day average resume ticking upwards, although not by a significant degree. It’s enough that I think it fair to say deaths have largely plateaued and not necessarily begun to climb. And as I keep saying, that would track for a state where we have seen new cases falling for the last few weeks now.

Unfortunately, that’s about it. Deaths in New Jersey have remained fairly stable, though the average has moved from 19.3 to 17.4 as of yesterday. Perhaps that could be an indication of a falling death rate. But just a few days ago it was still nearer 19 than 18. I would want to see more data showing a consistent and persistent decline before saying New Jersey is headed the right way.

And in Pennsylvania, Delaware, and Virginia, deaths are headed the wrong way, plain and simple. At the beginning of the sample set, Delaware reported 14 deaths in one day, the most in a month. Consequently the average has jumped from 2.6 last week to 3.4 today. In Virginia we had seen deaths jump from 20 to 34. Well this week they jumped again, though by half the amount, to 41 deaths per day. Pennsylvania performed the worst, however. Deaths here climbed from 43 to 57 per day.

While we have seen new cases plateau in Delaware and begin to fall in Virginia, which should mean declining death rates in a few weeks, in Pennsylvania the numbers of new cases may only be beginning to flatten. Consequently, unless we begin to see a sharp decline in new cases, we will likely continue to see rising deaths in the Commonwealth. At least for a little while longer.

Credit for the piece is mine.

Covid Update: 22 September

It’s been a little over a week now since my last update on Covid-19 in Pennsylvania, New Jersey, Delaware, Virginia, and Illinois. So where do we stand now, especially since last week we had seen a split with some good news and some not so good news?

Well let’s start with where we had good news last week: Illinois and New Jersey. In those two states we had the clearest evidence of the fourth wave peaking and beginning a slow descent.

New case curves for PA, NJ, DE, VA, & IL.

This week we can see that in Illinois the peak really does appear to have been reached as the seven-day average for new cases has been heading down slowly over the last week or so. In New Jersey we saw a sort of false peak, because new cases began to rise again not long after I posted. And with it the seven-day average did as well. However, in the last few days, the seven-day average has flattened ever so slightly, though it is still increasing.

Delaware is a bit harder to judge. When I last posted the seven-day average sat at 457 new cases per day. Yesterday? 454 new cases per day. If you look at the chart, you can see there was a brief spike that I had noted as a potential indicator of a peak for Delaware. After that brief decline however, you can see how the curve shot back up again, exceeding the earlier peak with an average of 470 new cases per day before cooling off slightly. New cases have been increasing for the last four days, but they are still below that 470 new cases number.

Virginia’s fourth wave long looked the worst. You can see some aberrant declines and spikes due to the extra day holiday in reporting—recall Virginia does not publish its weekend data. Since then however, there are some initial indications that Old Dominion may have peaked. Consider that when I last posted, the seven-day average sat at 4700 new cases per day. But over the last nine days, the average dropped to the 3600s for six days, then the 3500s for two days, and yesterday the average fell into the 3400s. That is the kind of flattening we want to see if there is a real peak.

Finally we have Pennsylvania. Right before Labour Day we had evidence of a slowing outbreak. But then after the holiday, new cases began to climb sharply. There was then a quick slowdown, but ever since we’ve continued to see rising numbers of new cases in the Commonwealth. At the time of my last post we had an average of 4100 new cases per day. Yesterday that was at 4700.

Pennsylvania looks like the only state we cover here that is clearly moving in the wrong direction.

But what about deaths?

Death curves for PA, NJ, DE, VA, & IL.

Well, here it’s almost all bad news. Before we can reasonably expect deaths to begin to slowdown, we need to see the spread of new cases slowdown. Remember that deaths are a lagging indicator as it can take weeks from infection to hospitalisation to death. And if most of our states have not yet clearly peaked, we shouldn’t really expect deaths to have peaked yet.

Here the only good news is Illinois where deaths peaked at 41 per day, but have since fallen to 31. Compare that to the shape of the curve in the new cases chart. We can clearly see the peak in new cases being followed by sometime by the peak in deaths.

In all the other states, however, we continue to see climbing numbers of deaths. In Pennsylvania over the last nine days we’ve seen the average climb from 24 deaths per day to 43. New Jersey increased a bit more slowly, from 13 to 19. And Delaware, again due to its small size, climbed, but only from 1.1 to 2.6. And in Virginia, we’ve seen the average number of deaths climb from 20 to 34.

If we are nearing peaks in New Jersey and Virginia, we should begin to see deaths cool down in the near future. The same holds true for Delaware, but there we have less evidence of a peaking outbreak.

Credit for the piece is mine.

Misleading Graphics Aren’t Limited to US Elections

Last week I wrote about how CBS News’ coverage of the California recall election featured a misleading graphic. In particular, the graphic created the appearance that the results were closer than they really were.

This week we had another election and, sadly, I find that I have to write the same sort of piece again. Except this time we are headed north of the border to Canada.

I was watching CBC coverage last night and I noticed early on that the vote share bar chart looked off given the data points. Next time it popped up I took a screenshot.

Look at the bars

First we need to note these are three-dimensional and the camera angle kept swinging around—not ideal for a fair comparison. This was the most straight-on angle I captured.

Second, at first glance, we have the Conservative share at a little more than 3/4 the Liberal vote share. That looks to be about right. Then you have the New Democratic Party (NDP) at roughly half the vote of the Conservatives. And the bar looks about half the height of the blue Conservative bar. Checks out. Then you have the People’s Party of Canada at roughly 1/4 the amount of NDP votes. But now look at the bar’s height. The purple bar is nearly the same height as the orange bar.

Clearly that is wrong and misleading.

The problem, I think, is that the designers artificially inflated the height of the bars to include the labels and data points for the bars. The designers should have dropped the labelling below the bars and let the bars only represent the data.

I created the following graphic to show how the chart should have looked.

And my take…

Here you can more clearly see how much greater the NDP victory was over the People’s Party. The labelling falls below the charts and doesn’t distort the height comparison between the bars. In some respects, it wasn’t even close. But the original graphic made it look else wise.

I just wish I knew what the designers were thinking. Why did they inflate the bars? Like with the CBS News graphic, I hope it wasn’t intentional. Rather, I hope it was some kind of mistake or even ignorance.

Credit for the original piece goes to the CBC graphics department.

Credit for the updated version is mine.

Correcting CBS News Charts

One of the long-running critiques of Fox News Channel’s on air graphics is that they often distort the truth. They choose questionable if not flat-out misleading baselines, scales, and adjust other elements to create differences where they don’t exist or smooth out problematic issues.

But yesterday a friend sent me a graphic that shows Fox News isn’t alone. This graphic came from CBS News and looked at the California recall election vote totals.

If you just look at the numbers, 66% and 34%, well we can see that 34 is almost half of 66. So why does the top bar look more like 2/3 of the length of the bottom? I don’t actually know the animus of the designer who created the graphic, but I hope it’s more ignorance or sloppiness than malice. I wonder if the designer simply said, 66%, well that means the top bar should be, like, two-thirds the length of the bottom.

The effect, however, makes the election seem far closer than it really was. For every yes vote, there were almost two no votes. And the above graphic does not capture that fact. And so my friend asked if I could make a graphic with the correct scale. And so I did.

One really doesn’t need a chart to compare the two numbers. And I touch on that with the last point, using two factettes to simply state the results. But let’s assume we need to make it sexy, sizzle, or flashy. Because I think every designer has heard that request.

A simple scale of 0 to 66 could work and we can see how that would differ from the original graphic. Or, if we use a scale of 0 to 100, we can see how the two bars relate to each other and to the scale of the total vote. That approach would also have allowed for a stacked bar chart as I made in the third option. The advantage there is that you can easily see the victor by who crosses the 50% line at the centre of the graphic.

Basically doing anything but what we saw in the original.

Credit for the original goes to the CBS News graphics department.

Credit for the correction is mine.

Covid Update: 13 September

It’s been a little less than a week since our last Covid-19 update for Pennsylvania, New Jersey, Delaware, Virginia, and Illinois. At the time we had just come back from the Labour Day holiday here in the United States and that left us with two big questions. First, what would the data show after we began to process the tests after the extra time off? Second, would the holiday itself cause any increase in the numbers of new cases?

We also need to remember that last week we had seen some positive signs in some states. And we can start with those states today.

New case curves for PA, NJ, DE, VA, & IL

In New Jersey and Illinois we had the clearest evidence of this fourth wave peaking and new cases, whilst still climbing, slowing down with the seven-day average beginning to fall. The good news continues to be that both states continue to show signs their fourth waves have peaked. In fact, Illinois appears to be beginning a downward trajectory. New Jersey has flattened the curve, in other words exhibiting steady numbers of new cases each day.

Delaware appeared to have peaked, but after a brief dip following the holiday, the numbers have begun to shoot back up again. The seven-day average as of yesterday hit 457 new cases per day, exceeding that spike just prior to Labour Day. In other words, it appears that the fear of the holiday increasing rates of new cases, just as they appeared to be peaking came true in Delaware.

What about Virginia and Pennsylvania? Well in the former we had some indications prior to Labour Day that Virginia may have been approaching a peak of new cases. And now you can throw that out the window. Over the three-day holiday weekend, Virginia added just under 11,000 new cases. This past weekend, only two days, Old Dominion added just over 9,200. Not surprisingly the seven-day average spiked upward yesterday to 4,700 new cases per day. If the fourth wave continues at that pace, it will soon surpass the rates we saw last winter.

And in Pennsylvania the data is also not great. We had seen perhaps the beginning of a decline after a peak prior to Labour Day. In the week since? Well, the numbers of new cases have started climbing once again. In fact, yesterday the seven-day average climbed to just under 4,100 new cases per day. That is still below the spring peak and well below winter, but surpasses the numbers we saw just before Labour Day.

In other words, the fear of Labour Day creating new cases appears to have come true.

So then what about deaths? We know that deaths from any increase in cases won’t manifest in the data for a few weeks.

Death curves for PA, NJ, DE, VA, & IL.

Starting with good news, let’s look at Pennsylvania. Two days after Labour Day the Commonwealth’s seven-day average for deaths reached 30.1 deaths per day. In the almost week since that rate has steadily dropped to 24.3 per day. Ideally we would want to see that trend extend beyond five days. Because if the Labour Day surge persists, it wouldn’t be beyond belief to imagine deaths rising again in coming days.

But that’s also about it for good news. True, Delaware went from 0.9 deaths per day to just 1.0. But that’s more of a stable rate than anything. All the other states have seen their death rates continue to climb of late. Although, we would also expect deaths to peak sometime after the peak in new cases, so this trend makes sense.

In New Jersey deaths climbed from 12.4 to 13.1 per day. Not terrible, but again still an increase in deaths. The worst increases were in Illinois and Virginia. In Illinois deaths have continued to climb, rising from 30.7 last time we wrote to 34.7. But Virginia has seen the worst, despite an apparent dip around Labour Day. Instead people are dying at increasing rates, climbing from 16.7 deaths per day to 27.1 as of yesterday.

Unfortunately, until we see new cases truly peak in Virginia those numbers are likely to continue climbing in coming days and possibly weeks.

Covid Update: 8 September

Last time we looked at the state of the Covid-19 pandemic in Pennsylvania, New Jersey, Delaware, Virginia, and Illinois we had some encouraging signs. In particular we had evidence of a potential slowdown in New Jersey, Delaware, and Illinois and I wrote that I would not be surprised if we saw a peak in new cases. Virginia was the only state where things were bad and getting worse, though the rate at which they were getting bad had begun to slow. Finally, Pennsylvania had some conflicting data with its new cases and I wanted to see another week’s worth of evidence.

So a week or later, where are we?

First, the obvious caveat that the Labour Day holiday may affect these numbers in both the short term collection of data and the medium term potential for a surge of new cases from gatherings and parties.

New case curves for PA, NJ, DE, VA, & IL.

If we look to last week’s good news states of New Jersey, Delaware, and Illinois, we do indeed see what we’ve long been waiting for since this summer: potential peaks in this fourth wave. New Jersey and Illinois. We can see the trend most clearly in New Jersey and Illinois where the beginnings of a decline from the peak appear as a slight dip from what we hope was the peak of the fourth wave. In Delaware that peak is still apparent, but the decline is less so.

Additionally for Delaware, over the last week the numbers rose above those of the third wave, i.e. in terms of cases the fourth wave is worse than the third wave of the spring. We had already seen Illinois reached that unfortunate milestone and fortunately for New Jersey the Garden State peaked at a point nearly half of the third wave’s peak.

What about last week’s bad news state? Well, Virginia, which does not report data on weekends, had an additional day of zero earlier this week. You can see that with the peak on Tuesday, which exceeded 10,000 new cases in one day. Of course, that’s really over three days and so we are talking about 3,000 per day. Unfortunately that extra holiday affected the seven-day average and caused a sudden fall. If we look closely at the data we can see that the trend probably points to a situation that continues to worsen. Two weeks ago the seven-day average was generally about 2800; last week it was about 3100; and heading into this week—excluding the Labour Day aberration—it looks to be about 3300. The very rough differences of 300 to 200 could point to a slowing rise in new cases, the necessary precursor to a peak, but we’d need to see how the rest of this week plays out before we can make any determination. But I’d probably say we are beginning to see the first signs of arriving at a peak in the coming weeks, maybe not next but perhaps in two or so.

And then we have Pennsylvania, where we had conflicting data and I wanted another week’s worth before making comment. I think the Commonwealth has indeed peaked, but unlike in New Jersey, Delaware, and Illinois, this peak looks more complicated. Note how we do have the recent spike I alluded to last week, but subsequent to that spike the numbers have been lower. I say complicated because in the aftermath of the holiday weekend we are seeing a slight tick upwards in the number of new cases, but it’s still below that spike. Consequently I’m reasonably confident we’ve just begun to peak here in Pennsylvania, but I’ll clearly want another week’s data before saying that with more authority.

What about deaths? How have those progressed over the last week?

Here too I’d be remiss if I failed to reiterate the caveats above that Labour Day can skew with the seven-day average—as we saw with Virginia—though any clustering of a surge of deaths would likely be weeks away given death’s status as a lagging indicator.

Death curves for PA, NJ, DE, VA, & IL.

Here, unfortunately, we have not reached peak deaths for the fourth wave, at least not for all five states.

Starting with the bad news, we have two states where the numbers continue to climb. In Pennsylvania and Illinois, the two largest states in the data set, we have deaths continuing to climb. Both states’ averages exceeded 30 deaths per day yesterday. For Pennsylvania that is the first time since early June. We need not go much further back for Illinois, which had last recorded an average of 30 deaths per day in late May.

In fact, Illinois yesterday reached an average of 30.7 deaths per day. The state’s peak during the third wave was not much higher, 31.7. Given that we are seeing higher numbers of new cases in the fourth wave than we saw in the third, I would expect the deaths to continue climbing and exceed the third wave’s death rate in coming days.

Pennsylvania’s seven-day average peaked at 51 deaths per day earlier this summer and the Commonwealth’s average of 30.1 yesterday is still far below that level. Given that this fourth wave appears to be less severe in terms of new cases than the third wave, I doubt we reach the level of 51 per day, but I wouldn’t put a level in the 40s out of reach.

Next we have three states where we probably have some good news. Delaware is probably the easiest to report. Since the state has so few people with which to begin, we can expect to see fewer deaths. Indeed, this fourth wave may have peaked and did so at only 3.4 deaths per day. But yesterday that number fell to 0.9. However, I wonder if that is due to the Labour Day holiday. I would want to see more data before saying with more authority that Delaware may have peaked in terms of deaths.

Virginia and New Jersey both present cases where the seven-day averages are now down from some high numbers about two weeks ago. In late August, New Jersey reached a level of 14.3 deaths per day and Virginia hit 21.4. Yesterday’s averages had each state at 12.4 and 16.6, respectively. That looks good. But we can also see that in the last two days both states reported their highest number of daily increases since the beginning of the fourth wave. Yesterday New Jersey reported an additional 29 deaths. Virginia reported 30 yesterday, not the highest, but for that we need look only to the day before when it reported 48.

In other words, I want to see if these recent high numbers of new deaths are the result of delays from Labour Day or if we are beginning to see an actual reversal in the trend. Both at this point appear plausible. I would suspect, however, that New Jersey, given its peaked number of new cases, is more likely to be on actual downward trend in deaths. That said, given the recentness of that peak, I would still expect deaths to rise. I want another week’s worth of data to better evaluate the Garden State.

Virginia seems pretty clear to me, the most likely cause in the dip in deaths of late relates to the holiday. With the numbers of new cases continuing to climb and a peak appearing to be at least a few weeks away, Virginia probably can expect deaths to resume climbing for a bit more time. And of course this wave is already worse, in terms of deaths, than the third wave. Unfortunately I think that story line will only get stronger.

Credit for the piece is mine.

Covid Update: 31 August

A brief bit of housekeeping, your author will be taking a brief holiday during which I won’t be posting. But I should return to posting next week.

Last week we looked at some relatively good news in terms of the spread of Covid-19 in the states of Pennsylvania, New Jersey, Delaware, Virginia, and Illinois. We had been watching some recent data that suggested some of the five states had begun to see a real and measurable slowdown in the rate of increase of new cases.

Where are we this week? Did those trends continue?

Kind of…

New case curves for PA, NJ, DE, VA, & IL.

Starting with the bad news, we have Virginia. Old Dominion is now in the throes of a Covid wave worse than what it saw back in the Spring, and fast nearing the heights—maybe depths—of the winter wave. That wave peaked just under 6,200 new cases per day. (And fell to as low as 129 per day in mid-June.) Presently Virginia reports just under 3,200 new cases per day, or nearly half that previous peak. Unfortunately, we do not yet see any significant decline in the rate at which those case numbers have increased. The line in the graphic above is no longer curving upwards, instead you can describe it as more a straight line.

Somewhere below Virginia in that it’s not bad news, but it’s also not great news, we have Delaware and Illinois. In both states the unfortunate news remains that new cases continue to increase. But at present we can also see that new cases have begun to slow. In these states the curves have begun to flatten out, though they still tilt positive.

Contrast that to New Jersey, where we have good news. The Garden State looks similar to Delaware and Illinois, but the difference is the curve in New Jersey may have peaked. The line is now tilted negative. Of course, this is a very recent development and we would want to see this trend continue for a week or so before we begin to speak of New Jersey’s wave cresting.

But between New Jersey, Delaware, and Illinois, I would not be surprised if by the end of next week we begin to see new cases peaking and beginning to decline.

But what about Pennsylvania? Initially I would have placed the Commonwealth with Delaware and Illinois as it clearly had not peaked, but it did exhibit evidence that its curve was beginning to flatten. In recent days, however, as one can clearly see in the chart, the average has begun to shoot back up again. But as I cautioned last week, that’s not uncommon. Consequently, I want to see another week’s worth of data before we begin to talk about what direction Pennsylvania is taking.

In all this though, we do have one wildcard. This weekend we in the United States begin our Labour Day holiday. Will Labour Day gatherings and parties lead to increased spread of the virus? Will we have super-spreader events? Unfortunately we will not know for about a week or week and a half after the holiday.

As all this has been happening, we also have the death rate.

Death curves for PA, NJ, DE, VA, & IL.

Last week I noted that we had begun to see rising numbers of deaths. This made sense given that deaths lag behind new cases. Early in the pandemic it often—not always—took a few weeks before people needed hospitalisation. Then a few weeks later is often—not always—when people would die. So a few weeks after the fourth wave began to take hold we continue to see rising numbers of deaths in all five states.

In Virginia and Illinois we see two of the most significant increases. In fact in the third wave, Illinois peaked at just under an average of 32 deaths per day. As of Tuesday the seven-day average was at just over 25. And with the current trend pointing towards increasing death, it’s possible we could see the fourth wave be more lethal in Illinois than the third.

Compare that to Virginia. Old Dominion saw a smaller death rate in the third wave, peaking at 18 deaths per day. However, just yesterday the state reached an average of 21 deaths per day. In other words, Virginia’s fourth wave has become more lethal than its third wave. Unfortunately, like in Illinois we continue to see deaths climbing and there is no evidence yet that deaths are slowing down.

In the tri-state area we see some slightly better news by comparison. In Pennsylvania and New Jersey deaths remain below their third wave peak. For example, in the third wave, Pennsylvania peaked at nearly 50 deaths per day. Yesterday the average was just below 20. Despite both states being below their third wave peaks, however, deaths do continue to climb.

Delaware is the exception here. With such a small population, it reached a third wave peak of about two deaths per day. At present it’s just reached three. But I would not say that three is significantly greater than two.

Overall, however, I expect to see deaths continue to climb over the next week or two until these slowing rates of new cases begin to create slowing death rates. And so I am hopeful that in the coming few weeks we will begin to see the new case rates slow, peak, and begin to decline by about mid-September. That’s more likely in places like New Jersey, Delaware, and Illinois, but if we’re lucky those patterns or similar will soon begin to emerge in Pennsylvania and Virginia.

Credit for the piece is mine.

Big Beer

A few weeks back, a good friend of mine sent me this graphic from Statista that detailed the global beer industry. It showed how many of the world’s biggest brands are, in fact, owned by just a few of the biggest companies. This isn’t exactly news to either my friend or me, because we both worked in market research in our past lives, but I wanted to talk about this particular chart.

Not included, your home brew

At first glance we have a tree map, where the area of each “squarified” shape represents, usually, the share of the total. In this case, the share of global beer production in millions of hectolitres. Nothing too crazy there.

Next, colour often will represent another variable, for market share you might often see greens or blues to red that represent the recent historical growth or forecast future growth of that particular brand, company, or market. Here, however, is where the chart begins to breakdown. Colour does not appear to encode any meaningful data. It could have been used to encode data about region of origin for the parent company. Imagine blue represented European companies, red Asian, and yellow American. We would still have a similarly coloured map, sans purple and green,

But we also need to look at the data the chart communicates. We have the production in hectolitres, or the shape of the rectangle. But what about that little rectangle in the lower right corner? Is that supposed to be a different measurement or is it merely a label? Because if it’s a label, we need to compare it to the circles in the upper right. Those are labels, but they change in size whereas the rectangles change only in order to fit the number.

And what about those circles? They represent the share of total beer production. In other words the squares represent the number of hectolitres produced and the circles represent the share of hectolitres produced. Two sides of the same coin. Because we can plot this as a simple scatter plot and see that we’re really just looking at the same data.

Not the most interesting scatter plot I’ve ever seen…

We can see that there’s a pretty apparent connection between the volume of beer produced and the share of volume produced—as one would (hopefully) expect. The chart doesn’t really tell us too much other than that there are really three tiers in the Big Six of Breweries. AB Inbev is in own top tier and Heineken is a second separate tier. But Carlsberg and China Resources Snow Breweries are very competitive and then just behind them are Molson Coors and Tsingtao. But those could all be grouped into a third tier.

Another way to look at this would be to disaggregate the scatter plot into two separate bar charts.

And now to the bars…

You can see the pattern in terms of the shapes of the bars and the resulting three tiers is broadly the same. You can also see how we don’t need colour to differentiate between any of these breweries, nor does the original graphic. We could layer on additional data and information, but the original designers opted not to do that.

But I find that the big glaring miss is that the article makes the point despite the boom in craft beer in recent years, American craft beer is still a very small fraction of global beer production. The text cites a figure that isn’t included in the graphic, probably because they come from two different sources. But if we could do a bit more research we could probably fit American craft breweries into the data set and we’d get a resultant chart like this.

A better bar…

This more clearly makes the point that American craft beer is a fraction of global beer production. But it still isn’t a great chart, because it’s looking at global beer production. Instead, I would want to be able to see the share of craft brewery production in the United States.

How has that changed over the last decade? How dominant are these six big beer companies in the American market? Has that share been falling or rising? Has it been stable?

Well, I went to the original source and pulled down the data table for the Top 40 brewers. I took the Top 15 in beer production, all above 1% share in 2020, and then plotted that against the change in their beer production from 2019 to 2020. I added a benchmark of global beer production—down nearly 5% in the pandemic year—and then coloured the dots by the region of origin. (San Miguel might not seem to fit in Asia by name, but it’s from the Philippines.)

Now I can use a good bar.

What mine does not do, because I couldn’t find a good (and convenient) source is what top brands belong to which parent companies. That’s probably buried in a report somewhere. But whilst market share data and analysis used to be my job, as I alluded to in the opening, it is no longer and I’ve got to get (virtually) to my day job.

Credit to the original goes to Felix Richter.

Credit for my take goes to me.

Covid Update: 23 August

Last week I mentioned how there was some initial evidence showing the rapid, near-exponential spread of the virus was beginning to slow down. One week later, where are we?

The good news is that those initial signals do appear to be true, i.e. not noise. You can see it if you look at the very end of the charts for all but Virginia.

New case curves for PA, NJ, DE, VA, & IL.

We can see the slowing spread rate most easily in Illinois and New Jersey. The shape of the curve now resembles more like the top of a hill rather than the beginning of a roller coaster. To be clear, this doesn’t mean Covid-19 is no longer spread—that is not the case at all. Rather, just the speed at which people are spreading the virus has slowed from that initial rapid acceleration.

In the last week, however, despite the good news for Illinois, we can also see that this fourth wave, driven by the Delta variant, has now exceeded the third wave we saw earlier this spring. Virginia still remains the only other state joining Illinois in that auspicious category, but Delaware is edging ever closer.

However, Delaware as well as Pennsylvania can both join Illinois and New Jersey in seeing slowing rates, though it’s not nearly as evident as in the other two states. Delaware continues to approach its third wave peak.

Virginia is the one state where we might just now be seeing the beginning of a slowdown. Though it’s probably the hardest state in which to see it. Yesterday, after a weekend of no data updates, the state reported over 7,000 new cases. That’s bad. But jumping from 5,900 new cases last Monday to yesterday’s 7,100 is comparatively good. Compare Monday to Monday, four weeks ago the increase was 91%. Three weeks ago it was 88.8%. Three weeks ago it fell to 30.9%. And then two weeks ago it was 26.8%. Yesterday’s increase was only 20%. Again, not great, but that’s a slowdown.

The hope in all five states is that we can begin to actually peak perhaps in early- to mid-September before the seven-day average begins to decline. The question then will be what do things look like as begin to head into flu season, which is when last winter’s deadly surge began in earnest.

What about deaths though?

Death curves for PA, NJ, DE, VA, & IL.

Last week I discussed how we were seeing death rates hold fairly steady with only small increases to the seven-day averages. Unfortunately this past week we saw more significant increases. Nothing too dramatic, to be clear, but increases all the same.

Take Pennsylvania, for example. Two weeks ago we went from an average of 7 deaths per day due to Covid-19 to just 9 last week. But yesterday that number jumped up to 16. Illinois, which had went from 12 to 13, climbed from 13 to 20 as of yesterday.

This is also not terribly surprising. As we are now several weeks into this wave, we would expect to see hospitalisations increase, which we had been seeing, before, sadly, deaths followed suit. We may now be entering that phase where deaths, again, a lagging indicator, begin to rise.

I do not think, however, that we will see numbers near to the extremes we saw this past winter. Even to reach levels we saw this past spring will be difficult. However, I’d be remiss if I didn’t point out that Illinois has reached nearly half its third wave peak number of deaths.

We will need to continue observing these death rates over the coming week to see if they continue to increase. I suspect they will before, like new cases, they begin to slow down before then peaking.

Credit for the piece is mine.

Rarely Shady in Philadelphia

After a rainy weekend in Philadelphia thanks to Hurricane Henri, we are bracing for another heat wave during the middle of this week. Of course when you swelter in the summer, you seek out shade. But as a recent article in the Philadelphia Inquirer pointed out, not all neighbourhoods have the same levels of tree cover, or canopy.

From a graphics standpoint, the article includes a really nice scatter plot that explores the relationship between coverage and median household income. It shows that income correlates best with lack of shade rather than race. But I want to focus on a screenshot of another set of graphics earlier on in the article.

On the other hand, pollen.

I enjoyed this graphic in particular. It starts with a “simple” map of tree coverage in Philadelphia and then overlays city zip codes atop that. Two zip codes in particular receive highlights with bolder and larger type.

Those two zip codes, presumably the minimum and maximum or otherwise broadly representative, then receive call outs directly below. Each includes an enlarged map and then the data points for tree cover, median income, and then Black/Latino percentage of the population.

I don’t think the median income needs to be in bar chart form here, especially given the bars do not line up so that you can easily compare the zip codes. The numbers would work well enough as factettes or perhaps a small dot plot with the zip codes highlighted could work instead.

Additionally, the data labels would be particularly redundant if a small scale were used instead. That would work especially well if the median income were moved to the lowest place in the table and the share charts were consolidated in one graphic. Conceptually, though, I enjoy the deep dive into those two zip codes.

Then I wanted to highlight some great design work on the maps. Note how in particular for Chestnut Hill, 19118, the outline of the zip code is largely in a thicker, black stroke than the rest of the map. At the upper right, however, you have two important roads that define the area and the black stroke breaks at those points so the roads can be clearly and well labelled. The other map does the same thing for two roads, but their breaks are shorter as the roads run perpendicular to the border.

Overall this was just a great piece to read and I thoroughly enjoyed the graphics.

Credit for the piece goes to John Duchneskie.