In my database I began with a basic join using players' full names and debut seasons to match baseball-ref IDs with Fangraphs, Elias, BP, MLB, retrosheet etc....
493
tangotiger
Feb 16, 2013 4:25 pm
The MASTER table in the Lahman database has the BRef ID. Tom ... The Book--Playing The Percentages In Baseball http://www.InsideTheBook.com...
494
James Gentile
dangerwhatevs
Feb 16, 2013 4:49 pm
Also a correction: looks like there are 202 cases where the bbrefID != master table's playerID. -- Uh, what?...
495
Theodore Turocy
arb1ter
Feb 16, 2013 5:23 pm
All, Chadwick Baseball Bureau maintains a master persons register and ID cross-reference, which is available under very good terms (basically: (a) share the...
496
Brian L Cartwright
brianlcartwr...
Feb 16, 2013 8:58 pm
Those terms do sound very good, is there a url or any other instructions for acquiring the Chadwick Register? thanks Brian Cartwright From: Theodore Turocy ...
497
nsmiceli
Mar 2, 2013 6:20 pm
Hi, I'm looking to calculate pitch counts, and I want to make sure that I'm reading these fields correctly. I used Chadwick (current version 0.6.0) to make the...
498
tangotiger
Mar 2, 2013 8:21 pm
I'd stick with just pitches to the batter. Otherwise, if you want to include pickoff throws, you should also include fielding throws as well. Tom ... The...
499
nsmiceli
Mar 3, 2013 6:54 pm
Ted, What's the best way to get in touch with you about getting access to the below referenced cross-reference database? Should I email you at ted.turocy <aht>...
500
Casey Franklin
crfrank76
Mar 4, 2013 3:52 pm
Ted, I'd be *eternally grateful* for access to this as well. Ok, maybe that's hyperbole - but it would make my life much easier and I'd be happy to contribute...
501
N. S. Miceli, Ph.D.
nsmiceli
Mar 4, 2013 5:52 pm
Ted Turocy & Chadwick Baseball Bureau are absolute lifesavers. Now I don't have to go through the pain of cleaning the tables up so that there are no duplicate...
502
tangotiger
Mar 4, 2013 6:01 pm
I agree, Ted's resource is one of the best things out there (to say nothing of CWEVENT, CWGAME, CWSUB). Whatever Ted deems the best way to utilize the...
503
Wells Oliver
xmutex
Mar 4, 2013 6:05 pm
It might be worth our (being the community) time to setup a public web service with this information and allow for easy of updating and adding. Just a thought....
504
William Skelton
weskelton
Mar 4, 2013 8:55 pm
A few years back, there was a BaseballID working group formed. I believe it was started by Ted. At one point they had started to post the updated register...
505
William Skelton
weskelton
Mar 4, 2013 8:55 pm
A few years back, there was a BaseballID working group formed. I believe it was started by Ted. At one point they had started to post the updated register...
506
Brian L Cartwright
brianlcartwr...
Mar 4, 2013 10:19 pm
What I believe we need are convenient methods to both download the data and be able to send in additions/corrections. Last year, when the file was at SABR, the...
507
Theodore Turocy
arb1ter
Mar 5, 2013 10:51 am
All, With full respect for the enthusiasm shown, I don't have any particular interest in trying to start a "community" project, or in building any tools, etc....
508
N. S. Miceli, Ph.D.
nsmiceli
Mar 26, 2013 4:44 pm
Hi, I'm doing data management for ongoing research, and I need to indicate whether someone is a starting pitcher or a relief pitcher. I don't want to have to...
509
tangotiger
Mar 26, 2013 4:49 pm
Assuming you mean at the game or event level (as opposed to seasonal level): You should be using CWEVENT to parse the data. There is a field there ...
510
nsmiceli
Mar 26, 2013 5:16 pm
Tom, Thanks for that. Issue was me being unfamiliar with the data. Same dataset previously parsed with "cwevent". Will go back through the data dictionary to...
511
Wells Oliver
xmutex
Mar 29, 2013 4:15 am
Hey everyone. Was wondering if team IDs are ever re-used (ANA, WAS, etc). Would team/year be the PK, or is team ID sufficient? Thanks. -- Wells Oliver ...
512
tangotiger
Mar 29, 2013 4:45 am
teamID is unique Tom ... The Book--Playing The Percentages In Baseball http://www.InsideTheBook.com...
513
Wells Oliver
xmutex
Mar 29, 2013 8:06 pm
I'm not sure if this is a RetroSQL or a Chadwick question, but why are we exporting dates in these wild and wooly integer formats? Wouldn't the world be a lot...
514
Theodore Turocy
arb1ter
Mar 31, 2013 10:19 am
All, As this was mentioned on these lists recently: I have given the Chadwick Bureau persons register a stable home at ...
515
Wells Oliver
xmutex
Apr 2, 2013 5:28 am
What am I missing here? I am including: Out, K, 1B, 2B, 3B, and HR. Jeter's add up only to 682, but Reference has 683. Discrepancies in the data sets? The...
516
Brian L Cartwright
brianlcartwr...
Apr 2, 2013 5:55 am
Looking Jeter up on B-Ref, he's credited with 740 PA and 683 AB, so 57 non-AB events - 45 BB, 5 HBP, 6 SH and 1 SF, plus 1 IBB. I have those exact same totals...
517
Michael Donato
ceetar
Apr 2, 2013 12:11 pm
I remember this, I think the discrepancy was a catcher's interference call, but I can't recall the specific event. Doesn't look like I saved my notes when I...
518
Freddy
fredcolina
Apr 13, 2013 6:47 pm
Hello, I was following the thread but it's not clear to me the steps to follow if I will be interested on the Chadwick's master persons register and ID...
519
Michael Thain
mthain333
Apr 19, 2013 4:51 am
Freddy - here's the link: http://chadwick-bureau.com/the-register/ Michael Thain...
520
Freddy
fredcolina
Apr 20, 2013 7:00 pm
Thanks Michael. It's a really good work......
521
Freddy
fredcolina
Apr 20, 2013 7:03 pm
Hi everybody, Trying to find a table with the Yahoo Players ID. Any ideas? Regards, Freddy...
