Texas-scale Cold

The middle third of the United States sits under some pretty cold Arctic air, helping to bring frozen precipitation, i.e. snow, to places unfamiliar with it, most notably Texas. I say unfamiliar, but Texas is also negligently unprepared. There are photos circulating the internet of Texarkana, a city straddling the Texas–Arkansas border, of the Arkansas side plowed and safe for travel whilst the Texas side…is not. You also have a deregulated and privatised energy grid, which has seen wholesale prices spike to $9,000 per megawatt hour. (Some companies in the Texan market charge wholesale rates to their customers, so I wouldn’t be surprised to see stories coming out in the next few weeks of excessively large electric bills.)

What’s driving this Texas-scale cold? Why is Arctic air over Dallas? In years past you’ve probably heard the term “polar vortex”. The super simple version is that really cold air spins in a tight upper-atmosphere vortex over the pole, hence the name. But when the vortex weakens, say due to warmer air, it becomes a bit more unstable. When it becomes unstable, a chunk of it might break off and descend south. It doesn’t always descend over continental North America, but when it does… well, since the mid 2010s we’ve been calling it the polar vortex. Keep in mind, that it’s not, it’s a part of an upper-level low whose cold air eventually falls to the surface, but despite my protestations, the name has stuck.

Anyway, it means we presently are witnessing some frigid temperatures across the US and this graphic from the National Weather Service (NWS) highlights just how extreme those temperatures are.

The distance is no surprise here, because in winter one would expect Minneapolis and Miami to exhibit extreme temperature differences. But it’s the scale of this difference that is so dramatic.

I could probably do a whole piece—or several—about the design of NWS graphics, but I’ll just point out that I’d probably lighten the black lines working as state/provincial borders. And while their colours are standardised, I wonder if making a clearer distinction between freezing and above freezing (32ºF in this map) would make some more sense.

Credit for the piece goes to the NWS.

Covid Update: 15 February

Last week we discussed the potential impact of a major nor’easter that struck the East Coast and interrupted testing and vaccination operations in the states we cover: Pennsylvania, New Jersey, Delaware, Virginia, and Illinois (affected by the storm as one of the components moved east across the Midwest).

The possibility of an exaggerated downward trajectory concerned me and that it could be followed with an uptick in new cases and deaths. So a week later, where are we?

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

We can see something in the middle. With the exception of Illinois, which has continued its downward trend for new cases, we saw a brief interruption last week. In some cases, like Pennsylvania, that emerged as a rolling seven-day average that began and ended the workweek with the same exact number. And without a lot of variation during the week, you can see that pattern as the flat line towards the end of the chart. As numbers resumed heading down, you can see that beginning of a downward direction at the line’s very end.

In the remaining states of New Jersey, Delaware, and Virginia we saw brief upticks in the seven-day averages with daily spikes of new cases. None of these upticks came anywhere close enough to be threatening—though any upward tick should be monitored—but they were all significant enough to be seen as the quick, upward pointing jogs in the lines. But as we entered the weekend, those numbers also began to drop again.

Next we look at deaths. Last week I described a muddled picture. Delaware and Virginia had begun to rebound and reach or approach new peaks whilst Pennsylvania and Illinois continued to see steady but significant declines. New Jersey fell somewhere between the two. What about this week?

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

This week is an improved picture. We did see the potential interruption from the storm—Pennsylvania’s death trend evinces the disruption with the same straight line pattern we saw with new cases. But, overall, numbers continue to trend down. Delaware and Virginia show dramatic improvement with steep drops over the last week. And whilst Illinois continues to show steadily declining numbers, New Jersey now falls somewhere near the top of the pile. Its death rate continues to decline very slowly, relative to the other states. But it is heading down.

Finally, a look at vaccinations for Pennsylvania, Virginia, and Illinois.

Last week we talked about how the states all reached at least 2% over the course of the week. Even better news this week.

Vaccination curves for PA, VA, & IL.

Last week we needed approximately one week to climb one percentage point from 1% to 2%. This week in the same one week time period we saw Virginia climb two percentage points from 2% to 4%. Illinois has slowed its vaccination efforts as it’s still in the mid 3% range. And Pennsylvania is tricky. Because the city of Philadelphia does not report its data on the weekend, we have an incomplete picture until after I post this on Mondays. Even though today is Tuesday, yesterday was a holiday so the same pattern holds true. I would suspect, however, the Commonwealth surpasses 4% later today when the new numbers are released or it comes near to reaching that level.

Credit for the piece is mine.

