My Work – Page 6 – Coffee Spoons

Biden’s English Ancestry Revisited

Last week I posted about an article in the BBC on the English ancestry of American president Joe Biden. And these types of article are a bit pro forma, famous person has an article about their personal ancestry with a family tree attached. Interestingly, this article did not, just the timeline I mentioned and a graphic as part of an aside on the declining self-identification as English-American.

And that, normally is it. Perhaps the article comes out with a few revisions upon the famous person’s marriage, birth of children, and more rarely death, but that is it. Yesterday, however, the BBC posted a follow-up article about an English family claiming kinship with Joe Biden. This article, however, included a family tree of sorts.

This isn’t a family tree in the traditional sense, I would argue it’s the sort of chart genealogists would use to highlight two parties’ relationship to their most recent common ancestor (MCRA). But this chart does something odd, it spaces out the generations inconsistently and so Joe Biden appears at the bottom, aligned with the grandchildren of Paul Harris, the man at the centre of the story.

If you compare the height/length of the lines linking the different generations you can see the lines on Biden’s side of the graphic are very long compared to those on the Harris’ side. This isn’t technically incorrect, but it muddies the water when it comes to understanding the generational differences. So I revisited the design below.

Here I dropped the photographs because, primarily, I don’t have access to them. But they also eat up valuable real estate and aren’t necessary to communicate the relationships. I kept the same distance between generations, which does a better job showing the relationship between Joe Biden and Paul Harris, who appear to be actual fifth cousins. Joe is clearly at a different level than that of Paul’s grandchildren.

I added some context with labelling the generational relationship. At the top we have William and James Biden, assuming they are brothers, listed as siblings. The next level down are first cousins, then second, &c. Beyond Paul, however, we have two additional generations that are removed from the same relationship level. This is where the confusing “once-removed” or “twice-removed” comes into play. One way to think of it is as the number of steps you need to take from, say, Paul’s grandchildren, to get to a common generational level. In their case two levels, hence the grandchildren are fifth cousins to Joe Biden, twice removed.

These types of charts are great to show narrow relationships. Because, if we assume that up until recently each of the generations depicted above had four or five children, that tree would be unwieldy at best to show the relationship between Paul’s family and Joe Biden. If you ever find yourself working on your family ancestry or history and need to show someone how you are related, this type of chart is a great tool.

Credit for the original goes to the BBC graphics department

Credit for my remake is mine.

Covid Update: 20 June

So today’s post will be a little bit shorter than usual. The big reason is probably good, but also worth addressing. States are increasingly less reliable about their data. For several weeks I have mentioned that Philadelphia had not been updating their vaccination data. Last week or two weeks ago I noticed a small line of text had been inserted saying they were ramping down reporting to just two days per week. That’s unfortunate, because Philadelphia County represents 1/9 of Pennsylvania and that can make a significant impact on the Commonwealth’s total numbers.

But this week we have Illinois. There’s been no update since Friday and it’s not clear if this is due to a glitch, or given the coincidence, a change in reporting schedule that omits weekend data updates. Not reporting for a weekend is not a big deal, as states often have to perform back-end server maintenance or clean up data and the best time for that is the weekend. But heretofore, Illinois had been the most reliable state in terms of reporting data.

There was one thing I wanted to address this week, but the lack of Illinois data makes that tricky. So I may have to wait and maybe do it next week or later this week.

Anyway, the data below is not quite as up-to-date for Illinois, but we’ll see how the Land of Lincoln addresses the issue probably today.

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

Otherwise, the numbers are good. Yes, the downward slopes are shallowing out and that is increasingly obvious, but there’s increasingly less room to drop. Pennsylvania, for example, last week was just over 400 new cases per day, but the seven-day average now sits at 261. Illinois last week sat at 336, but as of its last update, that was down to 237. Virginia’s decrease was smaller, from 143 to 129, while Delaware fell from 33 to 27.

Only in New Jersey have we seen the seven-day average rise, from 168 to 179. This was not a one-off spike, however. As the delta variant takes hold in the United States, the variant brings increased ease of transmission and more severe effects for younger populations, the population group last to vaccinate and increasingly seen as not willing to vaccinate. Is this driving the slight uptick in New Jersey we saw last week? It’s too early to say.

But it serves as a reminder to everyone, please, if you haven’t already, get vaccinated.

Deaths now appear to be dropping once again across the board.

