http://www.gnu.org/philosophy/license-list.html The design science license may be appropriate for what we are doing. However, that would allow others to...
2
Sean Forman
sean-forman@...
Oct 9, 2001 5:44 pm
Just to get this on record. tables to include in new release, and columns naming conventions new tables to build what to do with new data and how to proof it ...
3
Sean Forman
sean-forman@...
Oct 10, 2001 5:08 am
http://baseball-reference.com/data/2001/...
4
Mike Emeigh
mwemeigh@...
Oct 10, 2001 12:39 pm
I noted a fair number of birthdates were not in the updated 2001 data for debut players. So - I went hunting on the ESPN Web site and got the missing ones....
5
Mike Emeigh
mwemeigh@...
Oct 10, 2001 12:45 pm
Where's Lloyd McClendon? Mike Emeigh piratefan1@......
6
Sean Forman
sean-forman@...
Oct 10, 2001 1:17 pm
... Did he actually do anything this year? ... 62 | 100 | 6 | 0 | | I had the wrong entry for his lahman_ID in the manager table. It should ...
7
Sean Lahman
slahman@...
Oct 10, 2001 3:18 pm
I realize it's outside the scope of what you've done, Sean, but what about non-active players who have died? The SABR biographical committee can provide an...
8
Sean Forman
sean-forman@...
Oct 10, 2001 4:03 pm
... committee ... or ... The data that I sent out was only to be consistent with the data currently in the DB. I've been able to add big chunks of biographical...
9
Justin Kubatko
jkubatko@...
Oct 11, 2001 2:26 am
Sean, A few errors I found in the 2001 files: 1) Brent Hinchliffe's lahman_id in the batting and pitching files is listed as "hinclbr01". It should be...
10
Sean Forman
sean-forman@...
Oct 11, 2001 4:36 am
... All of these are changes that need to be made in the main database. I don't have the debut column in my db, so I just fudged it in this case. Hinchliffe...
11
Sean Lahman
slahman@...
Oct 11, 2001 8:11 pm
Am I missing something, or is there a reason why all of the pitcher ERA's are "NULL" in the update? Easy enough to calculate, of course. --S...
12
Justin Kubatko
jkubatko@...
Oct 11, 2001 9:01 pm
Sean(s), In the 2001 "TEAM.txt"; file, the New York Mets and New York Yankees team_id's are reversed: NYN AL E 161 95 65 ... NYA NL E 162 82 80 ... Thanks, ...
13
Justin Kubatko
jkubatko@...
Oct 11, 2001 9:48 pm
Sean, ... This is also the case in the batting file... piazzmi01 2001 NYA NL jeterde01 2001 NYN AL ...as well as the pitching file: appieke01 2001 NYA NL ...
14
Sean Forman
sforman71
Oct 12, 2001 4:18 am
... Thanks, there was an error in how I had my ID's and the Lahman team ID's cross-referenced in my team table. They should be right now. Also, I updated the...
15
Justin Kubatko
kubatko
Oct 12, 2001 3:41 pm
Sean, Dave Martinez of the Atlanta Braves is listed in the 2001 pitching file, but is not credited with a game pitched. Did he actually appear as a pitcher ...
16
Sean Lahman
slahman@...
Oct 12, 2001 4:03 pm
The Sporting News shows a pitching line for him but no IP, no batters faced, and no credit for a game appaearance. ESPN shows the same thing. I'm going to...
17
Sean Lahman
slahman@...
Oct 12, 2001 5:24 pm
See: http://espn.go.com/mlb/profiles/gamelogs/2001/pitching/3898.html STATS erroneously shows Dave Martinez throwing 17 pitches in the July 4 game against ...
18
Sean Forman
sean-forman@...
Oct 13, 2001 12:43 am
... Good catch. I deleted the record and the site will show the update in a minute or so. Did I mention that I'm glad I wrote a script that does the dump and...
19
Michael Mavrogiannis
mmavrogi@...
Oct 13, 2001 1:49 pm
Zounds: Update Master set Lastname="Wilson" where Lastname="A. Wilson"; For consistency with all the other players known by their initials: Update Master set...
20
Sean Forman
sean-forman@...
Oct 14, 2001 2:08 am
... Thanks for catching this. The site has been updated. Sincerely, Sean Forman Baseball Stats! http://www.Baseball-Reference.com/ Baseball Analysis!...
21
micke.hovmoller@...
Oct 15, 2001 3:51 pm
Warning: Long post! Some changes I'd like to see made to the Lahman DB. And also a bunch of questions, suggestions, etc. Take it for what it's worth. 1. I'd...
22
Sean Lahman
slahman@...
Oct 15, 2001 4:09 pm
I'll follow up to some of Micke's comments... ... I don't think this data is that easy to find, and I've always resisted this sort of thing for a couple of...
23
Tom Tom
tmasc@...
Oct 15, 2001 4:41 pm
... be added *** *** Yes, this should be done before releasing the database. Milwaukee 98-2000, there are 2 hitters in 1997 (one has SEA NL as an entry), etc,...
24
Tom Tom
tmasc@...
Oct 15, 2001 4:44 pm
... be added *** *** Yes, this should be done before releasing the database. Milwaukee 98-2000, there are 2 hitters in 1997 (one has SEA NL as an entry), etc,...
25
Sean Forman
sean-forman@...
Oct 15, 2001 9:35 pm
micke.hovmoller@... wrote: I don't think I'm repeating anything anyone else has posted on this, so I'll just answer as I go. ... BR.com is...
26
Sean Forman
sean-forman@...
Oct 15, 2001 9:43 pm
Greg sent this to me and labeled it the "ultimate Baseball Reference". I think I agree. I've annotated some of the entries. Players Major League Statistics ...
27
micke.hovmoller@...
mhovm1
Oct 16, 2001 10:07 am
... As Sean F suggested, it is perhaps better to include the instructions on how to create these tables as opposed to actually including the tables with data...
28
micke.hovmoller@...
mhovm1
Oct 16, 2001 10:36 am
... Team order is the "proper" solution, definitely. The question is, is it the desirable solution? The trade-off is the amount of time it takes to gather and ...
29
Tom Tom
tmasc
Oct 16, 2001 6:50 pm
... Braves ... called 'BOS'. *** *** Team ID must be unique, unless you ensure that the League field is always paired up to the Team ID field. Any field that...
30
Michael Mavrogiannis
mmavrogi
Oct 16, 2001 10:51 pm
For pitchers, the pattern seems to be that the Batting.G column shows the number of non-DH games in which the pitcher played, except for pitchers who did not...
