Answers.Body: <p>I've downloaded the Lichess database from 2013 to the end of 2022, and counted the final move of all the games, including whether it was a check or checkmate. For space reasons, I processed this in a streaming fashion (i.e not keeping any data after it was downloaded and processed), and I had forgotten to include recording whether the final move was by black or white; the only things I know are the number of games where the final move played was X. It's broken down by month, as well as collected into a grand total.</p>
  <blockquote>
  <p>You can see the raw stats <a href="https://github.com/unchessful-games/game-termination-counter/tree/main/output" rel="noreferrer">on the GitHub repo next to the counting program</a>, and here's a <a href="https://docs.google.com/spreadsheets/d/1W1cDoVRxTNN16BnHvUjlBvjDxhLOlq6Y0LE0deHcfEA/edit" rel="noreferrer">Google Sheet with the final data and some sample calculations</a>.
  In total, there are 4,004,175,546 recorded rated games in this period.</p>
  </blockquote>
  <p>Here are a few highlights:</p>
  <ul>
  <li>Only 26.5% of games ended in a checkmate, with the remaining 15.19% ending with a check and 58.31% with neither; thus, 73.5% of games ended in a timeout, draw or resignation.</li>
  <li>The most popular game terminations are <code>Q(x)g2#</code> and <code>Q(x)g7#</code>: together, these account for a whole 3.03% of games and 11.43% of checkmates.</li>
  <li>Of the checkmates, the most popular one is with the queen: these account for 64.78% of all checkmates. (Note that moving the pawn to the final rank to deliver checkmate counts as a pawn move, not the move of the promoted-to piece.) The other popular option is with the rook, which accounts for another 25.39%. All the other pieces combined account for only 9.83% of checkmates, with a king move only delivering 0.0258% of them (exclusively by means of a discovered attack, because the king itself cannot cause a check).</li>
  <li>32.43% of checkmates were also captures, and this is fairly consistent across the pieces: from 37.16% for the queen to 18.81% for the knight, it seems to hover somewhere around 20-30%. An exception is the king, which already has a rather small number of checkmates, but only 3.87% of those also capture a piece.</li>
  <li>1.88% of checkmates were caused by a promotion, most often  into a queen <code>??=Q#</code> (in 92.25% cases) but occasionally into a rook <code>??=R#</code> (7.53%).</li>
  <li>Checkmating by a castling move is very rare: this only happened 39,026 times in the data, or 0.000974%; and among these, <code>O-O-O#</code> is 67.01% while <code>O-O#</code> is half as frequent with 32.98%.</li>
  <li>There are a lot of extremely rare game endings: there are 2058 different final moves that were each played only once (and 798 of them are checkmates). Most of these seem to be fully-specified: for example, only one game ended in <code>Qe5xd4#</code>. These rare moves account for a substantial amount of my data: I've collected 22661 unique game-ending moves, and there's 5322 (23%) moves that concluded less than 10 games, and 9028 (40%) that finished less than 100 games; and among the latter, there was only 51975 checkmates, which is less than 0.0049% of all recorded checkmates.</li>
  </ul>
  <p>I haven't looked at the squares involved too much, but I imagine that there would be some more insights to be found there.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-03-23T13:22:36.870Z
