COVID-19 – Page 6 – Coffee Spoons

The Covid Recession’s Continuing Impact on Youth

Earlier this week, some of the work work my team does was published. We produced a one-page summary of a far larger and more comprehensive (relative to the scope of the summary) survey of consumers during the Covid Recession. I will spare you the details of recreating existing templates from scratch and the design decisions that went into that bit—neither insignificant nor unsubstantial—and rather focus on the one graphic we designed.

The broad thrust of the summary is that while overall we are beginning to see some job recovery, that the recovery is uneven and that, in fact, those below the age of 36 are getting hit pretty hard (my words, not the authors). That while in some industries the young are recovering in good numbers, in other industries, industries with a larger share of the youth population, young people are still losing jobs. Then we broke those top line numbers out by industries in the below graphic captured by screenshot.

How different age groups in different industries are faring in the recession.

There are a couple of things from a design side to discuss. We had about two or three days from when we started the project to develop some ideas and then execute and produce the summary. And as I noted above, that also included quite a bit of time in emulating existing documents and building ourselves a new template should we need to do something similar in the future.

But for that graphic in particular, there’s one thing I wanted to highlight: the lack of values on the axis. The challenge here was that the data displayed is people not working. And when we compared this time period (Wave 3) to the earlier waves, we were looking for declines. And so if we going to say that 36+ are gaining construction jobs, that would be -2% value and the youth are about a -13% increase. If you are doing a bit of a double-take at a negative increase, so did the team. Ultimately, we used the data to generate the chart, but then opted for qualitative labelling on the axes. They simply point that in one direction, youth are either gaining or losing jobs, and the same for the 36+. To reinforce this idea, we also added some descriptors in the far corner of each quadrant that said whether the age groups were gaining or losing jobs.

Despite the unusual design decisions I took in the graphic, I’m really proud of this piece especially given its tight turnaround. It shows in almost real-time how fractured the recovery—is this a recovery?—is at this point.

Credit for the piece goes to the team on this, Tom Akana, Kate Gamble, Natalie Spingler, and myself.

Covid-19 Update

As I mentioned last week, I am going to try using my blog here for the weekly update on the five states people have asked me to explore. And for the second week in a row, we are basically seeing numbers down compared to previous days. But given that numbers are generally lower on the weekends, that is not terribly surprising.

The real question is by Friday, will these numbers have rebounded?

The Covid-19 curves for PA, NJ, DE, VA, and IL

The Covid-19 death curves for PA, NJ, DE, VA, and IL.

Credit for these graphics is mine.

What Will the Next Recovery Look Like?

Earlier this morning, the Bureau of Economic Analysis released its US 2nd quarter GDP figures and the news…isn’t great. On an annualised basis, we saw -32.9% growth. That’s pretty bad. Like Great Depression level bad. I’ve posted on the social media how bad this current recession is and how nobody in the workforce today worked or didn’t through the Great Depression to really relate to the numbers we are seeing.

But that’s all today. The sun will come out tomorrow. (And scorch the Earth as climate change renders certain parts of the globe uninhabitable to mankind. But we’ll get to those posts in later weeks.) And when it does come out, eventually, what will the recovery look like? I’ve seen a few mentions recently in the media of a V-shaped recovery. What is this mysterious V-shape?

A long time ago, in a galaxy far away. Or during the last recession in Chicago, I worked with some really smart people in some of my professional projects and we covered the exact same question. There are a couple key “shapes” to an economic recovery. And when we say recovery, we mean just to return to pre-recession peak levels of growth. Anything above that is an expansion. That’s what we want to get back to.

What kind of shape will the recovery take? — Who knew typographers loved economics?

The V-shape we hear a lot about is a sharp recovery after the economy bottoms out (the trough). Broadly speaking, if a recession has to last two consecutive quarters (it doesn’t, but that’s a pretty common definition so let’s stick with it), then in a V-shape, we are talking about a recovery one or two quarters later.

Similar to the V is the W-shape, where things start to improve rapidly, but some kind of shock to the economic system and things go back negative once again before finally picking up quickly. It’s not hard to imagine something going horribly wrong with the Covid-19 pandemic to be just that external shock that could push the economy back down again.

Similar still is the U-shape. Here, after hitting rock bottom, growth isn’t quite as quick to pick up as we linger in the depths of the valley of recession. But after a bit of time, we again see a rapid recovery to pre-recession levels of growth.

These are all pretty short term recoveries, the W being a little bit longer because two sharp downturns. But they are nothing compared to what’s also possible.

