Historical database issues go here! - Page 8

LansdowneSt · 01-09-2022, 01:44 PM

Some of the John Fitzgeralds have the wrong ML import IDs. I was trying to get the 1891 Brave and got an 11,866-year-old man. Confirmed my import year and bRef codes were correct. Checked my OOTP21 database as I had it cracked open in a csv, and it seems all the John Fitzgeralds have some wrong info. Here's the 21 database showing that the 1891 John F's bRef code of fitzgjo03 was tied to the 1958 Giant. Some of the issues may have gotten fixed in 22 but the fact my import of him still had issues, I'd look at all the John Fitzgerald lines in 22 to ensure they ties to the proper bRef import code/MLB ID.

https://www.baseball-reference.com/p...itzgjo03.shtml

actionjackson · 01-09-2022, 02:05 PM

I haven't looked at every post in here, but being a bit of a spreadsheet nerd, I've crawled around the OOTP22 Master.csv file quite a bit. The fixing of all the issues created with the placement of commas in either the nameNick or college columns is a wonderful step. That has allowed everything to settle in its proper column, which unscrambles a lot of problems. Mega props there!

One of the things I'm noticing though, is that all pitchers with 2020 MLB debuts have blank spots where their individual pitch ratings should be. Since my only active game is in OOTP21 (and is coming along swimmingly, with 35 years down, and hopefully 100+ to go), I don't know how starting pitchers are importing, but what I suspect is that guys like Sixto Sanchez, Casey Mize, and Tarrik Skubal will import with only two pitches, which will make it extremely difficult for them to become effective starting pitchers as their careers progress. There might be something that's different about OOTP22 that would prevent this from happening, but if I'm right, this will need a major workover for not just 22, but every version going forward.

Every other rating in the game (Batting, Fielding, Stuff, Movement, and Control) can be derived from real life stats, but individual pitch ratings rely on the columns AI to AT in the Master.csv file (to wit: Fastball, Changeup, Curve, Slider, Sinker, Splitter, Forkball, Cutter, Knuckleball, KnuckleCurve, Circle Change, and Screwball) to give pitchers ratings for these pitches. Column AN (Arm Slot) is blank too. I believe the game will default to a 3/4 arm slot, if it comes across a blank cell in this column, which is OK I guess. I think all the arm slots have something to do with what will happen with a pitcher's splits. Over the top, and 3/4 guys should theoretically have less extreme splits than sidearm/submarine guys, and I think that's what the game does, but I'm not sure. That's more of a cosmetic thing than the pitch ratings are though. I remember Markus being absolutely thrilled when he was able to include individual pitch ratings in OOTPX, and I know it was a real game changer. If I'm right about this, that amazing feat will be unnecessarily lost. It's not an easy thing to fix at all.

I've noticed over the years that the database started out with pitches being ranked from first to last (in terms of quality from 1 to X) for each pitcher. This worked brilliantly, as it gave each pitcher some semblance of the quality level of his pitches. Carlos Zambrano is an excellent example. He has seven pitches in there, ranked from 1-7. He had Sinker (2-seam FB), Slider, Fastball (4-seam FB), Splitter, Cutter, Curve, and Changeup in order of quality from 1-7. Beautiful. Should work a treat, and it's how it was meant to work. Somewhere in the 2000s, somebody started putting ratings on each pitch, so let's say with Scherzer, they looked at the pitches he threw, and gave him a 5 for every one. In this case, it was a 5 Fastball, a 5 Changeup, and a 5 Slider. That's not how this was designed to work. The game might read that as the Fastball, Changeup, and Slider being his 5th best pitch, and give them identical ratings.

One (of many) of the beautiful things about the Spritze DB is that we can get some of those original ratings back into the Master.csv, and thus into the Historical Database.odb to correct what went astray, where we can. Scherzer, for example, has those three pitches ranked in order from Fastball to Slider to Changeup (1 to 2 to 3). This will give him differentiation on his pitches, which is good. His best pitch will be the Fastball, then the Slider, and then the Changeup, which is a much better outcome than the 5-5-5 system. I get what the person was trying to do, which is to max (see what I did there?) out each of his pitches, but that's not the way the system was designed, and that won't give an optimal result to Mr. Scherzer. I suspect the game looks at his RL Stats to figure out the Stuff rating, and then apportions that across each of his pitches. Scherzer (and many others) will be much better served by restoring this system.

