lichess.org
Donate

Database function

Beloved folk, I approach you in need of advice.

The databases I know of do not show the moves that have been played in a given position, but the moves that lead to positions that occured in games of the database.
(To make this clearer: The number of '2.Nf3' in the position after '1.e4 c5' equals the number of '2.e4' in the position after '1.Nf3 c5' in my databases.)

Where and/or how can I find a database that shows the moves actually played in given positions?

Thank you guys in advance.
Normally "trees" give the number etc. So 1.e4 c5 and then you have the number which move is played how often. The transpositions don't matter "forward", only backwards.
Well, on e.g. chesstempo and the ChessBase database that is not the case. And I don't see a way to change the numbers to what you are describing.

How do you, @Sarg0n, get access to what you called trees?
The Lichess opening explorer shows exactly what you describe, i.e. the number of times a move has been played in the given position: lichess.org/analysis#opening

(This changed from the first version of the explorer).

For example 2. Nf3 was played 353457 times in the master database. 2. e4 was played only 2462 times.
Thank you so much :) I was unaware of that change.
Lichess is fantastic.

Thanks @revoof and thanks @Sarg0n for pointing out that relevant fact that previous transpositions are taken into account
Always remember: a "tree" is a collection/db of positions, not of games. This means that move repetitions lead to infinite loops.

For me it's the most important data source when investigating openings:
-which moves
-how often
-percentage
-(playing strength players)

This topic has been archived and can no longer be replied to.