Question on BHQ ID vs. MLB ID

[RAY@HQ]

Oh depth chart center, not projections. Got it.

[blueboy714]

Wait, let's back up a second. Which of our projection files doesn't have MLB ID? I thought they all did. And I just went through the mixed league files, and all of the Proj-only or Proj+YTD have both. Let me know where MLB ID is missing and I'll just get it added.

I just found this in my spam folder. The depth chart center CSV downloads of the batter/pitcher/AL/NL files only have 4 digit BLQID in them not 6 digit MLBID. Thanks

[RAY@HQ]

Wait, let's back up a second. Which of our projection files doesn't have MLB ID? I thought they all did. And I just went through the mixed league files, and all of the Proj-only or Proj+YTD have both. Let me know where MLB ID is missing and I'll just get it added.

[blueboy714]

Thanks, but Smart, Crunch Time, Chadwick don't offer a complete BHQ Player ID to MLB ID list. Then again, Rotowire and Fangraphs don't have a list available of their codes to MLB ID list either. The only one that does is Baseball Prospectus, but doesn't always work well with other spreadsheets like some of the previous ones I've listed.

I wish everyone used a the same MLB ID or Baseball Reference (MLB and/or MILB) - it would make things much simpler trying to combine data.

[Walt@HQ]

This doesn't answer your question since it doesn't have BBHQ ids, but I've found that the Player ID map is a really helpful tool for linking multiple datasets together:

https://www.smartfantasybaseball.com/tools/

Maybe BBHQ could reach out to Tanner Bell about including the BBHQ id in that file?

[blueboy714]

Do you have a master list of your BHQ ID and the corresponding MLB ID for each player? I ask because only your main projections include both and most everything else only include the BHQ ID. This can be a problem if a player isn't in projections but is in another file, so there is no way to figure out the BHQ ID without relaying on other sources besides BHQ. Thanks