First we have the L-shape. Here, after hitting bottom, things start to recover quickly. But that recovery is slow and takes a long time. Growth remains slower than average, creeping up to average, and then still takes its time to reach pre-recession levels. Is something like this possible? Well, if vaccines fail and if some countries still can’t get their act together (cough, US, cough), the willingness of consumers to go out, eat, drink, buy things, travel, and generally make merry could be suppressed for a long time. So it’s certainly not out of the question.

And then lastly we have the UUUU-shape. Though you could probably add or subtract a U or two. This features more drawn out stays at the bottom of the valley with quick and sharp upticks in growth. But those growths, never reaching pre-recession levels, also collapse quickly back into declines, though also never really reaching the same depths as earlier. Essentially, the recovery faces multiple setbacks knocking the economy back down as it sputters to life. As with the L-shape, it’s also not hard to imagine a world where a country hasn’t managed to contain its outbreak struggling to get back on its feet.

What do you think? Are we at rock bottom? Did I miss a recovery type?

Credit for the graphic is mine.

Sunday’s Covid Numbers

I do not want this blog to become a permanent Covid-19 data site. So in my push to resume posting last week, I tried to keep to from posting the numbers and instead focused on discussing how the data is displayed.

But I hear from quite a few people via comments, DMs, emails, and text messages that they find the graphics I produce helpful. So on the blog, I’m going to try posting just one set of graphics per week. Will it always be Monday? I don’t know. On the one hand, new week, new data. But on the other, weekend numbers tend to be lower than the rest of the week and could make it seem like, yay, the numbers are starting to go down especially if you only come to my blog and only see this data once a week.

Daily cases and their rolling average for Pennsylvania, New Jersey, Delaware, Virginia, and Illinois — Daily new cases

Daily new deaths and their rolling average for Pennsylvania, New Jersey, Delaware, Virginia, and Illinois. — Daily new deaths

So yeah, we’ll see how this goes. And I’ll try to keep Tuesday–Friday to discussing the world of data visualisation, although in these days, a good chunk of it will likely revolve around Covid.

Credit for these graphics is mine.

Wednesday’s Covid-19 Data

Here we have the data from Wednesday for Covid-19.

Pennsylvania saw continued spread of the virus. Notably, Monroe County in eastern Pennsylvania passed 1000 cases. It was one of the state’s earliest hotspots. That appears to have been because it was advertised as a corona respite for people from New York, not too far to the east and by then in the grips of their own outbreak.

New Jersey grimly passed 5000 deaths Wednesday. And it is on track to pass 100,000 total cases likely Friday or Saturday. Almost 2/3 of these cases are located in North Jersey, with some South Jersey counties still reporting just a few hundred cases and a handful of deaths.

Delaware passed 3000 cases and Kent Co. passed 500. While those don’t read like large numbers, keep in mind the relatively small population of the state.

Virginia has restarted reporting deaths, this time at the county level and not the health district level. What we see is deaths being reported all over the eastern third of the state from DC through Richmond down to Virginia Beach. In the interior counties we are beginning to see the first deaths appear. And in western counties, we still see that the virus has yet to reach some locations, but counties are beginning to report their first cases.

Illinois continues to suffer greatly in the Chicago area, and at levels that dwarf the remainder of the state. However, the downstate counties are beginning to see spikes of their own. Macon and Jefferson Counties each saw increases of 30–40 cases in just 24 hours.

Preview(opens in a new tab)

A longer-term look at the states shows how the states diverge in their outbreaks. Pennsylvania looks like it might be forcing the curve downward whereas New Jersey appears to have more plateaued. Earlier I expressed concern about Virginia, which does now appear to have not peaked and continues to see an increasing rate of spread. Then we have Illinois, which may have plateaued, but we need to see if yesterday’s record amount of new cases was a blip or an inflection point. And in Delaware a missing day of records makes it tricker to see what exactly the trend is.

Credit for the piece is mine.

Comparing Covid-19 to Influenza

I want to share a small graphic I made yesterday evening. And I am being charitable with the term graphic. Really it is nothing more than a collection of organised factettes. But I have seen the footage of those protesting the lockdowns in various states, including Pennsylvania.

To be clear, people can have different policy prescriptions to solve the pandemic. For example, the governor of Pennsylvania is considering lifting the lockdown piecemeal once the state overall has sufficient testing and tracing capabilities. Look at the state.

