Was the promptly implemented decision to rename the Managers.inseason field to Stint a wise one? The field indicates a very different thing than the existing...
1950
baseball-databank@yah...
Jan 16, 2004 7:00 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 : /...
1951
KJOK
kjokbaseball
Jan 16, 2004 7:02 am
I've posted what could be called a "prototype" for a Master Leagues File. I'm looking for feedback on the design and data elements before I get too far into...
1952
Michael Westbay
westbaystars
Jan 16, 2004 8:49 am
... Hash: SHA1 ... Regarding data: There were no games played in Japan in 1945 due to the war. That should either be a comment or the 1945 record should be...
1953
KJOK
kjokbaseball
Jan 16, 2004 3:49 pm
Michael: Thank you very much for the feedback. THis is exactly what I was looking for, as it's made me rethink what this would look like in "relational"...
1954
schedulejunkie
Jan 17, 2004 9:31 pm
Hi, just joined the group after lurking here for awhile. My personal area of interest are the playing schedules, both major and minor, so with that in mind let...
1955
KJOK
kjokbaseball
Jan 17, 2004 10:13 pm
1. Regarding the seaoson length, I was torn on whether to show the ACTUAL season length or the SCHEDULED season length. I think the information that is the...
1956
Paul Wendt
pgw02472
Jan 17, 2004 11:38 pm
... One team plays 161 games, another in the sameleague plays 163. ... Anyway, a comment field will be needed before 1892, or is it 1902 or 1921? By the way:...
1957
Larry Flatt
bball2339
Jan 18, 2004 12:48 am
Mike Venafro has been kind enough to allow a one hour chat session from 7 est to 8 est this coming Monday night. I will post a topic at 7 pm est in this...
1958
schedulejunkie
Jan 18, 2004 1:21 am
... I would say the scheduled length of the season is more relevant, as this is the plan the league was going to follow. The only reason teams end up playing a...
1959
KJOK
kjokbaseball
Jan 18, 2004 1:56 am
Yes, some teams may play 161 and another 163. I'm thinking the information in the table should probably be: 1. SCHEDULED Games per team - In almost every...
1960
KJOK
kjokbaseball
Jan 18, 2004 2:02 am
Yes, I agree. I think we'll definitely want to document in some way what the levels really mean relative to the major league level. schedulejunkie...
1961
KJOK
kjokbaseball
Jan 18, 2004 5:44 am
Paul - is information on reserve prices compiled somewhere for 19th century seasons? In years where there were no formal classifications (mostly 19th century)...
1962
Michael Westbay
westbaystars
Jan 18, 2004 11:31 am
... Hash: SHA1 Sorry for the delay getting back to you. Someone's asked for a lot of historic data on my site ;-), and I've been trying to finish up the 2003 ...
1963
KJOK
kjokbaseball
Jan 19, 2004 5:26 am
Michael Westbay <westbaystars@...> wrote: ..opting for a non-recursive structure with the following tables: ~ Classifications ~ Leagues ...
1964
Paul Wendt
pgw02472
Jan 19, 2004 2:31 pm
... Today it is. There was no such organization in 1901-1902, nor an organization including the Federal League in 1914-15, etc 19th century. So the...
1965
Michael Westbay
westbaystars
Jan 20, 2004 2:49 pm
... Hash: SHA1 ... It was pointed out that perhaps I need to read your paper on continuity. Do you have it in text or PDF format somewhere? I think that ...
1966
tmasc@...
tangotiger
Jan 20, 2004 3:34 pm
... This has happened in the NHL as recently as 30 years ago (Cle merging with Minnesota, and staying in Minnesota... essentially, Min "bought out" Cle, and ...
1967
Derek Adair
D_Adair
Jan 21, 2004 9:28 am
In the teams table, four columns are defined as: DivWin enum('Y39;,'N') NOT NULL default 'N', WCWin enum('Y39;,'N') NOT NULL default 'N', LgWin enum('Y39;,'N') NOT...
1968
KJOK
kjokbaseball
Jan 21, 2004 8:54 pm
I have completed the Postseason Fielding Table. Sorry it took so long, but it turned out to be more work than I had envisioned, and I got sidetracked on some...
1969
baseball-databank@yah...
Jan 21, 2004 8:55 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 :...
1970
Sean Forman
sforman71
Jan 22, 2004 3:04 am
... Thanks, I'll look to make there more consistent in the next iteration. Also, Kevin, GREAT work on the fielding post. very, very nice. -- Sincerely, Sean...
1971
Paul DuBois
pdubois20
Jan 22, 2004 3:31 am
... If we're talking about loading the data into MySQL (which it looks like from the use of ENUM columns above), that change may not be an improvement. At...
1972
Derek Adair
D_Adair
Jan 22, 2004 3:40 am
... You are correct. However, the decision was made as a group to use ,, as nulls. Each user will need to convert those ,, into proper representations of null...
1973
KJOK
kjokbaseball
Jan 22, 2004 4:38 am
I've searched the archives here, and can't find that "paper" on continuity - it may have been in an email. Trying to recreate it: "FranchiseID" is really a...
1974
Paul DuBois
pdubois20
Jan 22, 2004 6:15 am
... Okay. I was unaware of that. Thanks....
1975
Michael Westbay
westbaystars
Jan 22, 2004 12:11 pm
... Hash: SHA1 ... OK. That's pretty much what I thought a franchise was. Now, how do we define a franchise in the database? If I'm not mistaken, the...
1976
KJOK
kjokbaseball
Jan 22, 2004 10:36 pm
... <westbaystars@j...> wrote: "So, here's what I would propose for a (non-normalized) Franchises table: create table Franchises ( ~ Franch_ID varchar(3) not...
1977
Paul Wendt
pgw02472
Jan 23, 2004 12:08 am
Regarding "merger": ... Maybe. "merged" in what sense? Michael's 22 Jan 2004 followup does not answer that for me. ... On what grounds? The new hyphenated...
1978
baseball-databank@yah...
Jan 23, 2004 12: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 : /...