Everything You Need to Know About the Player ID Map
This post is intended to be an unexclusive discussion of the Player ID Map tool. Click the links unelevated to jump directly to a specific section below. Use the When browser or mouse sawed-off to jump when to this list.
- What is the Player ID Map?
- What Versions of the Tool are Available?
- How Do I Update or Refresh the Player ID Map?
- Do People Really Use This Thing?
- Does the Player ID Map Include all MLB Players?
- Are Players Overly Removed from the Player ID Map?
- What are Some Practical Examples of How to Use the Player ID Map?
- What ID Systems Are Included in the Player ID Map?
- What Other Information is Included in the Player ID Map?
- Why are the Columns in Such a Weird Order?
- How to Handle Missing Players or Make Edits
- Can I Use the Player ID Map in a Google Sheet?
- How Often Are Changes Made?
- Who Maintains the Player ID Map?
- I Downloaded One of Your Old Books. The Player ID Map Won’t Update. What’s the Deal?a
The MLB and fantasy baseball landscapes are wide reaching. We fantasy players gather information, projections, and opinions from many locations. Any time you have a situation like this, where data is coming from many disparate places, some form of “mapping” table can help connect the dots and data points from these variegated sources.
If you’ve overly tried to line projections from Fangraphs up with projections from Baseball Prospectus, Mastersball, or Baseball HQ, you’ll understand this challenge. You may have tried a VLOOKUP in Excel or Google Sheets to line the data up side-by-side. But player names are not a unconfined mechanism to do this. Names can transpiration (see Nick Castellanos and Nicholas Castellanos or B.J. Upton and Melvin Upton). Name conventions can differ between sites (see A.J. Pollock and AJ Pollock or Ronald Acuna and Ronald Acuna Jr.). Plane worse, there are occasionally indistinguishable names (Chris Young stuff a recent example).
The Player ID Map solves these discrepancies. It enables an owner to line up an A.J. Pollock in their spreadsheet to an AJ Pollock from projection system. The Player ID Map is the underpass that has enabled me to build tools like the Projection Aggregator and the Automated SGP Ranking Tool. It enables towers spreadsheet tools and other solutions that can work with or link to major sports websites (ESPN), projection systems (Steamer, Razzball, Mastersball, ATC), and fantasy baseball providers (NFBC, Fantrax, Yahoo!, Draftkings).
What Versions of This Tool are Available?
All the variegated “versions” unelevated are pointing to the same source information. They are just variegated formats of using or viewing the data.
- Excel Version (LINK) – A downloadable Excel file that can be incorporated into your own fantasy baseball spreadsheets. The data in this file contains connections to the main version I maintain in an online Google Sheet. This version will likely be out of stage when it is downloaded, but instructions on how to refresh the data through the connection to the Google sheet are easy-to-follow and are included later in this post. The Excel version contains two tabs:
- PLAYERIDMAP – All misogynist IDs and naming system information that I track
- Change Log – Explanations of changes made, including additions, corrections, and dates these changes were made
- Web Version of PLAYERIDMAP (LINK) – A live squint at the html/web-based version of the PLAYERIDMAP tab in the live Google Sheet. You might use this if you just want to see the Player ID Map or squint for specific pieces of information
- CSV Version of PLAYERIDMAP (LINK) – A one-time CSV download of the Player ID Map tab of the live Google Sheet. I wouldn’t really recommend using this considering there is no connection when to the live data I maintain, like in the Excel version. But it could be used if you only need an easy-to-use one-time dump of the data.
- Web Version of Transpiration Log (LINK) – A live squint at the html/web-based version of the Transpiration Log tab in the live Google Sheet. This could be used to review recent changes to the inside Sheet and determine if a refresh is needed.
- CSV Version of the Transpiration Log (LINK) – I have no idea why I make this available. Seems like it wouldn’t be valuable at all! But it’s here if you need it. It’s a one-time CSV download of just the Transpiration Log tab.
How Do I Update or Refresh the Player ID Map?
Note, you will be prompted well-nigh the potential danger of downloading Excel files from the internet the first time you download and unshut the Player ID Map. There are no dangerous macros or harmful lawmaking embedded in the file. It does maintain a connection when to my Google source file to enable you to download updated information. Click “Enable Editing” to winnow this reminder and be worldly-wise to interact with the Excel file.
You may at times moreover see an Excel warning that external data connections can be harmful. These are worldwide warning messages and good reminders that you do have to be shielding what you download on the web. Click “Enable Content” to indulge the data connection to pull in refreshed player ID data.
If you trust me and do download the Excel file, here’s how to refresh it.
|1.||Select a lamina inside of the player ID data. It does not matter which player or piece of data. It just has to be something inside the undecorous and white table.|
|2.||Right-click on the selected lamina and segregate the menu option to “Refresh”.|
|3.||You will uncork to see various status messages as Excel begins to refresh the connection. You may see information stuff relayed in the marrow right of Excel.
A popup may appear. And status information may plane towards in the marrow left of Excel (I couldn’t grab a screenshot quick enough).
The unshortened refresh may take 60 seconds or so. And it may depend on how much time has transpired since your last update. You don’t really get a “This is Done!!!” message. You’ll just know you’re ready to proceed when all the statuses stop changing.
I created the Player ID Map in 2013. I started my ID map largely from information from Tim Blaker’s map. Tim continues to provide updates in his mapping file, but our maps have variegated purposes. I needed the flexibility to add new names and systems and not be reliant upon someone else. But I protract to use Tim’s map as an input to mine when I’m performing major updates for new players that enter the baseball world.
The Player ID Map has grown since 2013. I protract to add new systems, new name formats, and plane new information well-nigh each player that will help me provide spreadsheet tools the the SFBB audience.
I’m surprised at how often it’s used. At the time I write this article, the file has been downloaded or refreshed over 280,000 times (Who knows. 200,000 of them could be me tinkering in spreadsheets). If I could only icon out a way to tuition ten cents each time it’s used…
It’s an integral part to towers long-lasting and flexible fantasy baseball spreadsheets that can take wholesomeness of many variegated sources of baseball data.
No. The tool is intended to be used for fantasy baseball purposes. Accordingly, the goal is to include only “fantasy relevant” players. That’s a purposely vague threshold. In the preseason, I often alimony the top 750ish players therefrom to NFBC ADP included in the Player ID Map. This should be unbearable players to imbricate most normal leagues. It’s possible the Player ID Map will not be deep unbearable for your 20-team NL-only league, your AL Central-only league, or your middle-reliever contest. Alimony reading for translating on how to get increasingly players widow to the Player ID Map.
No. Leaving old and retired players in the spreadsheet allows for people (myself, might I refer you to The Process) to self-mastery historical research. An “Active” post was widow to the spreadsheet in the fall of 2020. This field has values of “Y” for zippy players and “N” for inactive players. I err on the side of leaving players in an zippy state, if there is any uncertainty well-nigh them stuff retired or not. You can filter out inactive players using this new field, permitting you to trim the list of players to a increasingly reasonable length.
My most obvious example is the Projection Aggregator Excel tool I’ve created. This spreadsheet can work with up to five separate baseball projection systems and summate the stereotype projection for players wideness those variegated systems. The Player ID Map is the tool that makes this all possible. It’s what knows to stereotype the Steamer projection for player ID 10155, Baseball HQ projection for player 3857, and the Baseball Prospectus PECOTA projection for player 59432. That same tool enables you to create a hyperlink to the Statcast data for player 545361, determine if player 8861 has been drafted in an NFBC league, and link to the Rotowire player page for player 10956. This player is Mike Trout.
As of December 2020, these are the columns in the Player ID Map:
|A||IDPLAYER||I refer to this as SFBBID at times. It’s the main ID system I use in my spreadsheets. It’s substantially a mirror of the Baseball Reference ID (BREFID). There have been times where I’ve inadvertently had an error in a player’s ID that will make me differ from the true BREFID.|
|I||IDFANGRAPHS||Fangraphs ID. This is the ID used in player URLs and in all projection and statistic downloads made on the site. Note, minor league players receive a new ID when they reach MLB. This causes some problems with spreadsheet tools when an ID changes in the middle of the season.|
|J||FANGRAPHSNAME||Fangraphs name. This is often not needed, given Fangraphs wide use of very IDs.|
|K||MLBID||MLB ID. This is the ID used on MLB player pages, Statcast player pages, and often included in other projection downloads (e.g. Mastersball)|
|L||MLBNAME||MLB name. This is often not needed, given the use of the MLBID.|
|M||CBSID||CBS ID. This is the ID used in player URLs; however, it’s not used on projection downloads, which instead use only CBSNAME.|
|N||CBSNAME||CBS name. This is the ID that appears in standard CBS projection downloads.|
|O||RETROID||Retrosheet ID. This is the ID used in retrosheet.org data.|
|P||BREFID||Baseball-Reference ID. This is the ID used on Baseball-Reference player pages. It’s often exactly the same as the IDPLAYER field and is sometimes referred to as my SFBB ID. I will guess at what the BREFID will be for minor league players.|
|Q||NFBCID||NFBC ID. This is the ID used in player URLs; however, it’s not included on NFBC exports or ADP reports. Joining with NFBC data usually requires using the NFBCNAME or NFBCLASTFIRST fields.|
|R||NFBCNAME||NFBC name in a FirstName LastName convention. When looking at the NFBC website, names will towards in this format (FirstName LastName). However, when exporting a report, the names come out in the NFBCLASTFIRST format (LastName, Firstname).|
|S||ESPNID||ESPN ID. This is the ID used in player URLs. It is not included on downloadable projection sets, which instead use only ESNPNAME.|
|T||ESPNNAME||ESPN name. This is likely how you would match players if copying or downloading projection from the ESPN website.|
|U||KFFLNAME||No longer maintained. This was a popular fantasy site when I initially created the Player ID Map many years ago.|
|V||DAVENPORTID||Clay Davenport ID. This is the ID used in projection downloads from claydavenport.com.|
|W||BPID||Baseball Prospectus ID. This is the ID used in Baseball Prospectus’ PECOTA projection downloads.|
|X||YAHOOID||Yahoo ID. This is the ID used in player URLs; however, it’s not included on Yahoo reports, which instead use only YAHOONAME.|
|Y||YAHOONAME||Yahoo name. This is likely how you would match players if copying or downloading information from the Yahoo website.|
|Z||MSTRBLLNAME||Mastersball name. This is the naming institute used in Todd Zola’s Mastersball projections. Note, Todd often now includes the MLB ID for players in his reports, making this field mostly irrelevant.|
|AC||FANTPROSNAME||Fantasy Pros name. This is likely how you would match players if copying or downloading projections from FantasyPros.com.|
|AD||LASTCOMMAFIRST||This is a generic post in LastName, FirstName format. It can be used if you are using a data set not otherwise included in the Player ID Map that follows the LastName, Firstname format.|
|AE||ROTOWIREID||Rotowire ID. This is the ID used in player URLs at Rotowire.com. It is not included on downloadable projection sets from the site, which instead use only ROTOWIRENAME.|
|AF||FANDUELNAME||Fanduel name. This is often not needed, given the use of FANDUELID.|
|AG||FANDUELID||Fanduel ID. This is included on downloadable reports from the Fanduel website. I admittedly do not spend a lot of effort keeping this post up-to-date. Alimony in mind that “fantasy relevant” for DFS is a much variegated threshold than for season-long leagues, which I primarily focus on.|
|AH||DRAFTKINGSNAME||DraftKings name. I admittedly do not spend a lot of effort keeping this post up-to-date. Alimony in mind that “fantasy relevant” for DFS is a much variegated threshold than for season-long leagues, which I primarily focus on.|
|AI||OTTONEUID||Ottoneu ID. This is the ID used in player URLs at Ottoneu.com.|
|AJ||HQID||Baseball HQ ID. This is the ID used in player URLs at BaseballHQ.com and is moreover included in projection downloads from the site.|
|AK||RAZZBALLNAME||Razzball name. This is the naming institute used on Razzball projection downloads and there is no ID system misogynist on those exports. This is the field to join with if using Razzball projections. Note, there is an odd issue attempting to match players with an divagation in their name. The divagation included in Razzball downloads is not a standard divagation and cannot be incorporated into the Player ID Map.|
|AL||FANTRAXID||Fantrax ID. This is the ID used in player URLs at Fantrax.com; however, it is not included on Fantrax reports, which only include Fantrax name.|
|AM||FANTRAXNAME||Fantrax name. This is likely how you would match players if copying or downloading information from the Fantrax site.|
|AN||ROTOWIRENAME||Rotowire name. This is likely how you would match players if copying or downloading information from Rotowire.com.|
|AP||NFBCLASTFIRST||NFBC name in a LastName, FirstName convention. When looking at the NFBC website, names will not towards in this format. However, when exporting a report, the names do come out in this NFBCLASTFIRST format (LastName, Firstname).|
|B||PLAYERNAME||My own version of the player’s current name. This is not likely anything you want to match versus unless you’re using a source of information not included on one of the columns specific to flipside website or projection system.|
|D||FIRSTNAME||Only the first name portion from the PLAYERNAME field.|
|E||LASTNAME||Only the last name (non-first-name) portion from the PLAYERNAME field.|
|F||TEAM||My team abbreviation. It probably makes sense to point out that I do moreover maintain an MLB Team ID Map that tracks the variegated abbreviations and names used on variegated websites and projection systems here.|
|G||LG||League specification. “AL” for American League. “NL” for National League. “N/A” for someone not currently on an MLB team.|
|H||POS||Player’s position eligibility, the most valuable position they qualify for. This is unswayable using a 20-game threshold in most seasons and an 8-game threshold for the 2021 season (based on the shortened 2020 season). Position value is unswayable using a priority work order of C, SS, 2B, 3B, OF, 1B, DH.|
|AA||BATS||Player’s batting handedness. “L” for left, “R” for right, and “B” for switch/both.|
|AB||THROWS||Player’s throwing handedness. “L” for left, “R” for right.|
|AO||ALLPOS||A listing of all players a position will qualify for (not just the most valuable position that is specified in the “POS” post above).|
|AQ||ACTIVE||My determination of if the player is still an zippy baseball player or not. This is my judgement. I err on the site of leaving players zippy increasingly than listing them as inactive. A player may need to have several seasons of earning no MLB stats, no games played, or have a publicized retirement I can hands be enlightened of to wilt inactive. “Y” indicates an zippy player and “N” indicates an inactive player.|
Because many folks have spreadsheets directly unfluctuating to the Player ID Map, I have no nomination but to leave the ordering alone. Columns towards in the order in which they were originally widow to the spreadsheet (the rightmost columns are the most recent).
There is no translucent wordplay on the weightier tideway here. There are two vital options:
- Reach out to me via email (smart fantasy baseball at g mail dot com) or Twitter and request player(s) be added. Then wait for an updated version to wilt available. Please alimony in mind the “fantasy relevant” threshold previously discussed. This becomes expressly subjective during the season. But I’ll do my weightier to alimony things up-to-date.
- If you cannot wait for my updates, you are welcome to make your own edits directly in your reprinting of the Player ID Map. Just be shielding not to refresh the connection or your edits will be lost.
Yes. Using the pursuit formula in a Google Sheet will pull in a live and uncontrived connection to the Player ID Map:
Simply type that formula into lamina A1 on a zippo sheet and the unshortened Player ID Map will be pulled in.
Updates are well-matured in the pursuit windows:
- During the preseason (mid-November – March) – The updates are to stay aligned with the players expected to be fantasy-relevant in the next seasons. Updates will include self-ruling organ team changes, revisions to position eligibility, players coming to MLB from overseas, and rookies gaining sustentation for the upcoming season.
- During the first two months of the season (April – May) – If I’m stuff honest, this is well-nigh how long I can alimony up with the churn of MLB rosters, tabbed up rookies, shifts in playing time, etc. Updates will often include new players that have wilt fantasy-relevant early in the season.
- After the season – These updates are to capture any previously missing players from the Player ID Map that had relevance during the previous season (I often add any player with 100 Plate Appearances or 50 IP).
I’m embarrassed to shoehorn that I manually maintain the spreadsheet. I will use Excel formulas to pull in blocks of missing IDs, but there are moreover many times where I manually squint up players and simply type in their ID and name under the various systems and websites. But hey… Somebody’s got to do this, right?
Yes. I wrote a couple of instructional books on how to build your own points league or SGP files from scratch surpassing developing this updating/refreshing version of the Player ID Map. There are a couple of ways to work virtually this.
- You can follow this increasingly transmission process of updating the player list.
- Or you can download the new version of the Player ID Map, move it into your spreadsheet, and retread all existing formulas to reference the new Player ID Map instead of the old one. This will be labor intensive, but you’ll goody from having the unfluctuating ID map into the future.
Hopefully the peak overdue the curtain well-nigh how the ID map is maintained and updated is helpful to you. If you find that it’s missing something important or that will help many fantasy baseball players, please reach out to me and let me know. We can icon it out.
The post Everything You Need to Know Well-nigh the Player ID Map first appeared on Smart Fantasy Baseball.