Questions tagged [database]
A set of chess games, distributed as a stand-alone product or as part of a bundle of chess software. For endgame databases, use the [tablebases] tag instead.
124
questions
2
votes
3answers
121 views
How do convert/parse/extract data from a PGN into a spreadsheet/google sheet/excel file?
Sequel to this question: Live statistics chess960 from chess.com?
So suppose I go to like
https://api.chess.com/pub/player/gmwso/games/2020/12
or
https://api.chess.com/pub/player/gmwso/games/2020/12/...
3
votes
1answer
83 views
Live statistics chess960 from chess.com?
Cross-posted stackoverflow, but nothing.
Both lichess and chess.com have the feature to play the variant chess960 live. However, only lichess has a graph showing how your live chess960 rating has ...
5
votes
2answers
1k views
Find an opening based on the position of one player only
Given a position for just one player, how can I check to see if there is a standard opening that leads to that position?
For example, how could I find if there is an opening that leads (or may lead, ...
2
votes
1answer
158 views
Abbreviations like 't', 'm', 'zt', 'sf' in chess databases
I am just cleaning up the Event and Site headers in the games in my chess database.
There are a lot of abbreviations there. I am relatively sure about the following:
of, qf, sf and f – octo final, ...
2
votes
0answers
76 views
Winning percentage in chess 960 in 2021
How does the winning percentage (white win/draw/black win) in chess 960 (Fischer random) compare to that of regular chess?
The above was asked here. I would like to re-ask this question with the ...
0
votes
1answer
51 views
Create a list of discs from PGN file with a lot of comments [closed]
I need help to generate structured data from the PGN file as discs into a list in Python, or similar.
For example, say that I need to read this PGN file.
###############################################...
1
vote
1answer
45 views
A way to add an “opening names” column to the SCID game list
I've been googling and looking through SCID's options but just can't seem to find the answer.
The database gamelist in SCID has a few informative columns for all the games in the gamelist, including ...
2
votes
2answers
124 views
Is there a data file available (e.g. a .csv) containing every single rated game?
Question
Is there a data file somewhere containing every single (FIDE) rated game?
What I found out so far
I see many websites with some limited database search capability, or summary statistics, but ...
3
votes
2answers
90 views
What are some of the chess databases in the public domain that can be used for commercial purpose?
What chess databases allow commercial use without having to reveal source code as part of their license? I see a few chess databases online, even the huge databases on lichess. I wonder which of these ...
3
votes
1answer
163 views
What are the percentage rates for each promotion type?
I could not find the database which has this, but I would like to know what percentage of promoted pawns ends up being a queen, rook, bishop, or knight
4
votes
1answer
74 views
Are there any resources where one can view the popularity of a move by year?
I am currently under the impression that White players are allowing the Nimzo-Indian more and more, whereas before they were dodging it via 3. Nf3.
I wanted to check if that is true, but usually ...
1
vote
1answer
90 views
Listing engine evaluation of each game after opening to track my opening skill level
I've recently picked up the book "Pump up your rating" where the author talks about tracking each of your games with a post-mortem analysis. The report of all your games combined will show ...
2
votes
1answer
91 views
Issue with ChessBase results when filtering by “Good Games”
I'm trying to determine if I'm doing something wrong or if there might be a bug in the program.
One thing I was experimenting with was the search mask called "Good Games". The documentation ...
-1
votes
1answer
78 views
Need help finding a tactics database with motifs [duplicate]
I am trying to make a neural network which could determine what chess tactic is present in a position. For this, I need to have a database of chess tactics labelled with correct motifs.
A similar ...
6
votes
3answers
356 views
Free opening name database?
Is there a database available that the gives you the names of common openings? "Ruy Lopez", "Sicialian", "Queens Gambit", etc. Ideally it would just be a simple map of the opening PGN to the common ...
1
vote
2answers
380 views
Whats the difference between these chess tempo databases
Chesstempo seems to have two pages for database display.
This one works at random: https://chesstempo.com/game-database.html
Sometimes it shows the moves in sequence of most usage and then the ...
2
votes
1answer
78 views
What is the 'combustion point' of a game? This was in an upvoted answer
Saw an answer and it had been upvoted.
Person answering had a large rep on stack.
The term used that was not explained is:
'Combustion Point' (of a game)
My question is just what does 'combustion ...
2
votes
2answers
170 views
Why does chess tempo fail at random; what is the biggest free database online that is reliable
Sometimes chess tempo works. Sometimes it does not. Seems random. Is there another database that is completely reliable that is as big as chess tempo?
I am looking for a DB that gives the moves ...
2
votes
3answers
258 views
What to put in a personal chess database?
I was thinking about creating a personalized chess database for my correspondence chess play. What sorts of contents are useful to put in it and is there any big difference in having your own database ...
20
votes
9answers
3k views
How can someone find their Morphy number?
The Morphy number is a measure of how closely a chess player is connected to Paul Morphy (1837–1884) by way of playing chess games. It's analogous to the Erdős Number for mathematicians.
People who ...
2
votes
2answers
130 views
Are there any moves that are more popular in databases of GM games but are objectively inferior?
Usually in a particular opening position, if move A is more popular (in GM games) than move B, then either move A is objectively better than move B, or move A is equally good as move B.
Are there ...
3
votes
1answer
111 views
Are there any sources of massive transposition tables?
Do transposition databases exist the way tablebases do? Would an engine be able to take advantage of a pre-calculated TD? Is there a benefit to players when studying if they had access to pre-...
2
votes
0answers
55 views
Where to find a list of the computer stored in the FICS Games Database?
According to the FICS Games Database there are currently 1,525 "computers stored". Such accounts are indicated by a "(C)" after the username. However, this suffix does not seem to be recorded in the ...
6
votes
1answer
140 views
How do OTB games end up in databases?
How do games of players that are not so well known, or not huge events end up in Chessbase and other databases? What are the different ways that games are cataloged?
If they are not playing on an ...
4
votes
3answers
338 views
Are there any online public chess databases I can upload my own games to?
Does there exist any online public chess database that I can upload my own games to (so that others can look at them)? I know that sites where you can play online will store games (that you played on ...
1
vote
1answer
84 views
Is there any software (preferably Linux) that, when managing a database, can inform you about opening transpositions?
To make it simple, let's say that I play a game that opens with 1. e4 d5 2. d4.
I use Scid-vs-PC, and in this position, it just shows a bunch of games. Od course, if black plays now 2 ... e6, we ...
1
vote
1answer
142 views
Moving a game up or down the SCID database list?
Is there a way to move an individual game up or down the database list? Or give it a new game number in the list?
3
votes
1answer
195 views
Which online chess websites allow you to download their games?
I am looking for a list chess websites which allow you to download large numbers of previously played chess games. Currently I have found that lichess allows you to do so.
Are there any other sites?
...
2
votes
1answer
221 views
ChessBase: how to efficiently use two reference database simultaneously
In ChessBase I use the Mega Database as my reference database when in a board. However, I recently downloaded a Correspondence database and would like to look up positions in it as well. Is there a ...
7
votes
1answer
310 views
Chess database software for variants
For regular chess, I use SCID and it works well. It has database searches, position searches, player stats, and a nice compact file format (i.e. not PGN, which is inefficient and big).
Is there any ...
1
vote
2answers
426 views
Using the tree window in SCID on a subset of games in the database
With a database open in SCID, one can use the tree window to explore openings. Among other things, it shows the frequency of each move that has been played in the current position and how well that ...
4
votes
1answer
3k views
Database of chess results
I'm looking for a database or a collection of the chess results of all FIDE-rated games (standard time control). The data I'm interested in is: the white player, the black player, the result and the ...
5
votes
6answers
254 views
In the opening stage, can we determine that one move is better than another by looking at winning percentage?
After 1.c4 Nf6 2. Nc3 g6, thousands of games have been played with the following two moves of white: 3.g3 and 3.e4. It seems that the winning percentage suggested that 3.e4 is clearly better than 3....
4
votes
1answer
204 views
Professional Databases and Historical Games
I have tried to look for historical chess games (i.e. 19th century to early 20th century). I usually use Chessbase online database and chessgames.com.
I have never paid for a database or database ...
5
votes
1answer
427 views
How do TWIC, chessgames.com, chessbase, etc. keep up to date with new games?
Most players use these services to keep up to date on the latest chess results, but how do these services source their databases? It would seem like a prohibitive amount of work to scrape results from ...
-1
votes
2answers
80 views
Recommended master games for teaching chess
I am teaching chess to beginners and am looking for recommended games to be discussed/analyzed together.
So the games should be relatively simple, short and ideally focus on one main theme (e.g. ...
1
vote
1answer
104 views
Is there any database of every position ever played in a recorded game?
Is there any database of every position ever played in a recorded game? I don't ask of every possible position in chess, or "solving" chess. Only the positions that were played in a recorded game. ...
4
votes
1answer
140 views
Is there a database of endgame positions with known perfect play?
Perfect play as in, it leads to checkmate in the least moves possible. Not just forced mates.
0
votes
3answers
3k views
Where can I find a good chess database? [closed]
What is the best chess database out there (quality vs. price). Do you recommend online or offline chess database. Any experience with chessbase, chessok, chesstempo or openingmaster?
2
votes
1answer
173 views
How can I find all games between 2 specific players?
How can I find all games played by 2 specific players?
For example: Nigel Short and Magnus Carlsen.
Is there some official FIDE database or something like that?
I'd like an easy way to see things ...
11
votes
2answers
960 views
How can I get a collection of chess games with a 'Greek gift' sacrifice?
I would like to make a collection of chess games that feature the 'Greek gift' sacrifice. There are few games on chessgames.com annotated with this sacrifice. I could find blogs with individual ...
3
votes
1answer
216 views
Data set of board representations at checkmate?
I would like to do a simple project by looking at the pieces at play when checkmate occurs.
I have been scouring the internet for a dataset of standard chess games from which I can retrieve the ...
3
votes
2answers
207 views
Online or Print Sources for Historical Games
What are the best online or print sources for historical games? I am generally looking for pre-1930s games NOT by world champions, and, in particular, looking for games by some of the prominent women ...
6
votes
2answers
3k views
Why is it so hard to find a free downloadable chess database with older/historical chess games?
The best free, downloadable chess database I've found is Kingbase (http://www.kingbase-chess.net). It only has games since 1990. I also have the Android Chessbase Online app, which also appears to ...
14
votes
4answers
19k views
Chess Problem Database with PGN or FEN
Is there a database of chess probpems that have the game or positions PGN and or FEN?
6
votes
2answers
1k views
Recommended software for ICCF play?
I am interested in playing correspondence chess online through the ICCF. It is my understanding that using computers is not only allowed, but almost mandatory. My question is: What all kinds of ...
4
votes
2answers
1k views
Game databases vs. various languages/character sets
How do people use chess software in large countries like China, India or Russia, if they don't speak English, and more importantly, if they don't know Latin letters? With unicode there's not big ...
5
votes
0answers
573 views
How to use masks in scid for opening training [closed]
I've been trying to understand how the "mask" feature works in scid and how to use it for training opening lines. So far I did the following:
open a database of master games in scid
open the tree ...
7
votes
1answer
261 views
Database without rapid and blitz games
Last years Mega Database is full of rapid and blitz games taken from live broadcast boards.
Is it possible to filter them out?
Are there other bases that have games only from long time controls?
...
1
vote
1answer
163 views
Cleaning a database
I noticed that in the freely available TWIC databases (and perhaps in other databases as well) there are sometimes different notations for the same move. Just now I am looking at the Ruy Lopez where ...
