Online Chess Games
Data for 20,000+ chess games played on Lichess, including moves, victor and more
@kaggle.mysarahmadbhat_online_chess_games
Chess Games
@kaggle.mysarahmadbhat_online_chess_games.chess_games
- 3.54 MB
- 20058 rows
- 17 columns
game_idGame Id | ratedRated | turnsTurns | victory_statusVictory Status | winnerWinner | time_incrementTime Increment | white_idWhite Id | white_ratingWhite Rating | black_idBlack Id | black_ratingBlack Rating | movesMoves | opening_codeOpening Code | opening_movesOpening Moves | opening_fullnameOpening Fullname | opening_shortnameOpening Shortname | opening_responseOpening Response | opening_variationOpening Variation |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 13 | Out of Time | White | 15+2 | bourgris | 1500 | a-00 | 1191 | d4 d5 c4 c6 cxd5 e6 dxe6 fxe6 Nf3 Bb4+ Nc3 Ba5 Bf4 | D10 | 5 | Slav Defense: Exchange Variation | Slav Defense | nan | Exchange Variation | |
| 2 | true | 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 | 4 | Nimzowitsch Defense: Kennedy Variation | Nimzowitsch Defense | nan | Kennedy Variation |
| 3 | true | 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 | 3 | King's Pawn Game: Leonardis Variation | King's Pawn Game | nan | Leonardis Variation |
| 4 | true | 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 | 3 | Queen's Pawn Game: Zukertort Variation | Queen's Pawn Game | nan | Zukertort Variation |
| 5 | true | 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 | 5 | Philidor Defense | Philidor Defense | nan | nan |
| 6 | 5 | Draw | Draw | 10+0 | trelynn17 | 1250 | franklin14532 | 1002 | e4 c5 Nf3 Qa5 a3 | B27 | 4 | Sicilian Defense: Mongoose Variation | Sicilian Defense | nan | Mongoose Variation | |
| 7 | true | 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 | 10 | Blackmar-Diemer Gambit: Pietrowsky Defense | Blackmar-Diemer Gambit | nan | Pietrowsky Defense |
| 8 | 9 | Resign | Black | 15+30 | daniel_likes_chess | 1413 | soultego | 2108 | e4 Nc6 d4 e5 d5 Nce7 c3 Ng6 b4 | B00 | 5 | Nimzowitsch Defense: Kennedy Variation | Linksspringer Variation | Nimzowitsch Defense | nan | Kennedy Variation | |
| 9 | true | 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 | 6 | Italian Game: Schilling-Kostic Gambit | Italian Game | nan | Schilling-Kostic Gambit |
| 10 | true | 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 | 4 | Scandinavian Defense: Mieses-Kotroc Variation | Scandinavian Defense | nan | Mieses-Kotroc Variation |
CREATE TABLE chess_games (
"game_id" BIGINT,
"rated" BOOLEAN,
"turns" BIGINT,
"victory_status" VARCHAR,
"winner" VARCHAR,
"time_increment" VARCHAR,
"white_id" VARCHAR,
"white_rating" BIGINT,
"black_id" VARCHAR,
"black_rating" BIGINT,
"moves" VARCHAR,
"opening_code" VARCHAR,
"opening_moves" BIGINT,
"opening_fullname" VARCHAR,
"opening_shortname" VARCHAR,
"opening_response" VARCHAR,
"opening_variation" VARCHAR
);