Hi, I'm posting here at the suggestion of Sean Forman... I'm looking to add retrosheet game log data to my version of the lahman db, which I have installed in...
... I can give you my Access database. It has I think 108 fields or so. This was prior to Retrosheet adding the 54 fields at the end to tack on the id and...
... I can give you my Access database. It has I think 108 fields or so. This was prior to Retrosheet adding the 54 fields at the end to tack on the id and...
... This sounds doable. Thanks alot. ... I have done so. (So far, nobody has responded.) ... Ok, that would be great. ... Absolutely. Thanks again, John...
Would anyone know how to do a query where I could get the following output: Player ID, Year, Total Fielding Games, Games at Catcher. I am trying to get one...
Try something like: select playerid, year, sum(g) as Gtot, sum(Iif(pos=2,g,0)) as G2 from fielding group by playerid, year This will only work with Access. I...
MySQL also has an IF expression with a similar syntax. PostgreSQL has a CASE-WHEN construct that should accomplish the same thing (I think). Randy System...
Enter your vote today! A new poll has been created for the baseball-databank group: Who do you think is the best baseball player in the major leauges right...
baseball-databank@yah...
Apr 3, 2004 2:56 am
2062
We at WEBEUSA, custom design websites for the business community. If you are interested in a website for your business or want to upgrade your site please...
We at WEBEUSA, custom design websites for the business community. If you are interested in a website for your business or want to upgrade your site please...
... Well, the updates to the web-site have now been released. Sean, do you want to send me a list of what you want or should there be some discussion on the...
The "holes" in our data is as follows. I suggest that this post gets updated going forward. Hitting: SB - 1876 to 1885 CS - 1876 to 1919 IBB - 1871 to 1954 ...
Tom, Thank you again for the offer. I think we should start out small and get things tied together. In fielding, we could use Catcher SB, CS, and Catcher...
In a discussion over on Retrolist, Tom pointing me to these files on our egroup. I was wondering how this data was generated. The reason I ask is that park...
This list has been appended with Sean's note regarding breaking down start/relief appearances, which is really a great suggestion. Tom *** The "holes" in our...
... KJOK mentioned in a post in this group, probably over a year ago, (that I can't seem to find right now... we were discussing proofing, and sources, etc)...
Tom: The descriptive data (park configuration) was initially taken from Green Cathedrals (original version). The batting data was generated from Retrosheet...
... What about SB and CS for pitchers? By the way, something I keep track on Retrosheet is WP for catchers and passed balls for pitchers. ... What's the rule...
... Tom, you and I are among the handfuls (I think) that looks at this. If I was the Dr Evil of baseball, I would certainly add it. Not that we're going to do...
... Going through old box scores, these often were recorded differently. A few other notes: * The original (1969) Baseball Encyclopedia had innings pitched and...
While ballparks data bases are being discussed, I want to mention that the Pictorial History and Ballparks Committee have just begun a joint project to develop...
... handsful, I think ... I agree. If the NA Statistics Project were rerun today, it would be worthwhile to compile these disaggregated statistics. As it is,...
... Paul: http://dictionary.reference.com/search?q=handfuls In any case, I wasn't pondering the spelling of the word, but rather the idea that very few people...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
