Dataset: Online Chess Games

About this Dataset

Online Chess Games

Data for 20,000+ chess games played on Lichess, including moves, victor, rating, opening details and more.

Recommended Analysis

What percentage of games were won by white? How many ended in a draw?

Which opening move was most frequently used in games in which black won? What about when white won?

What percentage of games are won by the player with the higher rating? Does this vary by piece color?

Which user won the most amount of games? In what percentage of those games was the user the higher rated player?

Tables

Chess Games

@kaggle.mysarahmadbhat_online_chess_games.chess_games

3.54 MB
20058 rows
17 columns


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