Micke, G_old was the old value before I created the appearances table. I think the issue for the players below is that they were injured before the game ...
SABR is planning on revising their booklet on how to do baseball research and putting it on-line. One of the sections in the guide will be a discussion of...
3784
Tangotiger
tom@...
Aug 26, 2009 8:15 pm
... There are a few out there. Here's one: http://statspeak.net/2008/11/building-a-sabermetricians-workbench-part-i.html And you can quote Adler's book as...
Here is a great online tutorial on building an SQL database with databank http://statspeak.net/2008/11/building-a-sabermetricians-workbench-part-i.html ...
... There are a couple of data sets available from NPB (Nippon Professional Baseball) here: http://www.japanesebaseball.com/data/ The first one is mine. The...
Thanks for all the help. If the group doesn't mind, I might post a preliminary draft to the File section in a few weeks for review. Thanks again. Tom Ruane...
This could very well be a stupid question, but how similar is the data on baseball-databank and baseball1.com? I thought that at one point these were the same...
3789
Tangotiger
tom@...
Aug 31, 2009 3:27 pm
Of the tables that intersects, I would have to say the data is identical. I provided Lahman (and this group) with an Access script that loads all the...
Tangotiger; I found your "primpos.mdb" in the files section. I would like to use your queries with the Lahman 5.6 database. My interest is career prime...
3791
Tangotiger
tom@...
Sep 1, 2009 3:40 pm
That would seem to be correct. Try it out, and see what you get. Tom ... The Book--Playing The Percentages In Baseball http://www.InsideTheBook.com...
... Tom is correct. The underlying data is identical. The output formats are what's different. Sean Forman and I formed the baseball databank to help...
pardon my ignorance, but what is the primpos.mdb database?...
3795
Tangotiger
tom@...
Sep 2, 2009 2:05 pm
It's in the Files section. I don't remember if I put a Readme file with it. It's an Access query that figures out the primary position of every player....
Matthew; If you feel that Tom's primpos.mdb is something you might be interested in using, just be aware you need to make some changes to use it with later...
For anyone interested I have uploaded a text file (MLB Outfielder Positions.txt) to the files section. It contains around 480 major league outfielders and...
Thanks. I actually wrote a few functions as part of a php library to handle the data. One is a method of determining primary position and another is a list of...
3799
Tangotiger
tom@...
Sep 3, 2009 1:47 pm
PrimPos.mdb is dynamic. It'll automatically recalculate the positions any data the data set changes. Tom ... The Book--Playing The Percentages In Baseball ...
That's awesome Tom, I didn't know that, sorry for making an assumption. Is there anything that automatically updates data within the current season?...
3801
Tangotiger
tom@...
Sep 3, 2009 5:10 pm
... Best bet is to join the RetroSQL group. There's a couple of (external) ongoing things that are highlighted there. Tom...
On Wed, 26 Aug 2009 19:57:54 -0000, tjruane wrote: [snip] ... [snip] Tom: The Baseball Cube *is* willing to sell data. Never tried it, but it looks like they...
3803
Tangotiger
tom@...
Sep 8, 2009 1:33 pm
... I have a fairly exhaustive list here: http://tangotiger.net/wiki/index.php?title=Websites#Data Tom...
If this includes just raw data, there is some Japanese data here: http://japanesebaseball.com/data/index.jsp And I created a pretty decent database of the...
... I know you said no nitpicking allowed, but I should point out that these guys have duplicate records: davisch01 bondsbo01 winfida01 beltrca01 davisto02 ...
As I mentioned earlier, SABR is planning on updating its 2000 booklet, "How to Baseball Research" and making it available on-line. An early version of the...
I joined and searched retrosql and did not see anything for current year stats. Is there some kind of guide or readme on how things work on the group?...
Why not using >,<,=,>=,<=,<> instead of 'like' operator? Like operator is normally used for strings values. Ex. Select * from batting 3B > 23 .. Also you...
