I want to know the following data:
in a set of say: 1000 games

(a) how many pawns were killed?
(b) how many knights, quenns etc ...


is there any database awailable ???

any help would be appriciated

wrote:

You're a mathematician and/or statistician, right?

I want to know the following data:
in a set of say: 1000 games


Which 1000 games? Played by whom? Strong Grandmasters or very weak
players such as I am?

(a) how many pawns were killed?
(b) how many knights, quenns etc ...


is there any database awailable ???


There are chess databases available, but they are not designed to
perform such tasks. Rather, they are designed to help chess players do
the things that chess players do.

Looks like you'll have to write the code yourself, or maybe devise a
formula or macro to use in Wolfram's Mathematica...

Lots of luck!

any help would be appriciated

On Dec 29, 3:34 pm, wrote:
I want to know the following data:
in a set of say: 1000 games

(a) how many pawns were killed?
(b) how many knights, quenns etc ...

is there any database awailable ???

any help would be appriciated

I'm guessing you are not a serious chess player, otherwise you would
not use the odd term "killed" (rather than captured) or want to
investigate information which seems (to me at least) to have little
relevance or significance to chess play.
I know of no database with any feature that would automatically
compute what you ask for. However, any of the popular databases (e.g.
ChessBase, Chess Assistant, MasterChess 2000 etc.) could aid your
research. Most of these have at least a million games, some several
million, but you can narrow things down to your desired figure of 1,000
(or whatever) by various search criteria: opening, player name(s), a
specific year or range of years, type of event (tournament, match,
Olympiad etc.), venue, result (White wins, Black wins, draw) and other
factors.
That's the easy part. Once you have your desired set of games, you
would have to do the rest yourself. Look through the games one by one,
not playing over every move, but going immediately to the final
position (there is usually a button for this on the game display). The
material still on the board will tell you how many pieces and pawns
were captured over the course of the game. For example, in a position
with only kings and one white pawn left, obviously all 14 non-king
pieces, all 8 black pawns, and 7 white pawns have been captured. Going
through each game and tabulating such data manually will give you the
data you seek, albeit in a somewhat tedious process.
That, at least, is the best suggestion I can offer. Perhaps someone
with more sophisticated knowledge can offer better. To ask a couple of
experts, you might try contacting ChessBase expert Steve Lopez through
his ChessCafe column he

http://www.chesscafe.com/chessbasefaq/lopez.htm

or Chess Assistant Dadi Jonsson he

http://www.chesscafe.com/chessok/chessok.htm

Also Robert J. Pawlak is very knowledgeable. There is a link to
contact him on this site:

http://www.chessassistance.com/Autho...BobPawlak.html

Taylor Kingston wrote:

On Dec 29, 3:34 pm, wrote:
I want to know the following data:
in a set of say: 1000 games

(a) how many pawns were killed?
(b) how many knights, quenns etc ...

is there any database awailable ???

any help would be appriciated

I'm guessing you are not a serious chess player, otherwise you would
not use the odd term "killed" (rather than captured) or want to
investigate information which seems (to me at least) to have little
relevance or significance to chess play.
I know of no database with any feature that would automatically
compute what you ask for. However, any of the popular databases (e.g.
ChessBase, Chess Assistant, MasterChess 2000 etc.) could aid your
research. Most of these have at least a million games, some several
million, but you can narrow things down to your desired figure of 1,000
(or whatever) by various search criteria: opening, player name(s), a
specific year or range of years, type of event (tournament, match,
Olympiad etc.), venue, result (White wins, Black wins, draw) and other
factors.
That's the easy part. Once you have your desired set of games, you
would have to do the rest yourself. Look through the games one by one,
not playing over every move, but going immediately to the final
position (there is usually a button for this on the game display). The
material still on the board will tell you how many pieces and pawns
were captured over the course of the game.

Is that actually true, Taylor, or do programs generally display only
the material imbalance? I must admit that in my experience it's the
latter.

For example, in a position
with only kings and one white pawn left, obviously all 14 non-king
pieces, all 8 black pawns, and 7 white pawns have been captured. Going
through each game and tabulating such data manually will give you the
data you seek, albeit in a somewhat tedious process.
That, at least, is the best suggestion I can offer. Perhaps someone
with more sophisticated knowledge can offer better. To ask a couple of
experts, you might try contacting ChessBase expert Steve Lopez through
his ChessCafe column he

http://www.chesscafe.com/chessbasefaq/lopez.htm

or Chess Assistant Dadi Jonsson he

http://www.chesscafe.com/chessok/chessok.htm

Also Robert J. Pawlak is very knowledgeable. There is a link to
contact him on this site:

http://www.chessassistance.com/Autho...BobPawlak.html

A post of typically high quality, much more informative than my lame
effort, it must be admitted...

On Dec 30, 2:32 pm, "Mark Houlsby"
wrote:
Taylor Kingston wrote:
On Dec 29, 3:34 pm, wrote:
I want to know the following data:
in a set of say: 1000 games

(a) how many pawns were killed?
(b) how many knights, quenns etc ...

is there any database awailable ???

any help would be appriciated

I'm guessing you are not a serious chess player, otherwise you would
not use the odd term "killed" (rather than captured) or want to
investigate information which seems (to me at least) to have little
relevance or significance to chess play.
I know of no database with any feature that would automatically
compute what you ask for. However, any of the popular databases (e.g.
ChessBase, Chess Assistant, MasterChess 2000 etc.) could aid your
research. Most of these have at least a million games, some several
million, but you can narrow things down to your desired figure of 1,000
(or whatever) by various search criteria: opening, player name(s), a
specific year or range of years, type of event (tournament, match,
Olympiad etc.), venue, result (White wins, Black wins, draw) and other
factors.
That's the easy part. Once you have your desired set of games, you
would have to do the rest yourself. Look through the games one by one,
not playing over every move, but going immediately to the final
position (there is usually a button for this on the game display). The
material still on the board will tell you how many pieces and pawns
were captured over the course of the game.

