How Are Officers Dying in the Line of Duty

Lately we have seen a few incidents of violence amid the large mass of peaceful protests in Kenosha, Wisconsin and other places across the United States. With death on both sides of the protest line, the situation risks devolving into chaos. Though the governor of Wisconsin has sent in National Guard troops (with some additional units later dispatched by the President) to tamp down on the violence, the threat of chaos remains. And sadly the President admitted during a television interview last night that his trip later today to Kenosha is meant to drive up the enthusiasm for one side of those protest line.

Another element that the President also adds when discussing this law and order theme is the threat to the rank and file law enforcement officers in the line of duty. And there have been incidents of violence. As Vice President noted in his acceptance speech at the Republican Convention last week, a federal law enforcement officer died in Oakland, California at the hands of a protestor. Interestingly, while Pence implied that the protestor was from the left, that particular alleged murderer was actually from a right-wing anti-government group. But the point here is to acknowledge that law enforcement officers in the line of duty to face certain threats.

However, is the threat of dying from a protest turned violent the most dangerous threat?

No, it isn’t.

Data from the Officer Down Memorial Page, which tracks the deaths in the line of duty for officers across the United States, shows that there is one threat that has killed more than 3-times as many LEOs as has gunfire. What is it? What else could it be? Covid-19.

So remember as the President speaks in Kenosha today about the dangers posed to law enforcement that yes, there have been a few incidents of violence directed at law enforcement in protests turned violent. But that the violence has not all been from the left, but also from the right.

And more importantly, the biggest threat to law enforcement remains that which is the biggest threat to all Americans: Covid-19.

Credit for the piece is mine.

Big Bar Chart Better

Today isn’t a Friday, but I want to take a quick look at something that made me laugh aloud—literally LOL—whilst simultaneously cringe.

Not surprisingly it has to do with Trump and data/facts.

This all stems from an interview Axios’ Jonathan Swan conducted with President Trump on 28 July and that was released yesterday. I haven’t watched the interview in its entirety, but I’ve seen some excerpts. Including this gem.

It’s eerily reminiscent of a British show called The Thick of It written by Armando Iannucci or probably more accurately an interview out of one his earlier works with Chris Morris, On the Hour or The World Today. He later went on to create Veep for American audiences, based loosely or inspired by the Thick of It, but I found it a weak substitute for the original. But I digress.

In that clip, the President talks about how he looks at the number of deaths as a share of cases, the case fatality rate, whilst Swan is discussing deaths as a share of total population, deaths per capita. Now the latter is not a great data point to use, especially in the middle of the pandemic, because we’re not certain what the actual denominator is. I’ve discussed this before in some of my “this is not the flu” posts where the case fatality rate, sometimes more commonly called simply the mortality rate, was in the 3–5% range.

Regardless of whether or not one should use the metric, here is how the President visualised that data.


Four big and beautiful bar charts. The best charts.

The President claims the United States “Look, we’re last. Meaning we’re first. We have the best. Take a look again, it’s cases [it’s actually still the case mortality rate]. And we have cases because of the testing.”

The problem is that one, it’s the wrong metric. Two, the idea that testing creates cases is…insane. Third, the United States is last in that big set of bar charts. Why is every country a different colour? In the same data series, they should all be the same, unless you’re encoding a variable such as, say, region via colour. But with four data points, a bar chart taking up the entirety of a US-letter sized paper is grossly inefficient.

But that’s not even the full picture. Because if you look at a more robust data set, this one from Our World in Data, we get a better sense of where the United States sits.


Still not the highest on the chart, true. But even in this set; Norway (of not a shithole fame), India, South Korea, New Zealand, South Africa, and Congo all rank lower. The United States is far from last. And for those wondering, yes, I took the data from the same date as the interview.

There’s another clip within that clip I linked to earlier that deals with South Korea’s numbers and how the President says we “don’t know that”. And this is the bigger problem. We all know that data can be manipulated. But if we cannot agree that the data is real, we cannot have a framework for a real discourse on how to solve very real problems.

