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

Character Deaths

@kaggle.mylesoneill_game_of_thrones.character_deaths

23.47 KB
917 rows
13 columns

name Name	allegiances Allegiances	death_year Death Year	book_of_death Book Of Death	death_chapter Death Chapter	book_intro_chapter Book Intro Chapter	gender Gender	nobility Nobility	got GoT	cok CoK	sos SoS	ffc FfC	dwd DwD
Addam Marbrand	Lannister				56	1	1	1	1	1	1
Aegon Frey (Jinglebell)	nan	299	3	51	49	1	1			1
Aegon Targaryen	House Targaryen				5	1	1					1
Adrack Humble	House Greyjoy	300	5	20	20	1	1					1
Aemon Costayne	Lannister					1	1			1
Aemon Estermont	Baratheon					1	1		1	1
Aemon Targaryen (son of Maekar I)	Night's Watch	300	4	35	21	1	1	1		1	1
Aenys Frey	nan	300	5		59		1	1	1	1		1
Aeron Greyjoy	House Greyjoy				11	1	1		1		1
Aethan	Night's Watch					1				1


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