Appliance Matrix

Well, it’s Friday. And in the Northeast that means another snowstorm. In normal times, that would mean a nice half-hour walk to the office wherein my overcoat would likely become covered in snow and my trousers soaked in disgusting, salty, slush water. In other words, I’d need to wash and dry my clothes. But what household appliances should I use?

Thankfully, over at xkcd, Randall Munroe tackled that very problem with this helpful matrix.

Of course my aforementioned scenario is entirely moot, because like so many of you, I haven’t seen my office nor really left my flat in 11 months now. But here’s looking at you vaccines.

Credit for the piece goes to Randall Munroe.

Trading Andrew Benintendi

Yesterday, one year to the day the Boston Red Sox traded Mookie Betts to the Los Angeles Dodgers, the Red Sox made another big trade, sending Andrew Benintendi, their starting left fielder, to the Kansas City Royals as part of another three-team trade—last year’s three-team part fell apart, but initially involved Boston receiving a quality reliever from the Minnesota Twins.

In this year’s trade, the Red Sox receive an outfielder, Franchy Cordero, from the Royals and a pitcher, Josh Winckowski, from the New York Mets. Boston is sending $2.8 million to Kansas City to help defray the costs. Using data from Baseball Trade Value, we can make a quick graphic to show how this trade shakes out for the teams involved.

How the trade looks, with incomplete data

At first glance, we see that the Red Sox and the Royals are giving up more than they are receiving in value. The Mets look like the clear winner here, by a long shot.

And it could end up that way this time next year.

But, there is one enormous question mark—or maybe three. The Red Sox are also acquiring one player to be named later from the Mets and two from the Royals. Players to be named later are usually not the high end of prospects, but instead of low to middle value. And what appears likely in this case is that the Red Sox will be presented lists of players from both teams and Boston can choose which ones they like. The key here is that this could take a few months to sort out, because Boston wants to see how these players perform in the minor leagues. In 2020, there was no minor league season and so teams have very little to no information on players, which makes it nigh impossible to accurately assess their skill sets.

And so yes, we can make graphics like this and talk about how the Red Sox lost this trade. But in reality, we’ll need to wait a few months to see the last three players of the deal to see how badly—or how well—Boston does in the end.

Credit for the piece is mine.

The Changing Colours of Rivers

No two rivers are the same, though they certainly can be similar. Rivers have their own ecosystems and when I was at school, I learned of the different classifications of rivers by the colour of their water: black, white, and clear. Broadly speaking, that just means the amount of sediment dissolved in the river’s water. Black colours appear when slow moving water has absorbed lots from its environment, think swamps. White waters resemble tea or coffee with added milk or cream. This happens when sediments enter and dissolved into the water. Clear water is that, relatively clear and free of sediment.

But a team of scientists at University of North Carolina at Chapel Hill (UNC Chapel Hill) recently released some work where they used shifts in blue to yellow and green to help classify rivers. Their classification differs, but broadly can point to a change from healthy (blue) to unhealthy (yellow and green). The novelty in their work, however, focuses on using satellite imagery to capture the colour of rivers and their evolution since the mid 1980s.

A look at the broader lower-48 of the United States

They published their findings as an interactive application driven primarily by a clickable map. Clearly not all rivers are available, but a large number are, and you can see some obvious patterns at a national scale—their work excludes Alaska and Hawaii. If blue represents healthy rivers, we see healthy rivers in New England and the Pacific Northwest with a host of green rivers in the Mid-Atlantic and Upper Midwest with yellow in the Mississippi basin and southeast.

I wanted to look at Pennsylvania a bit more specifically given my familiarity with the Commonwealth and zoomed in a bit on the map.

The colour of Pennsylvania’s rivers

You can see that using that above scale, Pennsylvania’s rivers are in okay, not great state. Some of the upper stretches of the Delaware and Susquehanna Rivers are coloured blue, but we mostly see a lot of green.

To the right of the map, the designers placed three smaller charts driven by the user’s selection of river. Let’s take a look at the Juniata River as an example—my grandfather grew up living alongside a tributary that emptied into the Frankstown Branch just a short walk from his house.

A look at the Schuylkill River south of the Fairmount Water Works

We can see that the chart on the upper right shows the colour shift over the decades for that observed section of the river. The legend provides the information that the section of the river has shifting blue—gotten healthier—and then below it looks for any seasonal changes. Here the chart is grey, indicating the system lacks enough data for a clear trend. This examines the short changes we might see in a river based on seasonal effects like rainy season, dry season, and human-driven effects—perhaps we pollute more in the spring and then use rivers recreationally in the summer.

