... You might be able to fill some of these (other than Runs Allowed, already there) for NA pitchers. MLB.com has the data, and has posted some of it to its...
Derek; Thanks for the revised pitching table with added data. I've been hoping this would show up. Great job, my friend. Now if I can only get someone to...
I'm working on the bio data merge currently. After fixing a few retroID mappings, I have the following four players who appear in Master, but not in the...
... Done some tracking down - we have this combined with drisd101 - Denny Driscoll. retrosheet has these separate. ... This appears to be missing in our...
... The Biographical DB is the source for biographical data published at retrosheet.org/boxesetc/P*.htm When was .../P*.htm last updated to match the...
... Like, for instance, they are the only two players who have stint values of 0. This wouldn't be a problem if all you use the field for is matching across...
... Mike Crain provided me with the file - Mike, can you speak to this? If Tom Ruane is dialed in, he can speak to the first. ... Awesome - "u" does indeed...
I'm doing the matching up with the Bio data, and I'm interested in the opinion of the group on this. Just to give you an idea of the discrepancies I'm finding,...
... The examples and the implied questions must be clarified. Which data does the Biographical Committee systematically gather, assess, and record in its...
UPDATE Master SET retroID = 'osbop101' WHERE playerID = 'osburpa01'; Currently, his retroID is listed as 'osbup101' which makes sense, however Retrosheet's...
... This was caught by the cross-indexing I've done with the retro file; it and a number of similar changes will be reflected in the next Master table update. ...
... Having come across this before in parsing Retrosheet game files, I know that the entry in the gamelog, I believe, was derived from the game files, and the...
... I was under the impression that the VARCHAR(10) player ID was to be phased out in favor of the more "good database design" compliant numeric lahman ID....
... Our data is at a point where we could go that way now if we preferred, but we have, as a group, made the conscious decision not to. There'd be no need for...
... OK. I haven't read back quite that far in the archives. ... The numeric IDs change between releases? I'm glad I asked as I figured that those were the...
... In the current version of the Master table, Jr and Sr appear variously: with and without the period with and without the parentheses in nameLast and/or...
... Mike - I beleive that David Vincent updates it on a monthly basis, but doesn't necessarily give it version numbers - just check the saved date. What I ...
... I really like these two suggestions. I'm open to any arguments against either one or both. ... I don't particularly like these either. They're used for...
... and Derek Adair replied... ... I created those monstrosities back in the early days of the database. The initials helped to distinguish between players...
In regards to new fields for the Master table, I completely endorse MM's suggestions. How about providing three additional fields for linking back to ...
I agree.I think First, Middle and last should be in seperate fields. I also would not be sure what to do with the "monstrosities ", but think they should be...
Creating a separate field for nameMiddle sounds clever, but I think once someone tries to implement it, they will discover that the concept is not well-defined...
Just a comment as to the reason we deviated from "best practices" insofar as the ID key of the tables, most notably the player tables (but could be expanded to...
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.