As someone who works with data to communicate information or stories on a near daily basis, this is just frightening. It’s as if you say to me, the sky is a beautiful shade of blue today without a cloud in the sky and I reply, no, I think it’s a foreboding sky with those heavy clouds of green with red polka dots. At that point we cannot even have a discussion about the weather.

And it’s only Tuesday.

Credit for the Trump graphic goes to somebody in the White House I assume.

Credit for the complete graphics goes to Our World in Data.

Trump’s Executive Time

Tonight President Trump will give his State of the Union address, the annual speech about the president’s goals and agenda. Today I have a work meeting about management practices. So when I read this piece yesterday by Axios on Trump’s schedule (from a leak of November and December dates), I figured what better piece to highlight here on Coffeespoons.

All the orange…
All the orange…

To be fair, the concept is pretty straightforward. We have a stacked bar chart with each type of time block represented by a colour. Because the focus of the piece is the Executive Time blocks, I really think the designer did a great job summing the other types of time, e.g. travel and meetings, into one bin. And by being a lighter colour on nearly the same scale as the grey, it helps the orange Executive Time pop. Clearly Executive Time dominates the schedule, which as many analysts have been pointing out, is a departure from recent past presidents.

And, if you’re curious how the time blocks compare, elsewhere in the piece is a stacked bar chart summing all the types of time. Not surprisingly, most of his schedule is Executive Time.

Credit for the piece goes to Lazaro Gamio.

A Look Back

Well, we are one day away now. And I’ve been saving this piece from the New York Times for today. They call it simply 2016 in Charts, but parts of it look further back while other parts try to look ahead to new policies. But all of it is well done.

I chose the below set of bar charts depicting deaths by terrorism to show how well the designers paid attention to their content and its placement. Look how the scale for each chart matches up so that the total can fit neatly to the left, along with the totals for the United States, Canada, and the EU. What it goes to show you is best summarised by the author, whom I quote “those 63 [American] deaths, while tragic, are about the same as the number of Americans killed annually by lawn mowers.”

Deaths by terrorism
Deaths by terrorism

I propose a War on Lawn Mowers.

The rest of the piece goes on to talk about the economy—it’s doing well; healthcare—not perfect, but reasonably well; stock market—also well; proposed tax cuts—good for the already wealthy; proposed spending—bad for public debt; and other things.

The commonality is that the charts work really well for communicating the stories. And it does all through a simple, limited, and consistent palette.

But yeah, one day away now.

Credit for the piece goes to Steven Rattner.

Trumpland vs. Clintonopolis

I was not sure if I wanted to file this under either my humourous Friday posts or my regular weekday posts, but I ultimately decided to go with the weekly postings. Why?

It’s simply a different way of visualising the election results, by separating the two camps into two separate Americas. One is the geography connected by Trump’s victory, the other are those disconnected cities and geographies united around Clinton. A collection of almost Greek-like city states.





And what I can say as someone who often drove from the Chicago Sea to the Acela Channel, the United States is very much divided by economics and by culture. But in theory that is the great advantage of the pluralist, multicultural society—it allows for all people of all different types to cohabit an entire continent. Well, in theory at least.

Credit for the piece goes to Tim Wallace.

Deportation of Immigrants

Donald Trump announced how he wants to deport 2–3 million undocumented immigrants that have criminal convictions or that belong to gangs. I read up on the issue at FiveThirtyEight and came across the following graphic from the US Immigration and Customs Enforcement (ICE).

The government's chart on deportations
The government’s chart on deportations

However, when I review the graphic, I found it difficult to understand the FiveThirtyEight article’s point that President Obama has lessened the focus on deportation, but those deported are those convicted of serious criminal offences. So I expanded the size of the y-axis and broke apart the stacked bar chart to show the convicted criminals vs. the non-criminal immigration violators. This graphic more clearly shows the dramatic falloff in deportations, and the emphasis on those with criminal convictions.

A general decline in deportations has also seen a focus on convicted criminals over non-criminal immigration violators
A general decline in deportations has also seen a focus on convicted criminals over non-criminal immigration violators

Credit for the original goes to the graphics department of the US Immigration and Customs Enforcement. The other one is mine.