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...
4266
Clem Comly
ccomly2003
May 17, 2012 1:01 pm
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...
4267
KJOK
kjokbaseball
May 18, 2012 5:00 am
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...
4268
Clem Comly
ccomly2003
May 18, 2012 11:58 am
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...
4269
Clem Comly
ccomly2003
May 18, 2012 11:58 am
Yes, Rex Smith. Thanks, Kevin. But all existing smithre01 records will need stint = 2 (Fielding,Pitching, Batting) before changing smith02 to smithre01. ...
4270
Clem Comly
ccomly2003
May 20, 2012 11:43 am
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...
4271
OrcomBoy
May 28, 2012 10:58 am
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...
4272
KJOK
kjokbaseball
May 28, 2012 6:15 pm
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...
4273
chrislambrou
May 29, 2012 11:59 am
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...
4274
KJOK
kjokbaseball
May 29, 2012 6:46 pm
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 ...
4275
Sean Forman
sforman71
May 29, 2012 7:03 pm
sean ... Sean Forman Sports Reference LLC, President http://www.sports-reference.com/ ... sean --- Sean Forman Sports Reference LLC, President...
4276
chrislambrou
Jun 5, 2012 8:48 pm
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...
4277
railsplitter_44
Jun 5, 2012 9:50 pm
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...
4278
KJOK
kjokbaseball
Jun 5, 2012 10:13 pm
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...
4279
Clay Dreslough
upa2112
Jun 7, 2012 1:43 pm
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...
4280
chrislambrou
Jun 7, 2012 1:44 pm
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...
4282
mattr
mixmastermr
Jul 3, 2012 1:01 am
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...
4283
dangerwhatevs
Jul 4, 2012 2:24 am
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...
4284
James Gentile
dangerwhatevs
Jul 4, 2012 2:01 pm
Obviously that should read '2011'....
4285
Paul
paul.reeths
Sep 5, 2012 2:17 am
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...
4286
kevine323
Sep 11, 2012 2:12 am
Can you post your query? Thanks, Kevin...
4287
dangerwhatevs
Sep 11, 2012 10:04 am
Sorry Kevin, I've since learned the art of indexing and that fixed my speed issues. Operator ignorance. I appreciate the concern, though....
4288
Matthew Gargano
tkestars
Sep 11, 2012 1:59 pm
Good old PEBCAK!...
4289
kevine323
Sep 11, 2012 2:00 pm
Gotcha! I just came across this group and the database yesterday, so I'm pretty stoked. This brings my two passions together, baseball and database (I'm a SQL...
4290
Paul Reeths
paul.reeths
Sep 14, 2012 11:13 am
Just wanted to provide a quick update on the minor league statistical database project. I've heard from several people who want to assist the project in...
4291
Mark Knopper
mirv
Sep 14, 2012 2:51 pm
Paul, I'd consider helping with this. I am the author of the iPhone app, "Baseball Statistics 2012 Edition". I've been updating the app with the latest...
4292
aidanshealy
Nov 30, 2012 12:21 am
Is there a group that is working on this? Does anyone need help with anything? Scrubbing through data or anything like that? I am definitely interested in...
4293
anson2995
Nov 30, 2012 2:41 pm
No assistance need at this point, but thanks for the offer. I'll post details on a 2012 update soon. Would like to restart efforts to work on some other...
4294
Paul Reeths
paul.reeths
Nov 30, 2012 3:53 pm
If there is anything I can do to help in the area of integrating some of the loose tables or cleaning any of them up, please let me know. Paul Reeths OurSports...
4295
KJOK
kjokbaseball
Nov 30, 2012 5:02 pm
One project we've discussed on and off over the years was some type of basic splits table for batters and pitchers. Â Would probably just include bat-hand and...
