Question about "result" field in "Players_at_bat_batting_stats" table

silvam14 · 02-06-2007, 02:33 AM

I'm hoping someone will know this

I'm looking for a clarification of the "result" field in the
"Players_at_bat_batting_stats" field

It seems to have values of numbers bewteen 1-11.

Looking up a game log shows me that the value 1 might correspond to a single but I would like to get some definitive information.

Hopefully Markus, or Andreas will see this.

Thanks

Oh, I was trying to come up with a database query that will eventually give me player's career stats vs teams and/or pitchers with this.

Thanks

Comedian2004 · 02-06-2007, 09:03 AM

pResult(1) = "Strikeout"
pResult(2) = "Walk"
pResult(3) = "out"
pResult(4) = "Groundout"
pResult(5) = "Flyout"
pResult(6) = "Single"
pResult(7) = "Double"
pResult(8) = "Triple"
pResult(9) = "Homerun"
pResult(10) = "HBP"
pResult(11) = "Catchers Int."

silvam14 · 02-06-2007, 10:16 AM

Thanks a ton!

02-06-2007, 02:33 AM	#1
silvam14 Hall Of Famer Join Date: Apr 2004 Location: Dedham, MA Posts: 9,925	Question about "result" field in "Players_at_bat_batting_stats" table I'm hoping someone will know this I'm looking for a clarification of the "result" field in the "Players_at_bat_batting_stats" field It seems to have values of numbers bewteen 1-11. Looking up a game log shows me that the value 1 might correspond to a single but I would like to get some definitive information. Hopefully Markus, or Andreas will see this. Thanks Oh, I was trying to come up with a database query that will eventually give me player's career stats vs teams and/or pitchers with this. Thanks __________________ Senior "Nancy Boy" of the OOTP Boards _______________________________________________

02-06-2007, 09:03 AM	#2
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 7,085	pResult(1) = "Strikeout" pResult(2) = "Walk" pResult(3) = "out" pResult(4) = "Groundout" pResult(5) = "Flyout" pResult(6) = "Single" pResult(7) = "Double" pResult(8) = "Triple" pResult(9) = "Homerun" pResult(10) = "HBP" pResult(11) = "Catchers Int." __________________ Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]

02-06-2007, 10:16 AM	#3
silvam14 Hall Of Famer Join Date: Apr 2004 Location: Dedham, MA Posts: 9,925	Thanks a ton! __________________ Senior "Nancy Boy" of the OOTP Boards _______________________________________________