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...
4296
railsplitter_44
Dec 1, 2012 2:18 pm
I have a spreadsheet of L/R splits for pitchers and hitters for the pbp years (1945-2012), if you are looking for the data. If you are looking for pre-pbp...
4297
James Gentile
dangerwhatevs
Dec 1, 2012 4:10 pm
The pre-pbp splits estimates would be fascinating to see, if you don't mind. ... The pre-pbp splits estimates would be fascinating to see, if you don't mind....
4298
KJOK
kjokbaseball
Dec 1, 2012 5:24 pm
I think those would be nice additions to the database. THANKS, Kevin ... I think those would be nice additions to the database. THANKS, Kevin From:...
4299
Clem Comly
ccomly2003
Dec 3, 2012 2:25 pm
Split table may create confusion. As one does 20th century seasons splits don’t add exactly up to official totals. Also if we do true stints as opposed to...
4300
Tangotiger
tom@...
Dec 3, 2012 2:42 pm
I think the idea is to create splits off the Retrosheet event files, no different than what Baseball-Reference and Retrosheet.org does. It's really fairly...
4301
Paul Reeths
paul.reeths
Dec 3, 2012 3:51 pm
It seems as if there is some interest in the basic splits table. Are there any other loose tables or other data that others would like to see integrated,...
4302
aidanshealy
Dec 20, 2012 7:21 pm
Anyone have the 2012 debut players in the Master Player table? I run some data points off that Master table and was just wondering when/if just that table...
4303
anson2995
Dec 21, 2012 2:32 pm
We'll have a full release shortly. Here's a list of the players who debuted in 2012 with the assigned IDs. There are also new IDs for a manager, a HOF member,...
4304
anson2995
Jan 2, 2013 9:03 pm
An updated version of the database is now available, in both the CSV and Access versions. Links are below. CSV:...
4305
Tangotiger
tom@...
Jan 2, 2013 9:27 pm
For the batter's hand: you should make it as bathand and pithand, especially notable for someone like JT Snow who used to switch hit, and then didn't. We...
4306
KJOK
kjokbaseball
Jan 2, 2013 10:25 pm
My suggestion for H/R and left/right is to split first by H/R, THEN by L/R  H and Bathand A and Bathand etc. for both batters and pitchers. Switch hitters...
Hans Van Slooten was kind enough to pull together an SQL version of the updated database, for those who roll that way. Big thanks to Hans. Here's a link. ...
4309
Clem Comly
ccomly2003
Jan 3, 2013 12:13 pm
I downloaded the Access version but it doesn’t contain the consistency queries. I assume someone has run them. Could they post the queries and the results...
4310
Jeff
jnyveen
Jan 3, 2013 4:04 pm
Any chance of getting pitchers' doubles and triples against this year? -j...
4311
Chris Lambrou
chrislambrou
Jan 3, 2013 4:04 pm
Question for the master table: On players who debut in 2012 there appears to be a hexadecimal number in an unnamed column at the end (after bbrefID).  Is...