Last we discussed Pennsylvania bottoming out around that 18 deaths per day level. After a week of declines, that average is now down to just under 12 deaths per day. If we see continued progress, perhaps this time next week I can be writing about the Commonwealth’s seven-day average dropping into the single digits for the first time since April 2020.

Illinois also looked like it was slowing, but again, the lack of data is making it hard to say one way or another. But at last report, the average was down to 14 deaths per day.

Last week we also discussed a slowing rate in New Jersey, and that continued to slow, but still continued to fall and deaths are now at 5.6 per day. And after a rise I noted last week, Virginia is back below double digits and at 6.3 deaths per day.

Delaware actually managed to hit 0.0 deaths per day for a stretch of two days last week as it went a week-plus without a single Covid-19 death. It has had a few reported over the weekend and so that number is up, but still below 1 as we head into the week.

Vaccinations remain the slowing curve that we saw last week.

Thankfully we can see Virginia is now approaching and, hopefully, can cross the 50% fully vaccinated rate by the end of the week. Pennsylvania, again, is hard to gauge. The numbers sit at 46.7%, but the Philadelphia numbers have not updated in four days, so that could add a half percentage point or, earlier in the vaccination push, more. Optimistically, however, we are looking at numbers nearing 50%.

Credit for the piece is mine.

Biden’s English Ancestry

We all know Joe Biden as the Irish American president. And that’s no malarkey. But, go back far enough in your family tree and you may find some interesting ancestry and ethnic origins and that’s no different with Joe Biden. Keep in mind that our number of ancestors doubles every generation. You have four grandparents, and many of us met most of them. But you had eight great-grandparents. How many of those did you know? And you had 16 great-great-grandparents, you likely didn’t know any of them personally. It becomes pretty easy for an ethnic line to sneak into your ancestry.

And in Biden’s case it may well be English. Although sneaking in is probably a stretch, as this BBC article points out, because his patrilineal line, i.e. his father’s father’s father’s, &c., is likely English. Of course back in the day the Irish and the English mixing would have been unconscionable, at least as my grandmother would have described it. And so it’s easy to see how the exact origins of family lines are quietly forgotten. But that’s why we have genealogists.

The article eschews the traditional family tree graphic and instead uses only two charts. The first is a simple timeline of Biden’s direct ancestors.

No, it’s no family tree, but timelines are a critical tool used by genealogists because at its core, genealogy is all about time and place. And a timeline has got one of those two facets covered.

Timelines help visualise stories in chronological order. I cannot tell you the number of family trees I have seen where people who create trees casually simply copy and paste data without scrutiny. Children born well after the deaths of parents are common. Or children born to parents in their 50s or 60s—perhaps not strictly impossible, but certainly highly irregular. And so to see Biden’s ancestors plotted out chronologically is a common graphic for those who do any work in genealogy, which my regular readers know is my hobby.

That alone would make the article worth sharing. Because, I enjoyed that graphic. I probably would have created a separate line for the birthplace of each individual, but I quibble.

However, we have another graphic that’s not so great. And once again with the BBC I’m talking about axis lines.

Here we have a chart looking at US ancestry as claimed in the US censuses of 1980 and 2000. But we do not have any vertical lines making it easy for readers to accurately compare the lengths of the various bars. Twice lately I’ve posted about axis lines and the BBC. Third time’s the charm?

We can also look at using these not as bars, but as line charts as I did in this re-imagining to the right.

First, we no longer need two distinct colours, though you could argue the English line should be a highlight or call out colour given its role in the article. Instead each line receives a label at the right and only the English line crosses any other, but given their point-to-point slope, it’s not confusing like a line chart with all years between 1980 and 2000 could be.

Secondly, the slope here of the line reinforces the idea of falling population numbers. The bar chart also shows this, but through a leftward movement in bars. The bar option certainly works and there’s nothing wrong with it, but these lines offer a more intuitive concept of falling numbers.

I also added some clarification to the data definition. These lines represent the number of people who reported at least one ethnic ancestry—at the time US census respondents could enter upwards of two. For myself, as an example, I could have entered Irish and Carpatho-Rusyn. But my own small sliver of English ancestry would have been left off the list.

Ultimately, the declining numbers of responses along with some reporting on self-identification points to the disappearing concepts of “Irish American” or “English American” as many increasingly see themselves as simply White Americans. But that’s a story for another day.

In the meantime, we have Joe Biden, the Irish American president, with a small bit of English ancestry. Those interested in the genealogy, the article also includes some nice photos of baptismal records and marriage records. It’s an interesting read, though I’m hungry for more as it’s a very light duty pass.

