Chess Lakehouse Is it a dataset, a data warehouse or a data lake? It's a lakehouse 🏠🏞️🛶 Versions Lichess's openings dataset: 2026 01 05 Lumbras Gigabase: 2026 03 03 duckdb chess extension: 0.6.0 Process Pipeline process: https://github.com/dotneB/chess lakehouse Uses DVC Data sources: Lumbras Gigabase PGNs Use DuckDB chess extension (source) to parse PGN into duckdb Export to Parquet to a Schema similar to Lichess games datasets. Dataset Enrichment Eco, Opening: Uses Lichess's openings dataset to resolve Eco and Opening fields. UTCDate: Uses the first, most complete date value that exists, with the following fallback chain UTCDate Date EventDate Some dates are incomplete/placeholder. Unknown month/day ?? become 01: 2000.??.?? 2000 01 01 , 2000.06.?? 2000 06 01 Out of range day is clamped to month end when year/month are valid: 2015.11.31 2015 11 30 , 1997.02.29 1997 02 28 TimeControl: A best effort lenient parsing: 40/5400+30:1800+30 Lenient shorthands: 3+2 180+2 , 75 30 4500+30 , 15 + 10 900+10 Apostrophe forms: 10'+5'' 600+5 , 3' + 2''/mv from move 1 180+2 Free text: 3 mins + 2 seconds increment 180+2 , 90 minutes for 40 moves + 30 minutes for the rest + 30 seconds per move fr…
We use cookies for essential functionality and analytics. You can accept or reject analytics cookies.Cookie policy