He rightly said that Cameron County, one of the little light purple shapes in the upper left, with its one case for the last 25 days is in a different situation than Philadelphia where cases continue to grow, albeit at a slowing rate. And in the future it is possible that Cameron County could open before Philadelphia. That is a different policy prescription than, say, opening the state all at once.

I don’t think most people enjoy lockdown—I haven’t left my building in 38 days and I cannot wait to leave and go do something. But I recognise that spreading outside these walls we have a deadly pandemic for which we have no vaccine. But then I see people protesting—protesting in a manner that contradicts the guidelines put out by the health officials—and claiming that we should open up because this is nothing worse than the flu.

Well, Covid-19 is not the flu. It is much worse.

This isn't your grandmother's flu. Or anyone else's flu. Because this isn't the flu. — This isn’t your grandmother’s flu. Or anyone else’s flu. Because this isn’t the flu.

Now, those numbers will change because the pandemic is ongoing. But, let’s spitball. Let’s assume those numbers hold. The idea of the shutdowns, lockdowns, and quarantines is to prevent the spread of the virus. For the sake of this thought experiment, let’s just assume, however, that it infects 56 million people, the upper end of the range for this most recent influenza season.

Influenza this year killed as many as 62,000 people after infecting 56 million. Hypothetically, with a mortality rate of 5%, Covid-19 would kill 2,800,000 people.

With a 4% rate that drops to 2,240,000

With a 3% rate that drops to 1,680,000

With a 2% rate that drops to 1,120,000

With a a 1% rate that drops to 560,000

With a 0.5% rate that drops to 280,000

And even at 0.5% that is still far greater than the flu. And so that is why it is so important to keep the number of people infected as low as possible. (And I won’t even get into the surge problems overwhelming hospitals that acts as a force multiplier and is the proximate reason for the lockdowns.)

This is not the flu.

Credit for the piece is mine.

Covid-19 Data from Monday

Monday’s Covid-19 data for Pennsylvania, New Jersey, Delaware, Virginia, and Illinois provided a glimmer of good news, most notably in Pennsylvania. That, however, occurred on the same day as a protest in Harrisburg that could set the state back days if not weeks. More on that below.

Pennsylvania saw fewer than 1000 new cases for the first time since 1 April. The curve here may be doing more than flattening, but it might actually be falling. That is to say the infection rate is decreasing rather than stabilising and holding steady, as it appears to be doing in New Jersey. That said, new cases are appearing sporadically in the rural and less dense areas of the state. Problematically, protestors arrived in Harrisburg to let it be known they are unhappy with the quarantine. Because the rest of us are.

The problem is that it appears a significant percentage of those infected with the virus are asymptomatic carrier, i.e. they are sick, but do not show any symptoms like fever, coughing, difficulty breathing. Critically, they may not appear sick, but they can spread the sickness. And so a gathering of several hundred people in close quarters? Not ideal.

Compare that to a Christian cultish church in Daegu, South Korea. There, an infected parishioner did not heed government calls to isolate and instead attended a church service. The average infected person spreads this virus to two or three people. This congregant? They infected 43 people who then went on to infect other people.

It is quite possible that someone in that Harrisburg protest was an asymptomatic carrier. And given the lack of social distancing, the lack of masks, and the general reckless behaviour, it is quite possible that the rally could be a super-spreading event. But we won’t know for 5–10 days, the apparent incubation period of the virus. Hopefully we dodge the proverbial bullet. But it is quite easy to see how these kinds of protests could lead to surges in infections. And those surges would then force the government to extend its quarantine by weeks thereby defeating the entire point of the protestors.

We get it. Quarantine sucks. But we all have to suck it up.

Moving on to New Jersey, where we see continuing evidence of the plateauing of cases. The bulk of the cases remain in the north in the New York suburban counties with the fewest numbers in the counties in South Jersey. However, averages of nearly 3500 new cases daily remains quite high and the death toll of 4377 is likely to continue to climb higher, even if Monday’s 175 new deaths was lower than most days in recent weeks.

Delaware is back to reporting its figures. And in that release, we had Sussex County in the south climb above 1000 total cases. The levels or curves chart at the end will also show how the state might be flattening and stabilising its infection rate, but we will need several days of uninterrupted reporting to make that determination.

Virginia might be worrying. Or it might not be. Cases continue to increase in the big metropolitan counties like Fairfax and Henrico. But, there are still several counties out in the west that remain unaffected. And the curves chart at the end shows how there has not yet been any sort of even a near-exponential growth curve. Instead we just see a steady, slow increase in the number of cases. That in its own way makes it more difficult to see when the curve flattens, because it was already a relatively flat curve.