Credit for the BBC pieces goes to the BBC graphics department.

Credit for my reimagination is mine.

Inflating Areas

One trend people have begun to follow lately is that of rising prices for consumer goods. If you have shopped recently for things, you may have noticed that you have been paying more than you were just a few weeks ago. We call this inflation. The Bureau of Labour Statistics (BLS) tracks this for a whole range of goods. We call the the consumer price index (CPI)

Prices can vary wildly for some goods, most notably food and energy. For those of my readers who drive, recall how quickly petrol/gasoline prices can change. Because of that volatility, the Bureau of Labour Statistics strips out food and energy prices and the inflation that excludes food and energy is what we call Core CPI.

Lately, we have been seeing an increase in prices and inflation is on the rise. To an extent, this is not surprising. The pandemic disrupted supply chains and wiped out supplies and stores of goods. But with many people working remotely, many now have pent up savings they want to spend. But with low supply and high demand, basic economics suggests rising prices. As supplies increase in the coming months, however, the rise in prices will begin to cool off. In other words, most economists are not yet concerned and expect this spike in inflation to be passing in nature. But not everyone agrees.

Last week, the Washington Post had an article examining the cause of inflation for a number of industries. To do so, it used some charts looking at prices over the past two years. This screenshot is from the used car section.

I want to focus on the design of this graphic, though, not the content. The designers’ goal appears to be contrasting the inflation over the last year to that of the last two years. Easy peasy. Red represents one-year inflation and blue two-year.

Typically when you see a chart that look like this, an area or filled line chart, the coloured area reflects the total value of the thing being measured. You can also use the colour to make positive/negative values clearer. In this case, neither of those things are happening.

Because the blue, for example, starts at the beginning of the time series and at the bottom of the chart, it looks like an enormous amount of consistent blue growth. And when the line runs into May 2020, we begin to see what appears as a stacked area chart, with the blue area increasing at the expense of the red.

Another way of reading it could be that the 29.7% and 29.3% increases equal the shaded areas, but that’s also problematic. If the shaded area locked to the baseline like you’ll see in a moment, I could maybe see that working, but at this point it just leaves me confused.

Now you can use the area fill to make it clear when a line dips above or below the baseline, in this case 0%. And I took that approach when I reimagined the chart as seen below.

What we do here is we set the bottom of the area fill to the baseline. Consequently, where the chart is filled above 0 we have positive inflation, and where it falls below the 0 line we have negative inflation, or deflation.

We need to note here that the text in the original article talks about the monthly change in inflation, e.g. that used car prices have increased by 7.3% last month. That, however, is not what the chart looks at. Instead, the chart shows the change yearly, in other words, prices now vs last May. To an extent, the 29.7% increase is not terribly surprising given how terrible the recession was.

Ultimately, I don’t see the value in the filled blue and red areas of the chart because I am left more confused. Does the reader need to see how far back one year and two years are from May 2021? Don’t the date labels do that sufficiently well?

This is just a weird article that left me scratching my head at the graphics. But read the text, it’s super informative about the content. I just wish a bit more work went into the graphics. There are some nice illustrations beginning each section, but I kind of feel that more time was spent on the illustrations than the charts.

Credit for the piece goes to Abha Bhattarai and Alyssa Fowers.

Covid Update: 7 Jun

Technical difficulties yesterday. But I wanted to run the latest Covid numbers to start this week of posting, so we’re just going to use the Monday data, which is the lowest of the week since it captures the data reported by authorities on Sunday. That said, where are we?

Last week we began to see a slowdown in the rate of declining cases, though, crucially, cases were still in decline. The good news is that cases continue to decline. The seven-day averages for all five states are now well below 1,000 new cases per day, with Illinois dipping below 500. Only Pennsylvania remains above that level at 544 new cases per day.

We are no longer seeing the numbers fall by hundreds per day, most notably in New Jersey, but we remain in a race to the bottom. Unfortunately, with significant numbers of the population refusing vaccination and the near certainty of this coronavirus becoming endemic, i.e. a persistent, circulating virus, we will never reach zero. The numbers at some point will bottom out and a slowing rate of decline could indicate nearing that point.

Deaths have continued their even slower decline over the last week. New Jersey’s seven-day average fell into the high single digits for the first time since November. Virginia, which had flirted with single-digit days, has now reported a week-long run of about nine deaths per day. Delaware, due to its low population only reached double digits for most of February, but has seen a slight uptick to over two deaths per day.

