Lichess/chess-puzzles-with-games

[!CAUTION] This dataset is still a work in progress. Expect breaking changes.

This dataset was contributed by Marco Cognetta. The original archived repository describing the project can be found here: https://github.com/mcognetta/lichess-combined-puzzle-game-db

Background

This contains every puzzle from the Lichess Puzzle Database joined with their games from the Lichess Game Database. The puzzle data was pulled in September 2022. There are 2,969,948 puzzles in total. The game info was pulled from the Lichess API with every flag enabled.

Format

The database is given as a single bzip2 compressed ndjson file. Each line contains a JSON object with two top-level fields: game and puzzle. The game object contains the entire JSON dump of the game information from the Lichess API call with every flag enabled. The puzzle object contains all of the information from the puzzle database entry, with the field names being taken from the csv headers. That is, you can expect the following fields in the puzzle object (though they are not necessarily all populated): PuzzleId,FEN,Moves,Rating,RatingDeviation,Popularity,NbPlays,Themes,GameUrl,OpeningFamily, and OpeningVariation. The games and puzzles are joined by the game id (id in the game object). The matching id is extracted from a puzzle's GameUrl field. Note that PuzzleId and id are unrelated.