Illinois continues to be the tale of two states: Chicago vs. everywhere else. The combined Chicago and Cook County have over 20,000 total cases and the surrounding counties add a few thousand more, which gets you over 2/3 of the state’s 31,000 cases. That said, new cases and new fatalities are beginning to pop up in downstate counties.

Lastly a look at the curves. As I noted above when talking about Pennsylvania, you can clearly see the downward slope of the state’s new cases curve. Compare that to the plateau-like shape of New Jersey. Delaware and Illinois might be approaching a New Jersey-like curves. But I would want to see more data and in Delaware less volatility. But like I said, Virginia is a tricky one to read.

Credit for the pieces is mine.

Sunday’s Covid-19 Data

Here is a look at the data from Sunday’s releases on the COVID-19 outbreak in Pennsylvania, New Jersey, Virginia, and Illinois. I’ve omitted Delaware because they paused reporting on Sunday to move to a noontime release instead of their previous end-of-day.

I’m not exactly certain what that means for the data on Delaware and reporting time series. But, my guess is that will be more like a hole in the time series. I need to spend some time looking at that. But, anyways, on to the states for which we did have data on Sunday.

Pennsylvania continues to see growth in cases, but as we’ll get to with the levels, that appears to at least be stabilising. But in the spread of the outbreak, we are beginning to see the T of the state, that more rural and less densely populated area, beginning to fill in with cases. These are of course the areas of concern, the areas with shuttered rural hospitals, lack of comparatively developed infrastructure, where the impacts could be proportionately more severe than in the bigger cities. In terms of deaths, they have now spread almost across the state from east to west. I am still waiting until two adjacent counties connect before I make that final pronouncement.

For New Jersey, I have removed the orange outlines around each county. The initial idea was to show where deaths had occurred. But now that they have been reported in every county, they don’t seem to be as helpful as the small number I provide in the graphic. Regardless, 4200 deaths is a lot. But the approximately 200 new deaths is the lowest number reported in several days.

Virginia is a weird state. When we see the levels chart below, you will see how its uptick has been far more gradual, and to this point it does not yet appear to have peaked or begun to stabilise. Most of the reported cases continue to be in and around the state’s big cities, notably the DC metro area, but also Richmond.

Illinois has now seen cases from north at the Wisconsin border all the way south to Cairo. Most cases remain, however, concentrated in the Chicago metropolitan area, with lesser scale outbreaks occurring in the Quad Cities area and the suburban counties of Illinois this side of the Mississippi. Deaths continue to rise, and while most area again in the Chicago area, they are appearing increasingly at low levels in downstate counties.

But what about those curves? Excepting Delaware, which hasn’t reported new data, we can see that some states like Virginia continue to see increasing rates of infection. Others like New Jersey and Pennsylvania clearly have flattened and have entered a new phase. In New Jersey’s case it appears to be more of a stabilised plateau. In Pennsylvania, there was some evidence it was entering a declining rate phase, but that may now have begun to become more of a steady rate of infection like in New Jersey. Illinois is tough to read because of the variability of its data. It might be more of a pause in the rate of increase, or it may have begun to stabilise. We need more data.

Credit for the pieces is mine.

Monday Covid-19 Data

The data from Monday provided yet more evidence that the outbreak is flattening in several states. However, in some, the outbreak continues to pick up steam. Does this runs contrary to the idea that as a country is flattening? Not necessarily, but it is important to remember that a country that spans a continent and holds 330 million people will experience the pandemic differently at different times. So some states like Washington will be first, and others will be last.

Our five states cover the range of worsening to stabilising. We hope that those stabilising states soon enter the improving phase. Though to beat the dead horse, I would add that just because a state is improving doesn’t mean we can all go back to life like we knew it two months ago. That would likely result in us being right back here shortly thereafter.

Pennsylvania continues to be a state where the pandemic is spreading within the denser metropolitan areas of Philadelphia and Pittsburgh, leaving the central T to see fewer cases that spread more slowly.

Delaware might be approaching an inflection point, given that its most populous county, New Castle, is about to reach 1000 cases. (By the end of today it likely will if its new case trend holds.) We know that deaths lag new cases, and so the worry is that the number of deaths will begin to increase rapidly. The hope is that the slow initial growth of the outbreak will have left hospitals able to better cope over the longer time frame than if everyone had gotten sick all at once.