The two most interesting states with regards to deaths are Illinois and Pennsylvania, for different reasons. Starting with Illinois, we are beginning to see a pattern of bottoming out. For most of the last week the seven-day average has hovered about 20 with day-to-day changes of one or two additional/fewer deaths per day. We will have to watch over the coming week whether the numbers can resume pushing downwards or if we continue to see this bottoming out.

Then we have Pennsylvania. Through the beginning of the weekend, we saw progress as the Commonwealth’s seven-day average dropped below 20 deaths per day for the first time since October. Two days ago the Department of Health reported an additional 185 deaths, but then yesterday the total number of deaths dropped by 174. I haven’t yet been able to piece together what happened, but it does make the sudden spike in the seven-day average—to 46 deaths per day—a wee bit suspect.

Finally we have vaccinations. And the news is there is no news. Over the last week we have seen almost zero growth in the number of fully vaccinated individuals in Pennsylvania (1.8 percentage points), Virginia (1.53 pts), and Illinois (2.41 pts).

Total full vaccinations in PA, VA, & IL.

If we look at where the cumulative rates remain stuck, however, we see numbers in the mid-40s, short of 2/3 the estimated herd immunity range. The flattening of the curve, indicating slowing rates of vaccination, have become increasingly pronounced. This is not the curve we want to see flattened. Ideally this slowdown would have occurred nearer the 70% range and we could have eased into the estimated herd immunity range.

That said, we are approaching 50% in these three states and numerous communities, though not all, within these states are now over 50% fully vaccinated. But the longer we have largely unvaccinated reservoirs available, the more likely it is we will see new variants emerge that could potentially evolve to be more transmissible or even more deadly.

And so for any of my readers who haven’t received their shots yet, I encourage you to please do so. They’re free, they’re effective, and they’re necessary for us to get back to some sense of normal.

Credit for the piece is mine.

Covid Update: 31 May

Last week I wrote about how new cases had maybe flattened a wee bit in their rapid drop from peaks earlier this year. But the good news is that even in where new cases declines may have slowed down, they continue to decline.

We can see the tails at the right ends are all back to declining shapes. Delaware is perhaps the most deceptive, because remember that there was the anomalous spike from late processing of earlier new cases.

I had noted that deaths had finally seen some data showing them dropping. That has held true to some degree.

Indeed, the tails at the end of each state have shown slow declines. Delaware is even near 0 deaths per day. Illinois, however, is an exception with a small increase lately.

Finally, a brief look at vaccinations.

Full vaccination curves for PA, VA, & IL.

You can see that the rate of full vaccinations has begun to slow. All three states we cover are over 40%, though all are below 45%. Pennsylvania is difficult to evaluate, however, because for the last four days Philadelphia has not updated its numbers. And as the largest county by far in the state, it’s shifts can swing the overall state numbers.

Credit for the piece is mine.

Covid Update: 23 May

Last week I wrote about how we were seeing new cases continuing to rapidly decline. This week we can say cases are still declining, but perhaps a bit less rapidly than earlier.

The charts above show that slowdown in the tail at the right of the chart. First some points to note, Delaware reported that several hundred cases had not been entered into their database, and so we saw a one-time spike midweek. But note that after the spike, the numbers continue to trend down. In other words, the rapid decline was probably a bit less rapid than we saw, but it was still a decline.

Pennsylvania’s chart has a problem of your author’s own design. Now that I’m fully vaccinated I was able to leave the flat this weekend and the Pennsylvania data wasn’t ready by the time I left on Saturday. But by the Sunday data, it was and so the 2500 new cases is probably split somehow between those days—accounted for by the seven-day average. This points to a broader question for which I do not yet have an answer: as life increasingly returns to normal, how much longer will I continue to update these charts?

I started these graphics as a way for myself to track the spread of the virus in my home state and the state where I still have a large number of friends. At the time, there were few if any visualisations out there doing this. Now most media outlets have them and my work at home led to a similar project at work. The reason I continued to make these was you, my readers here and in other places where I post this work. Your comments, messages, texts, and emails made it clear you valued the work. First, I know there are still many people left to be fully vaccinated, nearly half the population, and due to bias, some of the people most likely to follow these posts are those most likely to get vaccinated as early as possible. But please let me know, readers, if you’re still getting value out of these graphics.

But back to the data, in two of the remaining three states, Virginia and Illinois, we saw numbers continue to decline. New Jersey, however, shows a tail with a slight uptick in the seven-day average of new cases. This will be something I follow closely this coming week.

