Where Trump Has Travelled

Okay, not entirely. But Bloomberg put together a solid series of graphics tracking not the travels of Donald Trump, but his private aircraft. But that information can serve as a rough proxy for Trump’s travels. But the data is not complete—Russia is missing from the map though he has visited the country for business.

Where Trump's private aircraft flew
Where Trump’s private aircraft flew

Credit for the piece goes to Vernon Silver, Michael Keller, and Dave Merrill.

The United States of Misspelled Werds

The National Spelling Bee was this week and Google produced a map of the words each state seeks the most help spelling goodly.

Naturally, there was a misspelling in their own graphic—unfortunately I do not have an image of that, but trust me they misspelled ninety as nintey in Maryland.

Wisconsin, you need help.

To be fair, it would take me a little while to sound out supercalifragilisticexpialidocious.
To be fair, it would take me a little while to sound out supercalifragilisticexpialidocious.

Credit for the piece goes to Googel.

Energy Production in Pennsylvania

Pennsylvania was the country’s first state to operate a nuclear power plant for electricity generation and is today the second-largest nuclear-generated electricity state after Illinois. But in recent years the triple threat of the Pennsylvania Marcellus Shale natural gas boom, wind power subsidies, and solar power subsidies have hit the state’s nuclear industry hard. Consequently the power company Exelon has announced plans to shutdown the generating station at Three Mile Island—yes, that Three Mile Island—in 2019 if Pennsylvania does not rescue the industry as have the states of Illinois and New York, each facing similar challenges.

I wanted to take a look at the electricity generated by nuclear power in Pennsylvania, but had to settle for energy produced. And while the data was only as recent as 2014, it did extend back to 1960 thereby dating back almost as far back as nuclear power in Pennsylvania—it began in 1957.

The subject has always been of interest to me and was the focus of one of my first data visualisation pieces back at university. And so while the data is not quite the same, nor over the same geographic area, it is interesting to see the spike since even 2008. (Worth noting that even in a coal state the long, slow decline of coal even before President Obama is self-evident.)

The rise of Marcellus Shale natural gas has been quick and dramatic
The rise of Marcellus Shale natural gas has been quick and dramatic

Unfortunately the EIA data came through a .pdf and not a more accessible data file so I spent most of my time recreating the data. Consequently, I had little time to do more than track these changes. But even still, I think you would agree the message is clear: natural gas has quickly disrupted the market. (Let’s again ignore the fact I could not plot renewable energy sources.)

Small disclaimer I suppose, I have always supported nuclear power as part of a non-carbon energy portfolio. But I also grew up within sight of and fascinated by the Limerick Generating Station steam clouds, so call me biased.

Credit for this graphic is mine.

Traffic Accidents in Philadelphia

I’m working on a set of stories and in the course of that research I came across this article from Philly.com exploring traffic accident in Philadelphia.

Lots of red there…
Lots of red there…

The big draw for the piece is the heat map for Philadelphia. Of course at this scale the map is pretty much meaningless. Consequently you need to zoom in for any significant insights. This view is of the downtown part of the city and the western neighbourhoods.

A more granular view
A more granular view


As you can see there are obvious stretches of red. As a new resident of the city, I can tell you that you can connect the dots along a few key routes: I-76, I-676, and I-95. That and a few arterial streets.

Now while I do not love the colour palette, the form of the visualisation works. The same cannot be said for other parts of the piece. Yes, there are too many factettes. But…pie charts.


This is the bad kind of pie
This is the bad kind of pie

From a design standpoint, first is the layout. The legend needs to be closer to the actual chart. Two, well, we all know my dislike of pie charts, in particular those with lots of data points, which this piece has. But that gets me to point three. Note that there are so many pieces the pie chart loops round its palette and begins recycling colours. Automotives and unicycles are the same blue. Yep, unicycles. (Also bi- and tricycles, but c’mon, I just want to picture some an accident with a unicycle.)

