Game Of Thrones

Explore deaths and battles from this fantasy world

@kaggle.mylesoneill_game_of_thrones

Table List

3 tables(137.22 KB)

Battles

Character Deaths

Character Predictions

Battles

@kaggle.mylesoneill_game_of_thrones.battles

21.47 KB
38 rows
25 columns

name Name	year Year	battle_number Battle Number	attacker_king Attacker King	defender_king Defender King	attacker_1 Attacker 1	attacker_2 Attacker 2	attacker_3 Attacker 3	attacker_4 Attacker 4	defender_1 Defender 1	defender_2 Defender 2	attacker_outcome Attacker Outcome	battle_type Battle Type	major_death Major Death	major_capture Major Capture	attacker_size Attacker Size	defender_size Defender Size	attacker_commander Attacker Commander	defender_commander Defender Commander	summer Summer	location Location	region Region	note Note
Battle of the Golden Tooth	298	1	Joffrey/Tommen Baratheon	Robb Stark	Lannister	nan	nan	nan	Tully	nan	win	pitched battle	1		15000	4000	Jaime Lannister	Clement Piper, Vance	1	Golden Tooth	The Westerlands	nan
Battle at the Mummer's Ford	298	2	Joffrey/Tommen Baratheon	Robb Stark	Lannister	nan	nan	nan	Baratheon	nan	win	ambush	1			120	Gregor Clegane	Beric Dondarrion	1	Mummer's Ford	The Riverlands	nan
Battle of Riverrun	298	3	Joffrey/Tommen Baratheon	Robb Stark	Lannister	nan	nan	nan	Tully	nan	win	pitched battle		1	15000	10000	Jaime Lannister, Andros Brax	Edmure Tully, Tytos Blackwood	1	Riverrun	The Riverlands	nan
Battle of the Green Fork	298	4	Robb Stark	Joffrey/Tommen Baratheon	Stark	nan	nan	nan	Lannister	nan	loss	pitched battle	1	1	18000	20000	Roose Bolton, Wylis Manderly, Medger Cerwyn, Harrion Karstark, Halys Hornwood	Tywin Lannister, Gregor Clegane, Kevan Lannister, Addam Marbrand	1	Green Fork	The Riverlands	nan
Battle of the Whispering Wood	298	5	Robb Stark	Joffrey/Tommen Baratheon	Stark	Tully	nan	nan	Lannister	nan	win	ambush	1	1	1875	6000	Robb Stark, Brynden Tully	Jaime Lannister	1	Whispering Wood	The Riverlands	nan
Battle of the Camps	298	6	Robb Stark	Joffrey/Tommen Baratheon	Stark	Tully	nan	nan	Lannister	nan	win	ambush			6000	12625	Robb Stark, Tytos Blackwood, Brynden Tully	Lord Andros Brax, Forley Prester	1	Riverrun	The Riverlands	nan
Sack of Darry	298	7	Joffrey/Tommen Baratheon	Robb Stark	Lannister	nan	nan	nan	Darry	nan	win	pitched battle					Gregor Clegane	Lyman Darry	1	Darry	The Riverlands	nan
Battle of Moat Cailin	299	8	Balon/Euron Greyjoy	Robb Stark	Greyjoy	nan	nan	nan	Stark	nan	win	pitched battle					Victarion Greyjoy	nan	1	Moat Cailin	The North	nan
Battle of Deepwood Motte	299	9	Balon/Euron Greyjoy	Robb Stark	Greyjoy	nan	nan	nan	Stark	nan	win	siege			1000		Asha Greyjoy	nan	1	Deepwood Motte	The North	nan
Battle of the Stony Shore	299	10	Balon/Euron Greyjoy	Robb Stark	Greyjoy	nan	nan	nan	Stark	nan	win	ambush			264		Theon Greyjoy	nan	1	Stony Shore	The North	Greyjoy's troop number based on the Battle of Deepwood Motte, in which Asha had 1000 soldier on 30 longships. That comes out to ~33 per longship. In the Battle of the Stony Shore, Theon has 8 longships, and just we can estimate that he has 8*33 =265 troops.


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
);