... Hash: SHA1 ... History.zip ... Regarding the above spreadsheet, which does PARK_ID point to: 1. RetroParkID 2. KJOKParkID as per ParksXREF.txt under...
1901
KJOK
kjokbaseball
Jan 1, 2004 8:20 pm
Funny you should ask that, as I'm actually working on a "super" league table while watching football today. This new table will include ALL leagues, both...
1902
baseball-databank@yah...
Jan 1, 2004 8:22 pm
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 : /...
1903
baseball-databank@yah...
Jan 2, 2004 4:26 am
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 : /...
1904
Michael Westbay
westbaystars
Jan 2, 2004 4:39 am
... Hash: SHA1 ... To that end, I've generated such a table from the Team_Table_CMS_Version.xls file on the SABR research site. The method by which I...
1905
Michael Westbay
westbaystars
Jan 2, 2004 4:41 am
... Hash: SHA1 ... Please see this message for the uploaded data file: http://groups.yahoo.com/group/baseball-databank/message/1903 - -- Michael Westbay ...
1906
KJOK
kjokbaseball
Jan 2, 2004 5:20 am
Michael: Actually, what you've done is great! I was basically doing the same thing, only a little more manually, with the Classification Codes in a separate...
1907
KJOK
kjokbaseball
Jan 2, 2004 5:24 am
... <westbaystars@j...> wrote: ... directory. .... The spreadsheet refers to the "KJOKParkID's" which are now 99.9% the same as the RetroParkID's, the only...
1908
Michael Westbay
westbaystars
Jan 2, 2004 6:54 am
... Hash: SHA1 ... It's part of the effort to normalize the database. One key rule is to have only ONE primary key per table. (Multiple unique fields are...
1909
Daniel Levine
dmlco
Jan 2, 2004 4:46 pm
Hi folks! In working with the Design group on the normalization, three data errors have cropped up. These aren't incorrect numbers, but, rather, incorrect ...
1910
KJOK
kjokbaseball
Jan 2, 2004 6:27 pm
... wrote: ... Don't know why, as the pitchingpostalt.csv file has NULL, but it should definitely be NULL. ... I believe this value should also be NULL, at...
1911
Sean Forman
sforman71
Jan 3, 2004 12:45 am
Thanks for pointing these out Mitchell. I'll add them to the list of corrections to make. The pitcher's batting entries are handled poorly. I believe what...
1912
Sean Forman
sforman71
Jan 3, 2004 12:51 am
... I don't believe it was intentional. I don't believe the data is known, and the columns were added with the intention that it would be added in the future....
1913
baseball-databank@yah...
Jan 3, 2004 8:21 am
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 : /...
1914
tjruane
Jan 3, 2004 4:02 pm
... That's odd. My database has this information and I believe I got it originally from the 1994 TB CD, which I think was also the source for Sean's data. ...
1915
tjruane
Jan 3, 2004 4:11 pm
... Again, perhaps I'm misunderstanding something, but if this is how batting games are handled, how do we tell how many games a pitcher appeared in? Let's...
1916
Sean Forman
sforman71
Jan 3, 2004 4:43 pm
... I was mainly referring to the reason that the pitchers had low numbers of games appeared in the batting table. We don't at the moment have a policy about...
1917
Sean Forman
sforman71
Jan 3, 2004 4:45 pm
... Ahh, I didn't think we had SH and SF columns, but I was too lazy to check and took Tom's note to say they were in there. We have never had these columns,...
1918
tmasc@...
tangotiger
Jan 3, 2004 6:23 pm
Tom, You are correct that the current design does not support the "games played" for a single player, but rather by his "role" or "position";. The new design...
1919
KJOK
kjokbaseball
Jan 3, 2004 9:40 pm
I apologize that I didn't think this through when Michael first questioned about League tables. Upon further review, since the "main" data level of...
1920
baseball-databank@yah...
Jan 3, 2004 9:41 pm
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 : /...
1921
tmasc@...
tangotiger
Jan 3, 2004 9:52 pm
KJOK/Paul, One thing that has come up is the association of the minor league teams to the MLB teams, with respect to a Franchise. Suppose that you have a minor...
1922
KJOK
kjokbaseball
Jan 3, 2004 10:42 pm
To try to answer all these good questions: First, we should make clear to everyone that "Franchise ID" is really NOT technically franchise but is really Team...
1923
KJOK
kjokbaseball
Jan 3, 2004 11:11 pm
I should also mention that, while Mr. Henry did an excellent job creating Team_Table_CMS_Version.xls, it does have some errors and typos. If someone has the...
1924
baseball-databank@yah...
Jan 4, 2004 1:52 am
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 :...
1925
tangotiger
Jan 4, 2004 1:53 am
Fielding data has been uploaded, but not verified. It's been broken down by various keys. 3 separate files. There's a readme file as well. Tom...
1926
tjruane
Jan 4, 2004 4:52 pm
... I think Sean is talking about 2 entirely different situations here. Pitchers, even if there is a DH, still appear in the lineup. If you looked at lineup...
1927
tjruane
Jan 4, 2004 4:59 pm
... I'm too busy working on the next release of the Retrosheet web-site, transaction data and player data-base right now, but in a month or so I would be more...
1928
KJOK
kjokbaseball
Jan 4, 2004 8:22 pm
"...pitcher doubles, triples allowed, stolen bases and caught stealing? catcher wild pitches? batting reached on catcher interference" I will just say yes,...
1929
tangotiger
Jan 4, 2004 9:00 pm
I would say that if anyone can provide any of the "holes" in the data, it would be much appreciated. (see list below) For some reason, I neglected to include...