The not so beautiful thing about the Spritze DB is that it runs out after 2015 RL stats, so anybody who debuted in 2016 or later can't be helped here. Alas, we don't have the man around to lean on anymore (huge loss, and most of us didn't really know him beyond this forum), so we'll have to find another way. The newer system, while not ideal, is still workable for 2016 through 2019, as starters will import with more than two pitches, which they will need, to be effective. But with 2020 and moving forward, unless this is addressed, I suspect we'll see starters importing with whatever two pitches the game chooses to give them. Possibly sinker/slider, or fastball/slider, or whatever. Doesn't matter really. The game sees the blank spot, and fills it as it sees fit to. Like the 3/4 slot, it will give every pitcher with blank pitch rating slots (all of the 2020 forward guys) two pitches, and quite probably the same two pitches for each pitcher. Sorry this got so long. I just thought it was a (very) important issue to raise, especially with OOTP23 nearing release. Might not be able to be fixed until OOTP24, but I think it does need a look. Thank you.

actionjackson · 01-09-2022, 02:15 PM

Quote:

Originally Posted by LansdowneSt

Some of the John Fitzgeralds have the wrong ML import IDs. I was trying to get the 1891 Brave and got an 11,866-year-old man. Confirmed my import year and bRef codes were correct. Checked my OOTP21 database as I had it cracked open in a csv, and it seems all the John Fitzgeralds have some wrong info. Here's the 21 database showing that the 1891 John F's bRef code of fitzgjo03 was tied to the 1958 Giant. Some of the issues may have gotten fixed in 22 but the fact my import of him still had issues, I'd look at all the John Fitzgerald lines in 22 to ensure they ties to the proper bRef import code/MLB ID.

https://www.baseball-reference.com/p...itzgjo03.shtml

Yeah, the John Fitzgeralds got a bit messy. Warren Fitzgerald was originally thought to be a John Fitzgerald, and thus he took the fitzgjo01 spot. That means that what we thought were fitzgjo01 through fitzgjo03 (John J, John H, and John F) become fitzgjo02 through fitzgjo04, and everything gets goofy.

actionjackson · 01-09-2022, 02:41 PM

So, your guy fitzge001joh is actually fitzgjo04, which unfortunately is not in the Master.csv file, which makes everything go ka-blooey, and the baby Jesus cry. Poor guy also, of course, imports with no real life stats. He was actually a one start and done pitcher, but because there are no stats for fitzgjo04 in the game, due to his not existing until those pesky baseball researchers uncovered Warren, he has no position, and no skills.

Here he is, after I made the changes in the Master.csv file using DrDoom's handy dandy OOTP Database Converter, but before I've been able to get into his Batting, Fielding, and Pitching files to fix him up right using same. I suspect John H, (formerly fitzgjo02, but now fitzgjo03) will have his stats, and so on. I'm glad these researchers are slogging through history to uncover these previously unknown gents, but they're really messing up our games. His age, and facegen are right though, so...There's that.

actionjackson · 01-09-2022, 02:46 PM

All four of these gents (Warren, and the three Johns) were pitchers IRL too.

actionjackson · 01-09-2022, 07:24 PM

Warren and the three Johns following the great untangling. Tough slogging lemme tell ya, but worth it in the end. In random debuts, there's some sort of neutralization process that takes place when players are brought into the draft, that doesn't happen when you do a manual import, so I'm not sure how these lads would fare in my random debut game, but all of them come in with terrible stuff because of their low strikeout totals. Well, John F (fitzgjo04) had 9.0 K/9, but he only pitched 3.0 innings in one RL start.

I know about this neutralization process, because it allows deadballers to hit 20-30 HR in a 162 game season if warranted, and steroid/liveballers get cut down to a high of about 40+, with a very rare 50. I haven't had a 50 HR guy yet in 35 seasons, and I've had some big boppers come through, including Bonds and McGwire. McGwire's high so far, is 37 in a 162 game season, while Bonds had a couple of 32s. Bonds had five 30 HR seasons, while McGwire has had eight. I've only had six 40+ seasons in 35 seasons in my game so far. Willie Aikens has the all-time high with 48. It should be tough dammit. I also (as many here know) use 1984 for stats output. Love the results I get. At the other end of the spectrum is Shoeless Joe, the deadball star, who just retired with 344 HR, and 13 20+ HR seasons, including one 30 right on the nose. Love it.

Anyway...Warren, and the three Johns in order of their MLB IDs.

actionjackson · 01-10-2022, 02:47 AM

Oof. Looking over that post about the pitching, and I don't like what I'm seeing. Yes, it probably needs correcting. No, I probably didn't need to be such a dink about it.

In short, I was well intentioned, but my execution was lousy. So much so that John McKay (wherever he is) has said he'd be all in favour of it. If anybody needs me, I'll just be over here with the pacifier in my mouth, wearing the cone of shame, and writing out 500 "I will not be such a jerk on the OOTP boards" lines on the blackboard. Total, total, total first world problem, at a time when I should be more respectful of others. I hope everybody is doing OK with COVID, and I'll try to chill out from now on.

On a positive note, I've found that I'm really getting somewhere with the Master file, by combining the strengths of the Spritze DB, with the strengths of the default DB. The 2020 guys will be a huge hurdle to get past, but the guys prior to those 212 (not all of them pitchers) players that debuted in 2020 should get easier as I go. Looks like 142 pitchers, but some were position players, so they really don't need much work. As for the 2020 guys, I'll have to figure out repertoires, and pitches from best to worst for each guy. Tedious, but not impossible. Sorry again. That's not me, except that today it was, so maybe it is me.

Then, there are the 265 player debuts in 2021 for OOTP23, which include 164 pitchers. Bit of a bear, but we'll see how it goes.

actionjackson · 01-10-2022, 01:15 PM

Hey wow, look...Actual contribution time. For some reason, some players who debuted in 2016, with first names beginning with "Br" are missing debut dates. To wit:

Brian Goodwin (goodwbr01)
Brett Nicholas (nichobr01)
Brock Stewart (stewabr01)
Brent Suter (suterbr01)

If I find anymore, I'll let you know.

LansdowneSt · 01-11-2022, 01:52 AM

https://forums.ootpdevelopments.com/...d.php?t=334227

Historic database question reposted here from General Discussions

actionjackson · 01-11-2022, 04:27 AM

Checked into it. Not a duplicate...For now...Dunh, Dunh, Dunh...

actionjackson · 01-15-2022, 04:00 AM

Brock Stewart (stewabr01), and Brent Suter (suterbr01) have no individual pitch ratings, and thus will enter with just two pitches, selected at random by the game. It's the same issue as with all of the pitchers who debuted in 2020. This is not as much of a problem for Suter, and Stewart, who are relievers, as it is for 2020 starters, and soon to be 2021 starters.

Amazin69 · 01-15-2022, 06:33 PM

Yet another "Caucasian" in the database who is actually black. Please correct, as usual.

Chuck Weatherspoon: weathe003cha

Amazin69 · 01-15-2022, 09:34 PM

Also not "Caucasian", Luke Vasser.

vasser001luc

actionjackson · 01-16-2022, 08:39 PM

I've gotta give some major props to whoever (team effort probably) cleaned up the Master.csv file. It's been quite a while since I took a deep dive into one, and I'd noticed over the years that they'd been steadily declining, mainly due to updates not being made with each version. This is quite stellar, and is a remarkable achievement, regardless of what I've said earlier about individual pitch ratings. I guess you can only criticize if you're willing to praise, and the amount of errors over the years that have been righted is truly staggering. Hard to keep up, with all the discoveries that are being made about old ballplayers by SABR, and other outfits. I have to acknowledge this. Amazing job, whoever's responsible.

Amazin69 · 01-17-2022, 01:20 PM

One more non-Caucasian "Caucasian": John Mason ( mason-004joh )

Thank you.

actionjackson · 01-17-2022, 05:05 PM

According to BB-Ref, Win Clark is clarkbi01, not clarkwi03, as is in the Master.csv file, and more importantly the historical_database.ODB. All his stats would need to be credited to clarkbi01, as well as other things I may not be aware of.

actionjackson · 01-17-2022, 05:11 PM

I've noticed a lot of Federal League guys coming in without stats. Is this a design decision? Not all of them, mind you, but a lot. No other league (NA, AA, UA, and PL) seems to have this problem. It's a strange one for me.

LansdowneSt · 01-19-2022, 06:07 PM

James M Brown should bat lefty. Sent correction to BRef too.

https://www.baseball-reference.com/r...d=brown-012jam

Evidence here in his self-filled out MLB questionnaire.

actionjackson · 01-20-2022, 05:42 PM

Bill Jones (jonesbi01) has his career running from 1882 through 1884 in the Master.csv file. In fact, his career began and ended in 1884, so that needs to be changed, and any stats he has in the database for the other two seasons need to be scrubbed.

LansdowneSt · 01-20-2022, 11:52 PM

Wandy Rodriguez (rodriwa01) weight check request. OOTP has 160 lbs and bRef has 195 lbs. I'm sure it varied over his career so even a middle ground would be great assuming theirs a source for the lower number. The difference between his pictures and the 160 lbs is confounding my facegen-making effort on this one... Thx

01-09-2022, 01:44 PM	#141
LansdowneSt Global Moderator Join Date: Feb 2004 Location: From Duxbury, Mass residing Baltimore Posts: 7,683	John Fitzgerald(s) Some of the John Fitzgeralds have the wrong ML import IDs. I was trying to get the 1891 Brave and got an 11,866-year-old man. Confirmed my import year and bRef codes were correct. Checked my OOTP21 database as I had it cracked open in a csv, and it seems all the John Fitzgeralds have some wrong info. Here's the 21 database showing that the 1891 John F's bRef code of fitzgjo03 was tied to the 1958 Giant. Some of the issues may have gotten fixed in 22 but the fact my import of him still had issues, I'd look at all the John Fitzgerald lines in 22 to ensure they ties to the proper bRef import code/MLB ID. https://www.baseball-reference.com/p...itzgjo03.shtml Attached Images

01-09-2022, 02:41 PM	#144
actionjackson Hall Of Famer Join Date: Apr 2009 Location: Toronto, ON Posts: 6,181	So, your guy fitzge001joh is actually fitzgjo04, which unfortunately is not in the Master.csv file, which makes everything go ka-blooey, and the baby Jesus cry. Poor guy also, of course, imports with no real life stats. He was actually a one start and done pitcher, but because there are no stats for fitzgjo04 in the game, due to his not existing until those pesky baseball researchers uncovered Warren, he has no position, and no skills. Here he is, after I made the changes in the Master.csv file using DrDoom's handy dandy OOTP Database Converter, but before I've been able to get into his Batting, Fielding, and Pitching files to fix him up right using same. I suspect John H, (formerly fitzgjo02, but now fitzgjo03) will have his stats, and so on. I'm glad these researchers are slogging through history to uncover these previously unknown gents, but they're really messing up our games. His age, and facegen are right though, so...There's that. Attached Images Last edited by actionjackson; 01-09-2022 at 02:43 PM.

01-09-2022, 07:24 PM	#146
actionjackson Hall Of Famer Join Date: Apr 2009 Location: Toronto, ON Posts: 6,181	Warren and the three Johns following the great untangling. Tough slogging lemme tell ya, but worth it in the end. In random debuts, there's some sort of neutralization process that takes place when players are brought into the draft, that doesn't happen when you do a manual import, so I'm not sure how these lads would fare in my random debut game, but all of them come in with terrible stuff because of their low strikeout totals. Well, John F (fitzgjo04) had 9.0 K/9, but he only pitched 3.0 innings in one RL start. I know about this neutralization process, because it allows deadballers to hit 20-30 HR in a 162 game season if warranted, and steroid/liveballers get cut down to a high of about 40+, with a very rare 50. I haven't had a 50 HR guy yet in 35 seasons, and I've had some big boppers come through, including Bonds and McGwire. McGwire's high so far, is 37 in a 162 game season, while Bonds had a couple of 32s. Bonds had five 30 HR seasons, while McGwire has had eight. I've only had six 40+ seasons in 35 seasons in my game so far. Willie Aikens has the all-time high with 48. It should be tough dammit. I also (as many here know) use 1984 for stats output. Love the results I get. At the other end of the spectrum is Shoeless Joe, the deadball star, who just retired with 344 HR, and 13 20+ HR seasons, including one 30 right on the nose. Love it. Anyway...Warren, and the three Johns in order of their MLB IDs. Attached Images

01-19-2022, 06:07 PM	#158
LansdowneSt Global Moderator Join Date: Feb 2004 Location: From Duxbury, Mass residing Baltimore Posts: 7,683	James M Brown (brown-012jam) James M Brown should bat lefty. Sent correction to BRef too. https://www.baseball-reference.com/r...d=brown-012jam Evidence here in his self-filled out MLB questionnaire. Attached Images Last edited by LansdowneSt; 01-20-2022 at 11:53 PM.

01-20-2022, 11:52 PM	#160
LansdowneSt Global Moderator Join Date: Feb 2004 Location: From Duxbury, Mass residing Baltimore Posts: 7,683	Wandy Rodriguez (rodriwa01) weight check request. OOTP has 160 lbs and bRef has 195 lbs. I'm sure it varied over his career so even a middle ground would be great assuming theirs a source for the lower number. The difference between his pictures and the 160 lbs is confounding my facegen-making effort on this one... Thx Attached Images

01-09-2022, 02:05 PM	#142
actionjackson Hall Of Famer Join Date: Apr 2009 Location: Toronto, ON Posts: 6,181	I haven't looked at every post in here, but being a bit of a spreadsheet nerd, I've crawled around the OOTP22 Master.csv file quite a bit. The fixing of all the issues created with the placement of commas in either the nameNick or college columns is a wonderful step. That has allowed everything to settle in its proper column, which unscrambles a lot of problems. Mega props there! One of the things I'm noticing though, is that all pitchers with 2020 MLB debuts have blank spots where their individual pitch ratings should be. Since my only active game is in OOTP21 (and is coming along swimmingly, with 35 years down, and hopefully 100+ to go), I don't know how starting pitchers are importing, but what I suspect is that guys like Sixto Sanchez, Casey Mize, and Tarrik Skubal will import with only two pitches, which will make it extremely difficult for them to become effective starting pitchers as their careers progress. There might be something that's different about OOTP22 that would prevent this from happening, but if I'm right, this will need a major workover for not just 22, but every version going forward. Every other rating in the game (Batting, Fielding, Stuff, Movement, and Control) can be derived from real life stats, but individual pitch ratings rely on the columns AI to AT in the Master.csv file (to wit: Fastball, Changeup, Curve, Slider, Sinker, Splitter, Forkball, Cutter, Knuckleball, KnuckleCurve, Circle Change, and Screwball) to give pitchers ratings for these pitches. Column AN (Arm Slot) is blank too. I believe the game will default to a 3/4 arm slot, if it comes across a blank cell in this column, which is OK I guess. I think all the arm slots have something to do with what will happen with a pitcher's splits. Over the top, and 3/4 guys should theoretically have less extreme splits than sidearm/submarine guys, and I think that's what the game does, but I'm not sure. That's more of a cosmetic thing than the pitch ratings are though. I remember Markus being absolutely thrilled when he was able to include individual pitch ratings in OOTPX, and I know it was a real game changer. If I'm right about this, that amazing feat will be unnecessarily lost. It's not an easy thing to fix at all. I've noticed over the years that the database started out with pitches being ranked from first to last (in terms of quality from 1 to X) for each pitcher. This worked brilliantly, as it gave each pitcher some semblance of the quality level of his pitches. Carlos Zambrano is an excellent example. He has seven pitches in there, ranked from 1-7. He had Sinker (2-seam FB), Slider, Fastball (4-seam FB), Splitter, Cutter, Curve, and Changeup in order of quality from 1-7. Beautiful. Should work a treat, and it's how it was meant to work. Somewhere in the 2000s, somebody started putting ratings on each pitch, so let's say with Scherzer, they looked at the pitches he threw, and gave him a 5 for every one. In this case, it was a 5 Fastball, a 5 Changeup, and a 5 Slider. That's not how this was designed to work. The game might read that as the Fastball, Changeup, and Slider being his 5th best pitch, and give them identical ratings. One (of many) of the beautiful things about the Spritze DB is that we can get some of those original ratings back into the Master.csv, and thus into the Historical Database.odb to correct what went astray, where we can. Scherzer, for example, has those three pitches ranked in order from Fastball to Slider to Changeup (1 to 2 to 3). This will give him differentiation on his pitches, which is good. His best pitch will be the Fastball, then the Slider, and then the Changeup, which is a much better outcome than the 5-5-5 system. I get what the person was trying to do, which is to max (see what I did there?) out each of his pitches, but that's not the way the system was designed, and that won't give an optimal result to Mr. Scherzer. I suspect the game looks at his RL Stats to figure out the Stuff rating, and then apportions that across each of his pitches. Scherzer (and many others) will be much better served by restoring this system. The not so beautiful thing about the Spritze DB is that it runs out after 2015 RL stats, so anybody who debuted in 2016 or later can't be helped here. Alas, we don't have the man around to lean on anymore (huge loss, and most of us didn't really know him beyond this forum), so we'll have to find another way. The newer system, while not ideal, is still workable for 2016 through 2019, as starters will import with more than two pitches, which they will need, to be effective. But with 2020 and moving forward, unless this is addressed, I suspect we'll see starters importing with whatever two pitches the game chooses to give them. Possibly sinker/slider, or fastball/slider, or whatever. Doesn't matter really. The game sees the blank spot, and fills it as it sees fit to. Like the 3/4 slot, it will give every pitcher with blank pitch rating slots (all of the 2020 forward guys) two pitches, and quite probably the same two pitches for each pitcher. Sorry this got so long. I just thought it was a (very) important issue to raise, especially with OOTP23 nearing release. Might not be able to be fixed until OOTP24, but I think it does need a look. Thank you.

01-09-2022, 02:46 PM	#145
actionjackson Hall Of Famer Join Date: Apr 2009 Location: Toronto, ON Posts: 6,181	All four of these gents (Warren, and the three Johns) were pitchers IRL too.

01-10-2022, 02:47 AM	#147
actionjackson Hall Of Famer Join Date: Apr 2009 Location: Toronto, ON Posts: 6,181	Oof. Looking over that post about the pitching, and I don't like what I'm seeing. Yes, it probably needs correcting. No, I probably didn't need to be such a dink about it. In short, I was well intentioned, but my execution was lousy. So much so that John McKay (wherever he is) has said he'd be all in favour of it. If anybody needs me, I'll just be over here with the pacifier in my mouth, wearing the cone of shame, and writing out 500 "I will not be such a jerk on the OOTP boards" lines on the blackboard. Total, total, total first world problem, at a time when I should be more respectful of others. I hope everybody is doing OK with COVID, and I'll try to chill out from now on. On a positive note, I've found that I'm really getting somewhere with the Master file, by combining the strengths of the Spritze DB, with the strengths of the default DB. The 2020 guys will be a huge hurdle to get past, but the guys prior to those 212 (not all of them pitchers) players that debuted in 2020 should get easier as I go. Looks like 142 pitchers, but some were position players, so they really don't need much work. As for the 2020 guys, I'll have to figure out repertoires, and pitches from best to worst for each guy. Tedious, but not impossible. Sorry again. That's not me, except that today it was, so maybe it is me. Then, there are the 265 player debuts in 2021 for OOTP23, which include 164 pitchers. Bit of a bear, but we'll see how it goes.

01-10-2022, 01:15 PM	#148
actionjackson Hall Of Famer Join Date: Apr 2009 Location: Toronto, ON Posts: 6,181	Hey wow, look...Actual contribution time. For some reason, some players who debuted in 2016, with first names beginning with "Br" are missing debut dates. To wit: Brian Goodwin (goodwbr01) Brett Nicholas (nichobr01) Brock Stewart (stewabr01) Brent Suter (suterbr01) If I find anymore, I'll let you know.

01-11-2022, 01:52 AM	#149
LansdowneSt Global Moderator Join Date: Feb 2004 Location: From Duxbury, Mass residing Baltimore Posts: 7,683	https://forums.ootpdevelopments.com/...d.php?t=334227 Historic database question reposted here from General Discussions

01-11-2022, 04:27 AM	#150
actionjackson Hall Of Famer Join Date: Apr 2009 Location: Toronto, ON Posts: 6,181	Checked into it. Not a duplicate...For now...Dunh, Dunh, Dunh...

01-15-2022, 04:00 AM	#151
actionjackson Hall Of Famer Join Date: Apr 2009 Location: Toronto, ON Posts: 6,181	Brock Stewart (stewabr01), and Brent Suter (suterbr01) have no individual pitch ratings, and thus will enter with just two pitches, selected at random by the game. It's the same issue as with all of the pitchers who debuted in 2020. This is not as much of a problem for Suter, and Stewart, who are relievers, as it is for 2020 starters, and soon to be 2021 starters.

01-15-2022, 06:33 PM	#152
Amazin69 Banned Join Date: Nov 2010 Location: Palmetto Pride! Posts: 4,218 Infractions: 0/4 (4)	Yet another "Caucasian" in the database who is actually black. Please correct, as usual. Chuck Weatherspoon: weathe003cha

01-15-2022, 09:34 PM	#153
Amazin69 Banned Join Date: Nov 2010 Location: Palmetto Pride! Posts: 4,218 Infractions: 0/4 (4)	Also not "Caucasian", Luke Vasser. vasser001luc

01-16-2022, 08:39 PM	#154
actionjackson Hall Of Famer Join Date: Apr 2009 Location: Toronto, ON Posts: 6,181	I've gotta give some major props to whoever (team effort probably) cleaned up the Master.csv file. It's been quite a while since I took a deep dive into one, and I'd noticed over the years that they'd been steadily declining, mainly due to updates not being made with each version. This is quite stellar, and is a remarkable achievement, regardless of what I've said earlier about individual pitch ratings. I guess you can only criticize if you're willing to praise, and the amount of errors over the years that have been righted is truly staggering. Hard to keep up, with all the discoveries that are being made about old ballplayers by SABR, and other outfits. I have to acknowledge this. Amazing job, whoever's responsible.

01-17-2022, 01:20 PM	#155
Amazin69 Banned Join Date: Nov 2010 Location: Palmetto Pride! Posts: 4,218 Infractions: 0/4 (4)	One more non-Caucasian "Caucasian": John Mason ( mason-004joh ) Thank you.

01-17-2022, 05:05 PM	#156
actionjackson Hall Of Famer Join Date: Apr 2009 Location: Toronto, ON Posts: 6,181	According to BB-Ref, Win Clark is clarkbi01, not clarkwi03, as is in the Master.csv file, and more importantly the historical_database.ODB. All his stats would need to be credited to clarkbi01, as well as other things I may not be aware of.

01-17-2022, 05:11 PM	#157
actionjackson Hall Of Famer Join Date: Apr 2009 Location: Toronto, ON Posts: 6,181	I've noticed a lot of Federal League guys coming in without stats. Is this a design decision? Not all of them, mind you, but a lot. No other league (NA, AA, UA, and PL) seems to have this problem. It's a strange one for me.

01-20-2022, 05:42 PM	#159
actionjackson Hall Of Famer Join Date: Apr 2009 Location: Toronto, ON Posts: 6,181	Bill Jones (jonesbi01) has his career running from 1882 through 1884 in the Master.csv file. In fact, his career began and ended in 1884, so that needs to be changed, and any stats he has in the database for the other two seasons need to be scrubbed.