players_at_bat_batting_stats help?

[ctorg]

I'm trying to make myself a little Access database that will help me look at some splits for players. In order to do so, I need to get a better handle on what the fields represent in the players. Can anyone who knows help me with some of these questions?

1. result - seems to be coded on a 1-9 scale, but I don't know what each number means. I assume each stands for an outcome (e.g., homerun, strikeout, etc.).
2. sb/cs - do these fields show whether the batter stole/was caught when he got on base, or do they show what runners on base did while the batter was up?
3. r - similarly, does this show whether the batter scored after reaching or whether someone scored during his ab?

Any info would be greatly appreciated.

[fhomess]

Originally Posted by ctorg

1. result - seems to be coded on a 1-9 scale, but I don't know what each number means. I assume each stands for an outcome (e.g., homerun, strikeout, etc.).

1 - strikeout
2 - walk
3 - ??? - I've never seen this set. It may be intended for reaching on error, but errors are actually recorded as the type of out they would have generated (e.g. an error on a ground ball is marked with result=4)
4 - ground out
5 - fly out
6 - single
7 - double
8 - triple
9 - home run
10 - hit by pitch
11 - reaches on catcher's interference

Originally Posted by ctorg

2. sb/cs - do these fields show whether the batter stole/was caught when he got on base, or do they show what runners on base did while the batter was up?

The sb column means the player eventually stole a base
The cs column means the player eventually was caught stealing

Originally Posted by ctorg

3. r - similarly, does this show whether the batter scored after reaching or whether someone scored during his ab?

The r column means the player eventually came around to score

So the answer to the last two questions is that it relates to the batter himself after he becomes a baserunner. It is not what other players are doing during his PA.

Also, note that the balls and strikes columns reflect the count when the pitch was thrown that determined the plate appearance. So, for example, a player who walks (result=2) will show 3 in the balls column, not 4.

[ctorg]

Thank you fhomess! This helps very much!