Merging Alaska Airlines and Virgin America

Alaska Airlines and Virgin America made some news the past few days when they announced Alaska would purchase Virgin America for $2.6 billion. I mapped out the flight routes of the two carriers to see where they overlapped. You can see the results in my piece for the blog today below.

A brief look at the merger of Alaska Airlines and Virgin America
A brief look at the merger of Alaska Airlines and Virgin America

Credit for the work is mine, except the underlying map, which I sourced from Brigham Young University Geography Department.

Trump Conservatism

Another Tuesday, more primary and caucus victories for Donald Trump in his quest to become the Republican nominee. However one of the refrains you hear from the right is that he is not a true conservative. How true is that? Well the BBC put together an article comparing Trump to the other candidates and some previous Republican presidents on various issues like foreign policy.

Republicans on foreign policy
Republicans on foreign policy

Okay, so it sort of works with cutout photos of people pasted onto an American flag background. But I cannot quite take the piece seriously because of its amateurish design. Maybe the American flag makes sense as a background graphic? But the heads? Surely not.

So what happens if we take a more serious approach—though I admit originally the idea of a Trump candidacy seemed farcical—to this graphic? Well I took a quick stab this morning.

My take
My take

Credit for the original goes to the BBC graphics department.

Fighting Off My Jet Lag

As I mentioned earlier this week, I visited London for work for a week and then took some rollover holiday time to stay around London and then visit Dublin. But now I am back. And this week that has meant all the jet lag. And while everybody experiences jet lag and recovers from it differently, I wanted to take a look at my experience. The data and such is below. But the basic point, it is about four days before I return to normal.

What is missing, unfortunately, is the Chicago-to-London data. Because anecdotally, that was far, far worse than the return flight.

My sleeping periods are in purple
My sleeping periods are in purple

Credit is my own.

Sugary Sweet Donut Charts

I know, I know. You probably expect some sort of climate post given the whole Paris thing. But instead, this morning I came across an article where the supporting chart failed to tell the story. So today we redesign it.

The BBC has an article about MPs backing a tax on sugary drinks. Within the text is a graphic showing the relative importance of sugary drinks in the sugar consumption of various demographics. Except the first thing I see is alcohol—not the focus of the article. Then I focus on a series of numbers spinning around donuts, which are obviously sugary and bad. Eventually I connect the bright yellow to soda. Alas, bright yellow is a very light colour and fails to hold its own on the page. It falls behind everything but milk products.

The BBC likes sugary donuts
The BBC likes sugary donuts

So here is 15 minutes spent on a new version. Gone are the donuts, replaced by a heat map. I kept the sort of the legend for my vertical because it placed soda at the top. I ran the demographic types horizontally. The big difference here is that I am immediately drawn to the top of the chart. So yeah, soda is a problem. But so are cakes and jams, you British senior citizens. Importantly, I am less drawn to alcohol, which in terms of sugars, is not a concern.

My version of sugar is so much sweeter
My version of sugar is so much sweeter

Credit for the original goes to the BBC graphics department. The other one is mine.

Redesigning the Turkish Election Results

Turkey held its elections over the weekend. And so on the way to work this morning I decided to check the results on the BBC. And I saw this graphic—screenshot from my phone.

The BBC results
The BBC results

So I decided to scrap today’s blog post and instead spend all of five minutes tweaking this to make it a bit clearer. Or, a lot clearer. Simple little tweaks can make all the difference in data clarity. Now you can visually see the scale of difference in the votes. You also don’t need to refer to a legend off to the side with tints of the same colour.

My results with their data
My results with their data

Credit for the original piece goes to the BBC graphics department.

The Spellecy’s Wisconsin Land Grant

I have returned from my trip up north to Minnesota and Wisconsin. Unfortunately, from the research side it was not the most successful of trips. I did find some records, but none that answered any of the big questions I had. If anything, I now have far more questions. Most of the information I learned deals with the homesteaded land that John Spellecy received in 1888, at the young age of 70. It turns out by the time he was given the land by the US government, he had already made one contract to sell a portion of it. And so to make some semblance of it, I made this animation to show how the land grant disappeared over only a 12 year period.

How the Spellecy plot disappeared
How the Spellecy plot disappeared

For the curious, the background image is a digitisation of the US government’s original land survey. The A.160 denotes 160 acres, the maximum allowed by a homestead claim.

Researching the Family History in Ashland, Wisconsin

I’m presently off in the northern reaches of Wisconsin, Ashland in particular, researching part of my family’s history. To aid me in understanding just how this frontier-following family moved over one century, I put together a crude map and a timeline to give me context (and jog my memory) while searching through files in the courthouse.

The movements of the Spellacy family
The movements of the Spellacy family

I am calling the map a migration map. It shows the locations where family members moved to in 1849: Sheboygan (from New Brunswick, Canada). And then how they quickly began to disperse, but slowly head north to Ashland County, before most ultimately headed to the West Coast. (My direct ancestors are that group near the bottom that move back to the in-laws original home of western Massachusetts.)

What I struggle with keeping in mind is that here we are looking at a perfectly rendered and understood map of modern Wisconsin. But in 1849, the state was but one year old and most of the towns to which this family would be going were only a decade or so old and still very much frontier towns without amenities. (Which is why I imagine the women of the family stayed in Milwaukee until the settlements in the north were, well, settled.)

To the right is a timeline. The details are not terribly important and in fact it is poorly designed. But, it was quick to make and will hopefully help me keep the names straight and the places for which I am looking top-of-mind.

Put the two together and you have an example of how I create visualisations for myself just to help me with my own work and research.

Baseball vs. Basketball vs. Hockey

There was an interesting article in Forbes on Monday that looked at baseball’s popularity. In short, the commonly believed argument is that baseball is becoming less popular vs. sports like football, basketball, &c. Hence, one of the reasons for the pace of play changes. However, last Wednesday, there were three nationally televised playoff games—two in basketball and one in hockey—and one nationally televised baseball game, Mets at the Cubs. The logic of the common argument would have non-playoff baseball falling behind the playoff games. But, in 14 of 24 media markets, the local baseball games drew more television viewers than playoff basketball or hockey, or even national baseball games. Unfortunately, the article in question used some really poor graphics to communicate this story. So, I decided to spend my Monday night making it clearer for you. Compare a snippet of the original to mine. You make the call.

The original chart
The original chart
How the local baseball game did against the national sports games
How the local baseball game did against the national sports games

Credit for the original piece goes to the Forbes graphics department.

Amtrak Train No. 188 Derails

I am a big fan of trains, rail transit, and Amtrak. I think the rail network connecting the East Coast’s big cities from Boston down to Washington is one of the big draws of the Northeast. Not surprisingly, I have taken that route I don’t know how many times. So, when Amtrak’s Northeast Regional No. 188 derailed in Philadelphia, it ran off rails with which I am familiar.

I made a graphic tonight—so much for all my other plans—charting and mapping out what was announced by Philadelphia’s mayor, Michael Nutter. I am sure that by the time I wake up in the morning, we will know more and some things will have changed. But, let this be a simple guide to the basics as they were Tuesday night.

Updated graphic
Updated graphic

Frankford Junction is in the Port Richmond area of Philly. And what I can attest is that trains do slow down here, because it is a fairly sharp turn at a fairly flat grade (I think).

Credit for the screenshot map image goes to Google.