Another advantage of having a STINTS table is that you can incorporate minor leagues as well. If someone has a Mets-Expos-Mets needs for same-year players,...
Without giving away (too many) trade secrets, I can state the following about the way I manage statistical data. There is only one statistical table,...
... The problem of bad data don't have anything to do with the database design. It's 100% attributable to me, the person who processed most of the updates....
I'm not sure what the source of the park factors for the database are, but I was under the assumption that it was the same as the multi-year park factors as...
Andy Phillips(phillan01), 2008, stint 1. Lahman 5.9.1 has 31 ABs. According to baseball-reference.com and Retrosheet, he only had 21 ABs. MLB.com has him...
My vote is to keep the stints as is. From a database perspective, it is much, much easier to take a stint divided table and sum it up to get the overall...
4252
Tangotiger
tom@...
Mar 24, 2012 11:28 pm
Paul, Your post is clear why we do *not* want to keep the stints as-is. The requirement about chrono-stints can already be addressed by a Stints table that...
Does anyone have a comment on the reply below? I'm always running into problems with appearances and have to use the fielding table. Not the best table to...
4254
Tangotiger
tom@...
Mar 26, 2012 6:47 pm
There's an APPEARANCES table in the Lahman DB. I haven't verified it, but that might help you. Tom ... The Book--Playing The Percentages In Baseball ...
Dear Members, Thank you to all who responded to my request for help for readers. As I get into the planning process for research, I'm sure that list members ...
I don't fully understand what is being proposed, but I just wanted to take a moment to speak out in favor of backwards compatibility. For example, people...
I don't currently have access to a good relational database. If I did, the solution for stints in Fielding.csv is easy. For all 2011 fielding stints for...
4258
Tangotiger
tom@...
Apr 8, 2012 3:05 pm
BDB or Lahman DB would be "backward compatible" with the proposed change, or at least have that as a potential. If we do this with a STINTS table that shows it...
Dear group members, Please excuse the cross posting. When examining more than one season's worth of data, do you think that there is a need to examine the data...
Being new to databases, I am wondering if someone might help me with instructions on how to query career stats from the csv data provided recently. I have...
4263
Tangotiger
tom@...
Apr 24, 2012 1:36 pm
You should download the Lahman MS Access database: http://www.seanlahman.com/baseball-archive/statistics/ It'll make life easier for you. Tom ... The...
The easy way: use microsoft access If you are using windows, the cheaper-and-not-as-easy-but-probably-better-way is to install XAMPP (or LAMP if you have a...
Hi there, I would like to merge (unite, join or however it's called) different databases. We have a baseball site to highlight stats of latino players and we...
The latest consistency check has 5 found when 2 expected. Two of the 5 are cases apparently where the same player is accidentally in Master twice. It looks...
I think smith02 is now smithre01 - Rex Smith? THANKS, Kevin ... 5 are cases apparently where the same player is accidentally in Master twice. It looks to me...
I downloaded the ACCESS version of the DB early this week and hope it is in sync with other versions, Alberto reported [query 09] There are 78 rows (season...
Yes, Rex Smith. Thanks, Kevin. But all existing smithre01 records will need stint = 2 (Fielding,Pitching, Batting) before changing smith02 to smithre01. ...
I downloaded Access version and it doesn’t come with consistency queries and posted consistency queries each need manual updating to run in access. For...
Good day, While I was merging the database with the current active rosters from mlb.com I came across the following discrepancies in birth dates: Name...
Freddie Garcia's discrepancy is I think well known. Apparently the date was originally mis-interpreted because 6/10 internationally is October 6th not June...
Probably a dumb question but can anyone lead me to a good source for 2012 MLB data? I'd like to provide current stats and suspect there are many services that...
From David Vincent via Rod Nelson, the SABR Biographical database (which Baseball-Reference.com uses) has most of these resolved: Player SABR DB MLB.com ...
