charting – Page 8 – Coffee Spoons

Redaction Action

Last week, the Department of Justice released the Mueller Report. It was—and still is—sort of a big deal. But this week I want to take a look at a few different approaches to covering the report in the media. We will start with a piece from Vox on the redactions in the report. After all, we only know what we know. And we know there is about 7% of the report we do not know. And we do not know what we do not know.

7% is still a fair amount of black when it's concentrated in one section. — 7% is still a fair amount of black when it’s concentrated in one section.

The above graphic looks at overall redactions as images of each page show how much was withheld from the public. Then we have a small donut chart to show that 7.25% was redacted. Did it need to be a donut? No. A simple factette could have worked in its place. It could be worse, though, it could be a similarly sized pie chart.

The rest of the article moves on to a more detailed analysis of the redactions, by section, type, &c. And this screenshot is one of the more interesting ones.

Fundamentally we have stacked bars here, with each section’s redactions per page broken down by type. And that is, on the one hand, useful. Of course, I would love to see this data separated out. That is, show me just “investigative technique” and filter out the rest. Imagine if instead of this one chart we had four slightly smaller ones limited to each type of redaction. Or, if we kept this big one and made four smaller ones showing the redaction types.

Overall the article does a really nice job of showing us just what we don’t know. Unfortunately, we ultimately just don’t know what we don’t know.

Credit for the piece goes to Alvin Chang and Javier Zarracina.

The Rise of White Nationalist Terrorism

Whilst I was on holiday, a terrorist killed nearly fifty people in Christchurch, New Zealand. Except this time, he was a white man and the victims were all Muslims. Admittedly, I really did not read much about it until I returned to the States, but it clearly is not a thing I was expecting out of New Zealand. But the Economist looked at the question of whether this shooting is more of another in a pattern or a one-off.

The graphic does a fairly good job of showing the increasing frequency of right-wing/white nationalist terror attacks. From a design standpoint, the nice touch is the use of transparency to show overlapping events. For example, the concentric circles for Utoya and Oslo show the two Anders Breivik attacks in Norway.

You could arguably say the treatment begins to fail, however, in the US/Canada timeline. Here, regrettably, there are often too many attacks in too close proximity that the dots are too overlaid. Here I wonder if some other method of stacking or offsetting the incidents could work.

Credit for the piece goes to the Economist data team.

Angry Birds? Bad Birds

Baseball is almost upon us. And oh boy do the Baltimore Orioles look bad. How bad? Historically bad. FiveThirtyEight went so far as to chart the expected WAR, wins above replacement, of each position of all teams since 1973. And the expected Orioles lineup looks remarkably bad.

What is nice about this graphic is the use of the medium grey for each team/year combination. I may have used a filled orange dot instead of open, but the dots do at least standout and show the poor positioning of just about everything but the second baseman.

Credit for the piece goes to the FiveThirtyEight graphics department.

The Stunted Growth of North Korea

This piece from the BBC is a few years old, but it provides some interesting nuggets about North Korea. Unsurprisingly it appeared on my radar because of the coverage of the Trump–Kim summit in Vietnam. The article says it is nine charts that tell you all you need to know about North Korea. Now, I do not think that is quite true, but it does contain the following graphic—I hesitate to call it a chart—that illustrates one of my favourite details.

It's just a matter of inches — It’s just a matter of inches

The two figures illustrate the average height of a person from North Korea and then South Korea. What do you see? That the North Korean is shorter. This is despite the fact that the populations were the same just a few decades ago. The impact of years of malnutrition, undernourishment, and general lack of well-being have manifested themselves in the physical reduction of size of human beings compared to their nearly identical population to the south.

Thankfully the rest of the piece contains data on things like GDP, birth rates, and life expectancy. So there are some things in there that one should know about North Korea. As much as I find the story of height interesting, I struggle to think it is one of the nine things you should really know about the state.

Credit for the piece goes to Mark Bryson, Gerry Fletcher, and Prina Shah.

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.

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 Not so Dry January

January has ended, and with it for, apparently, a very few Britons, Dry January. The Economist looked at alcohol consumption, using a proxy of beer sales, and compared that against the number of times people searched for “Dry January” on Google.

What I really like about this chart is that it does not try to combine the two series into one. Instead, by keeping the series separate on different plots, the reader can clearly examine the trends in both searches and consumption.

You also run into the problem of how to overlay two different scales. By placing one line atop the other, the user might implicitly understand that as higher or better than the lower series when, one, that may not be true. Or, two, the scales are so different they prevent the direct comparison the chart would otherwise imply as possible.

