I have reviewed the excellent work of the DB design committee and have some suggestions: On Managers: Revisit the relationship of TeamsHalf and ManagersHalf...
A number of the suggestions below make a lot of sense. I like the locations suggestion, in particular. A couple of thoughts: I don't understand the rationale...
... SABR Membership IDs, I presume. Some baseball personages are SABR members or former members. Eg, minor player Art Johnson. Eg, major player and manager...
... What I meant by the above was that I didn't know what the scheme was to create the ID's (such as first five letters of the last name, first two of the...
The SABRID is the numeric PlayerID in the Bibliography committee players table and is used extensively in the HRLog. I have a well developed table that cross...
Right. Same thing. ... From: Paul Wendt [mailto:pgw@...] Sent: Saturday, February 01, 2003 6:26 PM To: baseball-databank@yahoogroups.com Subject: RE:...
... If you could send that my way, I'd be happy to merge that with the Master table. ... See below. ... It does have an "independent key" if you examine the...
... I have a single-table view of the Biographical Database covering all and only the 1871 players. This is not much help to Derek but for the incomplete...
Thanks for your comments. See my comments that are interspersed, and those that I have no comments to, I have snipped off.... ... Please note that what we did...
... Even for AL1900, the best known of old minor leagues, there are several players whose identity with some MLB player is guessed, but not secured. (Eg, Which...
... Here's a good primer on key construction. And I should have said, as this article demonstrates, that it applies to all parent tables, though you can still...
(snip) ... The details are long and messy; suffice it to say that Retrosheet acquired the rights to the post-1983 data on the Web site from the Baseball...
... I'll have to direct you to them to answer that. That isn't my jurisdiction. -- Sincerely, Sean Forman Baseball Stats! http://www.Baseball-Reference.com/...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the baseball-databank group. File :...
baseball-databank@yah...
Feb 7, 2003 7:49 pm
1391
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the baseball-databank group. File :...
baseball-databank@yah...
Feb 7, 2003 7:53 pm
1392
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the baseball-databank group. File :...
baseball-databank@yah...
Feb 7, 2003 7:55 pm
1393
I've heard of "all-star" games being played between the old Negro Leagues and the "Major leagues". Does anyone have details of these games? Dates, box scores...
I'm looking for a source for the 2003 schedule in one or two files (csv, text, html, whatever). I can pull it from 30 different files, but I was hoping that...
This might help. USA Today keeps handy AL and NL daily schedules. I just wish they were more printer friendly, so if that's a problem, it might not help you...
EXACTLY what I need! Much thanks.... Tom ... http://www.usatoday.com/sports/baseball/alschedule.htm ... __________________________________________________ Do...
It's never so easy. I'm parsing this schedule, and Florida has 78 road games, Anaheim has 84 road. Philly has 80 home games. Texas has 84 road and 78 home....
Ok, I didn't parse the Monteal ones fine. So, that leaves us with the following errors: Texas is short 3 home games and Florida is short 3 away games. I'll...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the baseball-databank group. File :...
baseball-databank@yah...
Feb 11, 2003 4:54 pm
1401
The schedule is now complete and uploaded as a csv file. You can import this easily into Excel, and sort/filter as you need it. The errors were due to: 1 - I...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the baseball-databank group. File :...
baseball-databank@yah...
Feb 12, 2003 5:10 pm
1404
The file I have uploaded should help those people who write about players, and would like to insert a link to their favorite stats site (br-com, retrosheet,...