Finally a distribution of the river section’s colour, all in wavelengths of light.

My biggest critique here would be the wavelengths. Users likely will not the colour spectrum by wavelength, and adding some labels like blue, yellow, and green could go a long ways to help users understand at what they are looking.

Overall, though, this is a really fascinating project.

Credit for the piece goes to John Gardner et al.

Covid Update: 7 February

I missed last week’s posting on an update to Covid-19. Two weeks on from the last post, things in the states of Pennsylvania, New Jersey, Delaware, Virginia, and Illinois continue to improve, albeit with a few fits and starts. But the downward trend nonetheless can be seen in the new cases charts.

Consider that in the charts from two weeks ago, we saw downward slopes, but a look at the charts in the two weeks hence shows some blips.

Another thing to keep in mind is that a major snowstorm disrupted testing and vaccinating operations in the northeastern states of Pennsylvania, New Jersey, and Delaware. The storm, which also hit northern Illinois and Virginia, also likely impacted those states but to lesser degrees.

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

That means the downward trends in new cases could be slightly exaggerated in those states. Consequently, rebounds next week should be taken with a grain of salt. Indeed, Sunday’s data releases from the tri-state area were greater than we might normally see with weekend data.

When we at deaths, however, we see a more muddled picture.

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

In states like Delaware and Virginia, the average death rate is now higher than it was two weeks ago. In New Jersey, the rate is down slightly, but after two weeks of it being largely up and so all in all, largely a wash. Instead, it’s only in Pennsylvania and Illinois where we any real improvements in the average death rate. Both states are down and look to continue heading down.

Finally, we look at vaccinations and the percent of state populations that have been fully vaccinated.

The fully vaccinated percentage of the populations of PA, VA, & IL.

Two weeks ago, Pennsylvania and Illinois had just reached 1%. Neither New Jersey nor Delaware is reporting similar data, so both those states remain outside our consideration set. But, all three remaining states—Pennsylvania, Virginia, and Illinois—are now over 2%. Pennsylvania reports at least 2.5%—the city of Philadelphia reports separately from the statewide Department of Health, but does not update its figures at the weekend and so is likely higher. Both Virginia and Illinois have reached 2.3% full vaccination.

Credit for the piece is mine.

The Earth Is a Bit Bumpy

Last Friday I shared an xkcd post about the relative smoothness of the Earth. This week he posted an illustration but a slightly different scale. You can see more of Earth’s jagged edges.

Gotta love the Star Trek reference. I’m betting he used the length of the Kelvin timeline Enterprise, which I personally dislike, as it’s significantly larger than the prime timeline Enterprise of Shatner and Nimoy.

Anyway, Happy Friday, all.

Credit for the piece goes to Randall Munroe.

Viral Mutations

With Covid-19, one of the big challenges we face is the rapid mutations in the viral genetic code that have produced several beneficial—from the virus’ standpoint—adaptations. Several days ago the New York Times published a nice, illustrated piece that showed just what these mutations look like.

Of course, these were not just nice illustrations of protein molecules, but the screenshot below is of the code itself and you can see how just a few alterations can produce subtle, but impactful, effects.

In a biological sense, these mutations are nothing new. In fact, humanity wouldn’t be humanity but for mutations. Rather we are seeing evolution play out in front of our eyes—albeit eyes locked in the same household for nearly a year now—as the virus evolves adaptations better suited to spreading and surviving in a host population.

The piece includes several illustrations, but begins with an overall, simplified diagram of the virus and where its genetic code lies. And then breaks that code down similar to a stacked bar chart.

Designers identify where in the code the different mutations occur and the type of mutation. Later on in the piece we see a map of where this particular variant can be found.

I might come back to that map later, so I won’t comment too much on it here.

But I think this piece does a great job of showcasing just what we mean when we talk about virus mutations. It’s really just a beneficial slip up in the genetic alphabet.

Credit for the piece goes to Jonathan Corum and Carl Zimmer.

Biden’s Cabinet

Note: I wanted this to go up on Inauguration Day, but I had some server issues last week. And while I got everything back for Friday and Monday, I didn’t want to wait too long to post this. You’ll note at the end that I have questions about General Austin and whether he could be confirmed as Defence Secretary. Spoiler: He was.

Today is Inauguration Day and at noon, President Trump returns to being a citizen and Joe Biden assumes the office of the presidency. He comes to office with arguably the most diverse cabinet in American history supporting him and his agenda.