If you are going to have so many data points in the pie chart, they should be encoded in different colours. Of course, with so many data points, it would be difficult to find so many distinguishable but also not garish colours. But when you get to that point, you might also be at the point where a pie chart is a bad form for the visualisation. If I had the time this morning I would create a quick bar chart to show how it would perform better, but I do not. Trust me, though, it would.

Credit for the piece goes to Michele Tranquilli.

Maps and Legends

First, great song by R.E.M.

Second, you may recall a post last week where I shared some work by FiveThirtyEight about life expectancy. In particular I liked the set of small multiples. However, the New York Times just took what I liked and upped it a slight notch.

Maybe he's caught in the legend…
Maybe he’s caught in the legend…

Every small multiple set needs a legend to explain just what the user is looking at. What the Times did is integrate that legend into the Alaska multiple. And it can do that because of Alaska’s position in the upper-left, or northwest, portion of the “map” as a non-contiguous part of the United States.


Credit for the piece goes to the New York Times graphics department.

Let’s All Shake Hands

So this isn’t exactly an infographic, but it’s still great because it let’s me links to sites with the video. It’s about Donald Trump’s handshakes. If you missed yesterday’s two between him and new French president, Emmanuel Macron, well you missed something.


If you want to see the handshake, you can watch it in the video clip at the end of this article from the Telegraph. It sets the stage for the handshake snub that is at the top of said article.

Happy Friday, all.

Credit for the piece goes to the AFP graphics department.

Philly Falls from Fifth

Well it finally happened. While the Great Recession spared Philadelphia for several years, Phoenix has finally moved up into the rank of fifth-largest city in the United States.

There are some notable differences that this graphic captures. The big one is that Philly is relatively small at 135 square miles. Phoenix is half the size of Rhode Island. What the graphic does not capture, however, is that Philly is still growing, albeit more slowly than southern and western cities. Because also in the news is the fact that Chicago has shrunk and lost people. Personally I count as a -1 for Chicago and a +1 for Philly.

Comparing size and population
Comparing size and population

Credit for the piece goes to the Philly.com graphics department.

Trump’s Polling

My battery is about to die this morning and I don’t have my charger so this is going to be a shorter piece than usual. But I wanted to look back on the 100 Day polling that the New York Times posted. It does paint an interesting picture of somebody so polarising that Trump is probably safe despite being one of the least favourably viewed presidents in modern times. Why? Because his supporters are so fervently loyal.

Not only is Trump low, he's low historically
Not only is Trump low, he’s low historically

But that piece is almost a month old now. And so I wanted to point out something that FiveThirtyEight is doing—a running tracker of Trump’s polling. I am sure I will return to it in the future, after all we have over three and a half years to go until the next four year presidential term begins.

Trump is pretty low…
Trump is pretty low…

Credit for the piece goes to Karen Yourish and Paul Murray for the Times and Aaron Bycoffe, Dhrumil Mehta, and Nate Silver for FiveThirtyEight.

The World’s Fighter Jets

As you know, I am a sucker for military-related things. So here we have a piece from the Wall Street Journal on the leading fighter jets of the world. If you have a bone to pick on which jets were included, please take that up with them and not me.

Of course, speed isn't everything…
Of course, speed isn’t everything…

The screenshot is from the end of an animation where they depict the maximum range and the relative speed of each aircraft against each other.

Credit for the piece goes to Andrew Barnett, Jason French, and Robert Wall.

Life Expectancy in the US and All Its States

Happy Monday, all.

If this week’s news cycle cooperates, I am going to try and catch up on some things I have seen over the last several weeks that got bumped because of, well, Trump usually. Today we start with a piece on life expectancy from FiveThirtyEight.

The piece begins with a standard choropleth to identify, at county levels, pockets of higher mortality. But what I really like is this small multiples map of the United States. It shows the changes in life expectancy for all 50 states. And the use of colour quickly shows, for those states drastically different than the national average, are they above or below said average.

Look at all the little boxes
Look at all the little boxes

Credit for the piece goes to the FiveThirtyEight graphics department.