Name: Game Of Thrones
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Game Of Thrones

Context

Game of Thrones is a hit fantasy tv show based on the equally famous book series "A Song of Fire and Ice" by George RR Martin. The show is well known for its vastly complicated political landscape, large number of characters, and its frequent character deaths.

Content

Of course, it goes without saying that this dataset contains spoilers ;)

This dataset combines three sources of data, all of which are based on information from the book series.

Firstly, there is battles.csv which contains Chris Albon's "The
War of the Five Kings" Dataset. Its a
great collection of all of the battles in the series.
Secondly we have character-deaths.csv from Erin Pierce and Ben
Kahle. This dataset was created as a part of their Bayesian Survival
Analysis.
Finally we have a more comprehensive character dataset with
character-predictions.csv. It
includes their predictions on which character will die.

Acknowledgements

Firstly, there is battles.csv which contains Chris Albon's "The
War of the Five Kings" Dataset, which can be found here:
https://github.com/chrisalbon/war_of_the_five_kings_dataset . Its a
great collection of all of the battles in the series.
Secondly we have character-deaths.csv from Erin Pierce and Ben
Kahle. This dataset was created as a part of their Bayesian Survival
Analysis which can be found here:
http://allendowney.blogspot.com/2015/03/bayesian-survival-analysis-for-game-of.html
Finally we have a more comprehensive character dataset with
character-predictions.csv. This comes from the team at A Song of Ice and Data who scraped it from http://awoiaf.westeros.org/ . It
also includes their predictions on which character will die, the
methodology of which can be found here:
https://got.show/machine-learning-algorithm-predicts-death-game-of-thrones

Inspiration

What insights about the complicated political landscape of this fantasy world can you find in this data?

Tables

Battles

@kaggle.mylesoneill_game_of_thrones.battles

21.99 kB
38 rows
25 columns

CREATE TABLE battles (
  "name" VARCHAR,
  "year" BIGINT,
  "battle_number" BIGINT,
  "attacker_king" VARCHAR,
  "defender_king" VARCHAR,
  "attacker_1" VARCHAR,
  "attacker_2" VARCHAR,
  "attacker_3" VARCHAR,
  "attacker_4" VARCHAR,
  "defender_1" VARCHAR,
  "defender_2" VARCHAR,
  "defender_3" VARCHAR,
  "defender_4" VARCHAR,
  "attacker_outcome" VARCHAR,
  "battle_type" VARCHAR,
  "major_death" DOUBLE,
  "major_capture" DOUBLE,
  "attacker_size" DOUBLE,
  "defender_size" DOUBLE,
  "attacker_commander" VARCHAR,
  "defender_commander" VARCHAR,
  "summer" DOUBLE,
  "location" VARCHAR,
  "region" VARCHAR,
  "note" VARCHAR
);

Character Deaths

@kaggle.mylesoneill_game_of_thrones.character_deaths

24.03 kB
917 rows
13 columns

CREATE TABLE character_deaths (
  "name" VARCHAR,
  "allegiances" VARCHAR,
  "death_year" DOUBLE,
  "book_of_death" DOUBLE,
  "death_chapter" DOUBLE,
  "book_intro_chapter" DOUBLE,
  "gender" BIGINT,
  "nobility" BIGINT,
  "got" BIGINT,
  "cok" BIGINT,
  "sos" BIGINT,
  "ffc" BIGINT,
  "dwd" BIGINT
);

Character Predictions

@kaggle.mylesoneill_game_of_thrones.character_predictions

94.49 kB
1,946 rows
33 columns

CREATE TABLE character_predictions (
  "s_no" BIGINT,
  "actual" BIGINT,
  "pred" BIGINT,
  "alive" DOUBLE,
  "plod" DOUBLE,
  "name" VARCHAR,
  "title" VARCHAR,
  "male" BIGINT,
  "culture" VARCHAR,
  "dateofbirth" DOUBLE,
  "dateofdeath" DOUBLE,
  "mother" VARCHAR,
  "father" VARCHAR,
  "heir" VARCHAR,
  "house" VARCHAR,
  "spouse" VARCHAR,
  "book1" BIGINT,
  "book2" BIGINT,
  "book3" BIGINT,
  "book4" BIGINT,
  "book5" BIGINT,
  "isalivemother" DOUBLE,
  "isalivefather" DOUBLE,
  "isaliveheir" DOUBLE,
  "isalivespouse" DOUBLE,
  "ismarried" BIGINT,
  "isnoble" BIGINT,
  "age" DOUBLE,
  "numdeadrelations" BIGINT,
  "booldeadrelations" BIGINT,
  "ispopular" BIGINT,
  "popularity" DOUBLE,
  "isalive" BIGINT
);