As some of the folks from around the web who know me and my sabermetric research have requested, I've taken the time to document my "uberstat" invention,...
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 9, 2007 12:12 am
3319
The file I just uploaded contains definite errors in the FieldingOF table. (I think Tom Ruane may have reproted this a couple of years ago). The obvious...
I think there are a few mistakes in the Retrosheet team ID's in the Teams table: Washington, 2005 and 2006 - listed as MON, should be WAS LA Angels of Anaheim,...
Hi, Is there a data dictionary for the latest version of the Baseball Databank? Specifically, table names with field names and an explanation of the purpose of...
The Lahman database, at baseball1.com, has the best documentation for that. Tom ... http://www.InsideTheBook.com The Book--Playing The Percentages In Baseball ...
Has anyone created a front end for the database? I am currently weighing in the options as to how to manage this using Visual Basic. I was just wondering if...
I know this isn't what you are describing, and it does cost money, but I'm planning on keeping the Baseball-Reference Play Index up-to-date during the season....
I can heartily recommend the PI. As well, you should join the Retrolist Yahoo group, as someone just posted a link in the past few days to a sourceforge...
... What would be me ;-> I'll have the files from Baseball Databank available in Postgres, SQLite (http://www.sqlite.org), Derby (http://db.apache.org/derby/),...
... Randy Myers developed a front that is available for free download from my website (http://baseball1.com/statistics/bss.html). It's great for people who...
I'm thinking about how one would go about designing an effective query interface without the user having to know SQL, a way to pose a query in english and have...
I've run into the same problem (a week or so ago actually). I'm not sure what I've done different since, but this seems to work: SELECT Master.playerID,...
If all you require is an integer for an age, may I suggest simply doing: yearid - birthyear. Who really cares whether the guy was born Jun 30 or Jul 2, or Dec...
I generally use yearid - birthyear + (birthmonth > 6) The birthmonth > 6 is computed as a boolean, so it is either 1 or 0 depending on whether it is true or...
Oops, I take it back, that query included an extra table I made up (from a tangotiger query) that included positions for batters. This one should be compliant...
I was using a IIF statement in my Access 2000 database to calculate the age as of July 1 in a query. I just tried Sean's formula which is probably more ...
Yes, thank you. For some reason, I didn't include parens. This is probably the most clear yearid - (birthyear + (birthmonth > 6)) for example if birthyear=1980...
I just want to reiterate that, in society, only with ages do we not round. If you are 26.99 years old, you are "26". If someone is born on July 2, 1980, then...
First, let me thank everyone for taking the time. Charles, your SQL worked perfectly, so thank you very much. Truthfully, it never dawned on me to do something...
Tango, There is actually a reasonable reason for using July 1st as the cutoff. When you do that the player's age is given as the age they played most of the...
Sean and Mr. Myers, Excellent work on the B-R PI package! I think you have just made Sean's database info available to exponentially more baseball fans, and...
... Doesn't this assume that the birthrates are even throughout the year? It could just be that more kids are born in August and September. You'd probably need...
... . ... I'm probably butchering the results of the study, but I think the original study was for hockey and they found a similar effect, but between Dec. and...
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.
