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...
3323
tangotiger
Mar 6, 2007 12:58 am
The Lahman database, at baseball1.com, has the best documentation for that. Tom ... http://www.InsideTheBook.com The Book--Playing The Percentages In Baseball ...
3324
JeffBernstein
Mar 6, 2007 2:34 pm
... Exactly what I was looking for! Thanks! -Jeff...
3325
brad.behnke
Mar 7, 2007 1:28 am
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...
3326
Sean Forman
sforman71
Mar 7, 2007 1:34 am
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....
3327
tangotiger
Mar 7, 2007 1:38 pm
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...
3328
mkovach
matkovach
Mar 7, 2007 2:25 pm
... 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/),...
3329
Sean Lahman
anson2995
Mar 7, 2007 4:00 pm
... 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...
3330
Jeff Bernstein
JeffBernstein
Mar 7, 2007 6:06 pm
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...
3331
Jeff Bernstein
JeffBernstein
Mar 7, 2007 6:15 pm
Hey, that's pretty cool!! Nice job! -Jeff...
3332
btibert3
Mar 7, 2007 9:10 pm
I am using the current release of Sean's DB and I am trying to calculate the age for each pitcher with the following SQL: SELECT Pitching.playerID,...
3333
Charles
chazcreasy1
Mar 7, 2007 10:07 pm
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,...
3334
tangotiger
Mar 8, 2007 12:20 am
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...
3335
Sean Forman
sforman71
Mar 8, 2007 12:40 am
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...
3336
Charles
chazcreasy1
Mar 8, 2007 12:41 am
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...
3337
Keith Hemmelman
khemmelman
Mar 8, 2007 1:46 am
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 ...
3338
John Walsh
walshj58
Mar 8, 2007 9:49 am
Shouldn't that be yearid - birthyear - (birthmonth > 6) ?...
3339
Sean Forman
sforman71
Mar 8, 2007 9:53 am
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...
3340
tangotiger
Mar 8, 2007 1:43 pm
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...
3341
btibert3
Mar 8, 2007 2:15 pm
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...
3342
Sean Forman
sforman71
Mar 8, 2007 2:22 pm
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...
3343
cjhaddick
Mar 8, 2007 2:25 pm
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...
3344
Douglas Creager
dc1847
Mar 8, 2007 3:04 pm
... 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...
3345
Sean Forman
sforman71
Mar 8, 2007 3:18 pm
... . ... 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...
3346
roca_h@...
rocwwm2001
Mar 8, 2007 3:54 pm
Sean, do you know of any Minor League database such as Baseball-Reference. Many thanks regards Henri...
3347
Theodore Turocy
arb1ter
Mar 8, 2007 4:08 pm
... There are (currently) no free, generally-available minor league databases. I've compiled data from 2005 and 2006 (and 1982) at ...
3348
aprileric_1999
Mar 8, 2007 4:27 pm
I pulled birth by month data from http://abcnews.go.com/Health/Science/story?id=990641 (Covering 1995- 2002) and found that the player distribution provided...
3349
Sean Forman
sforman71
Mar 8, 2007 4:29 pm
thebaseballcube.com has a lot of recent minor league info. I'm hoping to do some work on minor leaguers as well on BR, but it will be awhile. sean ... -- -- ...
3350
Tom Stillman
giantsfan_94121
Mar 8, 2007 6:44 pm
I agree but would like to add an additional 2 cents. Often we hear about someone being the "oldest" or "youngest"; to accomplish a certain feat in baseball. In...
3351
Tom Stillman
giantsfan_94121
Mar 8, 2007 6:54 pm
I have to agree with this. How many people do you know that were born at the end of September/beginning of October (conceived during the Holidays) and how ...
