We found this amazing dataset of Game of Thrones on Kaggle . People there have done a great job collecting data on the series. We wanted to explore that a bit with our data visualization tool. Here we have some insights on Game of Thrones through some charts and graphs. Enjoy and click at “try now” at the end of article to explore the data yourself.
Let’s first look at what type of battles there have been on Game of Thrones and how successful the attackers have been in each of them. Interestingly it seems that the attacking party has always done exceptionally well regardless of the type of the battle while defenders have had the most victories in pitched battles and even then winning only 29% of those battles. If we take a closer look at the losses by attackers we can see that these losses are divided as follows: 2 to Robb Stark (against Joffrey/Tommen Baratheon), 2 Stanis Baratheon (against Robb Stark & Mance Ryder), and one loss for Joffrey/Tommen Baratheon against Robb Stark.
But could it be that they’ve just been doing more attacks, which leads to more attack losses? In fact as we can see from the chart below, most of the attacks have been made by Joffrey/Tommen Baratheon and Robb Stark and also that most of these fights have been between these two parties.
Another interesting thing in this chart is that Balon / Euron Greyjoy has attacked himself. There must be a perfectly good explanation to this, perhaps they just fought each other? Maybe one of you true fans could shed some light to this at our Facebook pages. What we managed to find out by drilling into the data was the battle name, Sack of Torrhen’s Square.
In addition we can see that Robb Stark has also managed to stay focused on his strategy and kept the attacks on Joffrey/Tommen Baratheon, where as others have been a bit all over the place.
So, how have these two actually performed against each other and what type of strategies have they employed the most? In following charts we’re going to drill into only the battles taking place in between these two parties.
The major difference in strategy is that Robb Stark has employed more ambush attacks against Joffrey/Tommen Baratheon, while Baratheons prefers attacking in pitched battles. When further drilling into data we found out that ambush has never been lost by the attacker. So one would imagine Rob Stark would have more wins. But as we can see from next chart, that’s not the case. So where does he fail?
All the lost battles are pitch battles. When we looked at the numbers of individual battles we found out that in the Battle of the Battle of the Fords the attacker had twice as many troops as defender and still managed to loose it. Also at the Battle of Duskendale Robb Stark only had 3000 men and the data we had did not include information on how many men did the defending side (Joffrey/Tommen Baratheon) have in this battle, maybe you could help us out here by posting numbers or other information you have on our Facebook pages.
Does location make a difference then? Not that much. It seems like most of the fighting has taken place in riverlands and location does not seem to play major role in who’s winning the battles.
We hope you like what we’ve done, you can browse the data and create your own charts by logging in.
- Kaggle (downloaded July 11, 2016)