Is that actually true, Taylor, or do programs generally display only
the material imbalance? I must admit that in my experience it's the
latter.

Any decent database shows the full position at the end of the game.
From that it's easy to determine with one's own eyes what material has
been captured.
Some databases have material imbalance as a possible search
criterion, but that's not what I'm talking about.


For example, in a position
with only kings and one white pawn left, obviously all 14 non-king
pieces, all 8 black pawns, and 7 white pawns have been captured. Going
through each game and tabulating such data manually will give you the
data you seek, albeit in a somewhat tedious process.
That, at least, is the best suggestion I can offer. Perhaps someone
with more sophisticated knowledge can offer better. To ask a couple of
experts, you might try contacting ChessBase expert Steve Lopez through
his ChessCafe column he

http://www.chesscafe.com/chessbasefaq/lopez.htm

or Chess Assistant Dadi Jonsson he

http://www.chesscafe.com/chessok/chessok.htm

Also Robert J. Pawlak is very knowledgeable. There is a link to
contact him on this site:

http://www.chessassistance.com/Autho...BobPawlak.html

A post of typically high quality, much more informative than my lame
effort, it must be admitted...

Taylor Kingston wrote:

On Dec 30, 2:32 pm, "Mark Houlsby"
wrote:
Taylor Kingston wrote:
On Dec 29, 3:34 pm, wrote:
I want to know the following data:
in a set of say: 1000 games

(a) how many pawns were killed?
(b) how many knights, quenns etc ...

is there any database awailable ???

any help would be appriciated

I'm guessing you are not a serious chess player, otherwise you would
not use the odd term "killed" (rather than captured) or want to
investigate information which seems (to me at least) to have little
relevance or significance to chess play.
I know of no database with any feature that would automatically
compute what you ask for. However, any of the popular databases (e.g.
ChessBase, Chess Assistant, MasterChess 2000 etc.) could aid your
research. Most of these have at least a million games, some several
million, but you can narrow things down to your desired figure of 1,000
(or whatever) by various search criteria: opening, player name(s), a
specific year or range of years, type of event (tournament, match,
Olympiad etc.), venue, result (White wins, Black wins, draw) and other
factors.
That's the easy part. Once you have your desired set of games, you
would have to do the rest yourself. Look through the games one by one,
not playing over every move, but going immediately to the final
position (there is usually a button for this on the game display). The
material still on the board will tell you how many pieces and pawns
were captured over the course of the game.

Is that actually true, Taylor, or do programs generally display only
the material imbalance? I must admit that in my experience it's the
latter.

Any decent database shows the full position at the end of the game.
From that it's easy to determine with one's own eyes what material has
been captured.
Some databases have material imbalance as a possible search
criterion, but that's not what I'm talking about.


Neither am I. I was referring to the fact that one may select/deselect
an option in ChessBase (or, indeed, in Fritz, etc.) which indicates, in
a small window at the bottom of the notation window, the material
imbalance, be it a Pawn, a Rook for a Knight, a Queen for a Knight, a
Bishop and two Pawns, whatever....

wrote:
I want to know the following data:
in a set of say: 1000 games

(a) how many pawns were killed?
(b) how many knights, quenns etc ...


is there any database awailable ???

any help would be appriciated

wrote:
I want to know the following data:
in a set of say: 1000 games

(a) how many pawns were killed?
(b) how many knights, quenns etc ...


is there any database awailable ???

any help would be appriciated

http://www.e4ec.org/statistics.html

wrote:
I want to know the following data:
in a set of say: 1000 games

(a) how many pawns were killed?
(b) how many knights, quenns etc ...


is there any database awailable ???

any help would be appriciated

(Piece): (Moves) (%) (Captures) (%) (Captured) (%)
King: 91633 10 7723 4 - -
Queen: 114673 12 33736 16 14845 7
Rook: 124627 13 30284 14 20708 10
Knight: 186355 19 41031 19 43087 20
Bishop: 157023 16 42147 19 38722 18
Pawn: 286219 30 61873 28 99432 45
Summarized: 960530 100 216794 100 216794 100

This seems to be a rather large sample, but I do not know the level of
play, I guess it must be averaged. The data is not surprising to me. I
wonder if it is really significative that Knights are more often
captured than Bishops (they make the same captures, though). I do not
play chess so I cannot explained this unexpected result, any idea?

Joaquim

wrote:
I want to know the following data:
in a set of say: 1000 games

(a) how many pawns were killed?
(b) how many knights, quenns etc ...


is there any database awailable ???

any help would be appriciated

(Piece): (Moves) (%) (Captures) (%) (Captured) (%)
King: 91633 10 7723 4 -
-
Queen: 114673 12 33736 16 14845 7
Rook: 124627 13 30284 14 20708 10
Knight: 186355 19 41031 19 43087 20
Bishop: 157023 16 42147 19 38722 18
Pawn: 286219 30 61873 28 99432 45
Summarized: 960530 100 2 16794 100 216794 100

This seems to be a rather large sample, but I do not know the level of
play, I guess it must be averaged. The data is not surprising to me. I
wonder if it is really significative that Knights are more often
captured than Bishops (they make the same captures, though). I do not
play chess so I cannot explain this unexpected result, any idea?


Joaquim