(Cross-posting to Retrolist and BDB) This is to point out a discrepancy, without knowing which is correct. The Lahman DB and B-R.com has Jim Busby with one...
3595
tangotiger
Sep 3, 2008 12:58 am
Thank you for showing that the best answer is found in the easiest of places. Tom ... From: J. G. Preston <jgpreston@...> Subject: Re: [RetroList] Jiim...
3596
Dave Carter
terpsfan101
Sep 26, 2008 11:15 am
I have compiled additional batting and pitching statistics from Retrosheet Play by Play data and wanted to share them here. I've linked the Retro ID's to the...
3597
Matthew Gargano
tkestars
Sep 26, 2008 7:16 pm
Dave - Thanks so much for your efforts from the baseball databank group! I was wondering if you could show me a thing or two. Also I was wondering if you knew...
3598
Dave Carter
terpsfan101
Sep 26, 2008 9:06 pm
Matt, I don't know anything about scraping data. The basic data (AB,H,...)is already in the BDB database. Unless you wanted to derive the basic data for 2008....
3599
Tangotiger
tom@...
Sep 26, 2008 9:06 pm
... Join RetroSQL yahoo group. Tom...
3600
Charles Saeger
rasputin443556
Sep 27, 2008 3:23 am
... For pre-1980 years, the differences between these will blur in the data, and you won't have hits. I'd just go for: Air Outs - Pulled Ground Outs - Pulled ...
3601
Dave Carter
terpsfan101
Sep 29, 2008 9:36 pm
Charles, Most of your suggestions shouldn't be difficult to implement. I had a feeling that I should have used outs for batted balls. Although seperating "Outs...
3602
Dave Carter
terpsfan101
Sep 30, 2008 6:35 pm
I guess that I could throw out some of the baserunning categories. Here's my new list: Batting: XI ROE ROE SH ROE SF RFC RFC SH PkO CS PkO PkO Error GB FB LD ...
3603
yonushonis
Sep 30, 2008 6:57 pm
I realize the season isn't over yet, but I always like the info....
3604
Sean Forman
sforman71
Sep 30, 2008 7:01 pm
There is a chance it will be next week. sean ... -- Sean Forman President, Sports Reference LLC http://www.sports-reference.com/...
3605
hackersdienow
Oct 7, 2008 7:34 pm
Hey guys...I don't know if anyone else noticed this since it's not a huge deal 99% of the time, but for some reason in the 2007 season (most recent in the...
3606
Tangotiger
tom@...
Oct 7, 2008 8:28 pm
We've longed discussed the idea of an APPEARANCES table, so that it captures exactly what it's supposed to capture, rather than taking over the BATTING table...
3607
hackersdienow
Oct 8, 2008 1:32 pm
That's the way I would approach it as well if I were the guy doing the building of the DB...I highly recommend Lahman/Forman work toward that goal. It sounds...
3608
Tangotiger
tom@...
Oct 8, 2008 1:59 pm
... There are no current plans, that's correct. How/when this will be rectified is undetermined. Tom ... The Book--Playing The Percentages In Baseball ...
3609
hackersdienow
Oct 9, 2008 12:27 pm
OK...thanks Tom. I'm going to ask our web coder to McGuyver an appearances table...that's the correct way to normalize the database anyway....
3610
wyerscj
Oct 19, 2008 12:00 pm
... some of the ... MySQL ... fields are ... range of ... int(4), ... as yearID ... Similarly, ... of ... season (or ... of 0 - ... playing ... been able ... ...
3611
Paul DuBois
pdubois20
Oct 19, 2008 4:48 pm
... If the nature of the data is that it is unsigned, it should be stored in an unsigned column. If the nature of your application is that you use the values...
3612
James
emiduplam
Oct 21, 2008 9:45 pm
... Anything in baseball that could possibly be a negative number?...
3613
Tangotiger
tom@...
Oct 22, 2008 1:20 am
Regarding the tinyint and int and the like issue: I disagree. I'll give you two good reasons: 1. An 8 GB flash drive costs $29. A 500 GB backup drive costs...
3614
Clem Comly
ccomly2003
Oct 24, 2008 5:43 pm
1952 Bud Black for Detroit-- his season IP total should be 7.2 not 8. Daily on microfilm has 7.2 for him and all the other Detroit Ps IPs are OK (seems to me...
3615
Sean Forman
sforman71
Nov 10, 2008 5:51 pm
I've made good progress on the BDB update for this year and should have something soon. I'm adding an Appearances table with the following schema (this will...
3616
KJOK
kjokbaseball
Nov 11, 2008 7:06 am
I think we've discussed having an appearance or roster table before, and talked about it as a very good idea.  I'm less clear about the need for the Batting...
3617
Sean Forman
sforman71
Nov 11, 2008 12:15 pm
... I see this as backwards compatibility. I know that lost of people use the tables as is and historically G has been all games played. This will leave ...
3618
tangotiger
Nov 11, 2008 12:18 pm
It is usually desirable to go vertically, than horizontally, like so: http://sports.groups.yahoo.com/group/baseball-databank/message/3606 You can create more...
3619
Matthew Gargano
tkestars
Nov 11, 2008 12:40 pm
Sean: That schema sounds great to me. Just a quick question - I did some research and searched the Yahoo! group and couldn't find the answer to this. There...
3620
robert bluestein
robertbluest...
Nov 11, 2008 3:50 pm
You can do it that way, but SABRE prefers it to be the other way. Â Â ... From: Tangotiger <tangotiger@...> Subject: Re: [baseball-databank] 2008...
3621
Tangotiger
tom@...
Nov 11, 2008 5:06 pm
Who is "SABRE", and can you cite their reasoning? Tom ... The Book--Playing The Percentages In Baseball http://www.InsideTheBook.com...
3622
Sean Forman
sforman71
Nov 13, 2008 7:27 pm
I've updated a BDB update today. Here are the release notes. One should consider this a proposed release as I would like lots of review to point out any...
3623
Tangotiger
tom@...
Nov 13, 2008 9:57 pm
Two hours without comment? I hope that's because we are in shock and not passe over this. Anyway, a huge thanks to Sean for delivering the data. I am going...
