Quick Question about the Primary Position Table

Quick Question about the Primary Position Table

John Signore 1227754009|%e %b %Y, %H:%M %Z|agohover

I was trying to follow the wOBA thread on the BOOK blog. I'm doing this in MySQL so I used the SQL on this page for the primpos table instead of tango's but I think its giving me different results.

For instance in 2006 for RperOut instead of .182 that he gets, im getting .185. I'm wondering if the difference between Colin's table and Tango's for primpos is why there's a difference?

Re: Quick Question about the Primary Position Table

Colin Wyers 1227755727|%e %b %Y, %H:%M %Z|agohover

That's probably the largest potential source of discrepancy. The other possibility I can think of is that Access and MySQL differ in how to handle fractional values like that. I can try to do some testing when I get home tonight.

Re: Quick Question about the Primary Position Table

chiefjamesp 1230699551|%e %b %Y, %H:%M %Z|agohover

I have another (probably pretty lame) question about the from statement in the primary position query

"FROM (SELECT * from fielding
WHERE IF(yearID>1995 AND POS = "OF",1,0) != 1 ORDER BY G Desc) f"

I can't really figure out whats going on there.

Re: Quick Question about the Primary Position Table

Colin Wyers 1230780150|%e %b %Y, %H:%M %Z|agohover

I probably didn't write that as clearly as I could/should have. Prior to 1996, fielding numbers in the Databank are only listed as OF; after 1995, they're broken down into the three OF positions as well. For those years where we have CF, LF and RF breakdowns, we're uninterested in the OF data, so that was discarded.

Re: Quick Question about the Primary Position Table

chiefjamesp 1230885345|%e %b %Y, %H:%M %Z|agohover

right on, thank you very much for the clarification! aren't there outfield positional breakdowns for the retrosheet era? Is the the data from 1956-1995 too unreliable to be used?