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 ...
I don't see any draft info in the master table and no external files that seem to contain this - is there a source for draft data elsewhere? Is this one of...
The only free data that I know of is from the retrosheet transactions database. But this will only contain draft info from players who made it to the major...
The data has been compiled, as you can see here: Â http://www.baseball-reference.com/draft/ Â However, to my knowledge that dataset has not been publicly...
Speaking of stints, is there a consensus on the abbreviation to use for the single-game wild card round when displaying player stats? For example, the current...
PlayerID for year 2011 is 'ortizra02' instead of 'ortizra01' in the appearances table only. Please let me know if I am missing something. Thanks. -Chris...
While trawling through this board I found a post about SABR's Baseball ID Working Group (Message #4130 Apr 11, 2011). It looks like that project stopped...
I've noticed that any query involving a join with the Master table in the latest 2011 Lahman download seems to stall indefinitely. When I run the same query in...
Would anyone who might be interested in helping work on a minor league baseball statistical database reply to this post or email me directly? I know there was...