Here, the designers rightly chose to separate the two plots, and then highlighted the month of January. (I also enjoy the annotation of the World Cup.) I might have gone so far as to further limit the palette and make both series the same colour, but I understand the decision to make them distinct.

But, overall, as the piece points out, drinking in Britain seems to correlate to the weather/temperature. People go out to the pubs more on warmer days than colder. But regardless of any post-holiday hangover, they still consumer beer in January.

I’ll drink to that.

Credit for the piece goes to the Economist Data Team.

Cold, Dangerous Cold

It’s cold out in Chicago. And not just the usual winter cold, but record-setting cold. And when the temperature gets that low, when you mix in a little bit of wind, it can become dangerous very quickly. In an article about the weather conditions in the Midwest, the BBC included this graphic at the end.

You don't want to be in the lower right — You don’t want to be in the lower right

Even the slightest bit of wind decreases the time one has before frostbite sets in. So wrap up and stay warm, everyone.

Credit for the piece goes to the BBC graphics department.

Border Arrests

We move from one manufactured crisis to another today as we look at a piece by the Economist on the number of illegal immigrants arrested at the US southern border. Lately, here in the United States we have been hearing of an invasion on our southern border. Illegal immigrants streaming across the border. Except, that is not true. In fact, illegal immigration is at or near its lowest rate in recent years.

Note how few there have been in recent years…

The graphic does one thing really well and that is its unorthodox placement of the map. Instead of the usual orientation, here the designers chose to “tilt” the map so that the border segments roughly align with the sets of charts below them. I might have desaturated the map a little bit and cut off the gradient so Mexico does not bleed through underneath the bars, but the concept overall is really nice.

On the other hand, we have the bar charts arranged like funnels. This does allow the reader to see the slopes trending towards zero, however, it makes it incredibly difficult to see changes in smaller numbers. And without a scale on the axis, the reader has to take the bars and mentally transpose them on top of the grey bars in the bottom right corner. I wonder if a more traditional set of bar charts in small multiples could have worked better beneath the map.

Overall, however, I really do like this piece because of the way the map and the bar charts interact in their positioning.

Credit for the piece goes to the Economist Data Team.

The World Grows On and On

I mentioned this this time last year, but I used to make a lot of datagraphics about GDP growth. The format here has not changed and so there is nothing new to look at there. But, the content is still interesting. And the accompanying Economist article makes the point that high growth rates are not always what they seem. After all, Syria’s high growth rate is because its base is so small.

Credit for the piece goes to the Economist Data Team.

PECO Outages Five Years Ago

Christmas time is a time when people receive gifts. Well this year was no different and I received a few. One, however, was in a box stuffed with old newspaper pages. And it turns out one of said pages had a graphic on it. So let us spend today looking at this little blast from the past.

The piece looks at PECO outages, PECO being the Philadelphia region’s main electricity supplier. The article is full page and is both headed and footed with photography, the graphic in which we are interested sits centre stage in the middle of the page.

Overall the graphic is fairly compact and works well at showing the distribution of the outages, which the bar chart below the choropleth shows was historically significant. (Despite my years in Chicago, I was somehow in the area for all but the storm written about and can confirm that they were, in fact, disruptive.)

The choropleth works, but I question the colour scheme. The bins diverge at about 50%, which to my knowledge marks no special boundary other than “half”. If that yellow bin represented, say, the average number of outages per storm or the acceptable number of outages per storm, sure, I could buy it. Otherwise, this is really just degrees of severity along one particular axis. I would have either kept the bins all red or all blue and proceeded from a light of either to a dark of either.

I probably would have also dropped Philadelphia entirely from the map, but I can understand how it may be important to geographically anchor readers in the most populous county to orientate themselves to a story about suburbia.

Lastly, I have one data question. With power lines down during an ice storm, I would be curious to see less of the important roadways as the map depicts and other variables. What about things like average temperature during the storm? Was the more urban and built-up Delaware County less susceptible because of an urban heat bubble preventing water from freezing? Or what about trees? Does the impact in the more rural areas have anything to do with increasing numbers of trees as one heads away from the city?

Those last data questions were definitely out of scope for the graphic, but I nevertheless remain curious. But then again, this piece is almost five years old. Just a look at how some graphical forms remain in use because of their solid ability to communicate data. Long live the bar chart. Long live the choropleth.

Credit for the piece goes to the Philadelphia Inquirer graphics department.