Answers.Text: Any cases of =N#? And how rare is en passant mate?
Answers.UserDisplayName: Rewan Demontay
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-03-23T16:18:43.157Z
Answers.Text: @RewanDemontay =N# happened 23194 times, or 0.001828% of checkmates. I don't have info on enpassant mates because enpassant is notated as a regular pawn move, and you'd need to know the state of the board before the move to know if it's an enpassant or regular capture.
Answers.UserDisplayName: Danya02
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-03-24T03:49:40.977Z
Answers.Text: Hi Danya02 since you are relatively new, you may be unfamiliar with the meta area where I have posted about the treatment of this question: https://chess.meta.stackexchange.com/questions/1220/questions-inappropriately-closed-are-too-hard-to-reopen
Answers.UserDisplayName: Laska
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-03-24T21:42:51.123Z
Answers.Text: Awesome answer, thanks. Are you missing draws in your 73.5% calculation? Also, is there a way you can share a longer list of the unique game-ending checkmate moves, perhaps with links to the games in question?
Answers.UserDisplayName: Steve Bennett
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-03-24T21:46:49.667Z
Answers.Text: @SteveBennett Like I said, the amount of information in this analysis is very limited, so in order to extract more info than you see in the Google Sheet you'd basically need to rerun the analysis from scratch. I'm currently downloading the Lichess database locally (I bought the HDDs for it), so I can extract more info from it for my own projects, and when that's done I may be able to add more info here.
Answers.UserDisplayName: Danya02
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-03-24T22:46:09.933Z
Answers.Text: So sorry, I completely missed the links. My bad.
Answers.UserDisplayName: Steve Bennett
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-03-23T11:34:02.977Z
Answers.LastActivityDate: 2024-03-24T21:48:49.460Z
Answers.LastEditDate: 2024-03-24T21:48:49.460Z
Answers.UserDisplayName: Danya02
Body: <p>I'm curious what checkmating move is the most common in the Lichess database? That is, the properly algebraically specified move, for a given color, like &quot;White plays Re8#&quot;.</p>
  <p>Answers for other databases are also welcome.</p>
  <p>(I'm guessing that Re8# for white may well be one of the top, as well as Qf7)</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-03-20T01:11:50.890Z
Comments.Text: If you have programming experience, Python has plenty of chess libraries and lichess provides free dumps. If that's not fast enough there's C++ and Rust libraries too.
Comments.UserDisplayName: qwr
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-03-20T10:20:36.190Z
Comments.Text: I'm curious as to why you want this.  In games between decent players (and more so among better ones) an actual checkmate will be pretty rare. So, you will be collecting data mostly on weak players.
Comments.UserDisplayName: Peter Flom
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-03-21T01:45:44.333Z
Comments.Text: Just curiosity. And your observation about checkmate holds true for classical matches between high rated opponents, but decreasingly less so at shorter time controls and lower rated opponents, which makes up the vast majority of the lichess database.
Comments.UserDisplayName: Steve Bennett
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-03-24T03:43:39.133Z
Comments.Text: I have posted in chess meta on this https://chess.meta.stackexchange.com/questions/1220/questions-inappropriately-closed-are-too-hard-to-reopen. Please opine
Comments.UserDisplayName: Laska
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-03-25T07:31:04.333Z
Comments.Text: I am glad the question has been reopened. But the broader problems with inappropriate closure remain unanswered. I have added an EDIT to my question at https://chess.meta.stackexchange.com/questions/1220/questions-inappropriately-closed-are-too-hard-to-reopen
Comments.UserDisplayName: Laska
Tags: <checkmate><database>
Title: What are the commonest checkmating moves in the Lichess (or similar) database?
ThreadText: # What are the commonest checkmating moves in the Lichess (or similar) database?
  
  (Asked by: username_0 on 2024-03-19)
  
  I'm curious what checkmating move is the most common in the Lichess database? That is, the properly algebraically specified move, for a given color, like "White plays Re8#".
  
  Answers for other databases are also welcome.
  
  (I'm guessing that Re8# for white may well be one of the top, as well as Qf7)
  
  **Tags:** checkmate, database
  
  > **Comments:**
  > **username_1**: If you have programming experience, Python has plenty of chess libraries and lichess provides free dumps. If that's not fast enough there's C++ and Rust libraries too.  
  > **username_2**: I'm curious as to why you want this.  In games between decent players (and more so among better ones) an actual checkmate will be pretty rare. So, you will be collecting data mostly on weak players.  
  > **username_0**: Just curiosity. And your observation about checkmate holds true for classical matches between high rated opponents, but decreasingly less so at shorter time controls and lower rated opponents, which makes up the vast majority of the lichess database.  
  > **username_3**: I have posted in chess meta on this https://chess.meta.stackexchange.com/questions/1220/questions-inappropriately-closed-are-too-hard-to-reopen. Please opine  
  > **username_3**: I am glad the question has been reopened. But the broader problems with inappropriate closure remain unanswered. I have added an EDIT to my question at https://chess.meta.stackexchange.com/questions/1220/questions-inappropriately-closed-are-too-hard-to-reopen  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_4 on 2024-03-23. Score: 13
  
  I've downloaded the Lichess database from 2013 to the end of 2022, and counted the final move of all the games, including whether it was a check or checkmate. For space reasons, I processed this in a streaming fashion (i.e not keeping any data after it was downloaded and processed), and I had forgotten to include recording whether the final move was by black or white; the only things I know are the number of games where the final move played was X. It's broken down by month, as well as collected into a grand total.
  
  > You can see the raw stats [on the GitHub repo next to the counting program](https://github.com/unchessful-games/game-termination-counter/tree/main/output), and here's a [Google Sheet with the final data and some sample calculations](https://docs.google.com/spreadsheets/d/1W1cDoVRxTNN16BnHvUjlBvjDxhLOlq6Y0LE0deHcfEA/edit).
  > In total, there are 4,004,175,546 recorded rated games in this period.
  
  Here are a few highlights:
  
  * Only 26.5% of games ended in a checkmate, with the remaining 15.19% ending with a check and 58.31% with neither; thus, 73.5% of games ended in a timeout, draw or resignation.
  * The most popular game terminations are `Q(x)g2#` and `Q(x)g7#`: together, these account for a whole 3.03% of games and 11.43% of checkmates.
  * Of the checkmates, the most popular one is with the queen: these account for 64.78% of all checkmates. (Note that moving the pawn to the final rank to deliver checkmate counts as a pawn move, not the move of the promoted-to piece.) The other popular option is with the rook, which accounts for another 25.39%. All the other pieces combined account for only 9.83% of checkmates, with a king move only delivering 0.0258% of them (exclusively by means of a discovered attack, because the king itself cannot cause a check).
  * 32.43% of checkmates were also captures, and this is fairly consistent across the pieces: from 37.16% for the queen to 18.81% for the knight, it seems to hover somewhere around 20-30%. An exception is the king, which already has a rather small number of checkmates, but only 3.87% of those also capture a piece.
  * 1.88% of checkmates were caused by a promotion, most often into a queen `??=Q#` (in 92.25% cases) but occasionally into a rook `??=R#` (7.53%).
  * Checkmating by a castling move is very rare: this only happened 39,026 times in the data, or 0.000974%; and among these, `O-O-O#` is 67.01% while `O-O#` is half as frequent with 32.98%.
  * There are a lot of extremely rare game endings: there are 2058 different final moves that were each played only once (and 798 of them are checkmates). Most of these seem to be fully-specified: for example, only one game ended in `Qe5xd4#`. These rare moves account for a substantial amount of my data: I've collected 22661 unique game-ending moves, and there's 5322 (23%) moves that concluded less than 10 games, and 9028 (40%) that finished less than 100 games; and among the latter, there was only 51975 checkmates, which is less than 0.0049% of all recorded checkmates.
  
  I haven't looked at the squares involved too much, but I imagine that there would be some more insights to be found there.
  
  > **Comments:**
  > **username_5**: Any cases of =N#? And how rare is en passant mate?  
  > **username_4**: @username_5 =N# happened 23194 times, or 0.001828% of checkmates. I don't have info on enpassant mates because enpassant is notated as a regular pawn move, and you'd need to know the state of the board before the move to know if it's an enpassant or regular capture.  
  > **username_3**: Hi username_4 since you are relatively new, you may be unfamiliar with the meta area where I have posted about the treatment of this question: https://chess.meta.stackexchange.com/questions/1220/questions-inappropriately-closed-are-too-hard-to-reopen  
  > **username_0**: Awesome answer, thanks. Are you missing draws in your 73.5% calculation? Also, is there a way you can share a longer list of the unique game-ending checkmate moves, perhaps with links to the games in question?  
  > **username_4**: @username_0 Like I said, the amount of information in this analysis is very limited, so in order to extract more info than you see in the Google Sheet you'd basically need to rerun the analysis from scratch. I'm currently downloading the Lichess database locally (I bought the HDDs for it), so I can extract more info from it for my own projects, and when that's done I may be able to add more info here.  
  > **username_0**: So sorry, I completely missed the links. My bad.  
  
  ---
  
  