Virginia is a state that we will contrast to New Jersey, which I will write about last. Because Virginia is a state where it appears the outbreak is beginning to pick up steam and accelerate, rather than flatten. There was the significant drop in cases on Sunday, but that was due to the state’s enhancement of reporting data. (Their website now includes many new statistics.) But just like that the Monday data showed over 450 new cases on Monday. The question will be whether or not over the remainder of the week those new case numbers fall from over 450 to less than 400 to show that the state can flatten the curve before the outbreak becomes especially severe.

Illinois has shown a lot of variability in its day-to-day numbers, hence the advantage of the rolling average. But even that has appeared a wee bit jagged. It’s tough to see the curve flattening just yet, but if we receive updates today and over the next few days that cases are consistently lower, than we might just be able to say the curve is flattening.

And of course in New Jersey we have a state where the curve really and truly has flattened. We have yet to see sustained evidence of a decline in the number of new daily cases. As I said before, this might be more a situation where the outbreak has stabilised and roughly the same number of new cases is being reported daily. Of course the hope is that whatever that rate is falls below the excess capacity threshold of the state’s hospitals.

But I also want to take a look at the state of New Jersey with a degree of granularity. Because, as I noted with Virginia above, not all states are at the same point in their outbreak. And the same can hold true within states. We know that the outbreak in New Jersey began in the north and was very late in reaching some parts of South Jersey. So the same metrics we run for the state, we can run for the counties—though the data I have been collecting from the states only goes back as far as St. Patrick’s Day.

New Jersey's curves — New Jersey’s curves

The northern counties, where the state has been hardest hit, have clearly begun to see the curve bend. But in the south the story is a bit more mixed. Some, like Burlington and Ocean, have seen the curve noticeably flatten. But in Camden and Mercer Counties, home to Camden and Trenton, respectively, the evidence is not quite there. Instead, in these populous counties there exists the very real possibility that the outbreak will continue accelerating for hopefully a very short while.

Credit for the pieces is mine.

Sunday Covid-19 Data

Another day, more cases of coronavirus and Covid-19. So let’s take a look at Sunday’s data as there were some interesting things going on.

First, let’s dispense with Virginia. The state is enhancing its reporting structure, and so they admit the data is likely an underestimate of the present situation in Virginia. So here’s Virginia, nothing really changed.

Moving on, we have Pennsylvania. Here we are beginning to truly see the disparity between the cities in the southeast and southwest, namely Philadelphia and Pittsburgh, and the T that describes what sometimes is used to describe Pennsyltucky. (Though it also includes cities like Harrisburg, the state capital.) The point is that the T of Pennsylvania has yet to suffer greatly from the outbreak. Of course, it’s also the part of the state least equipped to deal with a pandemic.

New Jersey is just bad. One can make the argument that South Jersey is hanging on. (Though I will touch on that later with an idea for today’s afterwork work.) Bergen County in the northeast is likely to surpass 10,000 cases on its own today. And that will put it above most states.

Delaware is tough because it sits as a small state next to several much larger ones. But, the numbers seem to indicate the outbreak is still worsening. Though in terms of geographic spread, there’s little to say other than that New Castle County, home to Wilmington, in the north is the heart of the state’s outbreak.

Illinois is a fascinating state, because of how dissimilar it is compared to Pennsylvania, a state which has a similar number of people.

The map shows that geographic spread still has a little way to go before reaching every county in the state. But the outbreak has been there longer than in Pennsylvania. And most of the darker purples are concentrated in the northeast, in Chicago and its collar counties. Compare that to Pennsylvania above where you will see dark purple scattered across the cities of its eastern third, e.g. Allentown and Scranton, and in the western parts near Pittsburgh. This too could be worth exploring in depth in the future.

Lastly I want to get to the cases curves charts. Here we look at the daily new cases in each state.

The curves, flattening or otherwise, of the five states.

And unfortunately Sunday’s numbers will impact the Virginia curve, but it overall looks as if the state is worsening. I would argue that Illinois, which appears to be bending towards a steadying condition is likely in a weird weekly pattern where it appears to stabilise on weekends and then resumes reported infections come Monday. Pennsylvania might well be flattening its curve. I would want to see a few more days’ worth of data before stating that more definitively. Let’s give it to Wednesday or Thursday.

And then in New Jersey we have a fascinating trend. The curve of increasing number of cases has clearly broken. But it also is not shrinking. Instead, it seems to be more of a plateau. And in that case, the outbreak in New Jersey is not getting worse, but it’s also not getting any better. At least not numerically. However, the goal of flattening the curve is to create a slower, more steady increase in case numbers to help hospitals cope with surge volumes. So good news?

Credit for the pieces is mine.