Looker is home to many Game of Thrones nerds, and recently we got our hands on some datasets describing the TV show and books. This is Part I of IV posts where we will dive into these datasets and share what we learned from the numbers on our favorite show - Game of Thrones.
There are a fair few resources on George R R Martin’s books (more on that later), but datasets on the TV show were much harder to find. In the end, we landed on two: a dataset on screen time from data.world and deaths in Game of Thrones by Kaggle. With some SQL magic from our analysts, we were able to join the two datasets together, as well as add some extra background from the books fact table. While there were a few limitations with this method, the data mapped surprisingly well between the book series and the TV series.
While simple, episode count and screen time tell us a lot about how the showrunners are thinking about the characters we know and love (or hate).
A character’s time on screen and episode inclusion is no accident. The writers of the show are putting characters in episodes for specific reasons and the amount of time they actually spend on screen is also conscious choice.
These two pieces of information combined with the death data allows us to dig under the surface of the show’s storyline and look for trends and patterns in the show itself, while also examining our own perception of the show and how it differs from what the data shows.
CAUTION : SPOILER ALERT
First, let’s look at Screentime and episode count:
Tyrion is definitely the star of the show - he has both the most episodes AND the most screen time. Now, this isn’t that surprising, until you look at how much of a lead Tyrion has in screen time. He has more than 25 minutes of screen time than the next character and more than 70 minutes more than the third!
The next two screentime leaders are Jon and Daenerys, and they are also tied for episode count. Again, these top three are no surprise (is it a sign?!), but the 47 minute difference between Jon’s and Daenerys’ screen time was really interesting. While Jon has for the most part lead his own story line, Daenerys’ storyline has been entirely her own. This data shows that Jon’s story has been given more screen time than Daenerys’
Cersei, Sansa, and Arya come next - with Cersei only leading Sansa by about a minute. I have always thought of Cersei as being a much larger character than Sansa, but according to screen time, that is not the case. I found this interesting because Cersei feels more important than Sansa throughout the show, with Sansa only really taking control over her story in Season 6. This is a clear juxtaposition of screen time vs. power in the story. Cersei has definitely done more to change the story than Sansa, but they both have had the camera pointed at them for virtually the same amount of time. What does that mean for these two characters from the perspective of the show creators? I don’t know that I have an answer, but I definitely have more questions.
Sansa has more screen time than Arya. Again, I underestimated Ms. Sansa Stark until now. It’s similar to the Jon vs. Dany realization - while Arya has been leading her own story and therefore feeling more powerful and important, the show creators haven’t given it as much time as Sansa’s story.
Ned Stark somehow, comes in at #12 on this list, even though he died in Season 1. His total screen time has gotten some help from return via flashback in Season 6, but even so, he has had more screen time than most of the characters we see today. No wonder his loss in Season 1 was so jarring, he was in practically the whole thing.
Some unintuitive character pairs & groups show up on this list. For example, Theon, Sam are very close to tied in screen time, and Brienne and Davos literally have the same amount of time on screen. Catelynn and Varys are about the same, and Tywin Lannister, Margaery and Robb are all close as well. Ramsay, Melisandre and Bronn are grouped together, and so are Gilly and Ygritte. This doesn’t provide a ton of insight, but it does show us who the show creators think are at similar levels of importance.
Now, if we keep screen time, but sort by episode some new insights show up:
While she may not be on top in screen time, Cersei is second in overall episode count (following her youngest brother, which I’m sure she would just love). This jump is pretty interesting when you consider Cersei’s methods of power in the early seasons. She is mostly working behind the scenes (or not really working at all)
Eddison Tollett is a surprising high ranker in the episode count list. He even has more episodes than Tywin and Podrick! This was especially surprising to me, because I didn’t even know who he was when I first saw his name on the list. I have since looked him up and I’m still surprised.
Missandei has been in a lot of episodes but hasn’t had very much screen time. While her role as Dany’s right hand lady explains her lack of time on screen, her inclusion in so many episodes leads to questions about her role in the show - are they leading up to something?
Varys’ and Pycelle’s high ranking on this list is also telling. We know them both to be “behind the scenes manipulators” so their lack of screen time makes a lot of sense. They are always there but purposefully out of the spotlight...
On the other end of the spectrum, this visualization highlights characters with high screen time but low episodes - Oberyn, Robert Baratheon and Ned Stark to name a few. I’ll talk more about this later on in this post, but it’s clear that “flash in the pan” characters are common in Game of Thrones...
Now let’s move on to the fun stuff - deaths!
Game of Thrones is known for killing off characters, so we examined a dataset that covers all named character deaths and when they happened. Let’s go through a few ways to look at this, starting with Deaths by Season.
Season 3 is the least deadly of the show so far, which is interesting because it had, arguably, the goriest murder scene of main characters in the show (Hi, Red Wedding)
Season 6 was the deadliest season yet… by a lot
But we can also slice this data in other ways - ever wondered which episodes are safest to DVR for Monday and not be ruined by Facebook spoilers? Let’s look at deaths by episode number...
When visualized, the answer to the question is pretty clear: waiting a day on episode 6 is your safest bet, followed by episodes 3 and 8… No promises though, because there has not been a consistently safe episode in the series as a whole
Overall, episode 10 is where we’ve lost the most characters. So don’t miss the finale, or if you have to, turn your eyes away from the internet until you have a chance to watch
A surprising tip from this chart is the spike in deaths in Episode 5. No procrastinating on the midseason episode, my friends!
In looking at deaths, I realized that not every named character death had the same impact on the storyline or our experience as viewers, so I changed my query to look at total screen time of the characters killed off in each season (assuming more screen time = more important, impactful deaths). Check out the new view:
(Note: I removed Jon Snow from this viz. He completely skewed Season 5, and for the purposes of this post, I’m focusing on characters who died and stayed dead)
This visualization challenges the logical assumption that overall, characters killed in later seasons would have more screentime because the show had just been around longer. Instead, it shows a cycle of characters getting very well known very quickly and then getting killed off in the same season or a few seasons later, while still maintaining the core character base. Remember those “flash in the pan” characters I mentioned earlier?
The jump in Season 4 is also notable. While there were fewer deaths in the season, the characters killed had almost the same combined screen time as Season 6
Season 1 killed the same amount of characters as Season 2 but we lost double the screen time (entirely because of Ned Stark)
Season 3 killed far fewer characters than Season 2, but those characters had much more screen time overall (Hi again, Red Wedding), which actually makes it more impactful deathwise
But we can get even more granular here. Let’s break it down by episode:
So far, episode 10 is definitely the deadliest episode, but this a new trend...
Seasons 1-3 were all about killing big characters in Episode 9, but starting in season 4 they started killing everyone in episode 10
In comparison to the rest of the show, Season 2 was very tame
No one of note has died in Episode 6 in the last three seasons
The death story arc changed halfway through the show - in the visualization above, look at how 1-3 compare and then 4-6. In early seasons, they killed very few characters before episode 5, saving them all for the end. As the show goes on, there is a bump from Episode 1-5 that completely ends at Episode 6 and then grows to a peak at Episode 10
Insights from this data range from surprising to mildly interesting, and it all leads to even more questions.
In the next few weeks leading up to the Season 7 premiere on July 17th, we will be diving into different areas of this data on Game of Thrones and looking at the show in new dimensions.
Subscribe to the blog to stay in the know on Looker’s latest posts, both GoT related and otherwise, and if you are interested in seeing what Looker will allow you to uncover in your data you can request a demo here! Thanks for reading :-)
Disclaimer: Game of Thrones belongs to HBO and is not affiliated with Looker in anyway.