Chess Game Dataset (Lichess)

20,000+ Lichess Games, including moves, victor, rating, opening details and more

@kaggle.datasnaek_chess

Table List

1 table(3.83 MB)

Games

@kaggle.datasnaek_chess.games

3.83 MB
20058 rows
16 columns

id Id	rated Rated	created_at Created At	last_move_at Last Move At	turns Turns	victory_status Victory Status	winner Winner	increment_code Increment Code	white_id White Id	white_rating White Rating	black_id Black Id	black_rating Black Rating	moves Moves	opening_eco Opening Eco	opening_name Opening Name	opening_ply Opening Ply
TZJHLljE		1504210000000	1504210000000	13	outoftime	white	15+2	bourgris	1500	a-00	1191	d4 d5 c4 c6 cxd5 e6 dxe6 fxe6 Nf3 Bb4+ Nc3 Ba5 Bf4	D10	Slav Defense: Exchange Variation	5
l1NXvwaE	true	1504130000000	1504130000000	16	resign	black	5+10	a-00	1322	skinnerua	1261	d4 Nc6 e4 e5 f4 f6 dxe5 fxe5 fxe5 Nxe5 Qd4 Nc6 Qe5+ Nxe5 c4 Bb4+	B00	Nimzowitsch Defense: Kennedy Variation	4
mIICvQHh	true	1504130000000	1504130000000	61	mate	white	5+10	ischia	1496	a-00	1500	e4 e5 d3 d6 Be3 c6 Be2 b5 Nd2 a5 a4 c5 axb5 Nc6 bxc6 Ra6 Nc4 a4 c3 a3 Nxa3 Rxa3 Rxa3 c4 dxc4 d5 cxd5 Qxd5 exd5 Be6 Ra8+ Ke7 Bc5+ Kf6 Bxf8 Kg6 Bxg7 Kxg7 dxe6 Kh6 exf7 Nf6 Rxh8 Nh5 Bxh5 Kg5 Rxh7 Kf5 Qf3+ Ke6 Bg4+ Kd6 Rh6+ Kc5 Qe3+ Kb5 c4+ Kb4 Qc3+ Ka4 Bd1#	C20	King's Pawn Game: Leonardis Variation	3
kWKvrqYL	true	1504110000000	1504110000000	61	mate	white	20+0	daniamurashov	1439	adivanov2009	1454	d4 d5 Nf3 Bf5 Nc3 Nf6 Bf4 Ng4 e3 Nc6 Be2 Qd7 O-O O-O-O Nb5 Nb4 Rc1 Nxa2 Ra1 Nb4 Nxa7+ Kb8 Nb5 Bxc2 Bxc7+ Kc8 Qd2 Qc6 Na7+ Kd7 Nxc6 bxc6 Bxd8 Kxd8 Qxb4 e5 Qb8+ Ke7 dxe5 Be4 Ra7+ Ke6 Qe8+ Kf5 Qxf7+ Nf6 Nh4+ Kg5 g3 Ng4 Qf4+ Kh5 Qxg4+ Kh6 Qf4+ g5 Qf6+ Bg6 Nxg6 Bg7 Qxg7#	D02	Queen's Pawn Game: Zukertort Variation	3
9tXo1AUZ	true	1504030000000	1504030000000	95	mate	white	30+3	nik221107	1523	adivanov2009	1469	e4 e5 Nf3 d6 d4 Nc6 d5 Nb4 a3 Na6 Nc3 Be7 b4 Nf6 Bg5 O-O b5 Nc5 Bxf6 Bxf6 Bd3 Qd7 O-O Nxd3 Qxd3 c6 a4 cxd5 Nxd5 Qe6 Nc7 Qg4 Nxa8 Bd7 Nc7 Rc8 Nd5 Qg6 Nxf6+ Qxf6 Rfd1 Re8 Qxd6 Bg4 Qxf6 gxf6 Rd3 Bxf3 Rxf3 Rd8 Rxf6 Kg7 Rf3 Rd2 Rg3+ Kf8 c3 Re2 f3 Rc2 Rg5 f6 Rh5 Kg7 Rd1 Kg6 Rh3 Rxc3 Rd7 Rc1+ Kf2 Rc2+ Kg3 …	C41	Philidor Defense	5
MsoDV9wj		1504240000000	1504240000000	5	draw	draw	10+0	trelynn17	1250	franklin14532	1002	e4 c5 Nf3 Qa5 a3	B27	Sicilian Defense: Mongoose Variation	4
qwU9rasv	true	1504230000000	1504230000000	33	resign	white	10+0	capa_jr	1520	daniel_likes_chess	1423	d4 d5 e4 dxe4 Nc3 Nf6 f3 exf3 Nxf3 Nc6 Bb5 a6 Bd3 Bg4 O-O Nxd4 Be2 Nxe2+ Qxe2 Bxf3 Qxf3 Qd4+ Be3 Qg4 Qxb7 Rd8 Qc6+ Nd7 Nd5 e6 Nxc7+ Ke7 Bd2	D00	Blackmar-Diemer Gambit: Pietrowsky Defense	10
RVN0N3VK		1503680000000	1503680000000	9	resign	black	15+30	daniel_likes_chess	1413	soultego	2108	e4 Nc6 d4 e5 d5 Nce7 c3 Ng6 b4	B00	Nimzowitsch Defense: Kennedy Variation \| Linksspringer Variation	5
dwF3DJHO	true	1503510000000	1503510000000	66	resign	black	15+0	ehabfanri	1439	daniel_likes_chess	1392	e4 e5 Bc4 Nc6 Nf3 Nd4 d3 Nxf3+ Qxf3 Nf6 h3 Bc5 a3 O-O Be3 Bxe3 Qxe3 Re8 Qf3 c6 Nc3 b5 Bb3 Qa5 O-O Bb7 Ne2 c5 Rfd1 d6 c4 bxc4 dxc4 Rac8 Rd5 Bxd5 exd5 Qb6 Nc1 e4 Qf4 Nh5 Qg4 Nf6 Qf4 Qa5 Bc2 Qe1+ Kh2 Nh5 Qxd6 Qxf2 Bxe4 Rxe4 Nd3 Qg3+ Kg1 Qxd3 Rf1 Rce8 Qd7 Qe3+ Kh1 Ng3+ Kh2 Nxf1+	C50	Italian Game: Schilling-Kostic Gambit	6
afoMwnLg	true	1503440000000	1503440000000	119	mate	white	10+0	daniel_likes_chess	1381	mirco25	1209	e4 d5 exd5 Qxd5 Nc3 Qe5+ Be2 Na6 d4 Qf5 Bxa6 bxa6 Nf3 Qe6+ Be3 Bb7 Ng5 Qc4 Qh5 Bxg2 Qxf7+ Qxf7 Nxf7 Kxf7 Rg1 Bf3 Rg3 Bh5 Rh3 g6 Ne4 Nf6 Nc5 e6 Nxa6 Rc8 Bf4 Bg4 Rg3 c6 Nb4 Bxb4+ c3 Ba5 b4 Bc7 Bxc7 Rxc7 Rb1 e5 dxe5 Re8 f4 Rd7 Kf2 Rd2+ Kg1 Rxa2 exf6 Kxf6 Rxg4 Kf5 Rg2 Rxg2+ Kxg2 Re2+ Kf3 Re4 Ra1 Rxf4+ K…	B01	Scandinavian Defense: Mieses-Kotroc Variation	4


CREATE TABLE games (
  "id" VARCHAR,
  "rated" BOOLEAN,
  "created_at" DOUBLE,
  "last_move_at" DOUBLE,
  "turns" BIGINT,
  "victory_status" VARCHAR,
  "winner" VARCHAR,
  "increment_code" VARCHAR,
  "white_id" VARCHAR,
  "white_rating" BIGINT,
  "black_id" VARCHAR,
  "black_rating" BIGINT,
  "moves" VARCHAR,
  "opening_eco" VARCHAR,
  "opening_name" VARCHAR,
  "opening_ply" BIGINT
);