CNN took a look at that diversity with this piece, which uses an interactive, animated stacked bar chart.

The proposed cabinet vs. the US ethnic breakdown

I took a screenshot at the ethnic/racial diversity. At the top, each bar represents one member of cabinet who you can reveal after mousing over the bar. Below is a stacked bar chart showing the racial makeup of the United States. You can see how it does resemble, and in some cases exceeds, the diversity of the broader United States.

One thing to note, however, is that we see 26 members of Cabinet. Some of those are the heads of the big executive departments like Treasury and Defence. But I’m not certain everyone is technically a cabinet-level position, e.g. Celia Rouse, Chair of the Council of Economic Advisors. It could be that the position is being elevated to cabinet level like John Kerry’s role as climate envoy. And if I just missed the press announcement, that’s on me. But that could affect the overall numbers.

Regardless, the nominated cabinet is more diverse than the previous two administrations as the CNN piece also shows.

The proposed cabinet vs. the preceding inaugural cabinets

I should point out that usually an incoming administration usually has a few of its national security positions already confirmed or confirmed on the first day, e.g. Defence and State. However, the Republican Senate, obsessed with the lie of a fraudulent election, has only just begun to start the confirmation process. In fact, as of late last night, only Avril Haines has been confirmed by the Senate (84–10) for Director of National Intelligence.

Furthermore, almost every administration has one or two nominations that fail to pass the Senate. George W Bush had Linda Chavez, Barack Obama had Tom Daschle, and Donald Trump had Andrew Puzder, just to give one from each of the last three administrations.

With a 50–50 Senate, I would expect there to be a few nominees who fail to make it over the line. Austin could be one, there appears to be some bipartisan agreement that we ought not nominate recent military officials as civilian heads of said military. Another to keep an eye out for is Neera Tanden. She riles conservatives and angers Bernie Sanders supporters, so whether the Senate will confirm her as Director of the Office of Management and Budget remains an open question in my mind.

Credit for the piece goes to Priya Krishnakumar, Catherine E. Shoichet, Janie Boschma and Kenneth Uzquiano.

Covid-19 Update: 24 January

Last week we saw some indications that the recent surge was beginning to ebb in Pennsylvania, Delaware, and Illinois with the same in New Jersey, but to a slight degree less so. Only Virginia presented us with data that showed its surge continuing unabated.

So this week we have some generally good news to look at.

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

The drop in Pennsylvania, New Jersey, and Illinois appears real and sustained. Even in Virginia, we are beginning to see some signs of a decline in new cases—albeit it after a week of record reports of new cases.

Of course we should also mention that even though we are seeing declines in new cases, in no state are we close to approach low levels of community spread. Things are still bad out there, but they have gone from catastrophic spread to merely a disaster. Illinois is probably the closest to reaching summer-like levels of viral spread.

Deaths, however, because they lag behind new cases, are just now beginning to show signs of ebbing.

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

If last week’s pattern with new cases was that we were seeing positive trends in four states, we can say this week we are seeing positive trends in deaths for the same four states. Virginia is, again, the outlier.

Though I would be remiss if I noted that the declines in deaths is not nearly as pronounced as in new cases. In Pennsylvania, the seven-day trend for new deaths has appeared to have crested. But in New Jersey, recent days have suggested the decline may not be as steady. Only in Illinois are we really seeing a sustained downward trend in deaths.

And Virginia just Saturday saw its seven-day trend reach another new record, over 50 deaths per day.

But what about vaccinations?

Firstly, we still only have data for the three states of Pennsylvania, Virginia, and Illinois. Secondly, keep in mind that I am looking only at people reported fully vaccinated, i.e. they have had both their shots—both Pfizer’s and Moderna’s vaccines require two shots.

Vaccination curves in PA, VA, & IL.

There’s not a lot to report on yet, other than that both Pennsylvania and Illinois reached the 1% threshold. I think that for most people, however, that you can begin to see their respective lines easing off the 0% baseline. Virginia lags behind those two states, however, with just 0.5% of its population reported as fully vaccinated.

I’m curious to see if I cannot find some additional/alternative data sources for New Jersey and Delaware next weekend. I don’t love the idea of mixing data sources, but after a few weeks, we haven’t really seen any improvements to the data sharing from those states.

That said, I should also note that the new US administration has identified data transparency as an issue—or the lack thereof—in the current vaccination programme and is working to develop national and state-level dashboards to inform the public.

Credit for the piece is mine.