Deaths finally appear to be dropping.

Not by large numbers, no, but in Virginia and Illinois we saw declines of 5 deaths per day. Pennsylvania was even greater with a decline of 7. We are still above rates we saw last summer, but it does appear that finally we have hit the inflection point we have been waiting for the last several weeks.

Finally we have vaccinations. These charts look at the cumulative number of people fully vaccinated.

Fully vaccinated curves for PA, VA, & IL.

And in that the number keeps going up, and that’s good. But they can also only keep going up. But if you look closely at the right tail of the curve, you begin to see it flattening out as the rate of daily vaccinations begins to drop. Unfortunately we’re well below levels we think we’d need for herd immunity. But, to try and look at the positive, we’re almost halfway there and that is certainly playing a role as we can see with the rapid decline in numbers of new cases. But we need to keep trying to get more people vaccinated.

Credit for the piece is mine.

Some Data on Deaths in Gaza and Israel

I’ve seen an uptick in traffic to the blog the last few days, specifically my older content on the Middle East. I don’t exactly have the bandwidth to track the conflict between Israel and Gaza in addition to Covid-19 and my other projects. But as we approached the ten-day mark since Hamas first fired rockets into Israel, I wanted to get a sense of the death toll and so here we are.

The biggest thing to note is that we should take all this data with a grain of salt. For example, the Israeli Defence Force will likely talk up the effectiveness of its Iron Dome air defence system and downplay total civilian deaths. Conversely, Hamas will likely talk up civilian deaths while not detailing at all the deaths of its fighters. And when it comes to deaths in Gaza, it’s not clear what share of those reported by civilian authorities, i.e. the hospital systems, are militant fighters vs. civilians.

Not at all covered by any of this is a discussion of the opportunity costs involved, particularly when it comes to Israeli air strikes. For example, if a Gaza household contains a known Hamas fighter, one can certainly regret an Israeli drone strike that kills the fighter and his non-combatant son whilst in a field. But that strike may be a better outcome than striking the fighter’s home and along with killing not just him and his son, but now his wife, daughters, and the rest of his family.

Credit for the piece is mine.

Baseball’s Injury Problem

Last week, Ken Rosenthal of the Athletic wrote an article examining the recent spate of injuries in Major League Baseball. For those interested in the sport, the article is well worth the read. For the unfamiliar, baseball played only about 1/3 of the number of games as usual last year due to Covid-19. This year, pitcher after pitcher seems to be falling prey to arm troubles. Position players are straining hamstrings, quads, and other muscles I’ve never heard of let alone used over the last year. And joking aside, therein is thought to be the problem.

And the evidence, in part, shows that we are seeing an increase in the numbers of injuries. But 2020 may not be as much of a problem as youngsters throwing baseballs near 100 mph. But I digress. The article contained a table detailing the numbers of injuries for certain body parts in the first month (April) of the season in both 2021 and 2019, the last comparable season due to Covid-19.

To be fair, the table was nice, but in the exhaustion of post-second dose shot last weekend, I sketched out some things and decided to turn it into a proper post.

Credit for the piece is mine.

Covid Update: 9 May

Last week I wrote about how, for new cases, we had seen a few consecutive days of increasing cases. Were we witnessing an aberration, a one-off “well, that was weird”? Or was this the beginning of a trend towards increasing new cases?

A week later and we have our answer. Just a one-off.

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

If we focus on just the seven-day average, in just one week the numbers in New Jersey have fallen by half. In Pennsylvania, Virginia, it’s by one quarter. Illinois is a little less than that, as is Delaware. Across the board, numbers are falling and falling quickly.

When we move to deaths, we’re beginning to see an improvement. As the lagging indicator, we would expect these to begin to drop a few weeks after new cases begin to drop. We have begun to see what might be the peaks of deaths in a few states.

Full vaccination curves for PA, NJ, DE, VA, & IL.

Over this coming week, I’ll be closely watching these numbers to see if we can finally begin to say authoritatively that deaths are in decline.

Vaccinations drive all of this. And we continue to see the total number of fully vaccinated people climbing in Pennsylvania, Virginia, and Illinois. But, that rate is slowing down. Most likely we are entering a phase where those eager for their shots have largely received them. Now begins the challenge of vaccinating those who might lack easy access or have reservations.

But to be clear, we need those people to become fully vaccinated before we can truly begin to return to normal. Whatever normal is. It’s hard to remember anymore.

Credit for the piece is mine.